Financial Transactions (tpppc2100m100)

Field Information

Project

The project code.

Description

The description or name of the code.

Project Status

The project status.

Cost

Transaction Time

The date and time when the transaction line is created.

Element

The code of the element linked to the project.

Description

The description or name of the code.

Work Authorization Status

The work authorization status of the element linked to the transaction.

Activity

The code of the activity linked to the project.

Description

The description or name of the code.

Work Authorization Status

The work authorization status of the activity linked to the transaction.

Cost Type

The cost type linked to the project.

Cost Object

The cost object.

Quantity

The quantity of the cost object linked to the transaction.

Note: 

LN considers the number of labor hours (instead of quantity), for the cost component of the cost type Labor, when calculating the cost and revenues for the project.

MAUH = total hours/inventory quantity

• LN defaults this value of the Moving Average Unit Hours (MAUH) from Warehousing , and is used to calculate the number of labor hours.
• The number of labor hours are required for the accurate cost calculation of Overheads and considered for Invoicing .

Unit

The unit used to express the quantity of the cost object.

Project Cost in Home Currency

The project cost amount expressed in the home currency. The home currency amount (debit) contains the home currency amounts expressed using the exchange rates of the financial company linked to the project.

Cost Amount in Home Currency (Debit)

The cost amount expressed in the home currency (debit).

Posting Type

The posting type for the cost object.

Allowed values

Additional Calculation Office Variance

Shipment Variance Intercompany (Project)

General Costs Intercompany

Material

Material Intercompany

Value Correction

Repair Warranty Costs

WIP Hours

Warranty Costs

WIP Costs (through Financials)

WIP Transfer Issue

WIP Transfer Receipt

WIP Transfer Receipt Intercompany

Warehouse Surcharge Issue

Warehouse Surcharge Receipt

Cost of Sales

Goodwill

Tool Costs

Tool Costs Intercompany

Issue Intercompany (Project)

Adjustment

Landed Costs

Landed Costs Variance

Landed Costs Invoiced

Landed Costs Variance Invoiced

Invoiced WIP

Issue (Project)

Loan Result

Sales Order Price Variance

COS Intercompany

Planned Stage Payment

Released Stage Payment

Receipt (Stage Payment)

Loan

Borrow

Payback Result

Receipt Variance (Stage Payment)

Cost Peg Reallocation (Stage Payment)

Currency Variance (Stage Payment)

Approval (Claim)

Expense Tax (Stage Payment)

Loan Reversal

Borrow Reversal

Currency Variance

WIP Quarantine Issue

Quarantine Adjustment

Currency Variance (Landed Costs)

Revenues Intercompany

COS Price Variance

WIP Costs Intercompany

WIP Hours Intercompany

Expenses Intercompany

Landed Costs Intercompany

Landed Costs Invoiced Intercompany

Receipt Intercompany (Stage Payment)

Direct Receipt Intercompany

Variance Intercompany

COS Variance

Work Order Price Variance

Cost of Sales Recognition

COS Invoiced (Project)

Soft Commitment (Project Control)

Soft Commitment (Project Control) - Rev

Receipt (Project Warehouse)

Matched Receipt

Project Control

Inventory

Cost Invoice

Price Variance - Rev

Expense Tax

Landed Costs Expense Tax

Purchase Invoice

Landed Costs without Invoice

Field Service Cost

Labor Cost

Hours (Subcontracting)

Manual Sales

Surcharge on Soft Commitment

Surcharge on Hard Commitment (Project)

Surcharge on Cost

Applied Overhead

Direct Delivery Issue

Stage Payment Invoice

Cost Peg Reallocation (Expense Tax)

Currency Gain and Loss

Direct Delivery Issue Intercompany

Direct Delivery Variance

Direct Delivery

Issue Result

Expenses

Variance Adjustment

Freight Price Variance

Field Change Order Costs

Freight Costs

General Costs Variance

General Costs (through Financials)

General Costs

General Costs Work Order

Interim Result

Issue

Issue Intercompany

Item Surcharge Receipt

Item Surcharge Issue

On Order

Operation Costs

Price Variance

Transfer from Service WIP

Contract

Quarantine Receipt

Purchase Price Variance

Receipt

Rejection

Revaluation

Revenues

Revenues Analysis

Reverse Interim Result

Receipt Intercompany

Shipment Variance

Subcontracting

Subcontracting WIP

Rejection Intercompany

Subcontracting Intercompany

Operation Costs Intercompany

General Costs Work Order Intercompany

Origin

The source document type.

Allowed values

Production Order

Not Applicable

Warehouse Order

Service Order

PRP Purchase Order

PRP Warehouse Order

Purchase Order

Service Call

Service Contract

Financial Document

Warehouse Transfer

Production Batch

Sales Order

Assembly Part Demand

Purchase Order (Manual)

Warehouse Transfer (Manual)

Maintenance Sales Order

Maintenance Work Order

Freight

Cycle Counting Order

Adjustment Order

Revaluation Order

Production Schedule

Production Kanban

Project

Project (Manual)

Purchase Schedule

Warehouse Transfer (Distribution)

Sales Schedule

Inventory Ownership Change Order

Buy-From BP Transfer (Purchase)

Buy-From BP Transfer (Schedule)

Sold-To BP Transfer (Sales)

Sold-To BP Transfer (Schedule)

Sold-To BP Transfer (WH Manual)

Sold-To BP Transfer (Manual)

ASC Production Order

Sold-To BP Transfer (WH Distribution)

Planned Cost Peg Transfer

Cost Peg Transfer

Contract

Document

The code that identifies the order number.

Order Line

The position number of the order line.

Cost Rate

The standard cost per unit.

Cost Amount

The total cost amount for the transaction.

Cost Currency

The currency code.

Original Document Amount in Home Currency

The cost amount of the original document expressed in the home currency. The home currency amount (credit) contains the home currency amounts expressed using the exchange rates of the financial company of the origin of the transaction (for example, the financial company of the purchase office for a purchase order).

Home Currency

The home currency (credit) for the transaction.

Project Currency Rate and Rate Factor

The project currency rate.

Rate Factor

The rate factor

Amount of Time

The number of time units. For example, the number of days that a crane is used for a project.

Time Unit

The unit used to express the time.

Labor Type

The labor type code.

Stage Payment

The supplier stage payment line number linked to the order line of the type Purchase Order.

Rate Date (Costs)

The date on which the exchange rate is valid.

Exchange Rate Type (Costs)

The exchange rate type.

Description

The description or name of the code.

Rate Determiner (Costs)

The method to determine which date is used to determine the exchange rates.

Allowed values

Document Date

LN uses the rate that is valid on the date and time on which the documents are created. The Document Date rate determiner applies to all types of transactions. You can manually change the rate.

The rate is updated by Invoicing when the invoice is posted.

Manually Entered

You can manually enter the rate. By default, LN uses the rate that is valid on the date and time on which the documents are created. The Manually Entered rate determiner applies to all types of transactions.

Delivery Date

If the goods are not yet delivered, LN uses the rate that is valid on the order date. However, if this order date is in the past, LN uses the rate that is valid on the current date.

If the goods are delivered, LN uses the rate that is valid on the actual delivery date.

The Delivery Date rate determiner only applies to sales orders, service orders, and sales invoices. You cannot manually change the rate.

Receipt Date

LN uses the rate that is valid on the date and time on which you expect to receive the goods. The Receipt Date rate determiner only applies to purchase orders and purchase invoices. You cannot manually change the rate.

Expected Cash Date

LN uses the rate that is valid on the date and time at which payment of the sales invoice or purchase invoice is expected.

Expected cash date = expected delivery/receipt date + payment period 

The payment period is specified in the Payment Terms (tcmcs0113s000) session. The Expected Cash Date rate determiner applies to all types of transactions. You cannot manually change the rate.

The rate is updated by Invoicing when the invoice is posted.

Fixed

You can use this rate determiner only for a dependent currency system or a single currency system. The Fixed rate determiner applies to all types of transactions.

If you manually enter the rates between the transaction currency and the reference currencies, the rate is fixed. If you do not manually enter the rates, the rate is not fixed and LN uses the rate that is valid on the date and time on which the documents are created.

Fixed Hard

You can use this rate determiner only for an independent currency system. The Fixed Hard rate determiner applies to all types of transactions.

If you manually enter the rate between the transaction currency and the reporting currencies, the rates are fixed. The local currency rate is based on the document date of the actual document.

If you do not manually enter the rate between the transaction currency and the reporting currencies, the rates are not fixed and LN uses the rates that are valid on the date and time on which the documents are created.

Fixed Local

You can use this rate determiner only for an independent currency system. The Fixed Local rate determiner applies to all types of transactions.

If you manually enter the rate between the transaction currency and the local currency, the rate is fixed. The other rates are based on the document date of the actual document.

If you do not manually enter the local currency rate, the rate is not fixed and LN uses the rate that is valid on the date and time on which the documents are created.

Fixed Local and Hard

You can use this rate determiner only for an independent currency system. The Fixed Local and Hard rate determiner applies to all types of transactions.

If you manually enter the rate between the transaction currency and the home currencies, the rates are fixed. The local currency rate is based on the document date of the actual document.

If you do not manually enter the rates between the transaction currency and the home currencies, the rates are not fixed and LN uses the rates that are valid on the date and time on which the documents are created.

Hours Surcharge %

The surcharge percentage used for the transaction.

Note: This field is applicable only for the transactions of the cost type Labor.

Sequence

The sequence number of the transaction.

Source

Extension

The code that identifies the extension linked to the transaction.

Description

The description or name of the code.

Extension Status

The status of the extension.

Cost Component

The cost component linked to the project.

Note: You can only specify a cost component for which the Component Type is set to Detail or Collect in the Cost Components (tcmcs0148m000) session.

Description

The description or name of the code.

Employee

The code that identifies the employee.

Employee Name

The name of the employee.

Description

The description or name of the code.

Effectivity Unit

The effectivity unit code.

Description

The description or name of the code.

Phantom Item

The code of the phantom item that is a part of the bill of material.

Description

The description or name of the code.

Phantom Quantity

The quantity of the phantom item.

Unit

The unit of measure used to express the phantom item quantity.

Effectivity Unit Phantom

The effectivity unit code for the phantom item.

Description

The description or name of the code.

Cost Component for Mapping

The code of the cost component for mapping.

Description

The description or name of the code.

Description

The description or name of the code.

Plan

The code that uniquely identifies the plan to which the transaction is linked.

Original Item

The original item linked to the transaction.

Description

The description or name of the code.

Hours Accounting Sequence

The sequence in which the project hours are accounted.

Commitment Sequence

The sequence number of the corresponding commitment.

Text

If this check box is selected, a text is present.

Integration Transaction GUID

The generated internal code (GUID) used for the integration of the financial transaction.

Unique ID

The unique ID of the integration transaction.

Sales

Sales Price

The sales price of the cost object.

Sales Amount

The total sales amount.

Sales Currency

The currency used to express the sales price.

Sales Currency Rate and Rate Factor

The currency exchange rate.

Rate Factor (Sales)

The rate factor

Sales Amount in Home Currency

The sales amount in the home currency.

Currency

The currency used to express the amounts for the transactions.

Rate Date (Sales)

The date on which the exchange rate was valid.

Transaction

Project Costs

Infor LN selects this check box to indicate that the project costs are included in the transaction and that the transaction adds cost to the project.

Note: Infor LN clears this checkbox to indicate that another transaction is created to nullify the costs added to the project by this transaction.

Post to Finance

Infor LN selects this check box to indicate that the costs are posted to Financials . However, all the transactions may not be posted to Financials .

If this check box is selected, the costs are posted to the Project WIP in Financials . You can view the integration transaction in the Integration Transactions (tfgld4582m000) session. The default value of the Integration Document Type is Project Costs & Commitments. These costs are generated from various origins, such as purchase orders, warehouse orders, inventory transfers, project hours, and other types of financial variances such as price and currency variances and surcharges. When the project is closed, these cost transactions are transferred from the project WIP costs to the final project costs using the Project Costs and Commitments/Completion postings.

If this check box is not selected the costs are assigned to the project, but are yet to be posted to the Project WIP. From a financial perspective the costs are still part of one of these ledgers in Financials :

• Inventory
• Production WIP
• Service WIP
• Goods Delivered Not Invoiced (GDNI)

Receipt Expense Tax

Indicates if the financial transaction is related to expense tax.

Note: This check box is displayed only if the At Receipt check box is selected in the Consume Expense Tax in Inventory / WIP section of the ACP Parameters (tfacp0100m000) session.

Run Date

The date when the financial transactions are processed.

Note: This field is applicable only for the transactions originating from Project and that are also approved and processed in Project .

Processing Run

The number generated when the transactions are processed.

Note: This field is applicable only for the transactions originating from Project and that are also approved and processed in Project .

Transaction Origin

The transaction origin.

Transaction Type Financial Transaction

The transaction type of the financial document.

Financial Transaction

The status of the financial transaction.

Old-fashioned Flow

Infor LN selects this check box to indicate that the transaction processing is not based on pegging.

Borrow/Loan

Infor LN selects this check box to indicate that the cost peg transfer type of the transaction is borrow/loan (that is temporary transfer of inventory between cost pegs).

In Warehousing , you can transfer the inventory from one project cost peg to another, temporarily, wherein, the inventory that is pegged to a specific project cost peg is borrowed ( Borrow/ Loan - Payback) from one project cost peg and used for another project cost peg during the warehouse outbound procedure. The borrowed items are replenished to the lending cost peg using Payback and generated on receipt of the inventory actually ordered for the borrowing project cost peg.

Document

The code of the document that contains the transaction details.

Settlement Origin

Infor LN selects this check box to indicate that the transaction is posted as a result of a fluctuation settlement.

Project Completion

Completion Transaction in Finance

Infor LN selects this check box to indicate that the financial result of the transaction is processed in Project using the Process Transactions (tpppc4802m000) session.

Completion Run Date

The date when the financial transactions are completed.

Completion Run

The number generated when the transactions are completed.

Financial Registration Date at Completion

The financial registration date on which the transaction is processed in Project using the Process Transactions (tpppc4802m000) session.

Document

Contract

The code that identifies the contract.

Description

The description or name of the code.

Contract Line

The contract line number.

Description

The description or name of the code.

Purchase Receipt

The sequence number of the purchase receipt.

Warehouse Receipt / Shipment

The warehouse receipt number.

Warehouse Receipt / Shipment Line

The warehouse receipt line number.

Warehouse

The code of the project warehouse.

Warehouse

The code of the warehouse.

Intercompany Trade Order

The company in which the intercompany trade order is created.

Intercompany Trade Order Number

The order number of the intercompany trade order.

Intercompany Trade Order Line Number

The line number of the intercompany trade order.

Employee Company

The logistic company specified for the employee department.

Note: 

• This field is mandatory if an employee is linked to the cost transaction.
• The value of the employee company is zero for transactions that originate from earlier versions.

Description

The name of the company.

Logistic Company of Document

The logistic company that stores the original document.

Description

The description or name of the code.

Reason

The reason code.

Description

The description or name of the code.

Invoice Batch Number

The invoice-sequence number that LN assigns when an invoice is processed based on the corresponding order line.

Buy-from Business Partner

The buy-from business partner for the transaction.

Description

The description or name of the code.

Invoice-from Business Partner

The invoice-from business partner code.

Description

The description or name of the code.

Subcontracting

The code that identifies the subcontracting cost object.

Business Object Name

The business object linked to the transaction.

Business Object Reference

The business object reference linked to the transaction.

Overhead

Overhead Base

The code that identifies the overhead base.

Version

The version number that LN generates based on the unique base code.

Description

The description or name of the code.

Overhead Percentage

The overhead percentage as defined in the Overhead Application Bases (tppdm2100m000) session.

Description

The description or name of the code.

Landed Cost

Landed Cost

The code that identifies landed costs.

Landed Cost Line

The landed cost line number.

Description

The description or name of the code.

Invoice

Approved for Invoicing

Infor LN selects this check box to indicate that the transactions are approved for invoicing.

Transferred to Invoicing

Infor LN selects this check box to indicate that the transactions are transferred to invoicing.

Suppressed for Next Billing Cycle

If this check box is selected, the selected transaction is not invoiced to the business partner.

Note: By default, this check box is cleared.

Financial Document (Sales Invoicing)

The code of the financial document for the sales invoice.

Transaction Type

The code of the invoice type.

Invoice Document

The invoice document number.

Note: 

• The Invoicing module identifies an invoice by this field.
• Infor LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing . When you cancel the invoice, you can only modify the invoice data such as reference, address, and tax number, if required.
• You can also modify the Invoice Amount when you create a credit note for a specific invoice line..
• Infor LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing.
• When you cancel the invoice, you can modify the invoice data such as reference, address, and tax number. However, you can also modify the Billable Amount if you create a credit note for a specific invoice line. Only the authorized users (in Invoicing) can modify the amount.
• The invoice must not be linked to an installment.
• The status of the project must not be Closed.

Sales Invoice Line

The sequence number of the invoice line.

Financial Document

The code of the financial document.

Document Financial Transaction

The code of the financial document for invoicing.

Line Number Financial Transaction

The line number of the financial document.

Sequence Number Finance

The sequence number of the financial document.

Holdback

Infor LN selects this check box to indicate that holdback is applicable.

Holdback Sequence Number

The code of the holdback number.

Billable

Infor LN selects this check box to indicate that the transactions are billable.

Company

Entity

The type of entity for the transaction.

Allowed values

Sales Office

sales office

Shipping Office

shipping office

Project Management Office

project management office

Production Department

production department

Purchase Office

purchase office

Not Applicable

Service Department

service department

Work Center

work center

Warehouse

warehouse

Project

project

Accounting Office

accounting office

Contract

contract

Inventory Management Department

Inventory management department

Entity

The code of the entity type.

Enterprise Unit

The enterprise unit responsible for the delivery specified on the transaction line.

Description

The description or name of the code.

Project Financial Company

The code of the receiving company.

Description

The description or name of the code.

Intercompany

Infor LN selects this check box to indicate that intercompany transactions are linked to the transaction line.

Financial Company Transaction Origin

The code of the financial company in which the transaction is originally created.

Description

The description or name of the code.

Period

Cost Control Period

The code that identifies the cost control period for the transaction.

Cost Control Year

The cost control year in which the transaction is posted to cost history.

Cost Control Period

The period in which the transaction is posted to cost history for cost control.

Financial Control Period

The code that identifies the financial period for the cost transaction.

Fiscal Year

The year of the period in which the transaction is posted to Financials .

Fiscal Period

The period in which the transaction is posted to Financials .

Hours Control Period

The period code used for the hours control period.

Note: This field is applicable only for the transactions with the cost type set to Labor.

Year Hours Accounting

The period that identifies the actual hours control period.

Note: This field is applicable only for the transactions with the cost type set to Labor.

Period Hours Accounting

The year together with the period number, identifies the actual hours control period.

Note: This field is applicable only for the transactions with the cost type set to Labor.

Registration Date

The date and time when the transaction line is registered.

Financial Registration Date

The financial registration date on which the transaction is processed in Project .

Tax

Tax Classification

The tax classification for the transaction.

Description

The description or name of the code.

Exempt

If this check box is selected, the tax code represents tax exemption.

Tax Country

The tax country for the transaction.

Description

The description or name of the code.

Own Tax Number

The tax number of the company.

Note: 

• This is a display field.
• Infor LN populates this value based on the:
  • The Financial company that is linked to the Sales Office of the contract line.
  • The Tax country linked to the contract line.
  • The Reference date from which the tax is applicable. Usually, the invoice date is considered as the reference date.

Tax Code

The tax code for the transaction line.

Description

The description or name of the code.

BP Tax Country

The tax country defined for the business partner.

Description

The description or name of the code.

BP Tax Number

The tax number allotted by the government to the sold-to business partner.

Exemption Certificate

The tax exemption certificate number, if tax is exempted for the transaction.

Exemption Reason

The code that identifies the reason for tax exemption.

Description

The description or name of the code.

Cost Text

The additional text related to the transaction.