Application for Payment Lines (tpppc6131m000)

Field Information

Details

Application for Payment

The code of the application for payment linked to the scope document line.

Number

The line number of the AFP.

Status

The status of the AFP.

Allowed values

Free

The initial status of the AFP.

Initiated

After specifying the required AFP data the status of the AFP can be set to Initiated.

Ready to Submit

When the status is set to Complete the application set the status to Ready to Submit.

Submitted

After the AFP is sent to the customer for assessment, the status can be set to Submitted.

Post Assessment Review

If the AFP has a Payless Amount (the certified amount is less than the applied amount), the contractor can ask for a review of the assessment. In such a case, the certified values as received from the customer can be specified. However, the status must be set to Post Assessment Review.

Certified

After the customer specifies the certified amount or quantity for the AFP line, the status can be set to Certified.

Canceled

When the AFP is canceled, this status is applicable.

Closed

When the installment is created for the AFP, the application sets the status of the AFP to closed.

Not Applicable

Scope Document

The code of the scope document.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the scope line data is defaulted.
• If the line is initiated from the Generate AFP from Physical Progress (tpppc6230m000) session, this field is blank.

/

The AFP line number.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the running line number is defaulted.
• If the line is initiated from the Generate AFP from Physical Progress (tpppc6230m000) session, the running line number is defaulted.

Call-Off Line

The call-off line number associated with the scope document line.

Note: 

• If this line is initiated from the Call-Offs (tpctm6603m000) session, the scope line data is defaulted.
• If the line is initiated from Generate AFP from Physical Progress (tpppc6230m000) session, this field is blank.

Project

Project

The code of the project.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the scope line data is defaulted.
• If the line is initiated from the Activity Physical Progress (tpppc1560m000) session, the value specified in the Project field is defaulted.

Plan

The code of the plan associated with the scope line.

Activity

The code of the activity linked to the project for the scope document line.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the scope line data is defaulted.
• If the line is initiated from the Activity Physical Progress (tpppc1560m000) session, the value specified in the Activity field is defaulted.

Line Type

The method to determine the pricing of the AFP line.

Allowed values

Amount Only

Rate Only

Quantity and Rate

Not Applicable

Note: In the Scope Document Lines (tpctm6101m000) session if this field is set to:

• Amount Only, you can specify only the Cost Amount for the defined Cost Object.
• Rate Only, you can specify only the Unit Cost field. However, you can specify the Capped Amount, and this is the total amount that can be invoiced.
• Quantity and Rate, you can specify the Quantity and Unit Cost.

Description Only

If this check box is selected, only the description must be specified for the scope line without linking a Cost Object. This check box is used when the work cannot be defined using the Cost Type field.

Cost Type

The cost type linked to the scope document line.

Allowed values

Labor

A specific task. You can use labor codes to control the costs of a labor code or of a group of labor codes.

Materials

The substance of which an item is composed, for example, wood, copper, nylon.

Equipment

A cost type that is required for resources, which is not consumed while the project is carried out. Examples of equipment are machinery and tools.

Subcontracting

A type of cost object representing services purchased from a third party for use in a project.

Sundry Costs

Indirect cost and costs that do not belong to other cost types are booked as sundry costs, for example, insurance costs.

Reference Activity

The smallest unit of work that is required. For example, to carry out a maintenance activity.

Composite

A combination of different cost types.

Note: This value is defaulted from the Scope Document Lines (tpctm6101m000) session.

Item

The code of an item associated with the scope line.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the scope line data is defaulted.
• If the line is initiated from the Generate AFP from Physical Progress (tpppc6230m000) session, this field is blank.
• This value is defaulted from the Scope Document Lines (tpctm6101m000) session.

Cost Object

The code of the cost object associated with the scope document line.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the scope line data is defaulted.
• If the line is initiated from the Generate AFP from Physical Progress (tpppc6230m000) session, this field is blank.
• This value is defaulted from the Scope Document Lines (tpctm6101m000) session.

Quantity

The quantity of the Item specified in the scope document.

Note: This value is defaulted from the Scope Document Lines (tpctm6101m000) session.

The unit in which the Quantity of the scope is expressed.

Sales Price

The default sales price per unit of the Cost Object.

Note: 

• If this line is initiated from the Scope Document Lines (tpctm6601m000) session, the sales price data is defaulted from the Activity.
• The currency must match the currency specified in the Contract Lines (tpctm1110m000) session.
• This value is defaulted from the Scope Document Lines (tpctm6101m000) session.

Currency

The currency in which the Sales Price is expressed.

Sales Amount

The total sales amount calculated for the Cost Type. This amount is calculated based on the Cost Amount and Markup Percentage specified. formula: Sales Amount = Quantity * Sales Price.

Capped Amount

The maximum payable amount for the specific scope line.

Note: This field is enabled only if the Line Type field is set to Rate Only.

Materials at Site Only

Indicates if the AFP line reports the value of the materials at site.

Note: This value is defaulted from the Scope Document Lines (tpctm6601m000) session.

Period to Date

Materials at Site (Applied)

Materials at Site

The value of the materials available at the project site but not consumed. This value includes the previously billed materials if the material is not consumed. This value reflects the materials available at the project site at a specific time and not the cumulative value.

Note: 

• This field is enabled only if the status of the related AFP is set to Free or Initiated in the Application for Payment (tpppc6630m000) session.
• This value cannot exceed the value specified in the Sales Amount or Capped Amount fields for the related scope document line in the Scope Document Lines (tpctm6601m000) session.
• This value is defaulted from the preceding AFP and can be modified, if required.

Previously Billed Materials at Site

The value of the materials that are billed in the previous periods. This value is used to determine the net value of materials for billing, ensuring that only unclaimed material is included for billing purposes.

Note: 

• This field is enabled only if the status of the related AFP is set to Free or Initiated in the Application for Payment (tpppc6630m000) session.
• This value is defaulted with the value specified in the Materials at Site field and can be modified, if required.
• You cannot set this field to a value greater than the value specified in the Materials at Site field.

Net Applied Materials at Site

The total value of the materials available at the project site. The net value is calculated using this formula:

Net Applied Materials at Site = Materials at Site (Applied) - Previously Billed Materials at Site

Previously Billed Materials Consumed

The value of the consumed materials that are billed in the previous period. When material is consumed for work at a project site, it is specified as progress on the subsequent AFP lines. The material that is specified in the previous AFP as materials at site and consumed at the project site is displayed in this field.

If the AFP Number is set to 1, this value is set to 0. From the second AFP onwards, this value is calculated using this formula:

Previously Billed Materials Consumed = Materials at Site value of preceding AFP (current AFP Number – 1) – Previously Billed Materials at Site (current AFP Number)

Certified

Materials at Site

The certified value of the materials available at the project site but not yet consumed. This value includes the previously billed materials and is certified by the customer.

Note: 

• This field is enabled only if:
  • The status of the related AFP is set to Submitted.
  • The Customer Assessment Complete check box is selected.
• You can specify a value that is less than or equal to the value specified in the Materials at Site field in the Materials at Site (Applied) group box.

Previously Billed Materials at Site

The certified value of the materials that are billed in the previous periods.

Note: 

• This field is enabled only if:
  • The status of the related AFP is set to Submitted.
  • The Customer Assessment Complete check box is selected.
• This value cannot be greater than the value specified in the Materials at Site fields in the Certifiedgroup box in the current and preceding AFP lines.

Net Certified Materials at Site

The total certified value of the materials available at the project site. The net value is calculated using this formula:

Net Applied Materials at Site = Materials at Site - Previously Billed Materials at Site

Previously Billed Materials Consumed

The certified value of the consumed materials that are billed in the previous period.

Note: This value is defaulted from the Previously Billed Materials Consumed field in the Materials at Site (Applied) group box.

Holdback

Use Holdback

If this check box is selected, you can use the holdback functionality for the AFP line.

Note: 

• By default, this check box is selected if the Use Holdback check box is selected for:
  • The related AFP in the Application for Payment (tpppc6630m000) session.
  • The linked activity in the Activities (tppss2100m000) session.
• This check box is enabled only until the status of the related AFP is set to Submitted.

Percentage

The holdback amount expressed as a percentage.

Note: This value is defaulted with the value specified in the Holdback field for the related AFP in the Application for Payment (tpppc6630m000) session.

Expected Holdback

The value of the holdback amount. To calculate this value, the holdback percentage is applied to the certified amount of the current period of the AFP.

Certified Holdback Amount

The holdback amount that is certified by the customer.

Note: This field is enabled only if the Customer Assessment Complete check box is selected for the related AFP in the Application for Payment (tpppc6630m000) session.

Previous Periods

Applied Progress

The applied progress reported by the contractor for the previous AFP.

%

The applied progress expressed in percentage for the scope line.

Certified Progress

The progress certified by the customer for the previous AFP.

Applied Quantity

The applied quantity in the previous AFP.

Note: This value is field defaulted from the last AFP number.

Certified Quantity

The quantity certified by the customer for the previous AFP(s).

Note: This value is defaulted from the Certified Quantity field of the last AFP.

Applied Amount

The applied amount reported by the contractor for the previous AFP(s).

Note: This value is defaulted from the Applied Amount field of the previous AFP.

Certified Amount

The total certified amount for the previous period.

Note: This value is defaulted from the Certified Amount field of the previous AFP.

Current Period

Applied Progress

The applied progress percentage for the current period. If the AFP Assessment Basis field is set to Cumulative in the Application for Payment (tpppc6630m000) session, this value is defaulted based on the cumulative Applied Progress field. formula: Progress % Applied (Current AFP) = Cumulative Progress % (Applied) - Cumulative Progress % (Applied, Till Previous Period)

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Quantity and Rate or Amount Only.
  • The AFP Status is set to Initiated.
• If you specify quantity, Applied Progress percentage is calculated by dividing the order quantity by progress quantity.

  Example:

  The order quantity is 500 and applied quantity is 100, the progress percentage is calculated as: Progress percentage = (100/500) *100 = 20%.

• If you specify an amount, Progress percentage is calculated by dividing the order amount by applied amount.

  Example: The order amount is 150000 and the applied amount is 30000 defaulted from the order for a line, the Progress percentage is calculated as: Progress percentage = (30000/150000) * 100 = 20%.

Total Applied

The total applied value is calculated using this formula:

Applied Progress + Net Applied Materials at Site - Previously Billed Materials Consumed

Note: This value can be negative only if the Materials at Site Only check box is selected for the AFP line in the Application for Payment Lines (tpppc6131m000) session.

Certified Progress

The certified progress percentage of the scope line for the current period.

If the AFP Assessment Basis field is set to Cumulative in the Application for Payment (tpppc6630m000) session, this value is defaulted based on the cumulative Applied Progress field. formula: Progress % Certified (Current AFP) = Cumulative Progress % (Certified) - Cumulative Progress % (Certified, to Previous AFP)

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Quantity and Rate or Amount Only.
  • The AFP Status is set to Initiated.
• If you specify quantity, Progress percentage is calculated by dividing the order quantity by progress quantity.

  Example: The order quantity is 500 and certified quantity is 100, the progress percentage is calculated as: Progress percentage = (100/500) * 100 = 20%.

• If you specify an amount, Progress percentage is calculated by dividing the order amount by applied amount.

  Example: The order amount is 150000 and the applied amount is 30000 defaulted from the order for a line, the Certified Progress percentage is calculated as: Certified Progress = (30000/150000) * 100 = 20%.

Applied Quantity

The applied quantity for the current period. If the Assessment Basis field is set to Cumulative in the Application for Payment (tpppc6630m000) session, this value is defaulted based on the cumulative Applied Progress field. formula: Applied Quantity (Current AFP) = Cumulative Quantity (Applied) - Cumulative Quantity (Applied, Till Previous Period).

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Quantity and Rate.
  • The AFP Status is set to Free or Initiated.
• If you specify progress percentage, applied quantity is calculated by multiplying the percentage with the order quantity.

  Example: The order quantity is 100 and progress percentage is 20%, the applied quantity is calculated as: Applied Quantity = (100*20) / 100 = 20.

• If you specify an amount, applied quantity is calculated by dividing the amount by rate. Example: The amount is 50000 and the rate is 100 defaulted from the order for a line, the quantity is calculated as: Applied Quantity = 50000/100 = 500.

Certified Quantity

The certified quantity for the current period.

formula: Applied Quantity (Current AFP) = Applied Quantity (cumulative) - Applied Quantity (cumulative, till previous period).

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Quantity and Rate.
  • The AFP Status is set to Submitted.
• If you specify progress percentage, applied quantity is calculated by multiplying the percentage with the order quantity.

  Example: The order quantity is 100 and progress percentage is 20%, the quantity is calculated as: Applied Quantity = (100*20) / 100 = 20.

• If you specify an amount, applied quantity is calculated by dividing the amount by rate. Example:

  The amount is 50000 and the rate is 100 defaulted from the order for a line, the quantity is calculated as: Applied Quantity = 50000/100 = 500.

Payless Quantity

The balance quantity after deducting Certified Progress from the Applied Quantity. formula: Payless Quantity = Applied Quantity – Certified Quantity (Current Period).

Applied Amount

The applied amount for the current period. If the AFP Assessment Basis field is set to Cumulative in the Application for Payment (tpppc6630m000) session, this value is defaulted from the Applied Amount field.

formula: Applied Amount (current AFP) = Applied Amount (cumulative) - Applied Amount (cumulative, till previous Period).

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Amount Only or Rate Only or Quantity and Rate.
  • The AFP Status is set to Initiated.
• If you specify quantity, amount is calculated by multiplying quantity by rate.
• If you specify progress percentage, the amount is calculated by the order amount by applied progress percentage.

  Example: The order amount is 50000 and the progress percentage is 20%, the amount is calculated as: Applied Amount = (50000*20) / 100 = 10000

Certified Amount

The certified amount for the current period. If the AFP Assessment Basis field is set to Cumulative in the Application for Payment (tpppc6630m000) session, this value is defaulted from theCertified Amount field.

formula: Certified Amount (Current Period) = Cumulative Amount (Certified) - Cumulative Amount (Certified, to Previous AFP)

Note: 

• This field is enabled only if:
  • The AFP Assessment Basis field is set to Periodic.
  • The Line Type field is set to Amount Only or Rate Only or Quantity and Rate.
  • The AFP Status is set to Submitted.
• If you define quantity, the amount is calculated by the order amount by multiplying quantity by rate.
• If you define progress percentage, the amount is calculated by the order amount by certified progress percentage.

  Example: The order amount is 50000 and the progress percentage is 20%, the amount is calculated as: Certified Amount = (50000*20) / 100 = 10000.

Total Certified

The total certified value is calculated using this formula:

Certified Progress + Net Certified Materials at Site - Previously Billed Materials Consumed (Certified)

Payless

Payless Quantity

This value is calculated as the difference between Applied Quantity and Certified Quantity specified for the materials at site during the current period.

Payless Amount

This value is calculated as the difference between Applied Amount and Certified Amount specified for the materials at site during the current period.

Payless Total

This value is calculated as the difference between Total Applied and Total Certified for the current period.

Cumulative

Applied Progress

The cumulative applied progress percentage of the scope document line. formula: Applied Progress % (current AFP) = Applied Progress (cumulative) – Applied Progress % (cumulative till Previous Period).

Certified Progress

The cumulative certified progress percentage of the scope document line. formula: Certified Progress % (Current AFP) = Certified Progress (Cumulative) – Certified Progress % (cumulative certified, to Previous Period).

Applied Quantity

The cumulative applied quantity of the scope document line. formula: Applied Quantity (Current AFP) = Applied Quantity (cumulative) - Applied Quantity (cumulative, till previous period).

Certified Quantity

The cumulative certified quantity of the scope document line. formula: Applied Quantity (Current AFP) = Applied Quantity (cumulative) - Applied Quantity (cumulative, till previous period).

Applied Amount

The cumulative applied amount of the scope document line. formula: Applied Amount (current AFP) = Applied Amount (cumulative) - Applied Amount (cumulative, till previous Period).

Applied Materials at Site

The cumulative applied materials at site value is calculated as the sum of Net Applied Materials at Site of all AFPs till date.

Applied Materials Consumed

The cumulative applied materials consumed value is calculated as the sum of Previously Billed Materials Consumed of all AFPs till date.

Total Applied

The cumulative total applied value for materials at site is calculated as the sum of Total Applied of all AFPs till date.

Certified Amount

The certified amount of the scope document line. formula: Applied Quantity (Current AFP) = Applied Quantity (cumulative) - Applied Quantity (cumulative, till previous period).

Certified Materials at Site

The cumulative certified materials at site value is calculated as the sum of Net Certified Materials at Site of all AFPs till date.

Certified Materials Consumed

The cumulative certified consumed materials value is calculated as the sum of Previously Billed Materials Consumed of all AFPs till date.

Total Certified

The cumulative total certified value is calculated as the sum of Total Certified of all AFPs till date.

Payless Amount

The balance quantity after deducting certified amount from the applied amount. formula: Payless Amount = Applied amount – Certified amount (Cumulative).

Payless Materials at Site

This value is calculated using this formula:

Applied Materials Consumed - Certified Materials Consumed

Payless Total

This value is calculated using this formula:

Total Applied – Total Certified

Previous Periods

Applied

Applied Materials at Site

This value is calculated as the sum of Net Applied Materials at Site of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Applied Materials Consumed

This value is calculated as the sum of Previously Billed Materials Consumed of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Total Applied

This value is calculated as the sum of Total Applied of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Certified Materials at Site

This value is calculated as the sum of Net Certified Materials at Site of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Certified Materials Consumed

This value is calculated as the sum of Previously Billed Materials Consumed of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Total Certified

This value is calculated as the sum of Total Certified of all AFPs till the previous AFP. The previous AFP is the Current AFP-1 till date.

Payless Materials at Site

This value is calculated as the difference between Net Applied Materials at Site and Net Certified Materials at Site, till previous AFP. The previous AFP is the Current AFP-1 till date.

Consumption Variance

This value is calculated as the difference between Applied Materials Consumed and Net Certified Materials Consumed, till previous AFP. The previous AFP is the Current AFP-1 till date.

Payless Total

This value is calculated as the difference between Total Applied and Total Certified, till previous AFP. The previous AFP is the Current AFP-1 till date.