FTP File Layout - MOCAS - Project Product Bills - Cost Voucher

If you are using the Mechanization of Contract Administration Service (MOCAS) pay system, refer to the following table to see the FTP layout used for project product bills and where the information is pulled from.

This is for the cost voucher invoice type.

Line	Field	Loop	Description	Type	iRAPT Min/Max	CP Length	iRAPT Req Des	iRAPT Notes	Entry/Calculation	Source/Table	Column/Field	Data Entry Screen	Data Entry Field
START	1		Form Counter	N	1/3		M	Number of transactions within the file.	No. of A records.			The file creation process populates this field with the number of invoices in the file.
A	1		User ID	AN	8/30	20	M	iRAPT User ID	iRAPT User ID	Create iRAPT Billing Files		Enter the user ID on the Create iRAPT Billing Files screen.	Enter the user ID in the User ID field.
B	1		Form Type	ID	2/2	5	M	CV - Cost Voucher	CV	proj_wawf_info	wawf_invc_type_cd	Select the form type on the Manage Project iRAPT Information screen.	Select the Cost Voucher option.
1	1		Contract Number	AN	1/19	20	M	See Field 2 notes on varying contract number sizes based on delivery order entry.		proj	prime_contr_id	Enter the contract number on the Manage Project User Flow screen.	Enter the contract number in the Prime Contract No field.
	2		Delivery Order Number	AN	0/19	20	O	A delivery order number must be blank, 4, 13, or 17 alphanumeric characters. If the Delivery Order Number is blank or is four alphanumeric characters in length, the Contract Number reported in line 1, field 1, must be 13 alphanumeric characters. If the Delivery Order Number is 13 or 17 alphanumeric characters in length, the Contract Number reported in line 1, field 1 must be 1/19 alphanumeric characters.		proj_prod_invc_hdr	cust_po_id	Enter the purchase order number on the Manage Project Product Bills screen.	Enter the delivery order number in the Purchase Order field on the header of the Manage Project Product Bills screen.
	3		Issue Date	DT	8/8		O	CCYYMMDD	Blank			The file creation process does not populate this optional field at this time.
	4		Task Order	AN	1/30	30	O			proj_wawf_info	wawf_task_order_id	Enter the task order on the Manage Project iRAPT Information screen.	Enter the task order in the Task Order field.
1A	1		Foreign Currency Code	AN	3/3	3	O			proj_prod_invc_hdr	trn_crncy_cd	The Foreign Currency Code defaults from the Manage Project Billing Information screen but can be modified on the Exchange Rates subtask.
6	1		Voucher Number	AN	7/8	15	M	The voucher number is converted to upper case. For MOCAS, begins with BVN, the fourth position is alphanumeric, the 5th - 7th positions are numeric, and the 8th position is used only for the final shipment and is a Z.	Enter a Z in the 8th position if this is a final invoice.	proj_prod_invc_hdr	bill_no_id	The voucher number is represented as the bill number. Enter the bill number on the Address Info tab of the Manage Project Product Bills screen.	You can modify the bill number on the Address Info tab of the Manage Project Product Bills screen.
	2		Voucher Date	DT	8/8		M	CCYYMMDD		proj_prod_invc_hdr	invc_dt	The Voucher Date is the invoice date. The invoice date is the date on which the invoice is entered.	You can modify the invoice date on the Manage Project Product Bills screen.
	3		Final Invoice	ID	1/1	1	M	Identifies whether the invoice is a final invoice. Enter a capitalized Y for Yes, or N for No. This field is used only if an Invoice Number is submitted in Field 1.	If the 8th position of the voucher is a Z, this field must be Y.	proj_wawf_info	wawf_last_invc_fl	The check box indicating that this shipment is the final shipment is located on the Manage Project iRAPT Information screen.	The check box indicating that this shipment is the final shipment is located on the Manage Project iRAPT Information screen. If this check box is selected, the voucher number must have a Z as the eighth character.
	4		Vendor's Invoice Number	AN	1/30	15	O			proj_prod_invc_hdr	invc_id	Enter the invoice number on the Manage Project Product Bills screen. If the field is left blank during save, the last company wide invoice number assigned is incremented by one and assigned to the saved bill.	Enter the invoice number in the Inv field. If the field is left blank during save, the last company wide invoice number assigned is incremented by one and assigned to the saved bill.
7	1		Service Start Date	DT	8/8		M	CCYYMMDD		proj	proj_start_dt	Enter the service start date on the Manage Modifications screen.	Enter the service start date in the Start Date field of the Service group box.
	2		Service End Date	DT	8/8		M	CCYYMMDD		proj	proj_end_dt	Enter the service end date on the Manage Modifications screen.	Enter the service end date in the End Date field of the Service group box.
9	1		Prime Contractor CAGE/DUNS /DUNS+4	AN	5/13	13	M			proj_wawf_info	wawf_send_cage_cd	Enter the prime contractor CAGE code on the Manage Project iRAPT Information screen.	Enter the prime contractor CAGE code in the Cage Code field in the Sender Information group box.
	2		Extension	AN	1/6		O	Must be blank if the Prime Contractor CAGE is blank.		proj_wawf_info	wawf_cage_ext_cd	Enter the prime contractor CAGE extension on the Manage Project iRAPT Information screen.	Enter the prime contractor CAGE extension in the CAGE extension field in the Sender Information group box.
10	1		Administration DoDAAC	AN	6/6	6	M		Must be a DoDAAC activity.	proj_wawf_info	wawf_admin_id	Enter the administration DoDAAC on the Manage Project iRAPT Information screen.	Enter the administration DoDAAC in the Administration field in the DoDAAC group box.
10B	1		Cost Voucher Approver DoDAAC	AN	6/6	6	M	Use of the cost voucher requires entry of a valid DCAA DoDAAC for the Auditor function (Inspect By).		proj_wawf_info	wawf_inspect_id	Enter the inspect by DoDAAC on the Manage Project iRAPT Information screen.	Enter the inspect by DoDAAC in the Inspected By field in the DoDAACs group box.
	2		Cost Voucher Approver Extension	AN	1/6		O	Must be blank if the Inspect by DoDAAC is blank.		proj_wawf_info	inspect_ext_cd	Enter the inspect by extension on the Manage Project iRAPT Information screen.	Enter the inspect by extension in the Inspected By Extension field in the DoDAACs group box.
12	1		Payment Office DoDAAC	AN	6/6	6	M			proj_wawf_info	wawf_pmt_office _id	Enter the payment office DoDAAC on the Manage Project iRAPT Information screen.	Enter the payment office DoDAAC in the Payment Office field in the DoDAACs group box.
13	1		Service Approver DoDAAC	AN	6/6	13	M			proj_wawf_info	wawf_ship_to_id	Enter the contracting officer DoDAAC on the Manage Project iRAPT Information screen.	Enter the contracting officer DoDAAC in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.
	2		Service Approver Extension	AN	1/6		O	Must be left blank if the Contracting Officer DoDAAC is blank.		proj_wawf_info	ship_to_ext_cd	Enter the contracting officer extension on the Manage Project iRAPT Information screen.	Enter the contracting officer extension in the Contracting Officer/Ship To/Service Acceptor Extension field in the DoDAACs group box.
15	1	15	Line Item	AN/ID	4 or 6	10	M	This field may contain a CLIN, SLIN, or miscellaneous fee. (Taxes and allowances are not allowed.)	Only one miscellaneous fee can be included in a document: only F460 or I260 is allowed.	proj_prod_invc_ln		Enter the line item, CLIN, or catalog on the Manage Project Product Bills screen. If it is left blank and these are not other charges, the Default CLIN from the Manage Project iRAPT Information is screen is used. If that does not exist, the Item Selling Description is used. Enter the line item for other charges on the Other Info tab of the Manage Project Product Bills screen.	Enter the line item, CLIN, or catalog in the CLIN or Catalog columns. If there is no CLIN/SLIN or catalog and these are not other charges, the Default CLIN from the the Manage Project iRAPT Information screen is used. If that does not exist, the Item Selling Description is used. Enter the line item for other charges in the Code column of the Other Charges group box. Be sure to enter an acceptable code for your payor and invoice type.
	2	15	Line Item Type	ID	1/1	1	M	1 — CLIN/SLIN, 2 — Fee/Charge (Taxes and allowances are not allowed.)		proj_prod_invc_ln	line_item_type_cd	This populates with a 1 unless other charges are entered, in which case the value is a 2. If  the Include Discounts and Taxes in CLIN check box is selected on the Manage Project iRAPT Information screen, any discounts and taxes are included with the billed amounts.
	3	15	GFE	ID	1/1	1	N/A	Use this field only if Field 1 is a CLIN/SLIN. Optional even if CLIN/SLIN per telcon with iRAPT.	Not used.			The file creation process does not populate this optional field at this time.
16	1	15	Stock Number	AN	1/32	20	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.		proj_prod_invc_ln	stock_no or "NONE" if there is no stock number.	The Stock Number is populated with the PART.nsn_id (if one exists), or is populated with NONE if no item is entered. This line is not populated if the Line Item Type is 2.
	2	15	Product Service Type	ID	2/2	2	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.		proj_prod_invc_ln	prod_svc_type_cd	If an item is entered and a stock number exists, the Product Service Type is populated with FS. If no stock number exists or no item is entered, the Product Service Type is MG. This field does not populate for other charges.
16A	1	15	Description	AN	1/75	60	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.		proj_prod_invc_ln	item_selling_desc	Enter the description on the Manage Parts, Manage Goods, or Manage Services screens for any items that are billed. If no items are billed, the description comes from the Item Selling Description.	Enter the description in the Desc field in the Basic Characteristics group box for Parts, and in the Description field for Goods and for Services. You can modify this description in the Item Selling Description field. If no item is billed, this field is populated by the value in the Item Selling Description field.
16B	1	15	ACRN	AN	2/2	2	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line	Generate line 16B only if there is only one row in proj_prod_acrn.	proj_prod_acrn	acrn_cd	Enter the ACRN on the ACRNs subtask of the Manage Project Product Bills screen.	Enter the ACRN in the ACRN field. If there is only one ACRN for a CLIN/SLIN, this field displays the ACRN.  Otherwise, this field is not populated.
	2	15	SDN	AN	1/30	30	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line	Generate line 16B only if there is only one row in proj_prod_acrn.	proj_prod_acrn	sdn_cd	Enter the SDN on the ACRNs subtask of the Manage Project Product Bills screen.
	3	15	AAA	AN	6/6		C	The process does not populate this field.	Blank			Not populated.
16G	1	15	ACRN	AN	2/2	2	C	16B is used for one ACRN; 16G is used for multiple ACRNs.	Generate line 16G only if there is more than one row in proj_prod_acrn.	proj_prod_acrn	acrn_cd	Enter the ACRN on the ACRNs subtask of the Manage Project Product Bills screen.	Enter the ACRN in the ACRN column. If there are multiple ACRNs for a CLIN/SLIN, this field displays the ACRN. Otherwise, this field is not populated.
	2	15	ACRN Price	R9.2	1/15	14,2	C		Generate line 16G only if there is more than one row in proj_prod_acrn.	proj_prod_acrn	acrn_amt	Enter the ACRN price on the ACRNs subtask of the Manage Project Product Bills screen.	Enter the ACRN price in the ACRN Amount column. If there are multiple ACRNs for a CLIN/SLIN, this field displays the amount for each ACRN. The sum of the ACRN price lines must match the amount of the CLIN. This field is not populated unless multiple ACRNs exist.
17	1	15	Quantity Shipped / Invoiced or Provided Information	R8.2	1/11	14,4	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.	No decimals allowed.	proj_prod_invc_ln	units_qty	Enter the quantity on the Manage Project Product Bills screen.
	2	15	Ship Advice Code	ID	N/A		N/A	Not used.	Blank			iRAPT does not use this field. The file creation process does not populate this optional field at this time.
	3	15	Actual Quantity	N	N/A		N/A	Not used.	Blank			iRAPT does not use this field. The file creation process does not populate this optional field at this time.
18	1	15	Unit of Measure Code	AN	2/2	3	C	If the Line Item Type in Line Number 15, Field 2, is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.	If the Line Item is 1, use ITEM.dflt_um_cd.  If dflt_um_cd is blank, use EA.	item	dflt_um_cd	The Unit of Measure Code is populated during file creation for a Units billing with the value linked to an item on the Manage Parts, Manage Goods, or Manage Services screens. For non-units billings, the file creation process populates this field with EA if the Line Item Type is 1, and the process does not populate the field if the Line Item Type is 2.
19	1	15	Unit Price	R9.5	1/15	14,4	M	If the Line Item Type in Line Number 15, Field 2, is 1, this is the unit price. If the Line Item Type in Line Number 15, Field 2, is 2, this is the amount of the fee.	If the Line Item is 2, the field size is 11,2.	proj_prod_invc_ln	If Line 15, field 2 is 1, the value is trn_tot_price_amt divided by quantity (if the Include Discounts and Taxes in CLIN check box is selected) or  trn_unit_price_amt (if the Include Discounts and Taxes in CLIN check box is not selected). If line 15, field 2 is a 2, the value is PROJ_PROD_INVC_HDR.trn_oth_chg_amt1, 2, 3.	The unit price for items entered in the project product bill comes from the Project Unit Pricing subtask of the Manage CLIN Information screen or the Manage Product Price Catalogs screen but can be modified on each line. For non-unit lines with a Line Item Type of 1, the unit price and quantity can be entered. The unit price for non-unit billings with a Line Item Type of 2 matches the sum of the amounts entered on the Other Info subtask.	The unit price for items entered in the project product bill comes from the Project Unit Pricing subtask of the Manage CLIN Information screen or the Manage Product Price Catalogs screen but can be modified on each line. For non-unit lines with a Line Item Type of 1, the unit price and quantity can be entered. The unit price for non-unit billings with a Line Item Type of 2 matches the sum of the amounts entered on the Other Info subtask.
20	1		Issue By DoDAAC	AN	6/6	6	O			proj_wawf_info	wawf_issue_id	Enter the issue by DoDAAC in the DoDAACs group box of the Manage Project iRAPT Information screen.	Enter the issue by DoDAAC in the Issue By field.
23	1		Initiator Comments	AN	1/75	254	C		Required if there is a previously submitted final invoice against the Contract Number and Delivery Order.	proj_prod_invc_hdr	notes	Enter initiator comments on the Notes tab of the Manage Project Product Bills screen.	Enter initiator comments in the Notes field on the Notes tab of the Manage Project Product Bills screen. You must enter comments if a final invoice was previously submitted for the contract number and delivery order.
25	1		Attachment Indicator	ID	1/1		M	Enter a capitalized Y for Yes or N for No.	If wawf_attachment is null, insert N; otherwise, insert Y.			The file creation process populates the Attachment Indicator  field with a Y when there is an attachment, or an N when there is not an attachment.	If an attachment file name is entered or Use Invoice ID as Attachment File Name is selected, the value in this field is Y.
26	1		Attachment Files	ID	1/100	100	C	If the Attachment Indicator in Line Number 25, Field 1 is Y, this field is required. This field displays the name of the file to be attached to the document.	Insert the file name only, not the path.	proj_wawf_info	wawf_attachment	The file creation uses the attachment file name that you entered for the invoice type or uses the invoice ID if that option is selected.	Enter a file attachment name or select to use the invoice ID as the attachment name.
SEPARATOR OR END	1		Separator or End	ID	5/11		M	Use =SEPARATOR= to indicate that there are more documents in the file. Use =END= to indicate that this is the end of the file.	=SEPARATOR= or =END=	default		The file creation process enters Separator or End to indicate that there is at least one additional document following or that this is the end of the last document, respectively.