FTP FILE LAYOUTS PROGRESS PAYMENT BILLS

 

Line

Field

Loop

Description

Type

WAWF Min/Max

Costpoint Length

WAWF Req Des

WAWF Notes

Entry/Calculation

Source/Table

Column/Field

Data Entry Screen

Data Entry Field

START

1

 

Form Counter

N

1/3

 

M

Number of transactions within the file.

No. of A records.

 

 

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

 

A

1

 

User ID

AN

8/30

20

M

WAWF User ID

User's login ID

 

 

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

3/3

5

M

PPR — Progress Payment Report

PPR

proj_wawf_info

wawf_invc_type_cd

Select the invoice type and file source on the Manage Project WAWF Information screen.

Select the Progress Payment Invoice Type and Progress Payment File Source options.

1

1

 

Contract Number

AN

1/19

20

M

See Field 2 notes on varying contract number sizes based on delivery order entry.

 

prg_pmt_edit_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. You can modify this in Contract No field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen.

 

2

 

Delivery Order Number

AN

0/19

20

C

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, the Contract Number reported in line 1, field 1 must be 1/19 alphanumeric characters.

 

proj

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

 

M

CCYYMMDD

 

prg_pmt_edit_hdr

award_yr_no, award_mo_no

Enter the issue date on the Manage Progress Payment Bills screen.

The issue date is entered in the Date of the Initial Award Year and Month of the Section 1; Box 1 tab of the Manage Progress Payment Bills screen.

1A

1

 

Foreign Currency Code

AN

3/3

3

O

 

 

proj_bill_info

s_crncy_cd

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

 

2

1

 

Progress Payment Request Number

AN

7/8

15

M

If FMS is Y, the request number must begin with PPRB. Otherwise, the request number must begin with PPRA. If the request number is eight characters long, the eighth character must be a letter to designate a LOT Contract.  (PPRA or PPRB NNN A (N= numeric, A = alpha)

Truncate at eight characters. Request number must be seven or eight characters.

prg_pmt_edit_hdr

bill_no_id

The progress payment number is represented as the bill number. Enter the last bill number used on the Manage Project Billing Information screen. The Calculate Progress Payment Bills screen increments this number by one and populates the file with this incremented number.

The Bill Number is computed during the Calculate Progress Payment Bills process but can be modified in the Request No field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen.

 

2

 

PPR Date

DT

8/8

 

M

CCYYMMDD

 

prg_pmt_edit_hdr

invc_end_dt

The PPR date is computed as the system date when the progress payment invoice is computed. 

The PPR date is populated in the Date of this Request field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen.

3

1

 

Invoice Number

N/A

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.

 

 

2

 

Statement of Costs Through Date (SF1443 Section II Header)

DT

8/8

 

M

CCYYMMDD

 

prg_pmt_edit_hdr

invc_end_dt

The PPR Date is computed as the system date when the progress payment invoice is computed. 

The PPR Date is populated in the Date of this Request field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen.

4

1

 

Delivery On Invoice Indicator

ID

1/1

1

M

Enter Y for Delivery, Enter N for No Delivery.

 

proj_wawf_info

wawf_deliv_fl

The Delivery On Invoice check box is selected on the Manage Project WAWF Information screen.

 

 

2

 

Small Business Indicator (SF1443 – Line 3)

A

1/1

1

M

Enter Y or N.

 

prg_pmt_edit_hdr

small_bus_fl

The Small Business Indicator is selected on the Manage Project Billing Information screen by selecting the Bill Cost Incurred On Cash Basis check box.

 

 

3

 

FMS Indicator

A

1/1

1

M

Enter Y or N.

 

proj_wawf_info

wawf_fms_fl

The FMS check box is selected on the Manage Project WAWF Information screen.

 

 

4

 

Contract Price (SF1443 - Line 5)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

contr_price_amt

Enter the contract price on the Manage Modifications screen.

The contract value entered is inserted into the Contract Price field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen where it can be modified.

 

5

 

Progress Payment Rate (SF1443 – Line 6a)

N

1/2

10,8

M

 

Cannot have more than two digits to the left of the decimal.

prg_pmt_edit_hdr

prg_pmt_rt * 100

Enter the progress payment rate on the 1443 Info tab of the Manage Project Billing Information screen.

The progress payment rate entered is inserted into the Progress Payment Rate field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen where it can be modified.

 

6

 

Liquidation Rate (SF 1443 - Line 6b)

R2.1

1/4

10,8

M

 

Cannot have more than two digits to the left of the decimal or one digit to the right of the decimal. Round number.

prg_pmt_edit_hdr

liquid_rt * 100

Enter the liquidation rate on the 1443 Info tab of the Manage Project Billing Information screen.

The liquidation rate entered is be inserted into the Liquidation Rate field on the Section 1; Box 1 tab of the Manage Progress Payment Bills screen where it can be modified.

5

1

 

Prime Contractor CAGE

AN

5/5

5

M

 

 

proj_wawf_info

wawf_sender_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

If a Prime Contractor is not entered, this field must be left 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.

6

1

 

Administration DoDAAC

AN

6/6

 

M

 

 

proj_wawf_info

wawf_admin_id

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

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

6B

1

 

Inspect by  DoDAAC

AN

6/6

6

C

 

 

proj_wawf_info

wawf_inspect_id

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

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

 

2

 

Inspect by Extension

AN

1/6

 

C

If the Inspect by DoDAAC is blank, this field must be left blank. If an Inspect by DoDAAC is supplied, this field is optional.

 

proj_wawf_info

inspect_ext_cd

Enter the inspect by extension on the Maintain Project WAWF Information screen.

Enter the inspect By extension in the Inspected By extension field in the DoDAACs group box.

7

1

 

Payment Office DoDAAC

AN

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.

8

1

 

Contracting Officer DoDAAC

AN

6/6

6

M

 

 

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

 

Contracting Officer Extension

AN

1/6

 

O

 

 

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.

8B

1

 

Local Processing Office DoDAAC

AN

6/6

6

O

 

 

proj_wawf_info

wawf_local_proc_id

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

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

 

2

 

Local Processing Office Extension

AN

1/6

 

C

If the Local Processing Office DoDAAC is blank, this field must be left blank. If a Local Processing Office DoDAAC is supplied, this field is optional.

 

proj_wawf_info

local_proc_ext_cd

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

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

9

1

 

Issue By DoDAAC

AN

6/6

 

O

 

 

proj_wawf_info

wawf_inspect_id

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

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

10

1

 

Amount remaining which is eligible for Payment (SF1443, Line 19)

N

1/12

14,2

M

Maximum balance eligible for Progress Payments.

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_19_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

10A

1

 

Paid Costs Eligible Under PP Clause (SF1443, Line 9)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_9_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

2

 

Incurred Costs Eligible Under PP Clause (SF1443, Line 10)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_10_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

3

 

Total Costs Eligible for PP (SF1443, Line 11)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_11_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

4

 

Total Costs Incurred to Date (SF1443, Line 12a)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_12a_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

5

 

Est. Additional Cost to Complete (SF 1443 Line 12b)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_12b_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

6

 

Total Costs Eligible for PP times the Progress Payment Rate (SF 1443, Line 13)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_13_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

7

 

Progress Payments Paid to Subcontractors (SF1443, Line 14a)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_14a_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

8

 

Liquidated Progress Payments to Subcontractors (SF1443 Line 14b)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_14b_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

9

 

Unliquidated Progress Payments to Subcontractors (SF1443 Line 14c)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_14c_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

10

 

Subcontract progress billings approved for current billing (SF1443, Line 14d)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_14d_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

11

 

Eligible subcontractor progress payments (SF1443 Line 14e)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_14e_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

12

 

Total Dollar Amount (SF1443 Line 15)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_15_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

13

 

Contract Price Multiplied by Liquidation Rate (SF1443, Line 16)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_16_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

14

 

The lesser of either the Total Dollar Amount or the Contract Price Multiplied by the Liquidation Rate (SF1443 Line 17)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_17_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

15

 

Total amount of previous Progress Payments Requested (SF1443, Line 18)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_18_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

11

1

 

Max Permissible Progress Payments (SF1443, Line 25)

N

1/12

14,2

C

Refer to Line 4, Field 1. If the Delivery on Invoice Indicator is Y, Lines 11 and 11A are required.

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_25_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

11A

1

 

Costs included as Eligible that are applicable to items delivered, invoiced, and accepted as of the Statement of Costs through date (SF1443 Line 20a)

N

1/12

14,2

C

Refer to Line 4, Field 1. If the Delivery on Invoice Indicator is Y, Lines 11 and 11A are required. No decimals allowed; whole numbers only.

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_20a_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

 

2

 

Costs Eligible for Progress Payments, Applicable to undelivered items and to delivered items not invoiced and accepted (SF1443 Line 20b)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_20b_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

3

 

Items undelivered and not invoiced (Field 2) multiplied by progress payment rate (SF1443 Line 20c)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_20c_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

4

 

Eligible subcontractor progress payments (SF1443 Line 20d)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_20d_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

5

 

Limitation (Progress Payment clause (a(3)(ii) or (4)(ii)) (SF1443 Line 20e)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_20e_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

6

 

Contract price of items delivered, accepted, and invoiced through Statement of Costs Through date (SF1443 Line 21a)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_21a_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

 

7

 

Contract price of items not delivered, accepted, and invoiced (SF1443 Line 21b)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_21b_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

8

 

Contract price of items not delivered, accepted, and invoiced multiplied by the liquidation rate (SF1443 Line 21c)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_21c_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

9

 

Unliquidated advance payments plus accrued interest (SF1443 Line 21d)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_21d_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

 

10

 

Limitation (Progress Payment clause (a(3)(ii) or (4)(ii)) (SF1443 Line 21e)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_21e_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

11

 

Maximum unliquidated progress payments (SF1443 Line 22)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_22_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

 

12

 

Total amount applied to reduce progress payment (SF1443 Line 23)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_23_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

 

13

 

Unliquidated progress payments (SF1443 Line 24)

N

1/12

14,2

C

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_24_amt

Computed by the Calculate Progress Payment Bills process and cannot be modified.

 

12

1

 

Amount of Current Invoice for Progress Payment (SF1443 Line 26)

N

1/12

14,2

M

 

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_26_amt

Computed by the Calculate Progress Payment Bills process and can be modified.

 

17

1

 

Date of Last Communication

DT

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.

 

 

2

 

Date of Encumbrance

DT

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

 

Date of Most Recent Written Financial Info

DT

8/8

 

M

 

 

 

 

 

 

 

4

 

Previous Progress Pay Request

AN

7/8

15

O

Required for PPR transactions.

 

proj_wawf_info

wawf_prev_req_no

Enter the previous progress pay request on the Manage Project WAWF Information screen.

Enter the previous request in the Previous Progress Payment Request Number field.

 

5

 

PPR Certificate

ID

1

1

M

Enter Y for Yes and N for No. Must be capitalized.

 

proj_wawf_info

wawf_cert_fl

Enter the PPR certificate on the Manage Project WAWF Information screen.

Select the Certification option to certify the progress payment file.

18

1

 

Initiator Comments

AN

1/75

254

C

 

 

proj_bill_info

bill_desc

Enter the initiator comments in the Bill Heading field on the Other Info tab of the Manage Project Billing Information screen.

You must enter initiator comments if a final invoice was previously submitted for the contract number and delivery order.

19

1

 

Attachment Indicator

ID

1/1

 

M

Enter a capitalized Y (Yes) or N (No).

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

 

 

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

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

19A

1

 

Attachment Files

ID

1/100

 

C

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

Insert file name only, not path

proj_wawf_info

wawf_attachment

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

Enter a file attachment name or select to use the invoice ID as the attachment name on the Manage Project WAWF Information screen.

20

1

20

ACRN or FMS

AN

3/4

4

O

Enter the text ACRN or FMS. Must be capitalized.  The total FMS must match line 12 or ACRN must match line 12.

 

proj_wawf_acrn

wawf_acrn_fms_cd

Enter the ACRN or FMS indicator on the Manage Project WAWF Information screen.

Select ACRN or FMS as the indicator in the first column of the ACRN/FMS Worksheet.

 

2

20

ACRN or FMS Country Code

AN

2/2

3

O

 

ACRNs must be unique.

proj_wawf_acrn

wawf_acrn_cd

Enter the ACRN or FMS code on the Manage Project WAWF Information screen.

Enter the ACRN or FMS code in the ACRN/FMS Worksheet.

 

3

20

Associated Dollars

N

1/12

14,2

O

Whole dollars only; no decimals allowed.

No decimals are allowed. Round to the nearest dollar.

proj_wawf_acrn

wawf_acrn_amt

Enter the ACRN or FMS amount on the Manage Project WAWF Information screen.

Enter the ACRN or FMS amount in the ACRN/FMS Worksheet.

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.