Progress Payment Bills FTP File Layout

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

2/30

20

M

WAWF User ID

user's login ID

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

3/3

5

M

PPR - Progress Payment Report

PPR

proj_wawf_info

wawf_invc_type_cd

Select the Invoice Type and File Source in the Project WAWF Information screen (Projects\Maintain\Billing).

Select the Progress Payment Invoice Type and Progress Payment File Source 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.

prg_pmt_edit_hdr

prime_contr_id

Enter the Contract Number in the Project User Flow (Projects\Maintain\Project).

Enter the Contract Number in the Prime Contract No field. This can be edited in Contract No field in the Section I subtask.

2

Delivery Order Number

AN

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

proj

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

M

CCYYMMDD

prg_pmt_edit_hdr

award_yr_no, award_mo_no

Enter the Issue Date in the Edit Progress Payment Bills screen (Projects\Transactions\Billing).

The Issue Date is entered in the Date of the Initial Award Year and Month of the Section I subtask.

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 subtask of the Project Billing Information screen (Projects\Maintain\Billing).

2

1

Progress Payment Request Number

AN

7/8

15

M

If FMS = Y, the request number must begin with PPRB.  Otherwise the request number must begin with PPRA.  If request number is eight characters long, then 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 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 Progress Payment 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 Progress Payment Bills process (Projects\Process\Billing) but can be changed in the Request No field in Section I of the Edit Progress Payment Bills screen (Projects\Transactions\Billing).

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 in the Section I subtask of the Edit Progress Payment Bills screen (Projects\Transactions\Billing).

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 in the Section I subtask of the Edit Progress Payment Bills screen (Projects\Transactions\Billing).

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 Indicator is selected in the Progress Payment subtask of the Project WAWF Information screen (Projects\Maintain\Billing).

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 in the Project Billing Information screen (Projects\Maintain\Billing) by selecting the Bill Cost Incurred On Cash Basis flag.

3

FMS Indicator

A

1/1

1

M

Enter Y or N.

proj_wawf_info

wawf_fms_fl

The FMS Indicator is selected in the Progress Payment subtask of the Project WAWF Information screen (Projects\Maintain\Billing).

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

The Contract Price is entered in the Modifications screen of the Project User Flow (Projects\Maintain\Project).

The Contract Value entered will be inserted into the Contract Price field in Section I of the Edit Progress Payment Bills screen (Projects\Transactions\Billing) where it can be edited.

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

The Progress Payment Rate is entered in the 1443 Info subtask of the Project Billing Information screen (Projects\Maintain\Billing).

The Progress Payment Rate entered will be inserted into the Progress Payment Rate field in Section I of the Edit Progress Payment Bills screen (Projects\Transactions\Billing) where it can be edited.

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

The Liquidation Rate is entered in the 1443 Info subtask of the Project Billing Information screen (Projects\Maintain\Billing).

The Liquidation Rate entered will be inserted into the Liquidation Rate field in Section I of the Edit Progress Payment Bills screen (Projects\Transactions\Billing) where it can be edited.

9

1

Prime Contractor CAGE

AN

5/5

5

M

proj_wawf_info

wawf_sender_cage_cd

The Prime Contractor CAGE Code is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Prime Contractor CAGE Code is entered 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

proj_wawf_info

wawf_admin_id

The Administration DoDAAC is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Administration DoDAACs is entered in the Administration field in the DoDAAC group box.

10B

1

Inspect by  DoDAAC

AN

6/6

6

C

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

proj_wawf_info

wawf_inspect_id

The Inspect by DoDAAC is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Inspect By DoDAAC is entered 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.

12

1

Payment Office DoDAAC

AN

6/6

6

M

proj_wawf_info

wawf_pmt_office _id

The Payment Office DoDAAC is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Payment Office DoDAAC is entered 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

The Ship To/CAGE DoDAAC is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Ship To/CAGE DoDAAC is entered 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

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.

13B

1

Local Processing Office DoDAAC

AN

6/6

6

O

proj_wawf_info

wawf_local_proc_id

The Local Processing Office DoDAAC is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Local Processing Office DoDAAC is entered in the Local Processing Office field in the DoDAACs group box.

2

Local Processing Office Extension

AN

1/6

C

If Local Processing Office was not used, then this field must be left blank. If Local Processing Office is entered, then this field is optional.

proj_wawf_info

local_proc_ext_cd

The Local Processing Office Extension is entered in the Project WAWF Information screen (Projects\Maintain\Billing).

The Local Processing Office Extension is entered in the Local Processing Office Extension field in the DoDAACs group box.

20

1

Issue By DoDAAC

AN

6/6

6

O

proj_wawf_info

wawf_issue_id

Issue By DoDAAC is entered 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.

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

2

Incurred Costs Eligible Under PP Clause (SF 1443, 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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

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 screen (Projects\Process\Billing) and can be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

11

1

Max Permissible Progress Payments (SF1443, Line 25)

N

1/12

14,2

C

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

No decimals are allowed. Round to the nearest dollar.

prg_pmt_edit_hdr

line_25_amt

Computed by the Calculate Progress Payment Bills screen (Projects\Process\Billing) and cannot be edited

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 Delivery on Invoice Indicator is Y, then Lines 11 and 11A are mandatory. 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 screen (Projects\Process\Billing) and can be edited

2

Costs Eligible for Progress Payments, Applicable to undelivered items & to delivered items not invoiced & 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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

7

Contract price of items not delivered, accepted & 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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

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 screen (Projects\Process\Billing) and cannot be edited

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 screen (Projects\Process\Billing) and can be edited

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

proj_wawf_info

wawf_fin_info_dt

The Date of the Most Recent Financial Info is entered in the Progress Payment subtask of the Project WAWF Information screen (Projects\Maintain\Billing).

Enter the date in the Date of Financial Info field.

4

Previous Progress Pay Request

AN

7/8

15

O

Mandatory for PPR transactions.

proj_wawf_info

wawf_prev_req_no

The Previous Progress Pay Request is entered in the Progress Payment subtask of the Project WAWF Information screen (Projects\Maintain\Billing).

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

The PPR Certificate is selected in the Progress Payment subtask of the Project WAWF Information screen (Projects\Maintain\Billing).

Select the Certification option to certify the progress payment file.

18

1

Initiator Comments

AN

1/75

254

C

proj_bill_info

bill_desc

Initiator Comments are entered in the Bill Heading field in the Other Info subtask of the Project Billing Information screen (Projects\Maintain\Billing).

Initiator Comments 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 Y for Yes and N for No. Must be capitalized.

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

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.

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

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

20

1

20

ACRN or FMS

AN

3/4

4

O

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

proj_wawf_acrn

wawf_acrn_fms_cd

The ACRN or FMS indicator is entered in the PPR subtask

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

3

O

ACRNs must be unique.

proj_wawf_acrn

wawf_acrn_cd

The ACRN or FMS code is entered in the PPR subtask

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

The ACRN or FMS amount is entered in the PPR subtask

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