|
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 (Projects\Process\Billing) |
|
Enter the User ID in the Create WAWF Billing Files screen (Projects\Process\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
Select the 2N1 radio button. |
|
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 Details tab of the Project User Flow (Projects\Maintain\Project). |
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 Project User Flow (Projects\Maintain\Project). |
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 Information screen (Projects\Maintain\Billing). |
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, then the 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 Information screen (Projects\Maintain\Billing). The Calculate Bills screen (Projects\Process\Billing) increments this number by one and populates the file with this incremented number. |
The bill number is computed during the Calculate Bills process (Projects\Process\Billing) but can be changed in the Edit Standard Bills screen (Projects\Transactions\Billing). |
|
|
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\Transactions\Billing). |
|
|
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 checkbox indicating that this shipment was the final shipment is located in the 2N1 subtask of the Project WAWF Information screen (Projects\Maintain\Billing). |
Select the Final Shipment option in the 2N1 subtask of the Project WAWF Information screen (Projects\Maintain\Billing). |
|
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 Information screen (Projects\Maintain\Billing). The Calculate Bills screen (Projects\Process\Billing) increments this number by one and populates the file with this incremented number. |
The Bill Number is computed during the Calculate Bills process (Projects\Process\Billing) 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\Transactions\Billing). |
|
|
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 checkbox indicating that this invoice was the final invoice is located in the 2N1 subtask of the Project WAWF Information screen (Projects\Maintain\Billing). |
The checkbox indicating that this invoice is the final invoice is located in the 2N1 subtask of the Project WAWF Information screen (Projects\Maintain\Billing). |
|
|
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
Enter the Prime Contractor CAGE Extension in the CAGE Extension field in the Sender Information group box. |
|
10 |
1 |
|
Administration DoDAAC |
AN |
6/6 |
6 |
M |
|
Must be a DoDAAC activity. |
proj_wawf_info |
wawf_admin_id |
Enter the Administration DoDAAC in the Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 contractor’s Prime CAGE Code, Line 9, then this Field can be blank. |
|
proj_wawf_info |
wawf_ship_from_id |
Enter the Ship From CAGE/DoDAAC in the Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing). |
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 Project WAWF Information screen (Projects\Maintain\Billing), 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\Maintain\Billing) 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\Transactions\Billing) 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\Maintain\Billing) (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\Maintain\Billing), or the CLIN in the CLIN Mapping subtask in the Project WAWF Information screen (Projects\Maintain\Billing). 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 Parts User Flow (Materials\Maintain\Items\Parts User Flow), Services User Flow (Materials\Maintain\Items\Services User Flow), or Goods User Flow (Materials\Maintain\Items\Goods User Flow) 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\Maintain\Billing). If Default CLIN is used, populate the CLIN in the default CLIN field in the Project WAWF Information screen (Projects\Maintain\Billing). 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\Maintain\Billing). 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\Maintain\Billing). |
|
|
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\Maintain\Billing). 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\Maintain\Billing) |
|
|
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\Maintain\Billing). |
The current ACRN allocation amount is populated by the Calculate ACRN Billings screen (Projects\Process\Billing). |
|
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 Project WAWF Information screen (Projects\Maintain\Billing), the file creation process for units billings populates this field with the number of units entered through the Enter Units Usage screen (Projects\Transactions\Units) or the Import Units Usage Data screen (Projects\Review\Utilities\Import), posted via the Post Units Usage screen (Projects\Process\Post\Post Units Usage), and calculated through the Calculate Bills screen (Projects\Process\Billing). 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. Fractional units arerounded. |
|
|
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 Parts User Flow (Materials\Maintain\Items\Parts User Flow), Services User Flow (Materials\Maintain\Items\Services User Flow), or Goods User Flow (Materials\Maintain\Items\Goods User Flow). 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 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 Project WAWF Information screen (Projects\Maintain\Billing). |
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\Transactions\Billing). |
Initiator Comments are entered in the Bill Heading field of the Edit Standard Bills screen (Projects\Transactions\Billing) 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, 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 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. |
|