FTP FILE LAYOUTS MOCAS STANDARD BILLS COMBO

 

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

User ID responsible for submitting the file to the WAWF.

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 defaults to a value of B - DoD Contract (FAR), and all associated edits for Contract Number and Delivery Order number structure associated with DOD Contract (FAR) will be applied to the inbound file and if not met the file will fail.

 

bill_edit_invc_hdr

prime_contr_id

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

Enter the contract number in the Prime Contract No field.

 

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.

 

bill_edit_invc_hdr

cust_po_id

Enter the delivery order number on the Manage Project User Flow screen.

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

 

3

 

Issue Date

DT

8/8

 

O

CCYYMMDD

Blank

 

 

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

 

 

4

 

Task Order

AN

N/A

30

N/A

Not used.

Blank

 

 

The 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

 

 

bill_edit_invc_hdr

s_crncy_cd

Enter the foreign currency code on the Other Info tab of the Manage Project Billing Information screen.

Enter the foreign currency code in the Billing Currency field in the Currency Info group box.

2

1

 

Shipment Number

AN

7/8

15

M

Must be 7 or 8 characters in the format of AAAXNNN and may have a Z in the 8th position. The following edits will be applied:

If the Shipment Number is 8 characters, the 8th character must be a Z.

If the Final Shipment Indicator is Y, the Shipment Number must be exactly 8 characters with the 8th character being a Z.

If the Shipment Number is 8 characters and the 8th character is a Z, the Final Shipment Indicator must be set to Y.

Prefixes SER and BVN are not allowed.

 

bill_edit_invc_hdr

bill_no_id

The shipment number is represented as the bill number. The last bill number used is entered on the Manage Project Billing Information screen. The Calculate Standard Bills screen increments this number by one and populates the file with this incremented number.

The bill number is computed during the Calculate Standard Bills process but can be modified on the Manage Standard Bills screen.

 

2

 

Shipment Date

DT

8/8

 

M

CCYYMMDD

 

bill_edit_invc_hdr

invc_dt

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

You can modify the invoice date on the Manage Standard Bills screen.

 

3

 

Estimated Shipment Date Indicator

ID

1/1

 

O

Identifies whether the shipment date is estimated or not. Enter a capitalized E if 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 is the final shipment is located on the Manage Project WAWF Information screen.

The check box that indicates if this is the final shipment is located on the Manage Project WAWF Information screen. If the check box is selected, 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 under Combo Invoice Type.

4

1

 

Bill of Lading

AN

1/30

 

O

Not used.

 

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

 

 

 

 

2

 

TCN

AN

1/30

 

N/A

Not used.

 

 

 

 

 

 

3

 

Transportation Method/Type

ID

1/1

1

M

Used only for fast pay invoices for MOCAS.

 

proj_wawf_info

wawf_ln_haul_cd

This field is available on the Manage Project WAWF Information screen if the invoice is 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 Transportation Data will be submitted later. Y (Yes), N (No), or blank are allowed.

Blank

 

 

 

 

5

1

 

Discount Percent

 

 

 

O

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

Blank

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

 

 

 

 

2

 

Due Days

 

 

 

C

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

Blank

 

 

 

 

 

3

 

Discount Amount

 

 

 

O

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

Blank

 

 

 

 

 

4

 

Discount Date

 

 

 

C

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

Blank

 

 

 

 

 

5

 

Discount Type

 

 

 

C

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

21 if wawf_fast_pay_fl = Y.

proj_wawf_info

wawf_fast_pay_fl

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

Select the Fast Pay Invoice check box.

 

6

 

Net Days

 

 

 

O

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

Blank

 

 

 

 

6

1

 

Invoice Number

AN

1/8

15

M

The invoice number is converted to upper case.

 

bill_edit_invc_hdr

bill_no_id

Enter the last bill number used in the Manage Project Billing Information screen. The Calculate Standard Bills screen increments this number by one and populates the file with this incremented number.

The bill number is computed during the Calculate Standard Bills process and is only eight characters long for MOCAS.

 

2

 

Invoice Date

DT

8/8

 

M

CCYYMMDD

 

bill_edit_invc_hdr

invc_dt

The Invoice Date is the date on which the invoice was computed. 

You can edit the Invoice Date on the Manage Standard Bills screen.

 

3

 

Final Invoice

ID

1/1

1

M

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

 

proj_wawf_info

wawf_last_invc_fl

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

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

 

4

 

Vendor's Invoice Number

AN

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.

 

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 Point 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 Point 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 left blank if the Prime Contractor CAGE is blank.

 

proj_wawf_info

wawf_cage_ext_cd

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

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

10

1

 

Administration DoDAAC

AN

6/6

6

M

 

Must be a DoDAAC activity.

proj_wawf_info

wawf_admin_id

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

For MOCAS, the administration DoDAAC must represent a DCMA Activity.

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 on the Manage Project WAWF Information screen.

 

2

 

Inspect by Extension

AN

1/6

 

C

If the Inspect by DoDAAC is blank, this field must be left blank. If the Inspect by DoDAAC is supplied, 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 Inspected By Extension field in the DoDAACs group box.

11

1

 

Ship From CAGE / DUNS / DUNS+4/ DoDAAC

AN

5/13

13

O

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

 

proj_wawf_info

wawf_ship_from_id

Enter the ship from CAGE/DoDAAC on the Manage Project 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

 

O

If a Ship From was not entered, this field must be left blank.

If a Ship From is entered, this Field is optional.

 

proj_wawf_info

ship_from_ext_cd

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

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

The user enters the Ship From Extension in the Ship From Extension field in the DoDAACs Groupbox.

 

3

 

FOB

AN

1/1

1

C

Enter a capitalized S for Source, D for Destination, or O for Other. If line 3 is SVC, this field is not used.

 

proj_wawf_info

wawf_fob_cd

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

If Line 3 is SVC, this field is blank.

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.

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

 

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 DoDAAC is blank, this field must be left blank. If a Mark for Deliver DoDAAC is supplied, 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 in the Mark for Delivery extension field in the DoDAACs group box.

 

3

 

Mark For Delivery Representative

AN

N/A

 

N/A

Not used.

Blank

 

 

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

 

14B

1

 

Mark For Delivery Comments

AN

1/75

75

O

 

 

proj_wawf_info

wawf_comments

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

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

14C

1

 

Mark For Delivery Secondary Comments

AN

1/75

75

O

 

 

proj_wawf_info

wawf_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 Del Secondary Comments field.

15

1

15

Line Item

AN/ID

4 or 6

10

M

This field may contain a CLIN/SLIN or miscellaneous fee. Taxes and allowances are not allowed.

Only one miscellaneous fee can be included in a document: only F460 or I260 is allowed.

MOCAS Attachment

Line Item

On the Manage Project WAWF Information screen, you can select among three CLIN mapping methods. If you select Default CLIN, all billed amounts are grouped into the entered CLIN. If you select Use ACRN Mapping, the mapping from the Manage ACRN Bills screen is used and the CLIN comes from PROJ_ACRN_DETL.acrn_ln_item. If you select CLIN Mapping, you must map projects to CLINs (PROJ_WAWF_CLIN.clin_id). You can also map accounts and/or PLCs to a project/CLIN line. Within these methods, there are also two different methods of mapping units. If the units are mapped by account, the units are grouped within the assigned CLIN based on the account number charged. If they are combined based on the transaction CLIN or catalog, they are grouped within the file based on the CLIN or catalog charged at transaction. You can include discounts and taxes within the CLIN; otherwise, they are excluded. Other charges entered on the Header of the Manage Standard Bills screen are inserted as a line item 2 and the other charge code is in the field.

Billed amounts are grouped based on the CLIN linked to projects and, optionally, accounts and/or PLCs. If you select Use ACRN Mapping, the project/CLIN/ACRN mapping is completed on the Manage ACRN Bills screen (PROJ_ACRN_DETL). If you select Default CLIN, Costpoint groups the amount of the invoice into the CLIN entered in the Default CLIN field. If you select CLIN Mapping, Costpoint groups the billed amounts based on the CLIN/project link (PROJ_WAWF_INFO.clin_id) and account/PLC, if mapped. Other charges are grouped by charge code, and if taxes and discounts are not included in the CLIN, they are excluded from the file.

 

2

15

Line Item Type

ID

1/1

 

M

1 — CLIN/SLIN, 2 — Fee/Charge (Taxes and allowances are not allowed.)

1 or 2

MOCAS Attachment

Line Item Type

The file creation process populates this field according to the WAWF Notes.

All billed charges from Open Billing Detail are considered as a CLIN (1), other charges as Fee/Charge (2). If Include Discounts and Taxes in CLIN is not selected, the taxes and discounts are not included in the file. If ACRN mapping is used, discounts and taxes are always included within the CLIN.

 

3

15

GFE

ID

1/1

 

N/A

This field cannot have a value unless the Line Item Type in Field 2 is a 1 (CLIN/SLIN). Optional even if CLIN/SLIN per telcon with 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.

 

MOCAS Attachment

Stock Number

If line 3 is SPL, 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, Costpoint inserts the nsn_id. If the Line Item Type is CLIN/SLIN and line 3 is SVC, the value is SERVICES. The file creation does not populate this field for Line Item Types of 2, 3, or 4.

 

 

2

15

Product Service Type

ID

2/2

 

C

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

 

MOCAS Attachment

Product Service Type

If line 3 is SPL, 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 more than one item is billed within the CLIN, use MG. If line 3 is SVC, the value is SV. This field does not populate if the Line Item Type is 2, 3, or 4.

 

16A

1

15

Description

AN

1/75

60

C

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

 

MOCAS Attachment

Description

The file creation process populates this field with Amount Billed for XXXXXX, where XXXXXX is the CLIN entered in the  Default CLIN field, the CLIN on the Manage ACRN Bills screen, or the CLIN on the CLIN Mapping subtask of the Manage Project WAWF Information screen. If the Line Item Type is 2, 3, or 4, this field is not populated.  If this is a Units billing, the description is entered on the Manage Parts, Manage Goods, or Manage Services screens and is used if only one item is grouped within the CLIN.

If the mapping method is Use ACRN Mapping, the CLIN is populated as the line item in the table window of the Manage ACRN Bills screen. If you select Default CLIN, Costpoint populates the CLIN in the Default CLIN field on the Manage Project WAWF Information screen.  If you select CLIN Mapping, Costpoint populates the CLIN on the CLIN Mapping subtask where projects are linked.

16B

1

15

ACRN

AN

2/2

2

C

This field is optional if the Line Item Type in line 15, field 2 is 1. If Line 15 is not field 2 is not a 1, skip this line.

 

proj_acrn_detl

acrn_id

The file creation process populates this field with the ACRN linked to the line item on the Manage ACRN Bills screen. This is used only if the Use ACRN Mapping check box is selected.

Enter the ACRN in the child table window on the Manage ACRN Bills screen .

 

2

15

SDN

AN

13/15

 

C

The process does not populate this field.

Blank

 

 

Not populated.

 

 

3

15

AAA

AN

6/6

 

O

The process does not populate this field.

Blank

 

 

Not populated.

 

16D

1

15

UID Type

AN

3/4

5

M

16D—16F is considered a loop within loop 15. Enter UID1, UID2, ESN, GIAI, GRAI, OTHER, or VIN (see 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, pull information for the 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.

 

2

15

Issuing Agency Code

AN

1/2

3

C

The Issuing Agency Code is required if the UID Type is UID1 or UID2.

 

proj_wawf_uid

wawf_uid_iac_cd

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

Enter the issuing agency code in the IAC column. See the WAWF Interface Control Document Appendix K for valid codes.

 

3

15

Enterprise Identifier

AN

4/9

13

C

The Enterprise Identifier is required if the UID Type is UID1 or UID2. If an Enterprise Identifier is supplied, the Issuing Agency Code is required.

 

proj_wawf_uid

wawf_uid_eid_cd

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

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

 

4

15

Original Part Number

AN

1/32

32

O

The Original Part Number is required if the UID Type is UID2 and the Batch and Lot Number is blank.

 

proj_wawf_uid

wawf_uid_part_id

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

Enter the original part number in the Part No column.

 

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/32

 

O

 

Blank

 

 

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

 

 

10

15

Current Part Number Cost

R9.2

1/16

 

C

 

Blank

 

 

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

 

 

11

15

Current Part Number Effective Date

N

8/8

 

C

 

Blank

 

 

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

 

 

12

15

Original Manufacturer's Code

AN

1/3

 

O

 

Blank

 

 

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

 

 

13

15

Original Manufacturer's ID

AN

4/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) or N (No) or blank. If unknown, this Field must be left blank.

Blank

 

 

 

 

 

15

15

Not Used

 

N/A

 

N/A

 

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 in this field, it defaults to NS (Neither).

NS

 

 

 

 

16F

1

15

UID - Unique Identifier

AN

1/50

78

M

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 Detail Information subtask of the UID Information subtask of the Manage Project WAWF Information screen.

Enter the unique identifier in the Unique Identifier column.

 

2

15

UID - Serial Number

AN

1/30

30

O

 

 

proj_wawf_uid_detl

wawf_uid_serial_no

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

Enter the serial number in the UID Serial Number column.

16G

1

15

ACRN

AN

2/2

2

C

Use this field to report multiple ACRNs per line item.

 

proj_acrn_detl

acrn_id

The file creation process populates this field with the ACRN linked to the line item on the Manage ACRN Bills screen. This is used only if Use ACRN Mapping is selected.

Enter the ACRN in the child table window on the Manage ACRN Bills screen.

 

2

15

ACRN Price

R9.2

1/14

 

C

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

The total ACRN price must match the line the item total.

proj_acrn_detl

acrn_cur_alloc_amt

The file creation process populates this field with the computed current ACRN allocation amount linked to the line item on the Manage ACRN Bills screen.

The current ACRN allocation amount is populated by the Calculate ACRN Bills process.

17

1

15

Quantity Shipped / Invoiced or Provided Information

R8.2

1/8

14,4

C

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

No decimals allowed. If line 3 is SVC, enter a 1.

 

 

If line 3 is SVC, the value must be 1. If line 3 is SPL and if Combine Units by Transaction CLIN is selected on the Manage Project WAWF Information screen, the file creation process for units billings populates this field with the number of units entered on the Manage Unit Usage screen or the Import Units Usage Files screen, posted via the Post Unit Usage screen, and calculated by the Calculate Standard Bills screen. If Map Units by Account is selected on the Manage Project WAWF Information screen, the billed units are combined with other billed amounts and the file creation process populates this field with a 1. For non-unit billings where the Line Item Type is 1, the file creation process populates this field with a 1. For non-unit billings where the Line Item Type is other than 1, the file creation process does not populate this field.

No decimals are allowed for MOCAS. If fractional units are entered, they are rounded.

 

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

If the Line Item number 15 is Zero Lots and the document contains MILSTRIPs, UIDs, pack data, or the Pack Later Indicator is set to Y, this field is required. The Actual Quantity cannot be negative and if no quantity is sent, this field must be zero or blank.

Blank

 

 

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

 

18

1

15

Unit of Measure Code

AN

2/2

3

C

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

If line 3 is SVC, enter LO.

 

 

If line 3 is SVC, the value is LO. If line 3 is SPL, the Unit of Measure Code is populated during file creation for a units billing with the value linked to an item on the Manage Parts, Manage Goods, or Manage Services screens. For non-units billings or multiple items linked to one CLIN, the file creation process populates this field with EA if the Line Item Type is 1. If the Line Item Type is 2, 3, or 4, the file creation process does not populate the Unit of Measure Code.

 

19

1

15

Unit Price

R9.6

1/15

14,4

M

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

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

 

mu_bill_amt

If line 3 is SVC, the unit price is the total amount billed for the CLIN. If line 3 is SPL and if the unit mapping is Combine Units by Transaction CLIN used with ACRN or CLIN mapping, the unit price is the total amount billed or current ACRN allocation amount (may include taxes, discounts, over ceiling, retainage, withholding, withholding release, other costs, and so on) divided by the billed quantity (or 1 if there are no billed units). If the unit mapping is Map Units by Account used with ACRN or CLIN Mapping, the unit price is the total billed for the CLIN. If the Line Item Type is 2, the unit price is the total of the other charges, discounts, or taxes. 

 

20

1

 

Issue By DoDAAC

AN

6/6

6

O

 

 

proj_wawf_info

wawf_issue_id

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

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

21A

1

 

ARP - Alternate Release Procedure

ID

1/1

1

O

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

 

proj_wawf_info

wawf_arp_fl

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

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, default to N.

 

proj_wawf_info

wawf_cert_fl

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

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.

 

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.

 

bill_edit_invc_hdr

bill_desc

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

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

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

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

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.

Include only the file name, not the path.

proj_wawf_info

wawf_attachment

The file creation uses the attachment file name entered for the invoice type or the invoice ID if that option is selected.

The file creation uses the attachment file name that entered or the invoice ID if that option is selected.

28

1

28

Tag Type

AN

4/4

4

O

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

If more than one row is entered in proj_wawf_info, the additional lines must be identified as 28A, 28B, and so on.

proj_wawf_rfid

wawf_rfid_tag_cd

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

Enter the tag type in the Tag Type column.

 

2

28

Tag ID

ID

16/64

64

O

Enter RFID tag data.

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.

29

1

29

CLIN

AN

4/6

6

C

Line 29 is required if Line 28 is reported.

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