FTP FILE LAYOUTS — OTHER — PROJECT PRODUCT BILLS — 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

1

Form Counter

N

1/3

M

Number of transactions within the file.

No. of A records.

The file creation process populates this field with the number of invoices in the file.

A

1

User ID

AN

8/30

20

M

WAWF User ID

WAWF User ID

Create WAWF Billing Files screen

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

Enter the user ID in the User ID field.

B

1

Form Type

ID

5/5

5

M

COMBO

COMBO

proj_wawf_info

wawf_invc_type_cd

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

Select the COMBO option.

1

1

Contract Number

AN

13/13

20

M

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

proj

prime_contr_id

Enter the contract number on the Manage Project User Flow screen.

Enter the contract number in the Prime Contract No field.

2

Delivery Order Number

AN

0/4

20

C

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.

proj_prod_invc_hdr

cust_po_id

Enter the delivery order Number on the Manage Project Product Bills screen.

Enter the delivery order number in the Purchase Order No field.

3

Issue Date

DT

8/8

O

CCYYMMDD

Blank

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

4

Task Order

AN

1/30

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.

1A

1

Foreign Currency Code

AN

3/3

3

O

proj_prod_invc_hdr

trn_crncy_cd

The Foreign Currency Code defaults from the Manage Project Billing Information screen but can be edited on the Exchange Rates subtask.

2

1

Shipment Number

AN

2/22

15

M

The shipment number is converted to upper case.

proj_prod_invc_hdr

bill_no_id

The shipment number is represented as the bill number. Enter the bill number on the Address Info tab of the Manage Project Product Bills screen.

You can edit the bill number on the Address Info tab of the Manage Project Product Bills screen.

2

Shipment Date

DT

8/8

M

CCYYMMDD

proj_prod_invc_hdr

invc_dt

The Shipment Date is the date on which the invoice was entered. 

You can edit the invoice date on the Manage Project Product Bills screen.

3

Estimated Shipment Date Indicator

ID

1/1

O

Identifies whether the shipment date is estimated or not. Enter a capitalized E if date in 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.

4

Final Shipment

ID

1/1

1

M

Identifies whether the shipment is the final shipment. Enter a capitalized Y for Yes or N for No. 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.

If this is a Y, the shipment number must have a Z as the eighth character.

3

1

Services or Supplies

ID

3/3

3

M

SPL for supplies or SVC for services; must be capitalized.

proj_wawf_info

wawf_supply_svc_cd

Indicate whether this invoice is for services or for supplies on the Manage Project WAWF Information screen.

Indicate whether this invoice is for services or for supplies by selecting the Services or Supplies option in the Type group box.

4

1

Bill of Lading

AN

1/30

O

Not used.

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

The file creation process does not populate this field.

2

TCN

AN

1/30

N/A

Not used.

The file creation process does not populate this field.

3

Transportation Method/Type

ID

1/1

1

M

Used only for fast pay invoices for MOCAS.

proj_wawf_info

wawf_ln_haul_cd

This field is on the Manage Project WAWF Information screen if invoice is a fast pay.

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

4

Bill of Lading Type Indicator

N/A

N/A

N/A

Not used.

Blank

5

Serial Shipping Container Code

N

18/18

O

Blank

6

Transportation Later Indicator

AN

1/1

O

Enter Y (Yes) to indicate that transportation data will be submitted later. Valid values are Y (Yes), N (No), and blank.

Blank

5

1

Discount Percent

O

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

Blank

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

The file creation process does not populate this field.

2

Due Days

C

If the Discount Percent is entered, this field is required.

Blank

The file creation process does not populate this field.

3

Discount Amount

O

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

Blank

The file creation process does not populate this field.

4

Discount Date

C

If the Discount Amount is entered, this field is required.

Blank

The file creation process does not populate this field.

5

Discount Type

C

If data is entered in fields 1 and 2, or 3 and 4, this field defaults to the appropriate value. For fast pay invoices, insert 21.

21 if wawf_fast_pay_fl = Y.

proj_wawf_info

wawf_fast_pay_fl

Select the Fast Pay Invoice option on the Manage Project WAWF Information screen.

Select the Fast Pay Invoice option.

6

Net Days

O

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

Blank

The file creation process does not populate this field.

6

1

Invoice Number

AN

1/22

15

M

The invoice number is converted to upper case.

proj_prod_invc_hdr

bill_no

Enter the invoice number on the Address Info tab of the Manage Project Product Bills screen.

Enter the invoice number in the Bill Number field.

2

Invoice Date

DT

8/8

M

CCYYMMDD

proj_prod_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 Project Product Bills screen.

3

Final Invoice

ID

1/1

1

M

Identifies whether the invoice is a final invoice. Enter a capitalized Y for Yes or N for No. This field is used only if an Invoice Number is submitted in Field 1.

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.

4

Vendor's Invoice Number

AN

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.

8

1

Inspection Point

ID

1/1

1

M

Enter a capitalized S for Source, D for Destination, or O for Other.

proj_wawf_info

wawf_inspect_pt_cd

Select the option for the inspection point on the Manage Project WAWF Information screen.

Select the option for the inspection point in the Inspection group box.

2

Acceptance Point

ID

1/1

1

M

Enter a capitalized S for Source, D for Destination, or O for Other.

proj_wawf_info

wawf_accept_pt_cd

Select the option for the acceptance point on the Manage Project WAWF Information screen.

Select the option for the acceptance point in the Acceptance group box.

9

1

Prime Contractor CAGE/DUNS/DUNS+4

AN

5/13

13

M

proj_wawf_info

wawf_send_cage_cd

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

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

2

CAGE Extension

AN

1/6

O

Must be 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 extension field in the Sender Information group box.

10

1

Administration DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_admin_id

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

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

10B

1

Inspect by  DoDAAC

AN

6/6

6

C

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

proj_wawf_info

wawf_inspect_id

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

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

2

Inspect by Extension

AN

1/6

C

If the Inspect by  DoDAAC is not used, this field must be left blank. If the Inspect by DoDAAC is entered, 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.

11

1

Ship From CAGE / DUNS / DUNS+4/ DoDAAC

AN

5/13

13

O

If the Ship from CAGE/DoDAAC doesn't differ from the Prime Contractor CAGE code, Line 9, this field may be blank.

proj_wawf_info

wawf_ship_from_id

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

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

2

Ship from extension

AN

1/6

C

If a Ship From CAGE/DoDAAC is blank, this field must be left blank. If the Ship From CAGE/DoDAAC is supplied, this field is optional.

proj_wawf_info

ship_from_wxt_cd

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

Enter the ship from extension in the Ship From extension field in the DoDAACs group box.

3

FOB

AN

1/1

1

M

Enter a capitalized S for Source or D for Destination or O for Other.

proj_wawf_info

wawf_fob_cd

Select the option for the FOB on the Manage Project WAWF Information screen.

Select the FOB option in the FOB group box.

12

1

Payment Office DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_pmt_office _id

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

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

13

1

Ship To CAGE / DUNS / DUNS+4/ DoDAAC / Contractor DoDAAC

AN

5/13

13

M

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

proj_wawf_info

wawf_ship_to_id

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

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

2

Ship To Extension

AN

1/6

O

If the Ship To CAGE/DoDAAC is blank, this field must be left blank. If a Ship To CAGE/DoDAAC is supplied, 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

1

Local Processing Office DoDAAC

AN

6/6

6

O

proj_wawf_info

wawf_local_proc_id

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

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

2

Local Processing Office Extension

AN

1/6

C

If the Local Processing Office DoDAAC is blank, this field must be left blank. If a Local Processing Office DoDAAC is supplied, 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.

13D

1

3rd Party -Other Office DODAAC

AN

6/6

O

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

proj_wawf_info

wawf_inspect_other or wawf_accept_other

Enter the 3rd party—other office DoDAAC on the Manage Project WAWF Information screen.

Enter the 3rd party—other office DoDAAC in the Other field of the Inspection Point group box or the Acceptance Point group box.

2

3rd Party - Other Office Extension

AN

1/6

C

If the 3rd Party — Other Office DoDAAC is blank, this field must be left blank. If a 3rd Party — Other Office DoDAAC is supplied, this field is optional.

proj_wawf_info

inspect_other_ext_cd or accept_other_ext_cd

Enter the 3rd party—other office extension on the Manage Project WAWF Information screen.

Enter the 3rd party—other office extension in the Other extension field of the Inspection Point group box or the Acceptance Point group box.

14

1

Mark For Delivery CAGE/ DUNS / DUNS+4 / DoDAAC

AN

5/13

13

O

proj_wawf_info

wawf_mark_deliv_id

Enter the mark for delivery DoDAAC on the Manage Project WAWF Information screen.

Enter the mark for delivery DoDAAC in the Mark For Delivery field in the DoDAACs group box.

2

Mark For Delivery Extension

AN

1/6

C

If the Mark for Delivery is  blank, this field must be left blank. If a Mark for Delivery is entered, this field is optional.

proj_wawf_info

mark_deliv_ext_cd

Enter the mark for delivery extension on the Manage Project WAWF Information screen.

Enter the mark for delivery extension n the Mark for Delivery extension field in the DoDAACs group box.

3

Mark For Delivery Representative

AN

1/50

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.

The file creation process does not populate this field.

14B

1

Mark For Delivery Comments

AN

1/75

75

O

proj_wawf_info

wawf_mark_deliv_comments

Enter mark for delivery comments on the Manage Project WAWF Information screen.

Enter mark for delivery comments in the Mark for Delivery Comments field.

14C

1

Mark For Delivery Secondary Comments

AN

1/75

75

O

proj_wawf_info

wawf_mark_2nd_comments

Enter mark for delivery secondary comments on the Manage Project WAWF Information screen.

Enter mark for delivery secondary comments in the Mark for Delivery Secondary Comments field.

15

1

15

Line Item

AN/ID

2/6

10

M

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

Truncate to six characters.

proj_prod_invc_ln

Enter the line item, CLIN, or catalog on the Manage Project Product Bills screen. If both are left blank and these are not other charges, the Default CLIN from the Manage Project WAWF Information screen is used. If that does not exist, the Item Selling Description is used. Enter the line item for other charges on the Other Info tab of the Manage Project Product Bills screen.

Enter the line item, CLIN, or catalog in the CLIN or Catalog columns. If there is no CLIN/SLIN or catalog and these are not other charges, the Default CLIN from the Manage Project WAWF Information screen is used. If that does not exist, the Item Selling Description is used. Enter the line item for other charges in the Code column of the Other Charges group box. Be sure to enter an acceptable code for your payor and invoice type.

2

15

Line Item Type

ID

1/1

1

M

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

proj_prod_invc_ln

line_item_type_cd

This  populates with a 1 unless other charges are entered, in which case the value is a 2, discounts are a 3, and taxes are a 4. If Include Discounts and Taxes in CLIN is selected on the Manage Project WAWF Information screen, any discounts and taxes are included with the billed amounts.

3

15

GFE

ID

1/1

1

N/A

This field cannot have a value unless the Line Item Type in Field 2 is a 1 (CLIN/SLIN). Optional even if CLIN/SLIN per telcon with WAWF.

Blank

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

16

1

15

Stock Number

AN

1/32

20

C

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

proj_prod_invc_ln

stock_no or "NONE" if there is no stock number.

The Stock Number is populated with the PART.nsn_id (if one exists), or is populated with NONE if no item is entered. This line is not populated if the Line Item Type is 2, 3, or 4.

2

15

Product Service Type

ID

2/2

2

C

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

proj_prod_invc_ln

prod_svc_type_cd

If an item is entered and a stock number exists, the Product Service Type is populated with FS. If no stock number exists or no item is entered, the Product Service Type is MG. This field does not populate for other charges, taxes, or discounts.

16A

1

15

Description

AN

1/75

60

C

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

proj_prod_invc_ln

item_selling_desc

Enter the description on the Manage Parts, Manage Goods, or Manage Services screens for any items that are billed. If no items are billed, the description comes from the Item Selling Description.

Enter the description in the Desc field in the Basic Characteristics group box for Parts, and in the Description field for Goods and for Services. You can edit this description in the Item Selling Description field. If no item is billed, this field is populated by the value in the Item Selling Description field.

16B

1

15

ACRN

AN

2/2

2

C

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

Generate line 16B only if there is only one row in proj_prod_acrn.

proj_prod_acrn

acrn_cd

Enter the ACRN on the ACRNs subtask of the Manage Project Product Bills screen.

Enter the ACRN in the ACRN field. If there is only one ACRN for a CLIN/SLIN, this field displays the ACRN. Otherwise, this field is not populated.

2

15

SDN

AN

1/30

30

C

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

Generate line 16B only if there is only one row in proj_prod_acrn.

proj_prod_acrn

sdn_cd

Enter the SDN on the ACRNs subtask of the Manage Project Product Bills screen.

3

15

AAA

AN

6/6

O

The process does not populate this field.

Blank

Not populated.

16C

1

15

MILSTRIP Number

AN

1/15

15

C

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

proj_prod_milstrip

milstrip_no

Enter the MILSTIP number on the MILSTRIPs subtask of the Manage Project Product Bills screen.

No duplicates are allowed.

2

15

MILSTRIP Quantity

N

1/11

14,4

C

This field is required if a MILSTRIP Number is supplied.

proj_prod_milstrip

milstrip_qty

Enter the MILSTIP quantity on the MILSTRIPs subtask of the Manage Project Product Bills screen.

The sum of the quantities entered must match the quantity shipped in Line 17, field 1.

16D

1

15

UID Type

AN

3/4

5

M

16D — 16F is considered a loop within loop 15 — Enter UID1, UID2, ESN, GIAI, GRAI, OTHER, VIN.

Join the PROJ_PROD_INVC_LN.item_id to PROJ_WAWF_UID_DETL.wawf_item_id. If there is a join, pull information for item from PROJ_WAWF_UID_DETL for this loop. If no join is found, skip 16D.

proj_wawf_uid

wawf_uid_type_cd

Enter the UID type on the UID Information subtask of the Manage Project WAWF Information screen.

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

2

15

Issuing Agency Code

AN

1/2

3

C

proj_wawf_uid

wawf_uid_iac_cd

Enter the issuing agency code on the UID Information subtask of the Manage Project WAWF Information screen.

Enter the issuing agency code in the IAC column of the UID Information group box. See the WAWF Interface Control Document Appendix K for valid codes.

3

15

Enterprise Identifier

AN

4/9

13

C

proj_wawf_uid

wawf_uid_eid_cd

Enter the enterprise identifier on the UID Information subtask of the Manage Project WAWF Information screen.

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

4

15

Original Part Number

AN

1/32

32

O

proj_wawf_uid

wawf_uid_part_id

Enter the original part number on the UID Information subtask of the Manage Project WAWF Information screen.

Enter the original part number in the Part No. column of the UID Information group box.

5

15

Batch and Lot Number

AN

1/20

O

Blank

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

6

15

Unit Price

N/A

Not used.

Blank

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

7

15

Unit of Measure

N/A

Not used.

Blank

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

8

15

Miscellaneous

N/A

Not used.

Blank

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

9

15

Current Part Number

AN

1/16

O

Blank

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

10

15

Current part Number Cost

R9.2

1/16

C

Blank

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

11

15

Current Part Number Effective Date

N

8/8

C

Blank

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

12

15

Original Manufacturer's Code

AN

1/3

O

Blank

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

13

15

Original Manufacturer's ID

AN

4/9

C

Blank

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

14

15

Warranty Indicator

AN

1/1

O

Valid values are Y (Yes), N (No), and blank. If the value is unknown, this field must be left blank.

Blank

15

15

Not used.

N/A

N/A

Not used.

Blank

16

15

Special Tooling/ Special Test Equipment

AN

2/3

O

Valid values are ST (Special Tooling), STE (Special Test Equipment), and NS (Neither).

If no value is entered, this field defaults to NS (Neither).

NS

16F

1

16D

UID - Unique Identifier

AN

1/50

78

C

16D — 16F is considered a loop within loop 15. The number of UIDs reported must match the quantity reported in line 17, field 1.

proj_wawf_uid_detl

wawf_uid_cd

Enter the unique identifier on the UID Information subtask of the Manage Project WAWF Information screen.

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

2

16D

UID - Serial Number

AN

1/30

30

O

proj_wawf_uid_detl

wawf_uid_serial_no

Enter the UID serial number on the UID Information subtask of the Manage Project WAWF Information screen.

Enter the UID serial number in the UID Serial No column of the UID Information group box.

16G

1

15

ACRN

AN

2/2

2

C

16B is used for one ACRN; 16G is used for multiple ACRNs.

Generate line 16G only if there is more than one row in proj_prod_acrn.

proj_prod_acrn

acrn_cd

Enter the ACRN on the ACRNs subtask of the Manage Project Product Bills screen.

Enter the ACRN in the ACRN column. If there are multiple ACRNs for a CLIN/SLIN, this field displays the ACRN. Otherwise, this field is not populated.

2

15

ACRN Price

R9.2

1/14

14,2

C

Generate line 16G only if there is more than one row in proj_prod_acrn.

proj_prod_acrn

acrn_amt

Enter the ACRN price on the ACRNs subtask of the Manage Project Product Bills screen.

Enter the ACRN price in the ACRN Amount column. If there are multiple ACRNs for a CLIN/SLIN, this field displays the amount for each ACRN. The sum of the ACRN price lines must equal the amount of the CLIN. This field is not populated unless multiple ACRNs exist.

17

1

15

Quantity Shipped / Invoiced or Provided Information

R8.2

1/11

14,4

C

If UID information is entered in line 16D, this field must be a whole number. If the Line Item Type in Line Number 15, Field 2 is 1, this field is required. If Line 15, Field 2 is not a 1, skip this line.

proj_prod_invc_ln

units_qty

Enter the quantity on the Manage Project Product Bills screen.

2

15

Ship Advice Code

ID

1/1

O

Blank

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

3

15

Actual Quantity

N

1/8

C

Used for zero lots.

Blank

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

18

1

15

Unit of Measure Code

AN

2/2

3

C

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

If Line Item is 1, use ITEM.dflt_um_cde.  If dflt_um_cd is blank, use EA.

item

dflt_um_cd

The Unit of Measure Code is populated during file creation for a units billing with the value linked to an item in the Manage Parts, Manage Goods, or Manage Services screens. For non-units billings, the file creation process populates this field with EA if the Line Item Type is 1, and the process does not populate the field if the Line Item Type is 2.

19

1

15

Unit Price

R9.5

1/16

14,4

M

If the Line Item Type in Line Number 15, Field 2, is 1, this is the unit price. If the Line Item Type in Line Number 15, Field 2, is 2, 3, or 4, this is the amount of the fee, allowance, or tax.

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

proj_prod_invc_ln

If Line 15, field 2 is a 1, the value is trn_tot_price_amt divided by quantity (if Include Discounts and Taxes in CLIN is selected) or trn_unit_price_amt (if Include Discounts and Taxes in CLIN is not selected). If line 15, field 2 is a 2, the values are PROJ_PROD_INVC_HDR.trn_oth_chg_amt1, 2, 3. (If Include Discounts and Taxes in CLIN is not selected: If Line 15, field 2 is a 3, the value is trn_disc_amt. If Line 15, field 2 is a 4, the value is trn_sales_tax_amt.)

If Include Discounts and Taxes in CLIN is selected on the Manage Project WAWF Information screen, the unit price is the total price amount divided by the quantity. If this check box is not selected, the unit price is the unit price and the taxes and discounts are inserted into the file on Line Item 3 and 4 respectively. All like CLIN/catalogs are combined into one loop 15.

The unit price for items entered in the project product bill come from Project Unit Pricing or Product Price Catalog but can be edited on each line. For non-unit lines with a Line Item Type of 1, the unit price and quantity can be entered.  The unit price for non-unit billings with a Line Item Type of 2 matches the sum of the amounts entered on the Other Info tab of the Manage Project Product Bills screen. Taxes and discount can be included within the CLIN or reported on different line item types. These are entered in the child table window on the Manaqe Standard Bills screen.

20

1

Issue By DoDAAC

AN

6/6

6

O

proj_wawf_info

wawf_issue_id

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

Enter the issue by DoDAAC in the Issue By field.

21A

1

ARP - Alternate Release Procedure

ID

1/1

1

O

Enter a capitalized Y for Yes, or N for No. If left blank, defaults to N. ARP is allowed only for source/source and source/destination documents.

proj_wawf_info

wawf_arp_fl

The Alternate Release Procedure check box is located on the Manage Project WAWF Information screen.

2

COC - Certificate of Conformance

ID

1/1

1

O

Enter a capitalized Y for Yes, or N for No. If left blank, defaults to N. COC is allowed only for source/source and source/destination documents. 

proj_wawf_info

wawf_cert_fl

The Certificate of Conformance check box is located on the Manage Project WAWF Information screen.

3

Construction Certificate

ID

N/A

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.

The file creation process does not populate this field.

23

1

Initiator Comments

AN

1/80

254

C

Must be entered if there is a previously submitted final invoice against Contract Number and Delivery Order.

proj_prod_invc_hdr

notes

Enter initiator comments on the Notes subtask of the Manage Project Product Bills screen.

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

25

1

Attachment Indicator

ID

1/1

M

Enter a capitalized Y for Yes, or N for No.

If wawf_attachment is null, insert N; otherwise, insert Y.

The file creation process populates the Attachment Indicator  field with a Y when there is an attachment, or an N when there is not an attachment.

If an attachment file name is entered or Use Invoice ID as Attachment File Name is selected, the value in this field is Y.

26

1

Attachment Files

ID

1/100

100

C

If the Attachment Indicator in Line Number 25, Field 1, is Y, this field is required. This field displays the name of the file to be attached to the document.

Insert the file name only, not the path.

proj_wawf_info

wawf_attachment

The file creation uses the attachment file name that you entered in the subtask of the invoice type or the invoice ID if that option is selected.

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

28

1

28

Tag Type

AN

4/4

4

O

Enter RFID when RFID tag data is reported. If RFID is entered in Field 1, 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, and so forth.

proj_wawf_rfid

wawf_rfid_tag_cd

Enter the tag type on the RFID Information subtask of the Manage Project WAWF Information screen.

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

2

28

Tag ID

ID

4/64

64

O

Enter RFID tag data. Must be 16, 24, 32, or 64 characters. Characters allowed are numerals 0-9 and letters A-F.

If RFID is not reported in line 28, field 1, enter NONE here. 

proj_wawf_rfid

wawf_rfid_tag_id

Enter the tag ID on the RFID Information subtask of the Manage Project WAWF Information screen.

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

29

1

29

CLIN

AN

4/6

6

C

Line 29 is required if Line 28 is reported.

Lines 29 and 30 are a loop.

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

2

29

Quantity

R8.2

1/11

14,4

C

The number of UIDs reported must match the quantity reported here.

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

30

1

29

UID - Unique Identifier

AN

1/50

78

C

The Unique Identifier ensures uniqueness of items that are listed in the DoD UID Registry. The number of UIDs reported must match the quantity reported in Line 29, Field 2.

proj_wawf_uid_detl

wawf_uid_cd

All items that reported UIDs in Line 16D-16F are reported here directly below the item to which the UID relates.

2

Mark Indicator

AN

1/1

C

This Field must contain a Y (Yes) when UII within Multi-Box Pack and can be used only once per unique UII.

Enter N (No) or leave blank when using Line 30 for other than a Multi-Box Pack.

Blank

SEPARATOR OR END

1

Separator or End

ID

5/11

M

Use =SEPARATOR= to indicate that there are more documents in the file. Use =END= to indicate that this is the end of the file.

=SEPARATOR= or =END=

Default

The file creation process enters Separator or End to indicate that there is at least one additional document following or that this is the end of the last document, respectively.