FTP File Layout - Other - Standard Bills - Combo
Refer to the following table to see the FTP layout used for other standard bills and where the information is pulled from.
This is for the combo 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. | Number 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 | The ID of the user responsible for submitting the file to the iRAPT. | 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 | 5/5 | 5 | M | COMBO | COMBO | proj_wawf_info | wawf_invc_type_cd | Select the form type on the Manage Project iRAPT Information screen. | Select the COMBO option. | |
| 1 | 1 | Contract Number | AN | 1/19 | 20 | M | See Field 2 notes on varying contract number sizes based on delivery order entry. | bill_edit_invc_hdr | 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 | C | 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. | bill_edit_invc_hdr | cust_po_id | Enter the delivery order number on the Manage Project User Flow screen. | Enter the delivery order number in the Purchase Order No field. | |||
| 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 | N/A | 30 | N/A | Not used. | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | |||||
| 1A | 1 | Foreign Currency Code | AN | 3/3 | 3 | O | bill_edit_invc_hdr | s_crncy_cd | Enter the foreign currency code on the Other Info tab of the Manage Project Billing Information screen. | Enter the foreign currency code in the Billing Currency field in the Currency Info group box. | |||
| 2 | 1 | Shipment Number | AN | 2/22 | 15 | M | The shipment number is converted to upper case. | bill_edit_invc_hdr | bill_no_id | The shipment number is represented as the bill number. The last bill number used is entered on the Manage Project Billing Information screen. The Calculate Standard Bills screen increments this number by one and populates the file with the incremented number. | The bill number is computed during the Calculate Standard Bills process but can be changed on the Manage Standard Bills screen. | ||
| 2 | Shipment Date | DT | 8/8 | M | CCYYMMDD | bill_edit_invc_hdr | invc_dt | The Shipment Date is the invoice date. The invoice date is the date on which the invoice is computed. | You can edit the invoice date in the Manage Standard Bills screen. | ||||
| 3 | Estimated Shipment Date Indicator | ID | 1/1 | O | Identifies whether the Shipment Date is estimated or not. Enter a capitalized E if the date is Field 2 is an estimated shipment date. If not, leave blank. | blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | ||||||
| 4 | Final Shipment | ID | 1/1 | 1 | M | Identifies whether the shipment is the final shipment. Enter a capitalized Y for Yes or N for No. iRAPT defaults to N if left blank. | proj_wawf_info | wawf_last_ship_fl | The check box indicating that this shipment is the final shipment is located on the Manage Project iRAPT Information screen. | Select the Final Shipment option on the Manage Project iRAPT Information screen. | |||
| 3 | 1 | Services or Supplies | ID | 3/3 | 3 | M | SPL for supplies or SVC for services must be capitalized. | proj_wawf_info | wawf_supply_svc_cd | Indicate whether this invoice is for services or for supplies on the Manage Project iRAPT Information screen. | Indicate whether this invoice is for services or for supplies by selecting the Services or Supplies option in the Type group box. | ||
| 4 | 1 | Bill of Lading | AN | 1/30 | O | Not used. | If the invoice is not a fast pay invoice, do not create line 4. | ||||||
| 2 | TCN | AN | 1/30 | N/A | Not used. | ||||||||
| 3 | Transportation Method/Type | ID | 1/1 | 1 | M | Used only for fast pay invoices for MOCAS. | proj_wawf_info | wawf_ln_haul_cd | This field is available for entry on the Manage Project iRAPT Information screen if invoice is a fast pay. | Enter the first line haul mode. See the iRAPT Interface Design Document (IDD) for acceptable values. | |||
| 4 | Bill of Lading Type Indicator | N/A | N/A | N/A | Not used. | ||||||||
| 5 | Serial Shipping Container Code | N | 18/18 | O | |||||||||
| 6 | Transportation Later Indicator | AN | 1/1 | O | Enter Y (Yes) to indicate that transportation data will be submitted later. Valid values are Y (Yes), N (No), and blank. | ||||||||
| 5 | 1 | Discount Percent | O | This field must be blank if the Discount Amount, Discount Date, or Net Days field has a value. | Blank | If the invoice is not a fast pay invoice, do not create line 5. | |||||||
| 2 | Due Days | C | If the Discount Percent has a value, this field is required. | Blank | |||||||||
| 3 | Discount Amount | O | If the Discount Percent, Due Days, or Net Days field has a value, this field must be blank. | Blank | |||||||||
| 4 | Discount Date | C | If the Discount Amount has a value, this field is required. | Blank | |||||||||
| 5 | Discount Type | C | If data is entered in fields 1 and 2, or 3 and 4, this field defaults to the appropriate value. For fast pay invoices, insert 21. | 21 if wawf_fast_pay_fl = Y. | proj_wawf_info | wawf_fast_pay_fl | Select the Fast Pay Invoice option on the Manage Project iRAPT Information screen. | Select the Fast Pay Invoice option. | |||||
| 6 | Net Days | O | If the Discount Percent or Discount Amount has an entry, this field must be blank. | Blank | |||||||||
| 6 | 1 | Invoice Number | AN | 1/22 | 15 | M | The invoice number is converted to upper case. | bill_edit_invc_hdr | invc_id | The last company wide invoice number is stored on the Configure Billing Settings screen. The number is incremented and assigned to each successive invoice computed by the Calculate Standard Bills screen. | The last company wide invoice number, from which the current invoice number is created, is stored in the Last Company Wide Invoice No field. | ||
| 2 | Invoice Date | DT | 8/8 | M | CCYYMMDD | bill_edit_invc_hdr | invc_dt | The Invoice Date is the date on which the invoice is computed. | You can edit the invoice date on the Manage Standard 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. | proj_wawf_info | wawf_last_invc_fl | The check box indicating that this invoice is the final invoice is located on the Manage Project iRAPT Information screen. | The check box indicating that this invoice is the final invoice is located on the Manage Project iRAPT Information screen. | |||
| 4 | Vendor's Invoice Number | AN | N/A | N/A | Not used. | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | ||||||
| 8 | 1 | Inspection Point | ID | 1/1 | 1 | M | Enter a capitalized S for Source or D for Destination or O for Other. | proj_wawf_info | wawf_inspect_pt_cd | Select the option for the inspection point on the Manage Project iRAPT Information screen. | Select the option for the inspection point in the Inspection group box. | ||
| 2 | Acceptance Point | ID | 1/1 | 1 | M | Enter a capitalized S for Source or D for Destination or O for Other. | proj_wawf_info | wawf_accept_pt_cd | Select the option for the acceptance point on the Manage Project iRAPT Information screen. | Select the option for the acceptance point in the Acceptance 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 | CAGE Extension | AN | 1/6 | O | Must be left 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 Code extension field in the Sender Information group box. | ||||
| 10 | 1 | Administration DoDAAC | AN | 6/6 | 6 | M | proj_wawf_info | wawf_admin_id | Enter the administration DoDAAC on the Manage Project iRAPT Information screen. | Enter the administration DoDAACs in the Administration field in the DoDAACs group box. | |||
| 10B | 1 | Inspect by DoDAAC | AN | 6/6 | 6 | C | If the Inspection Point in Line 8, Field 1, is S, this field is required. | 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 | Inspect by Extension | AN | 1/6 | C | If Inspect by DoDAAC is blank, this field must be left blank. If Inspect by DoDAAC has a value, this field is optional. | 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. | ||||
| 11 | 1 | Ship From CAGE / DUNS / DUNS+4/ DoDAAC | AN | 5/13 | 13 | O | If the Ship from CAGE/DoDAAC doesn't differ from the Prime Contractor CAGE code, Line 9, this field may be blank. | proj_wawf_info | wawf_ship_from_id | Enter the ship from CAGE/DoDAAC on the Manage Project iRAPT Information screen. | Enter the ship from CAGE/DoDAAC in the Ship From field in the DoDAACs group box. | ||
| 2 | Ship from Extension | AN | 1/6 | C | If the Ship From CAGE/DoDAAC is blank, this field must be left blank. If the Ship From CAGE/DoDAAC has an entry, this field is optional. | proj_wawf_info | ship_from_ext_cd | Enter the ship from CAGE/DoDAAC extension on the Manage Project iRAPT Information screen. | Enter the ship from extension in the Ship From extension field in the DoDAACs group box. | ||||
| 3 | FOB | AN | 1/1 | 1 | C | Enter a capitalized S for Source or D for Destination or O for Other. | proj_wawf_info | wawf_fob_cd | Select the option for the FOB on the Manage Project iRAPT Information screen. | Select the option for the FOB in the FOB 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 | Ship To CAGE / DUNS / DUNS+4/ DoDAAC / Contractor DoDAAC | AN | 5/13 | 13 | M | If Inspection Point in Line 8, Field 1, is S and Acceptance Point in Line 8, Field 2, is S, a CAGE is permitted. Otherwise, this must be a DoDAAC. | proj_wawf_info | wawf_ship_to_id | Enter the ship to/CAGE DoDAAC on the Manage Project iRAPT Information screen. | Enter the ship to/CAGE DoDAAC in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box. | ||
| 2 | Ship To Extension | AN | 1/6 | O | If the Ship To CAGE/DoDAAC is blank, this field must be left blank. If the Ship To CAGE/DoDAAC has an entry, this field is optional. | proj_wawf_info | ship_to_ext_cd | Enter the ship to/service acceptor extension on the Manage Project iRAPT Information screen. | Enter the ship to/service acceptor extension in the Contracting Officer/Ship To/Service Acceptor extension field in the DoDAACs group box. | ||||
| 13B | 1 | Local Processing Office DoDAAC | AN | 6/6 | 6 | O | proj_wawf_info | wawf_local_proc_id | Enter the local processing office DoDAAC on the Manage Project iRAPT Information screen. | Enter the local processing office DoDAAC in the Local Processing Office field in the DoDAACs group box. | |||
| 2 | Local Processing Office Extension | AN | 1/6 | C | If the Local Processing Office DoDAAC is blank, this field must be left blank. If the Local Processing Office DoDAAC has an entry, this field is optional. | proj_wawf_info | local_proc_ext_cd | Enter the local processing office extension on the Manage Project iRAPT Information screen. | Enter the local processing office extension in the Local Processing Office extension field in the DoDAACs group box. | ||||
| 13D | 1 | 3rd Party — Other Office DODAAC | AN | 6/6 | O | Must be entered if line 8, Fields 1 or 2 are OTHER. | proj_wawf_info | wawf_inspect_other or wawf_accept_other | Enter the 3rd party—other office DoDAAC on the Manage Project iRAPT Information screen. | Enter the 3rd party—other office DoDAAC in the Other field of the Inspection Point group box or the Acceptance Point group box. | |||
| 2 | 3rd Party — Other Office Extension | AN | 1/6 | C | If the 3rd Party — Other Office DoDAAC is blank, this field must be left blank. If the 3rd Party — Other Office DoDAAC has an entry, this field is optional. | proj_wawf_info | inspect_other_ext_cd or accept_other_ext_cd | Enter the 3rd party—other office extension on the Manage Project iRAPT Information screen. | Enter the 3rd party—other office extension in the Other Extension field of the Inspection Point group box or the Acceptance Point group box. | ||||
| 14 | 1 | Mark For Delivery CAGE/ DUNS / DUNS+4 / DoDAAC | AN | 5/13 | 13 | O | proj_wawf_info | wawf_mark_deliv_id | Enter the mark for delivery DoDAAC on the Manage Project iRAPT Information screen. | Enter the mark for delivery DoDAA in the Mark For Delivery field in the DoDAACs group box. | |||
| 2 | Mark For Delivery Extension | AN | 1/6 | C | If the Mark for Delivery DoDAAC is blank, this field must be left blank. If the Mark for Delivery DoDAAC has an entry, this field is optional. | proj_wawf_info | mark_deliv_ext_cd | Enter the mark for delivery extension on the Manage Project iRAPT Information screen. | Enter the mark for delivery extension in the Mark for Delivery extension field in the DoDAACs group box. | ||||
| 3 | Mark For Delivery Representative | AN | N/A | N/A | Not used. | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | ||||||
| 14B | 1 | Mark For Delivery Comments | AN | 1/75 | 75 | O | proj_wawf_info | wawf_comments | Enter the mark for delivery comments on the Manage Project iRAPT Information screen. | Enter the mark for delivery comments on the Manage Project iRAPT Informationscreen. | |||
| 14C | 1 | Mark For Delivery Secondary Comments | AN | 1/75 | 75 | O | proj_wawf_info | wawf_2nd_comments | Enter the mark for delivery secondary comments on the Manage Project iRAPT Information screen. | Enter the mark for delivery secondary comments on the Manage Project iRAPT Information screen. | |||
| 15 | 1 | 15 | Line Item | AN/ID | 1/6 | 10 | M | This field may contain a CLIN, SLIN, tax code, or miscellaneous fee/charge/allowance. | Truncate at six characters. | Other SB Attachment | Line Item | On the the Manage Project iRAPT Information screen, you can select from three CLIN Mapping Methods. If you select Default CLIN, all billed amounts are grouped into the entered CLIN. If you select Use ACRN Mapping, the mapping from the Manage ACRN Bills screen is used and the CLIN comes from PROJ_ACRN_DETL.acrn_ln_item. If you select CLIN Mapping, you must map projects to CLINs (PROJ_WAWF_CLIN.clin_id). You can also map accounts and/or PLCs to a project/CLIN line. Within these methods, there are also two different methods of mapping units. If the units are mapped by account, the units are grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they are grouped within the file based on the CLIN or catalog charged at transaction. You can include discounts and taxes within the CLIN or have them inserted into the file as a Line Item Type 3 or 4. Other charges entered on the Header tab of the Manage Standard screen are Bills inserted as a Line Item Type 2 and the other charge code is in the field. | Billed amounts are grouped based on the CLIN linked to projects and, optionally, accounts and/or PLCs. If you selected Use ACRN Mapping, the project/CLIN/ACRN mapping is completed on the Manage ACRN Bills screen (PROJ_ACRN_DETL). If you selected Default CLIN, Costpoint groups the amount of the invoice into the CLIN entered in the default CLIN field. If you selected CLIN Mapping, Costpoint groups the billed amounts based on the CLIN/project link (PROJ_WAWF_INFO.clin_id) and account/PLC, if mapped. Other charges are grouped by charge code, and if taxes and discounts are not included in the CLIN, they are grouped together. |
| 2 | 15 | Line Item Type | ID | 1/1 | M | 1 — CLIN/SLIN, 2 — Fee/Charge, 3 — Allowance, 4 — Tax | Other SB Attachment | Line Item Type | The file creation process populates this field according to the iRAPT Notes. | All billed charges from Open Billing Detail are considered as a CLIN (1), sales tax as a tax (4), other charges as fee/charge (2), and discounts as allowance (3). If Include Discounts and Taxes in CLIN is selected, the taxes are combined within the CLIN if you use Default CLIN or CLIN Mapping. If you use ACRN mapping, discounts and taxes are always included within the CLIN. | |||
| 3 | 15 | GFE | ID | 1/1 | N/A | This field cannot have a value unless the Line Item Type in Field 2 is a 1 (CLIN/SLIN). Optional even if CLIN/SLIN per telcon with iRAPT. | Blank | The file creation process does not populate this optional field at this time. | |||||
| 16 | 1 | 15 | Stock Number | AN | 1/25 | 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. | Other SB Attachment | Stock Number or NONE if there is no stock number. | The file creation process populates this field with NONE if the Line Item Type is CLIN/SLIN and more than one item is grouped in CLIN or there is no PART.nsn_id. If one item is billed and the PART.nsn_id exists, insert the nsn_id. The file creation does not populate this field for Line Item Type 2, 3, or 4. | ||
| 2 | 15 | Product Service Type | ID | 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. | Other SB Attachment | Product Service Type | The file creation process populates this field with MG if the Line Item Type is CLIN/SLIN, or FS if the transaction type is units and a stock number exists for the item billed. If there is more than one item billed within the CLIN, use MG. This field does not populate if the Line Item Type is 2, 3, or 4. | ||||
| 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. | Other SB Attachment | Description | The file creation process populates this field with Amount Billed for XXXXXX, where XXXXXX is the CLIN entered in the Default CLIN field, the CLIN on the Manage ACRN Bills screen, or the CLIN on the CLIN Mapping subtask of the Manage Project iRAPT Information screen. If the Line Item Type is 2, 3, or 4, this field is not populated. If this is a units billing, the description is entered on Manage Parts, Manage Goods, or Manage Services screens the and is used if only one item is grouped within the CLIN. | If the mapping method is Use ACRN Mapping, the CLIN is populated as the line item in the child table window of the Manage ACRN Bills screen. If you select Default CLIN, Costpoint populates the Default CLIN field on the Manage Project iRAPT Information screen. If you select CLIN Mapping, Costpoint populates the CLIN in the CLIN Mapping subtask where projects are linked. | |
| 16B | 1 | 15 | ACRN | AN | 2/2 | 2 | C | This field is optional if the Line Item Type in line 15, field 2 is 1. If Line 15 is not field 2 is not a 1, skip this line. | proj_acrn_detl | acrn_id | The file creation process populates this field with the ACRN linked to the line item on the Manage ACRN Bills screen. This is used only if Use ACRN Mapping is selected. | Enter the ACRN in the child table window on the Manage ACRN Bills screen. | |
| 2 | 15 | SDN | AN | 13/15 | C | The process does not populate this field. | Blank | Not populated. | |||||
| 3 | 15 | AAA | AN | 6/6 | O | The process does not populate this field. | Blank | Not populated. | |||||
| 16D | 1 | 15 | UID Type | AN | 3/4 | 5 | M | 16D—16F is considered a loop within loop 15. Enter UID1, UID2, ESN, GIAI, GRAI, OTHER, or VIN (see the iRAPT ICD document for definitions of types). | Join the BILL_EDIT_DETL.item_id to PROJ_WAWF_UID_DETL.wawf_item_id. If there is a join, pull information for item from PROJ_WAWF_UID_DETL for this loop. If no join is found, skip 16D. | proj_wawf_uid | wawf_uid_type_cd | Enter the UID Type on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter or select a drop-down value for the UID type in the UID Type column in the UID Information group box. |
| 2 | 15 | Issuing Agency Code | AN | 1/2 | 3 | C | This field is required if the UID Type is UID1 or UID2. | proj_wawf_uid | wawf_uid_iac_cd | Enter the issuing agency code on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter the issuing agency code in the IAC column of the UID Information group box. See the iRAPT Interface Control Document Appendix K for valid codes. | ||
| 3 | 15 | Enterprise Identifier | AN | 4/9 | 13 | C | This field is required if the UID Type is UID1 or UID2. If this field has an entry, the Issuing Agency Code is required. | proj_wawf_uid | wawf_uid_eid_cd | Enter the enterprise identifier on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter the enterprise identifier in the Enterprise Identifier column in the UID Information group box. See the iRAPT Interface Control Document Appendix K for valid codes. | ||
| 4 | 15 | Original Part Number | AN | 1/32 | 32 | O | This field is required if the UID Type is UID2 and the Batch and Lot Number is blank. | proj_wawf_uid | wawf_uid_part_id | Enter the original part number on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter the original part number in the Part No. column of the UID Information group box. | ||
| 5 | 15 | Batch and Lot Number | AN | 1/20 | O | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 6 | 15 | Unit Price | N/A | Not Used | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | |||||||
| 7 | 15 | Unit of Measure | N/A | Not Used | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | |||||||
| 8 | 15 | Miscellaneous | N/A | Not Used | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | |||||||
| 9 | 15 | Current Part Number | AN | 1/32 | O | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 10 | 15 | Current Part Number Cost | R9.2 | 1/16 | C | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 11 | 15 | Current Part Number Effective Date | N | 8/8 | C | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 12 | 15 | Original Manufacturer's Code | AN | 1/3 | O | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 13 | 15 | Original Manufacturer's ID | AN | 4/13 | C | Blank | The file creation process does not populate this optional field at this time. | ||||||
| 14 | 15 | Warranty Indicator | AN | 1/1 | O | Valid values are Y (Yes), N (No), and blank. If the value is unknown, this field must be left blank. | |||||||
| 15 | 15 | Not used. | N/A | N/A | Not used. | Blank | |||||||
| 16 | 15 | Special Tooling/ Special Test Equipment | AN | 2/3 | O | Valid values are
ST (Special Tooling),
STE (Special Test Equipment), and
NS (Neither).
If no value is entered, this field defaults to NS (Neither). |
NS | ||||||
| 16F | 1 | 16D | UID — Unique Identifier | AN | 1/50 | 78 | C | 16D—16F is considered a loop within loop 15. The number of UIDs reported must match the quantity reported in Line 17, field 1. | proj_wawf_uid_detl | wawf_uid_cd | Enter the UID — unique identifier on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter the UID — unique identifier in the Unique Identifier column of the UID Information group box. | |
| 2 | 16D | UID — Serial Number | AN | 1/30 | 30 | O | proj_wawf_uid_detl | wawf_uid_serial_no | Enter the UID — serial number on the UID Information subtask of the Manage Project iRAPT Information screen. | Enter the UID — serial number in the UID Serial No column of the UID Information group box. | |||
| 16G | 1 | 15 | ACRN | AN | 2/2 | 2 | C | Use this field to report multiple ACRNs per line item. | proj_acrn_detl | acrn_id | The file creation process populates this field with the ACRN linked to the line item on the Manage ACRN Bills screen. This is used only if Use ACRN Mapping is selected. | Enter the ACRN in the child table window on | |
| 2 | 15 | ACRN Price | R9.2 | 1/15 | C | Use this field to report the ACRN amount for this line item. | The total ACRN price must equal the line item total. | proj_acrn_detl | acrn_cur_alloc_amt | The file creation process populates this field with the computed current ACRN allocation amount linked to the line item on the Manage ACRN Bills screen. | The current ACRN allocation amount is populated by . | ||
| 17 | 1 | 15 | Quantity Shipped / Invoiced or Provided Information | R8.2 | 1/11 | 14,4 | C | If UID information is entered in Line 16D or 16F, this field must be a whole number. 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. | Allows eight before the decimal and two after (10,2). | Other SB Attachment | Quantity Shipped | If Combine Units by Transaction CLIN is selected on the Manage Project iRAPT Information screen, the file creation process for units billings populates this field with the number of units entered on the Manage Unit Usage screen or the Import Units Usage Files screen, posted via the Post Unit Usage screen, and calculated by the Calculate Standard Bills process. If Map Units by Account is selected on the Manage Project iRAPT Informationscreen, the billed units are combined with other billed amounts and the file creation process populates this field with a 1. For non-unit billings where the Line Item Type is 1, the file creation process populates this field with a 1. For non-unit billings where the Line Item Type is not 1, the file creation process does not populate this field. | If the units mapping method is Combine Units by Transaction CLIN, the quantity shipped is the billed quantity. If the units mapping method is Map Units by Account, the quantity shipped is 1. For CLINs where there are no units billed, the quantity shipped is 1. |
| 2 | 15 | Ship Advice Code | ID | 1/1 | O | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | ||||||
| 3 | 15 | Actual Quantity | N | 1/8 | C | If the Line Item number 15 is Zero Lots and the document contains MILSTRIPs, UIDs, pack data, or the pack later indicator is set to Y, this field is required. The Actual Quantity cannot be negative, and if no quantity is sent, this field must be zero or blank. | Blank | 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. | Other SB Attachment | Unit of Measure | The file creation process populates the Unit of Measure Code 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 or multiple items linked to one CLIN, the file creation process populates this field with EA if the Line Item Type is 1. If the Line Item Type is 2, 3, or 4, the file creation process does not populate the Unit of Measure Code. | ||
| 19 | 1 | 15 | Unit Price | R9.6 | 1/16 | 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, 3, or 4, this is the amount of the fee, allowance, or tax. | If the Line Item Type is 2, 3, or 4, the field size is 11,2. | Other SB Attachment | Unit Price | If the unit mapping is Combine Units by Transaction CLIN and it is used with ACRN or CLIN Mapping, the unit price is the total amount billed or current ACRN allocation amount (can include taxes, discounts, over ceiling, retainage, withholding, withholding release, other costs, and so on) divided by the billed quantity (or 1 if there are no billed units). If the unit mapping is Map Units by Account and it is used with ACRN or CLIN Mapping, the unit price is the total billed for the CLIN. If the Line Item Type2, 3, is 4, or the unit price is the total of the other charges, discounts, or taxes. | |
| 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 Issued By field in the DoDAACs group box. | |||
| 21A | 1 | ARP — Alternate Release Procedure | ID | 1/1 | 1 | O | Enter a capitalized Y for Yes, or N for No. If left blank, defaults to N. ARP is allowed only for source/source and source/destination documents. | proj_wawf_info | wawf_arp_fl | The ARP — Alternate Release Procedure check box is located on the Manage Project iRAPT Information screen. | |||
| 2 | COC — Certificate of Conformance | ID | 1/1 | 1 | O | Enter a capitalized Y for Yes, or N for No. If left blank, defaults to N. | proj_wawf_info | wawf_cert_fl | The COC — Certificate of Conformance check box is located on the Manage Project iRAPT Information screen. | ||||
| 3 | Construction Certificate | ID | N/A | N/A | Not used. | Blank | The iRAPT process does not use this field at this time. The file creation process does not populate this field. | ||||||
| 23 | 1 | Initiator Comments | AN | 1/80 | 254 | C | bill_edit_invc_hdr | bill_desc | Enter initiator comments in the Header tab of the Manage Standard Bills screen. | Enter initiator comments in the Bill Heading field on the Manage Standard Bills screen. You must enter comments if there is a final invoice 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 the invoice ID if that option is selected. | Enter a file attachment name or select to use the invoice ID as the attachment name. | |
| 28 | 1 | 28 | Tag Type | AN | 4/4 | 4 | O | Enter the RFID when RFID tag data is reported. If RFID is entered in Field 1, RFID Tag ID data must be reported in Field 2. | If more than one row is entered in proj_wawf_info, identify the additional lines as 28A, 28B, and so on. | proj_wawf_rfid | wawf_rfid_tag_cd | Enter the tag type on the RFID Information subtask of the Manage Project iRAPT Information screen. | Enter the tag type in the Tag Type column of the RFID Information group box. |
| 2 | 28 | Tag ID | ID | 4/64 | 64 | O | Enter RFID tag data. Must be 16, 24, 32, or 64 characters. Characters allowed are numerals 0-9 and letters A-F. | If RFID is not reported in line 28, field 1, enter NONE here. | proj_wawf_rfid | wawf_rfid_tag_id | Enter the tag ID on the RFID Information subtask of the Manage Project iRAPT Information screen. | Enter the tag ID in the Tag ID column of the RFID Information group box. | |
| 29 | 1 | 29 | CLIN | AN | 4/6 | 6 | C | Line 29 is required if Line 28 is reported or if Line 15, field 2 is a 1. | Lines 29 and 30 are a loop. | All CLINs reported in the file must be reported in this field. | |||
| 2 | 29 | Quantity | R8.2 | 1/11 | 14,4 | C | The number of UIDs reported must match the quantity reported here | The quantity reported for each CLIN must be reported in this field. | |||||
| 30 | 1 | 29 | UID — Unique Identifier | AN | 1/50 | 78 | C | The unique identifier ensures the uniqueness of items that are listed in the DoD UID Registry. The number of UIDs reported must match the quantity reported in Line 29, Field 2. | proj_wawf_uid_detl | wawf_uid_cd | All items that reported UIDs in Line 16D—16F are reported here directly below the item to which the UID relates. | ||
| 2 | Mark Indicator | AN | 1/1 | C | This Field must contain a
Y (Yes) when UII within Multi-Box Pack and can be used only once per unique UII.
Enter N (No) or leave blank when using Line 30 for other than a Multi-Box Pack. |
Blank | |||||||
| 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. |