Contract Lines (Contract Lines (tpctm1110m000)

Use this session to create and maintain contract line data for a project linked to a contract.

Note
  • A contract can have multiple contract line items.
  • Each contract line can be linked to one or more deliverables.
  • The contract lines contain detailed information for price, shipping, payment and billing terms.

 

Summary
Contract
The code that uniquely identifies the contract.
Description
The description or name of the code.
Contract Status
Note

If the contract header status is Canceled, all the lines are also set to Canceled.

Contract Line
The contract line number.
Description
The description or name of the code.
Status
Note
  • The contract line can be set to Active only if the contract is set to Active.
  • If the contract header status is Canceled, all the lines are also set to Canceled.
Sales
Sold-to Business Partner
The sold-to business partner for the contract line.
Address
The address of the sold-to business partner.
Contact
The contact linked to the sold-to business partner.
Sales Office
The sales office of the sold-to business partner.
Contract Manager
The employee responsible for the contract.
Search Key
The search key for the contract line.
Execution
Contract Line Execution
The contract line type indicates whether your company executes the project as main contractor or as a subcontractor.

Allowed values

Contract Execution

Project
The code that identifies the project linked to the contract line.
Financials
Hold Reason
The code that identifies the reason for putting the contract on hold.
Phase
Contract Type
Currency
The currency of the contract line amount.
Contract Line Amount
The amount specified for the contract line.
Currency
The currency of the contract line amount.
Home Contract Amount
The contract line amount in home currency.
In Home Currency
The home currency of the contract line amount.
Total Deliverables
The sum of the amounts of all the deliverables.
Currency
The currency used to express the total deliverables amount.
Dates
Contract Line Award Date
The date when the contract line is awarded by the customer.
Effective Date
The date when the validity period of the contract line starts.
Expiry Date
The date when the validity period of the contract line ends.
Contract Delivery Date
The date requested by the sold-to business partner for delivering the contract.
Selling
Internal Sales Representative
The code of the internal sales representative, defined in the Employees - General (tccom0101m000) session. The sales representative is used as the company's contact with the sold-to business partner and is also used as a reference with the invoice in the Transfer Project Data to Central Invoicing (tppin4200m000) session.
Description
The description or name of the code.
External Sales Representative
The name of the employee who is the external sales representative for the contract line, defined in the Employees - General (tccom0101m000) session.
Expected Sales Amount
The amount that defines the sales potential for the contract line.
Currency
The currency used to express the expected sales amount.
Expected Sales Amount
The expected sales amount expressed in the home currency.
In Home Currency
The home currency of the expected sales amount.
Ceiling
If this check box is selected, you can specify the ceiling amount for the contract line in the Ceiling Amount field.
Note

This field is available only for contracts of the type Cost Reimbursement and Time & Materials.

Ceiling Amount
The agreed limit for which the costs are covered by the contract.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Currency
The currency used to express the ceiling amount.
Ceiling Amount
The Ceiling Amount expressed in the home currency.
In Home Currency
The home currency of the ceiling amount.
Funded Amount
The maximum amount that is funded for the contract.
Note

Infor LN displays a message if the funding limit exceeds the contract amount or the ceiling amount defined the contract, if applicable.

This is a display field for contract lines when the status is set to Closed, Canceled or On Hold.

Funded Amount in Home Currency
The contract funded amount expressed in the home currency.
Funding Distribution
The method used to determine the distribution of the contract line funded amount.

Allowed values

Funding Distribution

Default value

Infor LN defaults the value from the contract header. However, you can modify the value.

Approved for Invoicing
The amount approved for invoicing for the contract line.
Currency
The currency used to express the approved for invoicing amount.
Approved for Invoicing
The approved for invoicing amount expressed in the home currency.
Invoiced to Date
The amount invoiced till date for the contract line expressed in the contract line currency.
Note

The invoiced amount is based on the revenue transactions registered in the Revenue Transactions (tpppc3805m000) session and includes the invoiced amounts of any contract type/invoice type and processed through sales Invoicing. The holdback amount, advance payments and manual revenues are not included in the invoiced amount.

Invoiced to Date
The invoiced to date amount expressed in the home currency.
In Home Currency
The home currency of the invoiced to date amount.
Markup Material
The percentage added to the material costs to reach a sales amount.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Markup Labor
The percentage added to the labor costs to reach a sales amount.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Markup Equipment
The percentage added to the equipment costs to reach a sales amount.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Markup Subcontracting
The percentage added to the subcontracting costs to reach a sales amount.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Markup Sundry Cost
The percentage added to the sundry costs to reach a sales amount.
Note

This is applicable only for contracts of the type Cost Reimbursement and Time & Materials.

Enforce Invoicing Period
If this check box is selected, LN determines the invoicing period for the contract line. The costs registered for the contract line within the effective period (the period between the effective date and the expiry date) only are billable.
Note

This field is available only if the Contract Type field is set to Cost Reimbursement or Time & Materials.

References
References
Customer Order
The contract number used by the customer for the contract.
First Reference
The reference text to be printed on invoices, for example, the name of a contact person or a customer reference number.
Second Reference
The reference text to be printed on invoices, for example, the name of a contact person or a customer reference number.
Prime Contractor
Description
The description or name of the code.
Prime Contract Reference
The reference number of the prime contract. This is defined by the prime contractor only at the contract line level.
DPAS
The code that identifies the DPAS rating of the contract line.
Description
The description or name of the code.
Text
If this check box is selected, a text is present.
Text
The related text for the contract line.
Shipping
Shipping
Ship-to Business Partner
The ship-to business partner for the contract line.
Ship-from Address
City
The city of the ship-from business partner.
Ship-to Address
City
The city of the ship-to business partner.
Acceptance Point
The acceptance point for the contract line.

Allowed values

Acceptance Point

Delivery Terms
The delivery terms for the contract line.
Point of Title Passage
The point of title passage for the contract line.
Carrier/LSP
The carrier for the contract line.
Marked For
External Address Code
The external code for the ship-to address.

LN allows you to specify the external address code to be printed on the DD 250 report. If you do not specify a value in this field, the address code defined in the Addresses (tccom4530m000) session will be used.

Note

You can define external address codes in the Exernal Address Codes (tccom4160m000) session.

Type
The information that is printed on the DD 250 report.

Allowed values

Type

Address
The ship-to address that is printed on the DD 250 report.
Note

This field is available only if the Type field is set to Address.

Text
The text that is printed on the DD 250 report.
Note

This field is available only if the Type field is set to Text.

Invoicing
Invoicing
Invoice-to Business Partner
The invoice-to business partner as per the contract.
Contact
The contact linked to the sold-to business partner.
Address
The address of the invoice-to business partner.
Contact
The contact linked to the invoice-to business partner.
Invoice Type
The invoice type you choose to determine the invoicing method for the contract.

Allowed values

Invoice Type

Invoicing Method
The invoicing method for the contract.
Invoice Discount
The percentage calculated as a discount on the invoice amount of the contract.
Invoice Delivery Method
The invoice delivery method for the contract line.
Sales Type
The sales type for the contract line.
Project Text on Invoice
If this check box is selected, LN prints only the project related text on the invoices.
Billing Cycle
The billing cycle for the contract line.
Last Transferred to Invoicing
The date when the contract is last invoiced.
Next Invoice Date
The date when the next invoice is generated.
Financials
Exchange Rate Type
The exchange-rate type for the contract line.
Rate Determiner
The date used to determine the exchange rate.

Allowed values

Rate determiner

Rate Factor
The rate factor for the contract line.
Rate Date
The date when the exchange rate was valid.
Currency Rate
The currency exchange rate to convert the transaction currency to the displayed home currency.
Rate Factor
The rate factor for the contract line.
Rate
The rate defined by the rate determiner and the business partner exchange rate type.
Advances / Installments
Advance Payment Requests
The method used to determine whether advance payment request is applied on the contract or contract line.
Liquidation & Advances
The liquidation percentage calculated to settle the invoices against the advances for the contract line.
Note
  • This field is available only if the Advance Payment Requests field is set to By Contract Line.
  • Only the liquidation percentage * invoice amount is used to settle an advance payment request.
  • The full invoice amount is used to settle the advance if no liquidation percentage is specified.

Example: For an advance payment request for 2000 EUR , a percentage of 75% is defined on the contract line. If a delivery based invoice of 1000 EUR is sent to the customer, an amount of 750 EUR can be used to settle the advance and the customer is invoiced for 250 EUR. If no percentage is set, the maximum amount possible is settled.

Installment Type
The installment type for the contract.

Allowed values

Installment Type

Installment Schedule
The installment schedule for the contract.
Note

You can define the installment schedule for the contract only if the installment type field is set to Percentage or Amount. The installments are generated using the Generate Installments (tppin4251m000) session, based on the schedules defined in the Installment Schedules (tcmcs2140m000) session.

Number of Points
The total number of points that you can distribute to the installments of the contract.

Example

Contract amount by customerEUR 600,000
Number of points300
Installment 1100 pointsEUR 200,000
Installment 275 pointsEUR 150,000
Installment 375 pointsEUR 150,000
Installment 450 pointsEUR 100,000
--EUR 600,000

 

Note

This field is available only if the Installment Type field is set to Points.

Labor Part of Contract Amount
The percentage of the total contract amount based on the agreement with the main contractor for the labor costs.
Note

This field is relevant only in the Netherlands.

You can view this field only if the WKA check box is selected in the General Project Parameters (tppdm0100s000) session.

Labor B-Account
This field is only relevant in the Netherlands.
Note

You can view this field only if the WKA check box is selected in the General Project Parameters (tppdm0100s000) session.

Holdback
Holdback
Indicates if holdback is applicable for the contract or specify the option to calculate the holdback.

Allowed values

Holdback

Holdback Percentage
The holdback amount expressed as a percentage. You can define the holdback percentage only if the Holdback field is set to All Invoices or Based on Progress.
Progress Threshold
The progress threshold percentage for the contract. You can define the threshold percentage only if the Holdback field is set to All Invoices or Based on Progress.
Tax
Tax
Tax Classification
The tax classification for the contract line, defined in the Tax Classifications (tctax0116m000) session.
Exempt
If this check box is selected, the tax code represents tax exemption.
Tax Country
The tax country for the contract line.
Own Tax Number
The tax number allotted by the government.
Tax Code
The tax code for the contract line, defined in the Tax Codes by Country (tcmcs0536m000) session.
BP Tax Country
The tax country of the sold-to business partner for the contract line.
BP Tax Number
The tax number allotted by the government to the sold-to business partner.
Tax Exemption Certificate Number
The tax exemption certificate number if tax is exempted on the contract line
Note

You can enter the tax exemption certificate number if the Tax Exempt check box is selected.

Tax Exemption Reason
The code that identifies the reason if tax is exempted on the contract line.
Note

You can enter the tax exemption reason if the Tax Exempt check box is selected.

Paying
Paying
Pay-by Business Partner
The pay-by business partner as per the contract line.
Address
The address of the pay-by business partner.
Contact
The contact linked to the pay-by business partner.
Phone
The phone number of the pay-by business partner.
Payment Terms for Financial Analysis (in days)
The payment terms for the contract line.
Late Payment Surcharge
The late payment surcharge for the contract line.
Payment Method
The payment method for the contract line.
Bank Account Code
The code that uniquely identifies the bank.
Bank Account
The bank account number.

The bank account is identified by a number of the business partner with the bank indicated by the bank account code and displayed based on the bank account code.

International Bank Account Number
The international bank account number for the contract line. This is a display field.
Classification
Classification
Line of Business
The line of business of the project linked to the contract line. This is defined in the Lines of Business (tcmcs0131m000) session.
Description
The description or name of the code.
Acquiring Method
The code that identifies the acquiring method for the project linked to the contract line. This is defined in the Acquiring Methods (tppdm0140m000) session.
Financing Method
The code that identifies the financing method used for the project linked to the contract line. This is defined in the Financing Methods (tppdm0139m000) session.
Geographical Area
The geographical area associated with the project linked to the contract line.
Category
The code that identifies the category of the project linked to the contract line. This is defined in the Categories (tppdm0146m000) session.
Business Sector
The code that identifies the business sector of the project linked to the contract line. This is defined in the Business Sectors (tppdm0137m000) session.
Group
The code that identifies the project group linked to the contract line. This is defined in the Groups (tppdm0141m000) session.
Tracking
Created by
The user who creates the record.
Creation Date
The date when the record is created.
Last Modified by
The user who last modifies the record.
Last Modified on
The date when the record is last modified.
Last Change Reason
The code that identifies the reason for the most recent modification.
Additional Information
Additional Field
The additional information for the contract line.

 

Set Status to
Sets the contract line status to the selected value.
Free
Sets the contract line status to Free.
On Hold
Sets the contract line status to On Hold.
Active
Sets the contract line status to Active.
Closed
Sets the contract line status to Closed.
Canceled
Sets the contract line status to Canceled.