FTP FILE LAYOUTS - MOCAS - STANDARD BILLS

Line

Field

Loop

Description

Type

WAWF Min/Max

CP Length

WAWF Req Des

WAWF Notes

Entry/Calculation

Source/Table

Column/Field

Data Entry Screen

Entry/Calculation

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.

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 (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).

B

1

Form Type

ID

2/2

5

M

CV - Cost Voucher

CV

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.

1

1

Contract Number

AN

1/19

20

M

See Field 2 notes on varying contract number sizes based on Delivery Order entry.

bill_edit_invc_hdr

prime_contr_id

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

Enter the Contract Number in the Prime Contract No field.

2

Delivery Order Number

AN

4/17

20

C

A delivery order number must be blank, 4, 13, or 17 alphanumeric characters.  If the Delivery Order Number is blank or is 4 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.

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

O

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.

1A

1

Foreign Currency Code

AN

3/3

3

O

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.

6

1

Voucher Number

AN

7/8

15

M

The voucher number will be converted to upper case.  For MOCAS, begins with BVN, fourth position is alphanumeric, fifth - seventh positions are numeric, eighth position is only used for final shipment and is a Z.

Cannot be longer than 8 characters and may have a Z in eighth position if this is the final shipment.

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

2

Voucher Date

DT

8/8

M

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

3

Final Invoice

ID

1/1

1

M

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.

If eighth position of voucher is a Z, then this field should be Y (Documentation).

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

4

Vendor's Invoice Number

AN

1/30

15

O

bill_edit_invc_hdr

invc_id

The last Company Wide Invoice Number assigned is stored in the Billing Settings screen.  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.

7

1

Period of Performance Start Date

DT

8/8

M

CCYYMMDD

proj

proj_start_dt

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

Enter the Period of Performance Start Date in the Start Date field of the Period of Performance group box.

2

Period of Performance End Date

DT

8/8

M

CCYYMMDD

proj

proj_end_dt

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

Enter the Period of Performance End Date in the End Date field of the Period of Performance group box.

9

1

Prime Contractor CAGE

AN

5/5

5

M

proj_wawf_info

wawf_sender_cage_cd

Enter the Prime Contractor CAGE Code 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.

2

CAGE Extension

AN

1/6

O

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

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

If the Pay DoDAAC is MOCAS, then the Administration DoDAAC must be a DCMA activity.

proj_wawf_info

wawf_admin_id

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

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

10B

1

Cost Voucher Approver DoDAAC

AN

6/6

6

M

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

proj_wawf_info

wawf_inspect_id

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

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

2

Cost Voucher Approver Extension

AN

1/6

O

proj_wawf_info

inspect_ext_cd

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

Enter the Inspect By Extension in the Inspected By extension field in the DoDAACs group box.

12

1

Payment Office DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_pmt_office _id

Enter the Payment Office DoDAAC 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.

13

1

Service Approver DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_ship_to_id

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

2

Service Approver Extension

AN

1/6

O

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

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

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

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 included within the CLIN, otherwise they will be excluded.  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, group the amount of the invoice into the CLIN entered in the default CLIN field.  If CLIN Mapping is used, 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 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 will be 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 will not be included in the file.  If ACRN mapping is used, discounts and taxes will always be included within the CLIN.

3

15

GFE

ID

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.

16

1

15

Stock Number

AN

1/25

20

C

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

MOCAS 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 situations when entry is optional.

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

MOCAS 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 for line item types of 2, 3, and 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 mandatory.  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 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 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

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

2

15

SDN

AN

13/15

C

Process does not populate this field

blank

Not populated.

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

2

15

ACRN Price

R9.2

1/15

C

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

17

1

15

Quantity Shipped / Invoiced or Provided Information

R8.2

1/8

14

C

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

no decimals allowed

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

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

2

15

Ship Advice Code

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.

3

15

Actual Quantity

N

N/A

N/A

Not used

blank

Not used

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

MOCAS 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, Services or Goods 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.

19

1

15

Unit Price

R9.5

1/15

14,4

M

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, this is the amount of the Fee.

Allows up to 5 positions to the right of decimal

MOCAS 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, the unit price will be 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 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.

23

1

Initiator Comments

AN

1/75

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

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.

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

26

1

Attachment Files

ID

1/100

100

C

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.

Include only the file name, not the 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.

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

SEPARATOR OR END

1

Separator or End

ID

5/11

M

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.

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.

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 file to WAWF

WAWF User ID

Create WAWF Billing Files screen (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.

B

1

Form Type

ID

2/5

5

M

CI - Commercial Invoice/Fast Pay

CI

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.

1

1

Contract Number

AN

1/19

20

M

See Field 2 notes on varying contract number sizes based on Delivery Order entry.

bill_edit_invc_hdr

prime_contr_id

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

Enter the Contract Number in the Prime Contract No field.

2

Delivery Order Number

AN

4/17

20

O

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.

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.

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

2

1

Shipment Number

AN

7/8

15

M

Must be seven characters in the format of AAAXNNN and may have a Z in the eighth position for a final shipment invoice.  Commercial Invoices require that a receiving report is submitted before the invoice is submitted.  The Shipment number on the receiving report should match the shipment number on the invoice.

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

2

Shipment Date

DT

8/8

C

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

Mandatory for MOCAS

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

3

Estimated Shipment Date Indicator

ID

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.

4

Final Shipment

ID

1/1

1

C

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.

If eighth position of voucher is a Z, then this field should be Y.

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).  If this is a Y, then the shipment number must have a Z as the eighth character.

Select the Final Shipment option in the CI subtask of the Maintain Project WAWF Information.

3

1

Services or Supplies

ID

3/3

C

Used only for MOCAS. If no value is submitted in this field, WAWF will default SPL.

Default SPL.

The file creation process will populate the Services or Supplies field with SPL.

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

First Line Haul Mode

ID

1/1

1

M

Used only for Fast Pay Invoices for MOCAS.

proj_wawf_info

wawf_ln_haul_cd

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

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

5

1

Discount Percent

O

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.

2

Due Days

C

If Discount Percent is entered, this field is mandatory

blank

3

Discount Amount

O

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

blank

4

Discount Date

C

If the Discount Amount is entered, this field is mandatory

blank

5

Discount Type

C

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

6

Net Days

O

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

blank

6

1

Invoice Number

AN

1/8

15

M

The Invoice Number will be converted to upper case.  Commercial Invoices require that a receiving report are submitted before 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.

2

Invoice Date

DT

8/8

M

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

3

Final Invoice

ID

1/1

1

M

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

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.

9

1

Prime Contractor CAGE

AN

5/5

5

M

proj_wawf_info

wawf_sender_cage_cd

Enter the Prime Contractor CAGE Code 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.

2

CAGE Extension

AN

1/6

O

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.

10

1

Administration DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_admin_id

Enter the Administration DoDAAC 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.

11

1

Ship from CAGE/DoDAAC

AN

5/6

6

O

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

proj_wawf_info

wawf_ship_from_id

Enter the Ship From CAGE/DoDAAC 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.

2

Ship from extension

AN

1/6

C

If Ship From CAGE/DoDAAC was not entered, 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.

3

FOB

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.

12

1

Payment Office DoDAAC

AN

6/6

6

M

 If Pay DoDAAC is MOCAS, the Administration DoDAAC, Line 10, must be a DCMA activity.

proj_wawf_info

wawf_pmt_office _id

Enter the Payment Office DoDAAC in the 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.

13

1

Ship To CAGE/DoDAAC

AN

5/6

6

M

proj_wawf_info

wawf_ship_to_id

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

2

Ship To Extension

AN

1/6

O

If Ship To was not used, 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 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.

14

1

Mark For Delivery

AN

6/6

C

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

2

Mark For Delivery Extension

AN

1/6

C

If Mark for Delivery was not used, 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 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.

3

Mark For Delivery Representative

AN

1/50

N/A

Not used

blank

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

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

Within the 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, otherwise they will be excluded.  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 excluded from the file.

2

15

Line Item Type

ID

1/1

O

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 will be 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 will not be included in the file.  If ACRN mapping is used, discounts and taxes will always be included within the CLIN.

3

15

GFE

ID

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.

16

1

15

Stock Number

AN

1/25

20

C

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

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

MOCAS 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 for line item types of 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 mandatory.  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 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, Services and Goods 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

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

2

15

SDN

AN

13/15

C

Process does not populate this field

blank

not populated

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

2

15

ACRN Price

R9.2

1/15

C

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

No decimals allowed.

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

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

2

15

Ship Advice Code

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.

3

15

Actual Quantity

N

N/A

N/A

Not used.

blank

Not used

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

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

19

1

15

Unit Price

R9.5

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, then this is the amount of the Fee.  

Allows up to five positions to the right of decimal

MOCAS 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, the unit price will be 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 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.

23

1

Initiator Comments

AN

1/75

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

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.

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

26

1

Attachment Files

ID

1/100

100

C

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.

Include only the file name, not the 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.

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

SEPARATOR OR END

1

Separator or End

ID

5/11

M

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.

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 file to WAWF

WAWF User ID

Create WAWF Billing Files screen (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.

B

1

Form Type

ID

2/5

5

M

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.

1

1

Contract Number

AN

1/19

20

M

See Field 2 notes on varying contract number sizes based on Delivery Order entry.

bill_edit_invc_hdr

prime_contr_id

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

Enter the Contract Number in the Prime Contract No field.

2

Delivery Order Number

AN

4/17

20

O

A delivery order number must be blank, 4, 13, or 17 alphanumeric characters.  If the Delivery Order Number is blank or is four alphanumeric characters in length, the Contract Number reported in line 1, field 1, must be 13 alphanumeric characters.  If the Delivery Order Number is 13 or 17 alphanumeric characters in length, 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.

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

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.

2

1

Shipment Number

AN

7/8

15

M

The Shipment Number must contain the prefix SER followed by three numeric characters.  If this is a final shipment invoice, SER must be followed by one alphanumeric and then three numeric characters followed by a Z if this if a final shipment.

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 screen (Projects » Billing » Calculate Billings) but can be changed in the Edit Standard Bills screen (Projects » Billing » Edit Billings).

2

Shipment Date

DT

8/8

C

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

Mandatory for MOCAS.

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 the Edit Standard Bills screen (Projects » Billing » Edit Billings).

3

Estimated Shipment Date Indicator

ID

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.

4

Final Shipment

ID

1/1

1

C

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

6

1

Invoice Number

AN

1/8

15

M

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) and should only be eight characters long for MOCAS.

2

Invoice Date

DT

8/8

M

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 the Edit Standard Bills screen (Projects » Billing » Edit Billings).

3

Final Invoice

ID

1/1

1

M

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

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.

9

1

Prime Contractor CAGE

AN

5/5

5

M

proj_wawf_info

wawf_sender_cage_cd

Enter the Prime Contractor CAGE Code 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.

2

CAGE Extension

AN

1/6

O

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

10

1

Administration DoDAAC

AN

6/6

6

M

Must be a DoDAAC activity

proj_wawf_info

wawf_admin_id

Enter the Administration DoDAAC 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.

10B

1

Inspect by DoDAAC

AN

6/6

6

O

This Field is optional for the Invoice 2n1 and Construction Invoice.

proj_wawf_info

wawf_inspect_id

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

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

2

Inspect by Extension

AN

1/6

C

If Inspect By 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.

11

1

Ship from CAGE/DoDAAC

AN

5/6

6

O

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

proj_wawf_info

wawf_ship_from_id

Enter the Ship From CAGE/DoDAAC 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.

2

Ship from extension

AN

1/6

N/A

Not used.

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

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

3

FOB

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.

12

1

Payment Office DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_pmt_office _id

Enter the Payment Office DoDAAC 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.

13

1

Service Acceptor DoDAAC

AN

6/6

6

M

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.

2

Ship To Extension

AN

1/6

O

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.

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

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, otherwise they will be excluded.  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 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 will be 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 will not be included in the file.  If ACRN mapping is used, discounts and taxes will always be included within the CLIN.

3

15

GFE

ID

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.

16

1

15

Stock Number

AN

1/25

20

C

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

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

MOCAS 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 for line item types of 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 mandatory.  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 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

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).  This will only be used if the Use ACRN Mapping check box is selected.

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

2

15

SDN

AN

13/15

C

Process does not populate this field

blank

not populated

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 in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).  This will only be used if the Use ACRN Mapping check box is selected.

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

2

15

ACRN Price

R9.2

1/15

C

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

no decimals allowed

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

No decimals will be allowed for MOCAS.  If units are entered that are fractional, they will be 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

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.

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

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

19

1

15

Unit Price

R9.5

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, this is the amount of the Fee.  

Allows up to 5 positions to the right of decimal

MOCAS 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, the unit price will be 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 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.

23

1

Initiator Comments

AN

1/75

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 the Initiator Comments in the Header subtask of the 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.

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.

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

26

1

Attachment Files

ID

1/100

100

C

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.

Include only the file name, not the 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.

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

SEPARATOR OR END

1

Separator or End

ID

5/11

M

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.