FTP FILE LAYOUTS — OTHER — STANDARD BILLS — 2N1

2N1

Line

Field

Loop

Description

Type

WAWF Min/Max

CP Length

WAWF Req Des

WAWF Notes

Entry/Calculation

Source/Table

Column/Field

Data Entry Screen

Data Entry Field

START

Form Counter

1/3

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.

User ID

8/30

The ID of the user responsible for submitting the file to the WAWF.

WAWF User ID

Create WAWF Billing Files

Enter the user ID on the Create WAWF Billing Files screen.

Enter the user ID in the User ID field.

Form Type

2/6

CI 2N1 — Commercial Invoice/Fast Pay

CI2N1

proj_wawf_info

wawf_invc_type_cd

Select the form type on the Manage Project WAWF Information screen.

Select the 2N1 option.

Contract Number

13/13

Contract Number

If Contract Number Type is DOD Contract(FAR), the first 6 characters must be a valid Government DoDAAC unless positions 7-8 are less than 04 or greater than 70. Positions 7 and 8 must be numeric. Position 9 must be Alpha and may not be the letters O or I.

The file creation process supports only DOD Contract (FAR) at this time and does not create Line 1B used for the Contract Number Type. If the value is not provided, the transaction defaults to a value of B - DoD Contract (FAR), and all associated edits for Contract Number and Delivery Order number structure associated with DOD Contract (FAR) will be applied to the inbound file and if not met the file will fail.

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.

Delivery Order Number

0/4

Delivery Order, Call or Release Number

When the selected Contract Number Type is DoD Contract (FAR), the Delivery Order Number must be 0 or 4 alphanumeric characters.

See additional info in Field 1 above.

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.

Issue Date

8/8

CCYYMMDD

Blank

The file creation process does not populate this optional field at this time.

Task Order

1/30

N/A

Not used.

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

Foreign Currency Code

3/3

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.

Shipment Number

2/22

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.

Shipment Date

8/8

This field is required if the Shipment Number, Field 1, has a value.

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 on the Manage Standard Bills screen.

Estimated Shipment Date Indicator

1/1

N/A

Not used

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

Final Shipment

1/1

Identifies whether the shipment is the final shipment. Enter a capitalized Y for Yes or N for No. WAWF defaults to N if left blank.

proj_wawf_info

wawf_last_ship_fl

The check box that indicates if this shipment is the final shipment is located on the Manage Project WAWF Information screen.

Select the Final Shipment option on the Manage Project WAWF Information screen.

Invoice Number

1/22

The invoice number is converted to upper case.

bill_edit_invc_hdr

bill_no_id

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 this incremented number.

The bill number is computed during the Calculate Standard Bills process.

Invoice Date

8/8

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.

Final Invoice

1/1

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 that indicates if this invoice is the final invoice is located on the Manage Project WAWF Information screen.

Vendor's Invoice Number

1/22

N/A

Not used.

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

Prime Contractor CAGE / DUNS / DUNS+4

5/13

proj_wawf_info

wawf_send_cage_cd

Enter the prime contractor CAGE code on the Manage Project WAWF Information screen.

Enter the prime contractor CAGE code in the CAGE Code field in the Sender Information group box.

CAGE Extension

1/6

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 WAWF Information screen.

Enter the prime contractor CAGE extension in the CAGE Code extension field in the Sender Information group box.

Administration DoDAAC

6/6

proj_wawf_info

wawf_admin_id

Enter the administration DoDAAC on the Manage Project WAWF Information screen.

Enter the administration DoDAACs in the Administration field in the DoDAACs group box.

10B

Inspect by DoDAAC

6/6

This field is optional for the invoice 2n1 and construction invoice.

proj_wawf_info

wawf_inspect_id

Enter the inspect by DoDAAC on the Manage Project WAWF Information screen.

Enter the inspect By DoDAAC in the Inspect By field in the DoDAACs group box.

Inspect by Extension

1/6

If the Inspect by DoDAAC is blank, this field must be left blank. If the Inspect by DoDAAC is not blank, this field is optional.

proj_wawf_info

inspect_ext_cd

Enter the inspect by extension on the Manage Project WAWF Information screen.

Enter the inspect by extension in the Inspect By extension field in the DoDAACs group box.

Ship From CAGE / DUNS / DUNS+4/ DoDAAC

5/13

If ship from doesn't differ from the Prime Contractor CAGE code, Line 9, this field can be blank.

proj_wawf_info

wawf_ship_from_id

Enter the ship from CAGE/DoDAAC on the Manage Project WAWF Information screen.

Enter the ship from CAGE/DoDAAC in the Ship From field in the DoDAACs group box.

Ship from extension

1/6

N/A

Not used.

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

FOB

N/A

Not used.

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

Payment Office DoDAAC

6/6

proj_wawf_info

wawf_pmt_office _id

Enter the payment office DoDAAC on the Manage Project WAWF Information screen.

Enter the payment office DoDAAC in the Payment Office field in the DoDAACs group box.

Service Acceptor DoDAAC

6/6

Only a service acceptor DoDAAC is allowed, not a CAGE.

proj_wawf_info

wawf_ship_to_id

Enter the ship to/service acceptor DoDAAC on the Manage Project WAWF Information screen.

Enter the ship to/service acceptor DoDAAC iin the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.

Ship To Extension

1/6

If the Ship To is blank, this field must be left blank. If the Ship To is not blank, this field is optional.

proj_wawf_info

ship_to_ext_cd

Enter the ship to/service acceptor extension on the Manage Project WAWF 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

Local Processing Office DoDAAC

6/6

proj_wawf_info

wawf_local_proc_id

Enter the local processing office DoDAAC on the Manage Project WAWF Information screen.

Enter the local processing office DoDAAC in the Local Processing Office field in the DoDAACs group box.

Local Processing Office Extension

1/6

If the Local Processing Office DoDAAC is blank, this field must be left blank. If Local Processing Office DoDAAC is not blank, this field is optional.

proj_wawf_info

local_proc_ext_cd

Enter the local processing office extension on the Manage Project WAWF Information screen.

Enter the local processing office extension in the Local Processing Office extension field in the DoDAACs group box.

Line Item

AN/ID

2/6

This field can contain a CLIN, SLIN, tax code, or miscellaneous fee/charge/allowance.

Truncate to six characters.

bill_edit_detl

clin_id or price_catlg_cd

On the Manage Project WAWF 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 Bills screen are 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 select Use ACRN Mapping, the project/CLIN/ACRN mapping is completed in the Manage ACRN Bills screen (PROJ_ACRN_DETL). If you select Default CLIN, Costpoint groups the amount of the invoice into the CLIN entered in the Default CLIN field. If you select 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.

Line Item Type

1/1

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 WAWF 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 select Default CLIN or CLIN Mapping. If ACRN mapping is used, discounts and taxes are always included within the CLIN.

GFE

1/1

N/A

Use this field only if Field 1 is a CLIN/SLIN. Optional even if CLIN/SLIN per telcon with WAWF.

Blank

The file creation process does not populate this optional field at this time.

Stock Number

1/32

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 blank, insert NONE.

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 the 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.

Product Service Type

2/2

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 N/A, insert blank.

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

Description

1/75

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 in the Manage ACRN Bills screen, or the CLIN in the CLIN Mapping subtask of the Manage Project WAWF 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 in the Manage Parts, Manage Goods, or Manage Services screens 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 CLIN in the Default CLIN field on the Manage Project WAWF Information screen. If you select CLIN Mapping, Costpoint populates the CLIN on the CLIN Mapping subtask where projects are linked.

16B

ACRN

2/2

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.

SDN

13/15

The process does not populate this field.

Blank

Not populated.

AAA

6/6

The process does not populate this field.

Blank

Not populated.

16G

ACRN

2/2

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 the Manage ACRN Bills screen.

ACRN Price

R9.2

1/14

Use this field to report the ACRN amount for this line item.

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 the Calculate ACRN Bills process.

Quantity Shipped / Invoiced or Provided Information

R8.2

1/11

14,4

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 you selected Combine Units by Transaction CLIN on the Manage Project WAWF 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 you selected Map Units by Account on the Manage Project WAWF Information screen, 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 other than 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.

Ship Advice Code

1/1

Blank

The WAWF process does not use this field at this time. The file creation process does not populate this field.

Actual Quantity

N/A

Not used

Blank

Not used

Unit of Measure Code

2/2

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 in 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.

Unit Price

R9.5

1/16

14,4

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 Type is 2, 3, or 4, the unit price is the total of the other charges, discounts, or taxes.

Issue By DoDAAC

6/6

proj_wawf_info

wawf_issue_id

Enter the issue by DoDAAC in the DoDAACs group box of the Manage Project WAWF Information screen.

Enter the issue by DoDAAC in the Issue By field in the DoDAACs group box.

Initiator Comments

1/75

254

Must be entered if there is a previously submitted final invoice against contract number and delivery order.

bill_edit_invc_hdr

bill_desc

Enter initiator comments on the Header tab of the Manage Standard Bills screen.

Enter initiator comments in the Bill Heading field of the Manage Standard Bills screen. You must enter comments if there is a final invoice previously submitted for the contract number and delivery order.

Attachment Indicator

1/1

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 no 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.

Attachment Files

1/100

100

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.

SEPARATOR OR END

Separator or End

5/11

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.