FTP FILE LAYOUTS - OTHER - STANDARD BILLS

Cost Voucher

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

2/30

User ID responsible for submitting file to WAWF

WAWF User ID

Create WAWF Billing Files (Projects » Billing » Print Billings)

Enter the User ID in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

User ID field in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

Form Type

2/2

CV - Cost Voucher

proj_wawf_info

wawf_invc_type_cd

Select the Form Type in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Cost Voucher option.

Contract Number

1/19

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 in the Maintain Project Master screen (Projects » Project Setup » Project Master).

Enter the Contract Number in the Prime Contract No field.

Delivery Order Number

1/19

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, then 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, then 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 in the Maintain Project Master screen (Projects » Project Setup » Project Master).

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

proj_wawf_info

wawf_task_order_id

Enter the Task Order in the CV subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Task Order is entered in the Task Order field.

Foreign Currency Code

3/3

bill_edit_invc_hdr

s_crncy_cd

Enter the Foreign Currency Code in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

The Foreign Currency Code is entered in the Billing Currency field in the Currency Info group box..

Voucher Number

2/22

The voucher number will be converted to upper case.

bill_edit_invc_hdr

bill_no_id

The voucher number will be represented as the bill number. The last Bill Number used is entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). The Calculate Billings screen (Projects » Billing » Calculate Billings) increments this number by one and populates the file with this incremented number.

The Bill Number is computed during the Calculate Billings process (Projects » Billing » Calculate Billings) but can be changed in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Voucher Date

8/8

CCYYMMDD

bill_edit_invc_hdr

invc_dt

The Voucher Date is the invoice date. The invoice date will be the system date the invoice was computed.

The invoice date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

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 Final Invoice check box is in the Cost Voucher Subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Final Invoice option in the CV subtask

Vendor's Invoice Number

1/30

bill_edit_invc_hdr

invc_id

The last Company Wide Invoice Number assigned is stored in the Billing Settings screen (Projects » Billing » Controls). The number is incremented and assigned to each successive invoice computed by the Calculate Billings screen (Projects » Billing » Calculate Billings).

The last Company Wide Invoice Number, from which the current invoice number will be created, is stored in the Last Company Wide Invoice No field.

Period of Performance Start Date

8/8

CCYYMMDD

proj

proj_start_dt

Period of Performance Start Date is entered in the Modifications subtask of the Maintain Project Master screen (Projects » Project Setup » Project Master).

Period of Performance Start Date is entered in the Start Date field of the Period of Performance group box..

Period of Performance End Date

8/8

CCYYMMDD

proj

proj_end_dt

Period of Performance End Date is entered in the Modifications subtask of the Maintain Project Master screen (Projects » Project Setup » Project Master).

Period of Performance End Date is entered in the End Date field of the Period of Performance group box..

Prime Contractor CAGE

5/5

proj_wawf_info

wawf_sender_cage_cd

The Prime Contractor CAGE Code is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Prime Contractor CAGE Code is entered in the CAGE Code field in the Sender Information group box.

CAGE Extension

1/6

Must be blank if Prime Contractor CAGE was not entered.

proj_wawf_info

wawf_cage_ext_cd

The Prime Contractor CAGE Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Prime Contractor CAGE Extension is entered in the CAGE extension field in the Sender Information group box.

Administration DoDAAC

6/6

proj_wawf_info

wawf_admin_id

The Administration DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Administration DoDAACs is entered in the Administration field in the DoDAACs group box.

10B

Cost Voucher Approver DoDAAC

6/6

Use of the Cost Voucher requires entry of a valid DCAA DoDAAC for the Auditor function (Inspect By).

proj_wawf_info

wawf_inspect_id

The Inspect by DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By DoDAAC is entered in the Inspected By field in the DoDAACs group box.

Cost Voucher Approver Extension

1/6

Must be blank if Inspect By was not entered.

proj_wawf_info

inspect_ext_cd

The Inspect by Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By Extension is entered in the Inspected By extension field in the DoDAACs group box.

Payment Office DoDAAC

6/6

proj_wawf_info

wawf_pmt_office _id

The Payment Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Payment Office DoDAAC is entered in the Payment Office field in the DoDAACs group box.

Service Approver DoDAAC

6/6

proj_wawf_info

wawf_ship_to_id

The Contracting Officer DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Contracting Officer DoDAAC is entered in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.

Service Approver Extension

1/6

Must be left blank if Contracting Officer DoDAAC was not entered

proj_wawf_info

ship_to_ext_cd

The Contracting Officer DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Contracting Officer Extension is entered 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

The Local Processing Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office DoDAAC is entered in the Local Processing Office field in the DoDAACs group box.

Local Processing Office Extension

1/6

Must be left blank if Local Processing Office DoDAAC was not entered.

proj_wawf_info

local_proc_ext_cd

The Local Processing Office Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office Extension is entered in the Local Processing Office extension field in the DoDAACs group box.

Line Item

AN/ID

1/6

This Field may contain a CLIN, SLIN, Tax Code, or Miscellaneous Fee / Charge/ Allowance. Must be four alphanumeric or six alphanumeric.

Truncate value to six characters.

Other SB Attachment

Line Item

Within the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the user can select among three CLIN Mapping Methods. If Default CLIN is selected, all billed amounts will be grouped into the entered CLIN. If Use ACRN Mapping is selected, the mapping from the Maintain ACRN Bills screen (Projects » Billing » Billing Master) will be used and the CLIN will come from PROJ_ACRN_DETL.acrn_ln_item. If CLIN Mapping is selected, the user will be required to map projects to CLINs (PROJ_WAWF_CLIN.clin_id). It will be an option whether the user needs to 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 will be grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they will be grouped within the file based on the CLIN or catalog charged at transaction. The user will have the ability to 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 in the Header of the Edit Standard Bills screen (Projects » Billing » Edit Billings) will be inserted as a line item 2 and the other charge code will be in the field.

Billed amounts will be grouped based on the CLIN linked to projects and optionally accounts and/or PLCs. If Use ACRN Mapping is selected, the project/CLIN/ACRN mapping will be completed in the Maintain ACRN Bills screen (Projects » Billing » Billing Master) (PROJ_ACRN_DETL). If Default CLIN is used, we will group the amount of the invoice into the CLIN entered in the default CLIN field. If CLIN Mapping is used, we will group the billed amounts based on the CLIN/project link (PROJ_WAWF_INFO.clin_id) and account/PLC, if mapped. Other charges will be grouped by charge code, and if taxes and discounts are not included in the CLIN, they will be grouped together.

Line Item Type

1/1

1 - CLIN/SLIN, 2 - Fee/Charge,
3 - Allowance, 4 -Tax

1, 2, 3, 4

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 will be 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 will be combined within the CLIN if Default CLIN or CLIN Mapping is used. If ACRN mapping is used, discounts and taxes will always be included within the CLIN.

GFE

1/1

N/A

Optional even if CLIN/SLIN per telecon with WAWF.

blank

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

Stock Number

1/17

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

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 other line item type of 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 mandatory. 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 will 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 mandatory. 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 Maintain ACRN Bills screen (Projects » Billing » Billing Master), or the CLIN in the CLIN Mapping subtask in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If Line Item Type = 2, 3, or 4, this field will not be populated. If this is a Units billing, the Description is entered in the Maintain Parts (Materials » Product Definition » Part Master), Goods (Materials » Product Definition) or Services (Materials » Product Definition) screens and will be 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 CTW of the Maintain ACRN Bills screen (Projects » Billing » Billing Master). If Default CLIN is used, populate the CLIN in the default CLIN field in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If CLIN Mapping is used, populate the CLIN in 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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master). This will only be used if Use ACRN Mapping is selected.

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master)

SDN

13/15

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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

ACRN Price

R9.2

1/15

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

The current ACRN allocation amount is populated by the Calculate ACRN Billings process (Projects » Billing » Calculate Billings).

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 mandatory. If Line 15, Field 2 is not a 1, skip this line

allows 8 before the decimal and 2 after (10,2)

Other SB Attachment

Quantity Shipped

If Combine Units by Transaction CLIN is selected in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the file creation process for units billings populates this field with the number of units entered through the Enter Unit Usage screen (Projects » Billing » Units Usage) or the Upload Unit Usage Data screen (Projects » Billing » Units Usage), posted via the Post Unit Usage screen (Projects » Billing » Units Usage), and Calculated through the Calculate Billings screen (Projects » Billing » Calculate Billings). If Map Units by Account is selected in Maintain Project WAWF Info, the billed units will be 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 = 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 will be the billed quantity. If the units mapping method is Map Units by Account, the quantity shipped will be 1. For CLINs where there are no units billed, the quantity shipped will be 1.

Ship Advice Code

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.

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, then this Field is mandatory. If Line Number 15, Field 2 is not 1, do not create line.

Other SB Attachment

Unit of Measure Code

The Unit of Measure Code will be populated during file creation for a Units billing with the value linked to an item in the Maintain Parts (Materials » Product Definition » Part Master), Goods (Materials » Product Definition) or Services (Materials » Product Definition) screens. For non-units billings or multiple items linked to one CLIN, the file creation process will populate this field with EA if the Line Item Type = 1. If the Line Item Type is 2, 3, or 4, the file creation process will 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, then 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 Line Item Type is 2, 3, or 4, the field size is 9,2.

Other SB Attachment

Unit Price

If the unit mapping is Combine Units by Transaction CLIN used with ACRN or CLIN Mapping, the unit price will be the total amount billed or current ACRN allocation amount (could include taxes, discounts, over ceiling, retainage, other costs, etc) divided by the billed quantity (or 1 if there are not billed units). If the unit mapping is Map Units by Account used with ACRN or CLIN Mapping, the unit price will be the total billed for the CLIN. If the line item type is 2, 3, or 4, the unit price will be the total of the other charges, discounts, or taxes.

Issue By DoDAAC

6/6

proj_wawf_info

wawf_issue_id

Issue By DoDAAC is entered in the DoDAACs group box of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Issue By DoDAAC is entered in the Issued 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

Initiator Comments are entered in the Header subtask of the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Initiator Comments are entered in the Bill Heading field of the Edit Standard Bills screen (Projects » Billing » Edit Billings) and must be entered if there was 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 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 will be Y.

Attachment Files

1/100

100

If the Attachment in Line Number 25, Field 1, is Y, this Field is mandatory. This Field will contain the name of the file to be attached to the document.

Insert file name only, not path

proj_wawf_info

wawf_attachment

The file creation will use the attachment file name that the user entered in the subtask of the invoice type or we will use the invoice id if that option is selected.

Enter a file attachment name or select to use the invoice ID as the attachment name in the CV subtask.

SEPARATOR OR END

Separator or End

5/11

Use =SEPARATOR= to signal that there are more documents in the file. Use =END= to signal 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.

Commercial Invoice

Line

Field

Loop

Description

Type

WAWF

Min/

Max

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

2/30

User ID responsible for submitting file to WAWF

WAWF User ID

Create WAWF Billing Files (Projects » Billing » Print Billings)

Enter the User ID in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

User ID field in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

Form Type

2/5

CI - Commercial Invoice/Fast Pay

proj_wawf_info

wawf_invc_type_cd

Select the Form Type in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Commercial Invoice option.

Contract Number

1/19

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 in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Contract Number in the Prime Contract No field.

Delivery Order Number

4/17

bill_edit_invc_hdr

cust_po_id

Enter the Delivery Order Number in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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.

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 in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

The Foreign Currency Code is entered in the Billing Currency field in the Currency Info group box.

Shipment Number

2/22

The Shipment Number will be converted to upper case. Commercial Invoices require that a receiving report is submitted prior to the invoice. The shipment number on the invoice should match the shipment number on the receiving report.

bill_edit_invc_hdr

bill_no_id

The shipment number will be represented as the bill number. The last bill number used is entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). The Calculate Billings screen (Projects » Billing » Calculate Billings) increments this number by one and populates the file with this incremented number.

Shipment Date

8/8

This Field is mandatory if the Shipment Number, Field 1, is entered.

bill_edit_invc_hdr

invc_dt

The Shipment Date is the invoice date. The invoice date will be the system date the invoice was computed.

The invoice date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

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 if the Shipment is the Final Shipment. Enter a capitalized Y for Yes or N for No. WAWF will default to N if left blank.

proj_wawf_info

wawf_last_ship_fl

The check box indicating that this shipment was the final shipment is located in the CI subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Final Shipment option in the CI subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Discount Percent

This field must be blank if Discount Amount, Discount Date, or Net Days is entered.

blank

If the invoice is not a fast pay invoice, do not create line 5

Due Days

If Discount Percent is entered, this field is mandatory

blank

Discount Amount

If Discount Percent, Due Days, or Net Days is entered this field must be blank

blank

Discount Date

If the Discount Amount is entered this field is mandatory

blank

Discount Type

If data is entered in fields 1 and 2, or 3 and 4, this field will default 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 in the CI subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Fast Pay Invoice option in the CI subtask

Net Days

If Discount Percent or Discount Amount is entered this field must be blank.

blank

Invoice Number

1/22

The Invoice Number will be converted to upper case. Commercial Invoices require that a receiving report is submitted prior to the invoice. The invoice number on the invoice should match the invoice number on the receiving report.

bill_edit_invc_hdr

bill_no_id

The last Bill Number used is entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). The Calculate Billings screen (Projects » Billing » Calculate Billings) increments this number by one and populates the file with this incremented number.

The Bill Number is computed during the Calculate Billings process (Projects » Billing » Calculate Billings) and should only be eight characters long for MOCAS.

Invoice Date

8/8

CCYYMMDD

bill_edit_invc_hdr

invc_dt

The Invoice Date will be the system date the invoice was computed.

The Invoice Date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Final Invoice

1/1

Identifies if 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 was the final invoice is located in the CI subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The check box indicating that this invoice is the final invoice is located in the CI subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

5/5

proj_wawf_info

wawf_sender_cage_cd

The Prime Contractor CAGE Code is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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 Prime Contractor CAGE is not entered.

proj_wawf_info

wawf_cage_ext_cd

The Prime Contractor CAGE Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

The Administration DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

Ship from CAGE/DoDAAC

5/6

If Ship From doesn't differ from the contractors Prime CAGE Code, Line 9, then this Field may be blank.

proj_wawf_info

wawf_ship_from_id

The Ship From CAGE/DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

Ship from extension

1/6

If Ship From CAGE/DoDAAC was not entered, this Field must be left blank. If Ship From CAGE/DoDAAC is entered, this Field is optional.

proj_wawf_info

ship_from_wxt_cd

The Ship From CAGE/DoDAAC Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Ship From Extension in the Ship From extension field in the DoDAACs group box.

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

The Payment Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

Ship To CAGE/DoDAAC

5/6

Only a Service Acceptor is allowed.

proj_wawf_info

wawf_ship_to_id

The Contracting Officer DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Contracting Officer DoDAAC in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.

Ship To Extension

1/6

If Ship To was not used, then this field must be left blank. If Ship To is entered, then this field is optional.

proj_wawf_info

ship_to_ext_cd

The Contracting Officer DoDAAC Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Contracting Officer 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

The Local Processing Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office DoDAAC is entered in the Local Processing Office field in the DoDAACs group box.

Local Processing Office Extension

1/6

If Local Processing Office was not used, then this field must be left blank. If Local Processing Office is entered, then this field is optional.

blank

proj_wawf_info

local_proc_ext_cd

The Local Processing Office DoDAAC Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office Extension is entered in the Local Processing Office extension field in the DoDAACs group box.

Mark For Delivery

6/6

If required by contract, use only for fast pay invoices

If the invoice is not a fast pay invoice, do not create line 14.

proj_wawf_info

wawf_mark_deliv_id

The Mark for Delivery is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Mark for Delivery DoDAAC is entered in the Mark for Delivery field in the DoDAACs group box.

Mark For Delivery Extension

1/6

If Mark for Delivery was not used, then this field must be left blank. If Mark for Deliver is entered, then this field is optional.

proj_wawf_info

mark_deliv_ext_cd

The Mark for Delivery Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Mark for Delivery Extension is entered in the Mark for Delivery extension field in the DoDAACs group box.

Mark For Delivery Representative

1/50

N/A

Not used

blank

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

Line Item

AN/ID

1/6

This Field may contain a CLIN, SLIN, Tax Code, or Miscellaneous Fee / Charge/ Allowance.

Truncate at 6

Other SB Attachment

Line Item

Within the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), you can select among three CLIN Mapping Methods. If Default CLIN is selected, all billed amounts will be grouped into the entered CLIN. If Use ACRN Mapping is selected, the mapping from the Maintain ACRN Bills screen (Projects » Billing » Billing Master) will be used and the CLIN will come from PROJ_ACRN_DETL.acrn_ln_item. If CLIN Mapping is selected, the user will be required to map projects to CLINs (PROJ_WAWF_CLIN.clin_id). It will be an option whether the user needs to 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 will be grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they will be grouped within the file based on the CLIN or catalog charged at transaction. The user will have the ability to 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 in the Header of the Edit Standard Bills screen (Projects » Billing » Edit Billings) will be inserted as a line item 2 and the other charge code will be in the field.

Billed amounts will be grouped based on the CLIN linked to projects and optionally accounts and/or PLCs. If Use ACRN Mapping is selected, the project/CLIN/ACRN mapping will be completed in the Maintain ACRN Bills screen (Projects » Billing » Billing Master) (PROJ_ACRN_DETL). If Default CLIN is used, we will group the amount of the invoice into the CLIN entered in the default CLIN field. If CLIN Mapping is used, we will group the billed amounts based on the CLIN/project link (PROJ_WAWF_INFO.clin_id) and account/PLC, if mapped. Other charges will be grouped by charge code, and if taxes and discounts are not included in the CLIN, they will be 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 will be 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 will be combined within the CLIN if Default CLIN or CLIN Mapping is used. If ACRN mapping is used, discounts and taxes will always be 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/25

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. 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

Product Service Type

2/2

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

If N./A, then insert blank

Other SB Attachment

Product 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 will 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 mandatory. 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 Maintain ACRN Bills screen (Projects » Billing » Billing Master), or the CLIN in the CLIN Mapping subtask in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If Line Item Type = 2, 3, or 4, this field will not be populated. If this is a Units billing, the Description is entered in the Maintain Parts (Materials » Product Definition » Part Master), Goods (Materials » Product Definition) or Services (Materials » Product Definition) screens and will be 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 CTW of the Maintain ACRN Bills screen (Projects » Billing » Billing Master). If Default CLIN is used, populate the CLIN in the default CLIN field in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If CLIN Mapping is used, populate the CLIN in 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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

SDN

13/15

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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

ACRN Price

R9.2

1/15

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

The current ACRN allocation amount is populated by the Calculate ACRN Billings process (Projects » Billing » Calculate Billings).

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 mandatory. 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/Invoiced

If Combine Units by Transaction CLIN is selected in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the file creation process for units billings populates this field with the number of units entered through the Enter Unit Usage screen (Projects » Billing » Units Usage) or the Upload Unit Usage Data screen (Projects » Billing » Units Usage), posted via the Post Unit Usage screen (Projects » Billing » Units Usage), and Calculated through the Calculate Billings process (Projects » Billing » Calculate Billings). If Map Units by Account is selected in Maintain Project WAWF Info, the billed units will be 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 = 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.

Ship Advice Code

1/1

Not used

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 mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

Unit of Measure

Unit Price

R9.5

1/16

14,4

If the Line Item Type in Line Number 15, Field 2, is 1, then this is the Unit Price. If the Line Item Type in Line Number 15, Field 2, is 2, 3, or 4, then this is the amount of the Fee, Allowance, or Tax.

if Line Item Type is 2, 3, or 4, then the field size is 11,2.

Other SB Attachment

Unit Price

Issue By DoDAAC

6/6

proj_wawf_info

wawf_issue_id

Issue By DoDAAC is entered in the DoDAACs group box of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Issue By DoDAAC is entered in the Issued 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

Initiator Comments are entered in the Header subtask of the Edit Standard Bills screen (Projects » Billing » Edit Billings).

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 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 will be Y.

Attachment Files

1/100

100

If the Attachment in Line Number 25, Field 1, is Y, this Field is mandatory. This Field will contain the name of the file to be attached to the document.

Insert file name only, not path

proj_wawf_info

wawf_attachment

The file creation will use the attachment file name that the user entered in the subtask of the invoice type or we will use the invoice id if that option is selected.

Enter a file attachment name or select to use the invoice ID as the attachment name in the CV subtask.

SEPARATOR OR END

Separator or End

5/11

Use =SEPARATOR= to signal that there are more documents in the file. Use =END= to signal 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.

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

User ID responsible for submitting file to WAWF

WAWF User ID

Create WAWF Billing Files (Projects » Billing » Print Billings)

Enter the User ID in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

Enter the User ID in the User ID field.

Form Type

2/5

CI 2N1 - Commercial Invoice/Fast Pay

CI2N1

proj_wawf_info

wawf_invc_type_cd

Select the Form Type in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the 2N1 option.

Contract Number

1/19

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 in the Maintain Project Master screen (Projects » Project Setup » Project Master).

Enter the Contract Number in the Prime Contract No field.

Delivery Order Number

4/17

bill_edit_invc_hdr

cust_po_id

Enter the Delivery Order Number in the Maintain Project Master screen (Projects » Project Setup » Project Master).

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 in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

The Foreign Currency Code is entered in the Billing Currency field in the Currency Info group box.

Shipment Number

2/22

The Shipment Number will be converted to upper case.

bill_edit_invc_hdr

bill_no_id

The shipment number will be represented as the bill number. The last bill number used is entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). The Calculate Billings screen (Projects » Billing » Calculate Billings) increments this number by one and populates the file with this incremented number.

The bill number is computed during the Calculate Billings process (Projects » Billing » Calculate Billings) but can be changed in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Shipment Date

8/8

This Field is mandatory if the Shipment Number, Field 1, is entered.

bill_edit_invc_hdr

invc_dt

The Shipment Date is the invoice date. The invoice date will be the system date the invoice was computed.

The invoice date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

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 if the Shipment is the Final Shipment. Enter a capitalized Y for Yes or N for No. WAWF will default to N if left blank.

proj_wawf_info

wawf_last_ship_fl

The check box indicating that this shipment was the final shipment is located in the 2N1 subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Final Shipment option in the 2N1 subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Invoice Number

1/22

The invoice number will be converted to upper case.

bill_edit_invc_hdr

bill_no_id

The last Bill Number used is entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). The Calculate Billings screen (Projects » Billing » Calculate Billings) increments this number by one and populates the file with this incremented number.

The Bill Number is computed during the Calculate Billings process (Projects » Billing » Calculate Billings).

Invoice Date

8/8

CCYYMMDD

bill_edit_invc_hdr

invc_dt

The Invoice Date will be the system date the invoice was computed.

The Invoice Date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Final Invoice

1/1

Identifies if 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 was the final invoice is located in the 2N1 subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The check box indicating that this invoice was the final invoice is located in the 2N1 subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

5/5

proj_wawf_info

wawf_sender_cage_cd

The Prime Contractor CAGE Code is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Prime Contractor CAGE Code is entered in the CAGE Code field in the Sender Information group box.

CAGE Extension

1/6

Must be left blank if Prime Contractor CAGE is not entered.

proj_wawf_info

wawf_cage_ext_cd

The Prime Contractor CAGE Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

The Administration DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Administration DoDAACs is entered 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

The Inspect by DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By DoDAAC is entered in the Inspected By field in the DoDAACs group box.

Inspect by Extension

1/6

If Inspect By was not used, then this field must be left blank. If Inspect by is entered, then this field is optional.

proj_wawf_info

inspect_ext_cd

The Inspect by Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By Extension is entered in the Inspected By extension field in the DoDAACs group box.

Ship from CAGE/DoDAAC

5/6

If Ship From doesn't differ from the contractors Prime CAGE Code, Line 9, then this Field may be blank.

proj_wawf_info

wawf_ship_from_id

The Ship From CAGE/DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship From CAGE/DoDAAC is entered 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

The Payment Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Payment Office DoDAAC is entered 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

The Ship To/Service Acceptor DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship To/Service Acceptor DoDAAC is entered in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.

Ship To Extension

1/6

If Ship To was not used, then this field must be left blank. If Ship To is entered, then this field is optional.

proj_wawf_info

ship_to_ext_cd

The Ship To/Service Acceptor Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship To/Service Acceptor Extension is entered 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

The Local Processing Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office DoDAAC is entered in the Local Processing Office field in the DoDAACs group box.

Local Processing Office Extension

1/6

If Local Processing Office was not used, then this field must be left blank. If Local Processing Office is entered, then this field is optional.

proj_wawf_info

local_proc_ext_cd

The Local Processing Office Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office Extension is entered in the Local Processing Office extension field in the DoDAACs group box.

Line Item

AN/ID

1/6

This Field may contain a CLIN, SLIN, Tax Code, or Miscellaneous Fee / Charge/Allowance.

Truncate to six.

bill_edit_detl

clin_id or price_catlg_cd

Within the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the user can select among three CLIN Mapping Methods. If Default CLIN is selected, all billed amounts will be grouped into the entered CLIN. If Use ACRN Mapping is selected, the mapping from the Maintain ACRN Bills screen (Projects » Billing » Billing Master) will be used and the CLIN will come from PROJ_ACRN_DETL.acrn_ln_item. If CLIN Mapping is selected, the user will be required to map projects to CLINs (PROJ_WAWF_CLIN.clin_id). It will be an option whether the user needs to 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 will be grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they will be grouped within the file based on the CLIN or catalog charged at transaction. The user will have the ability to 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 in the Header of the Edit Standard Bills screen (Projects » Billing » Edit Billings) will be inserted as a line item 2 and the other charge code will be in the field.

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 will be 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 will be combined within the CLIN if Default CLIN or CLIN Mapping is used. If ACRN mapping is used, discounts and taxes will always be 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/25

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. 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

Product Service Type

2/2

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

If N./A, then insert blank

Other SB Attachment

Product Service Type

16A

Description

1/75

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. 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 Maintain ACRN Bills screen (Projects » Billing » Billing Master), or the CLIN in the CLIN Mapping subtask in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If Line Item Type = 2, 3, or 4, this field will not be populated. If this is a Units billing, the Description is entered in the Maintain Parts (Materials » Product Definition » Part Master), Goods (Materials » Product Definition) or Services (Materials » Product Definition) screens and will be used if only one item is grouped within the CLIN.

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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

SDN

13/15

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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

ACRN Price

R9.2

1/15

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

The current ACRN allocation amount is populated by the Calculate ACRN Billings process (Projects » Billing » Calculate Billings).

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 mandatory. If Line 15, Field 2 is not a 1, skip this line

Allows 8 before the decimal and 2 after (10,2).

Other SB Attachment

Quantity Shipped

If Combine Units by Transaction CLIN is selected in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the file creation process for units billings populates this field with the number of units entered through the Enter Unit Usage screen (Projects » Billing » Units Usage) or the Upload Unit Usage Data screen (Projects » Billing » Units Usage), posted via the Post Unit Usage screen (Projects » Billing » Units Usage), and Calculated through the Calculate Billings process (Projects » Billing » Calculate Billings). If Map Units by Account is selected in Maintain Project WAWF Info, the billed units will be 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 = 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.

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 mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

Unit of Measure

Unit Price

R9.5

1/16

14,4

if Line Item Type is 2, 3, or 4, the field size is 11,2.

Other SB Attachment

Unit Price

Issue By DoDAAC

6/6

proj_wawf_info

wawf_issue_id

Issue By DoDAAC is entered in the DoDAACs group box of the the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Issue By DoDAAC is entered in the Issued 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

Initiator Comments are entered in the Header subtask of the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Initiator Comments are entered in the Bill Heading field of the Edit Standard Bills screen (Projects » Billing » Edit Billings) and must be entered if there was 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 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 will be Y.

Attachment Files

1/100

100

If the Attachment in Line Number 25, Field 1, is Y then this Field is mandatory. This Field will contain the name of the file to be attached to the document.

Insert file name only, not path

proj_wawf_info

wawf_attachment

The file creation will use the attachment file name that the user entered in the subtask of the invoice type or we will use the invoice id if that option is selected.

Enter a file attachment name or select to use the invoice ID as the attachment name in the CV subtask.

SEPARATOR OR END

Separator or End

5/11

Use =SEPARATOR= to signal that there are more documents in the file. Use =END= to signal 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.

Combo

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

User ID responsible for submitting file to WAWF

WAWF User ID

Create WAWF Billing Files (Projects » Billing » Print Billings)

Enter the User ID in the Create WAWF Billing Files screen (Projects » Billing » Print Billings).

Enter the User ID in the User ID field.

Form Type

5/5

COMBO

proj_wawf_info

wawf_invc_type_cd

Select the Form Type in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the COMBO option.

Contract Number

1/19

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 in the Maintain Project Master screen (Projects » Project Setup » Project Master).

Enter the Contract Number in the Prime Contract No field.

Delivery Order Number

1/17

bill_edit_invc_hdr

cust_po_id

Enter the Delivery Order Number in the Maintain Project Master screen (Projects » Project Setup » Project Master).

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

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 in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

The Foreign Currency Code is entered in the Billing Currency field in the Currency Info group box.

Shipment Number

2/22

The Shipment Number will be converted to upper case.

bill_edit_invc_hdr

bill_no_id

Shipment Date

8/8

CCYYMMDD

bill_edit_invc_hdr

invc_dt

The Shipment Date is the invoice date. The invoice date will be the system date the invoice was computed.

The invoice date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Estimated Shipment Date Indicator

1/1

Identifies if Shipment Date is estimated or not. Enter a capitalized E if date is Field 2 is an Estimated Shipment Date. If not, leave blank.

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 if the Shipment is the Final Shipment. Enter a capitalized Y for Yes or N for No. WAWF will default to N if left blank.

proj_wawf_info

wawf_last_ship_fl

The check box indicating that this shipment was the final shipment is located in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Final Shipment option in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Services or Supplies

3/3

SPL for supplies or SVC for services must be capitalized.

proj_wawf_info

wawf_supply_svc_cd

The user indicates whether this invoice is for services or for supplies in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The user indicates this invoice is for services or for supplies by selecting the services or supplies option in the Type group box.

Bill of Lading

1/30

Not used

If the invoice is not a fast pay invoice, do not create line 4

TCN

1/30

N/A

Not used

First Line Haul Mode

1/1

Used only for Fast Pay Invoices for MOCAS.

proj_wawf_info

wawf_ln_haul_cd

This field will be available for entry in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master) if invoice is a fast pay.

Enter the first line haul mode in the COMBO subtask. See the WAWF Interface Design Document (IDD) for acceptable values.

Discount Percent

This field must be blank if Discount Amount, Discount Date, or Net Days is entered.

blank

If the invoice is not a fast pay invoice, do not create line 5

Due Days

If Discount Percent is entered, this field is mandatory.

blank

Discount Amount

If Discount Percent, Due Days, or Net Days is entered this field must be blank.

blank

Discount Date

If the Discount Amount is entered this field is mandatory.

blank

Discount Type

If data is entered in fields 1 and 2, or 3 and 4, this field will default 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 in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the Fast Pay Invoice option in the COMBO subtask

Net Days

If Discount Percent or Discount Amount is entered this field must be blank.

blank

Invoice Number

1/22

The invoice number will be converted to upper case.

bill_edit_invc_hdr

invc_id

The last Company Wide Invoice Number, from which the current invoice number will be created, is stored in the Last Company Wide Invoice No field.

Invoice Date

8/8

CCYYMMDD

bill_edit_invc_hdr

invc_dt

The Invoice Date will be the system date the invoice was computed.

The Invoice Date can be edited in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

Final Invoice

1/1

Identifies if 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 was the final invoice is located in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The check box indicating that this invoice is the final invoice is located in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Vendor's Invoice Number

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.

Inspection Point

1/1

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 in the Combo subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the option for the Inspection Point in the Inspection group box.

Acceptance Point

1/1

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 in the Combo subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the option for the Acceptance Point in the Acceptance group box.

Prime Contractor CAGE

5/5

proj_wawf_info

wawf_sender_cage_cd

The Prime Contractor CAGE Code is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Prime Contractor CAGE Code is entered in the CAGE Code field in the Sender Information group box.

CAGE Extension

1/6

Must be left blank if Prime Contractor CAGE is not entered.

proj_wawf_info

wawf_cage_ext_cd

The Prime Contractor CAGE Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

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

The Administration DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Administration DoDAACs is entered in the Administration field in the DoDAACs group box.

10B

Inspect by DoDAAC

6/6

If the Inspection Point in Line 8, Field 1, is S, this Field is required.

proj_wawf_info

wawf_inspect_id

The Inspect by DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By DoDAAC is entered in the Inspected By field in the DoDAACs group box.

Inspect by Extension

1/6

If Inspect By was not used, then this field must be left blank. If Inspect by is entered, then this field is optional.

proj_wawf_info

inspect_ext_cd

The Inspect by Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Inspect By Extension is entered in the Inspected By Extension field in the DoDAACs group box.

Ship from CAGE/DoDAAC

5/6

If Ship From doesn't differ from the contractors Prime CAGE Code, Line 9, then this Field may be blank.

proj_wawf_info

wawf_ship_from_id

The Ship From CAGE/DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship From CAGE/DoDAAC is entered in the Ship From field in the DoDAACs group box.

Ship from extension

1/6

If Ship From CAGE/DoDAAC was not entered, then this Field must be left blank. If Ship From CAGE/DoDAAC is entered, then this Field is optional.

proj_wawf_info

ship_from_wxt_cd

The Ship From CAGE/DoDAAC Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Ship From Extension in the Ship From extension field in the DoDAACs group box.

FOB

1/1

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 in the Combo subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Select the option for the FOB in the FOB group box.

Payment Office DoDAAC

6/6

proj_wawf_info

wawf_pmt_office _id

The Payment Office DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Payment Office DoDAAC is entered in the Payment Office field in the DoDAACs group box.

Ship To CAGE/DoDAAC

5/6

If Inspection Point in Line 8, Field 1, is S and Acceptance Point in Line 8, Field 2, is S, then CAGE is permitted. Otherwise, this must be a DoDAAC.

proj_wawf_info

wawf_ship_to_id

The Ship To/CAGE DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship To/CAGE DoDAAC is entered in the Contracting Officer/Ship To/Service Acceptor field in the DoDAACs group box.

Ship To Extension

1/6

If Ship To was not used, then this field must be left blank. If Ship To is entered, then this field is optional.

proj_wawf_info

ship_to_ext_cd

The Ship To/Service Acceptor Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Ship To/Service Acceptor Extension is entered 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

The Local Processing Office DoDAAC is entered in the Maintain Project WAWF Information screen.

The Local Processing Office DoDAAC is entered in the Local Processing Office field in the DoDAACs group box.

Local Processing Office Extension

1/6

If Local Processing Office was not used, then this field must be left blank. If Local Processing Office is entered, then this field is optional.

proj_wawf_info

local_proc_ext_cd

The Local Processing Office Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Local Processing Office Extension is entered in the Local Processing Office extension field in the DoDAACs group box.

13D

3rd Party -Other Office DODAAC

6/6

Must be entered if line 8, Fields 1 or 2 were OTHER.

proj_wawf_info

wawf_inspect_other or wawf_accept_other

Enter the 3rd Party-Other Office DoDAAC in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the 3rd Party-Other Office DoDAAC in the Other field of the Inspection Point group box or the Acceptance Point group box.

3rd Party - Other Office Extension

1/6

If 3rd Party - Other Office DoDAAC was not used, then this field must be left blank. If 3rd Party - Other Office DoDAAC is entered, then this field is optional.

proj_wawf_info

inspect_other_ext_cd or accept_other_ext_cd

Enter the 3rd Party-Other Office Extension in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the 3rd Party-Other Office Extension in the Other Extension field of the Inspection Point group box or the Acceptance Point group box.

Mark For Delivery DoDAAC

5/6

proj_wawf_info

wawf_mark_deliv_id

The Mark For Delivery DoDAAC is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Mark For Delivery DoDAAC is entered in the Mark For Delivery field in the DoDAACs group box.

Mark For Delivery Extension

1/6

If Mark for Delivery was not used, then this field must be left blank. If Mark for Deliver is entered, then this field is optional.

proj_wawf_info

mark_deliv_ext_cd

The Mark for Delivery Extension is entered in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Mark for Delivery Extension is entered in the Mark for Delivery extension field in the DoDAACs group box.

Mark For Delivery Representative

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.

14B

Mark For Delivery Comments

1/75

proj_wawf_info

wawf_comments

The Mark For Delivery Comments are entered in the Combo subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

14C

Mark For Delivery Secondary Comments

1/75

proj_wawf_info

wawf_2nd_comments

The Mark For Delivery Secondary Comments are entered in the Combo subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Line Item

AN/ID

1/6

This Field may contain a CLIN, SLIN, Tax Code, or Miscellaneous Fee / Charge/ Allowance.

Truncate at six.

Other SB Attachment

Line Item

Within the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the user can select among three CLIN Mapping Methods. If Default CLIN is selected, all billed amounts will be grouped into the entered CLIN. If Use ACRN Mapping is selected, the mapping from the Maintain ACRN Bills screen (Projects » Billing » Billing Master) will be used and the CLIN will come from PROJ_ACRN_DETL.acrn_ln_item. If CLIN Mapping is selected, the user will be required to map projects to CLINs (PROJ_WAWF_CLIN.clin_id). It will be an option whether the user needs to 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 will be grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they will be grouped within the file based on the CLIN or catalog charged at transaction. The user will have the ability to 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 in the Header of the Edit Standard Bills screen (Projects » Billing » Edit Billings) will be inserted as a line item 2 and the other charge code will be in the field.

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.

GFE

1/1

N/A

This Field cannot be entered unless the Line Item Type in Field 2 is a 1 (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/25

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. 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

Product Service Type

2/2

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

Product Service Type

16A

Description

1/75

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

Description

If the mapping method is Use ACRN Mapping, the CLIN is populated as the line item in the CTW of the Maintain ACRN Bills screen (Projects » Billing » Billing Master). If Default CLIN is used, populate the CLIN in the default CLIN field in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master). If CLIN Mapping is used, populate the CLIN in 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

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

SDN

13/15

Process does not populate this field

blank

not populated

16D

UID Type

3/5

16D -16F is considered a loop within loop 15 - Enter UID1, UID2, ESN, GIAI, GRAI, OTHER, or VIN (see WAWF 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
then pull info for
item from PROJ
_WAWF_UID
_DETL for this loop.
If no join is found,
the skip 16D.

proj_wawf_uid

wawf_uid_type_cd

Enter the UID Type in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter or selects a drop-down value for the UID Type in the UID Type column in the UID Information group box.

Issuing Agency Code

1/3

IAC is required if UID Type is UID1 or UID2.

proj_wawf_uid

wawf_uid_iac_cd

Enter the Issuing Agency Code in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Issuing Agency Code in the IAC column of the UID Information group box. See WAWF Interface Control Document Appendix K for valid codes.

Enterprise Identifier

5/13

Enterprise Identifier is required if UID Type is UID1 or UID2. If EID is entered, then IAC is mandatory.

proj_wawf_uid

wawf_uid_eid_cd

Enter the Enterprise Identifier in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Enterprise Identifier in the Enterprise Identifier column in the UID Information group box. See WAWF Interface Control Document Appendix K for valid codes.

Original Part Number

1/32

Original Part Number is required if UID Type is UID2 and Batch and Lot Number is not entered.

proj_wawf_uid

wawf_uid_part_id

Enter the Original Part Number in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Original Part Number in the Part No. column of the UID Information group box.

Batch and Lot Number

1/20

blank

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

Unit Price

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.

Unit of Measure

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.

Miscellaneous

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.

Current Part Number

1/32

blank

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

Current part Number Cost

R9.2

1/16

blank

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

Current Part Number Effective Date

8/8

blank

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

Original Manufacturer's Code

1/3

blank

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

Original Manufacturer's ID

5/13

blank

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

16F

16D

UID - Unique Identifier

1/78

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 in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the UID - Unique Identifier in the Unique Identifier column of the UID Information group box.

16D

UID - Serial Number

1/30

proj_wawf_uid_detl

wawf_uid_serial_no

Enter the UID - Serial Number in the UID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the UID - Serial Number in the UID Serial No column of the UID Information group box.

16G

ACRN

2/2

Use this field to report multiple ACRNs per line item.

proj_acrn_detl

acrn_id

Enter the ACRN in the child table window in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

ACRN Price

R9.2

1/15

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).

The current ACRN allocation amount is populated by the Calculate ACRN Billings process (Projects » Billing » Calculate Billings).

Quantity Shipped / Invoiced or Provided Information

R8.2

1/11

14,4

If UID Information is entered in Line 16D or 16F, then this field must be a whole number. If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. 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 in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the file creation process for units billings populates this field with the number of units entered through the Enter Unit Usage screen (Projects » Billing » Units Usage) or the Upload Unit Usage Data screen (Projects » Billing » Units Usage), posted via the Post Unit Usage screen (Projects » Billing » Units Usage), and Calculated through the Calculate Billings process (Projects » Billing » Calculate Billings). If Map Units by Account is selected in the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master), the billed units will be 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 = 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.

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

1/8

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, then this field is mandatory. Actual Quantity cannot be negative and if no Quantity is sent, then this Field should be zero or blank.

blank

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

Unit of Measure Code

2/2

If the Line Item Type in Line Number 15, Field 2, is 1, this Field is mandatory. If Line 15, Field 2 is not a 1, skip this line

Other SB Attachment

Unit of Measure

Unit Price

R9.6

1/16

14,4

if Line Item Type is 2, 3, or 4, the field size is 11,2.

Other SB Attachment

Unit Price

Issue By DoDAAC

6/6

proj_wawf_info

wawf_issue_id

Issue By DoDAAC is entered in the DoDAACs group box of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The Issue By DoDAAC is entered in the Issued By field in the DoDAACs group box.

21A

ARP - Alternate Release Procedure

1/1

Enter a capitalized Y for Yes, or N for No. If left blank, will default to N. ARP is only allowed for Source/Source and Source/Destination documents.

proj_wawf_info

wawf_arp_fl

The ARP - Alternate Release Procedure check box is located in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The ARP - Alternate Release Procedure check box is located in the COMBO subtask.

COC - Certificate of Conformance

1/1

Enter a capitalized Y for Yes, or N for No. If left blank, will default to N.

proj_wawf_info

wawf_cert_fl

The COC - Certificate of Conformance check box is located in the COMBO subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

The COC - Certificate of Conformance check box is located in the COMBO subtask.

Construction Certificate

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.

Initiator Comments

1/80

254

bill_edit_invc_hdr

bill_desc

Initiator Comments are entered in the Header subtask of the Edit Standard Bills screen (Projects » Billing » Edit Billings).

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 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 will be Y.

Attachment Files

1/100

100

If the Attachment in Line Number 25, Field 1, is Y, this Field is mandatory. This Field will contain the name of the file to be attached to the document.

Insert file name only, not path

proj_wawf_info

wawf_attachment

The file creation will use the attachment file name that the user entered in the subtask of the invoice type or we will use the invoice id if that option is selected.

Enter a file attachment name or select to use the invoice ID as the attachment name in the CV subtask.

Tag Type

4/4

Enter RFID when RFID tag data is going to be reported. If RFID is entered in Field 1, then RFID Tag Data must be reported in Field 2.

If more than one row is entered in proj_wawf_info, the additional lines should identified as 28A, 28B, etc.

proj_wawf_rfid

wawf_rfid_tag_cd

Enter the Tag Type in the RFID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Tag Type in the Tag Type column of the RFID Information group box.

Tag ID

4/64

Enter RFID Tag Data. Must be 16, 24, 32, or 64 characters. Characters allowed will be 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 in the RFID Information subtask of the Maintain Project WAWF Information screen (Projects » Project Setup » Project Master).

Enter the Tag ID in the Tag ID column of the RFID Information group box.

CLIN

4/6

Line 29 is mandatory if Line 28 is reported or if Line 15, field 2 is a 1.

Line 29 and 30are a loop.

All CLINs reported in the file must be reported in this field.

Quantity

R8.2

1/11

14,4

The number of UIDs reported must match the quantity reported here

The quantity reported for each CLIN must be reported in this field.

UID - Unique Identifier

1/78

The Unique Identifier that ensures 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 will be reported here directly below the item to which the UID relates.

SEPARATOR OR END

Separator or End

5/11

Use =SEPARATOR= to signal that there are more documents in the file. Use =END= to signal 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.