Standard Code Lists

Standard code lists are not published by Infor LN. The code values must be known for any application in the ION environment. Therefore, Infor PCL must implement these code lists and values, as listed in this Appendix.

The integration uses the standard ISO-code lists for currencies, countries, and languages:

Code List	Description
Currencies	Standard currency codes use the ISO 4217 currency code.
Countries	Standard country codes use the ISO 3166-1 alpha 2 country codes.
Languages	Standard language codes use the ISO 639-1 language code.

The integration also uses the following code lists and fixed values:

1. Code list: Billing Types - Enumerated codes used for defining the method to calculate invoice amounts for a specified project contract type - the type determines, the time when the invoices must be issued to the customer.

Published Value	Infor LN Value	Description
Cost Plus	Cost Plus	The invoice amount is based on the financial amounts specified at cost object level plus a profit.
Unit Rate	Unit Rate	The invoice amount is based on the financial amounts per unit, defined at project element or activity level.
Installment	Installment	The invoice amount is an agreed-upon part of the contract amount.
Progress Invoice	Progress Invoice	The invoice amount is based on progress for project, element or activity.
Delivery Based	Delivery Based	Invoicing is based on the sales amounts of the contract deliverables that are linked to the contract shipments.

2. Code list: Cost Types - Enumerated codes used for categorizing cost objects according to the nature of the costs.

Published Value	Infor LN value	Description
Material	Material	Costs for consumable items
Labor	Labor	Costs for specific tasks
Equipment	Equipment	Costs for non-consumable items, such as machinery and tools
Subcontracting	Subcontracting	Costs for hired third-party services
Sundry	Sundry Costs	Indirect costs and costs that do not belong to other cost types, for example, insurance costs
Overhead	Overhead	Costs for applied overhead

3. Code list: Earned Value Methods - Methods for measuring project performance by comparing planning with actuals.

Published Value	Infor LN value	Description
Milestone	Milestone	Based on milestones reached
Start and End Percent	Start and End Percentage	Based on percentage values attached to the start and end points of activities
Percent Complete	Percent Complete	Based on the percentage progress of activities
Effort Level	Level of Effort	Based on the performed proportional effort of time-driven activities
Apportioned	Apportioned	Based on an intrinsic performance relationship to another activity

*In Infor PCL, the first 3 earned value methods are supported. The last two are treated as Percent Complete by default.

4. Code list: Financial Status - The financial result status of a project, regarding the generation of final financial transactions.

Published Value	Infor LN Value	Description
Free	Free	For the project, the generation of final result financial transactions is not applicable
Determine	Determine Result	For the project, final result financial transactions have not been generated yet
Result	Result Determined	For the project, final result financial transactions have been generated and posted to the general ledger

5. Code list: Holdback Types - A classification that defines how holdback is defined, for example, for a project contract line. Holdback is a percentage amount that the customer withholds from the contract amount.

Published Value	Infor LN Value	Description
All Invoices	All Invoices	The holdback is applied on all invoices
Based on Progress	Based on Progress	The holdback is applied based on the progress of the related project
No Holdback	No Holdback	Holdback is not applied

6. Code list: Installment Types - Installment types indicate how installments are applied in Invoicing.

Published Value	Infor LN Value	Description
Amount	Amount	The installments are divided into fixed amounts
Percent	Percentage	The installments are divided as percentage amounts
Points	Points	The installments are divided into points
Not Applicable	Not Applicable	Installment is not applied

7. Code list: Posting Types - Posting types are used to identify financial transactions and to determine how the transactions must be posted to the general ledger. Posting types indicate where the financial transaction originates from, and combine related posting types in the project cost and revenue history.

Published Value	Infor LN Value	Description	Type of Cost
Additional Calculation Office Variance	Additional Calculation Office Variance	Additional calculation office variance	Actual Cost
Contract	Contract	Contract	Actual Cost
Adjustment	Adjustment	Adjustment	Actual Cost
Work Order Price Variance	Work Order Price Variance	Work order price variance	Actual Cost
DirectDeliveryIssue	Direct Delivery Issue		Actual Cost
DirectDeliveryVariance	Direct Delivery Variance		Actual Cost
Direct Delivery	Direct Delivery		Actual Cost
Issue Result	Issue Result	Issue result	Actual Cost
Expenses	Expenses	Costs entered as employee expenses related to a project	Actual Cost
Variance Adjustment	Variance Adjustment		Actual Cost
FreightPriceVariance	Freight Price Variance		Actual Cost
FreightCosts	Freight Costs		Actual Cost
General Costs Variance	General Costs Variance	General costs variance	Actual Cost
General Costs (through Financials)	General Costs (through Financials)	General costs (through Financials)	Actual Cost
General Costs	General Costs	General costs	Actual Cost
General Costs Work Order	General Costs Work Order		Actual Cost
Interim Result	Interim Result		Interim Results
Issue	Issue	Issue	Actual Cost
Issue Invoiced	Issue Invoiced		Actual Cost
Item Surcharge Receipt	Item Surcharge Receipt	Item surcharge receipt	Actual Cost
Item Surcharge Issue	Item Surcharge Issue	Item surcharge issue	Actual Cost
On Order	On Order	Commitment originating from purchase order entry	Soft Commitment
Operation Costs	Operation Costs		Actual Cost
Price Variance	Price Variance	Costs originating from a purchase price variance	Hard Commitment
QuarantineReceipt	Quarantine Receipt		Actual Cost
PurchasePriceVariance	Purchase Price Variance		Actual Cost
Receipt	Receipt	Commitment originating from assigning a purchase order to a project	Hard Commitment
Rejection	Rejection		Hard Commitment
Revaluation	Revaluation		Actual Cost
Revenues	Revenues		Actual Cost
RevenuesAnalysis	Revenues Analysis		Actual Cost
Reverse Interim Result	Reverse Interim Result		Reverse Interim Results
ReceiptInvoiced	Receipt Invoiced		Actual Cost
Shipment Variance	Shipment Variance	Costs originating from a shipment variance	Actual Cost
Subcontracting	Subcontracting		Actual Cost
SubcontractingWorkInProgress	Subcontracting WIP		Actual Cost
SubcontractingInvoiced	Subcontracting Invoiced		Actual Cost
OperationInvoiced	Operation Invoiced		Actual Cost
GeneralCostsWorkOrderInvoiced	General Costs Work Order Invoiced		Actual Cost
ShipmentVarianceInvoiced(Project)	Shipment Variance Invoiced (Project)		Actual Cost
GeneralCostsInvoiced	General Costs Invoiced		Actual Cost
Material	Material		Actual Cost
MaterialInvoiced	Material Invoiced		Actual Cost
Value Correction	Value Correction	Value correction	Actual Cost
Repair Warranty Costs	Repair Warranty Costs	Repair warranty costs	Actual Cost
Work in Process Hours	WIP Hours	Work in process hours	Actual Cost
Warranty Costs	Warranty Costs	Warranty costs	Actual Cost
WorkInProcessTransferIssue	WIP Transfer Issue		Actual Cost
Work in Process Transfer Receipt	WIP Transfer Receipt		Actual Cost
WorkInProcessTransferReceiptInvoiced	WIP Transfer Receipt Invoiced		Actual Cost
Warehouse Surcharge Issue	Warehouse Surcharge Issue	Warehouse surcharge issue	Actual Cost
Warehouse Surcharge Receipt	Warehouse Surcharge Receipt	Warehouse surcharge receipt	Actual Cost
CostOfGoodsSold	CostOfGoodsSold		Actual Cost
Goodwill	Goodwill	Goodwill	Actual Cost
Tool Costs	Tool Costs	Tool costs	Actual Cost
ToolCostsInvoiced	Tool Costs Invoiced		Actual Cost
IssueInvoiced(Project)	Issue Invoiced (Project)		Actual Cost
Landed Costs	Landed Costs	Landed costs	Actual Cost
Landed Costs Variance	Landed Costs Variance	Landed costs variance	Hard Commitment
Landed Costs Invoiced	Landed Costs Invoiced	Landed costs invoiced	Hard Commitment
Landed Costs Variance Invoiced	Landed Costs Variance Invoiced	Landed costs variance invoiced	Actual Cost
Invoiced Work in Process	Invoiced WIP	Invoiced work in process	Actual Cost
Issue (Project)	Issue (Project)		Actual Cost
Loan Result	Loan Result	Loan result	Actual Cost
Sales Order Price Variance	Sales Order Price Variance		Actual Cost
CostOfGoodsSoldInternalInvoice	COGS Internal Invoice		Actual Cost
PlannedStagePayment	Planned Stage Payment		Soft Commitment
ReleasedStagePayment	Released Stage Payment		Hard Commitment
Loan	Loan		Monitoring
Borrow	Borrow		Monitoring
PaybackResult	Payback Result		Actual Cost
ReceiptVariance(StagePayment)	Receipt Variance (Stage Payment)		Project WIP
CostPegReallocation(StagePayment)	Cost Peg Reallocation (Stage Payment)		Actual Cost
CurrencyVariance(StagePayment)	Currency Variance (Stage Payment)		Actual Cost
ExpenseTax(StagePayment)	Expense Tax (Stage Payment)		Actual Cost
LoanReversal	Loan Reversal		Monitoring
BorrowReversal	Borrow Reversal		Monitoring
CurrencyVariance	Currency Variance		Actual Cost
WorkInProcessQuarantineIssue	WIP Quarantine Issue		Actual Cost
QuarantineAdjustment	Quarantine Adjustment		Actual Cost
CurrencyVariance(LandedCosts)	Currency Variance (Landed Costs)		Actual Cost
Soft Commitment (Project Control)	Soft Commitment (Project Control)	Manually entered commitments	Soft Commitment
Soft Commitment (Project Control) - Reversal	Soft Commitment (Project Control) – Rev	Manual reversal of previously entered soft commitments, after posting to general ledger	Soft Commitment
Receipt (Project Warehouse)	Receipt (Project Warehouse)	Commitment originating from delivery of the ordered items to the project warehouse	Hard Commitment
Matched Receipt	Matched Receipt	Reversal of the hard commitment when a purchase invoice is processed	Hard Commitment
Project Control	Project Control	Manually entered project costs	Actual Cost
Inventory	Inventory	Material costs originating from a planned warehouse transfer	Actual Cost
Cost Invoice	Cost Invoice	Costs originating from a purchase cost invoice	Actual Cost
Price Variance – Reversal	Price Variance – Rev	Reversal of costs created for a purchase price variance	Hard Commitment
Expense Tax	Expense Tax	Purchase costs originating from non-deductible tax	Actual Cost
Landed Costs Expense Tax	Landed Costs Expense Tax	Landed costs expense tax	Actual Cost
Purchase Invoice	Purchase Invoice	Costs originating from a purchase order related invoice	Actual Cost
Landed Costs without Invoice	Landed Costs without Invoice	Additional costs for which no purchase invoice is received	Actual Cost
Field Service Cost	Field Service Cost	Costs that originate from a service order	Actual Cost
Labor Cost	Labor Cost	Costs for time-registered hours	Actual Cost
Hours (Subcontracting)	Hours (Subcontracting)	Costs originating from subcontracting labor	Actual Cost
Manual Sales	Manual Sales	Sales value originating from a manually entered billable cost line	Actual Cost
Surcharge on Soft Commitment	Surcharge on Soft Commitment	Surcharges on soft commitments	Soft Commitment
Surcharge on Hard Commitment (Project)	Surcharge on Hard Commitment (Project)	Surcharges on hard commitments	Hard Commitment
Surcharge on Cost	Surcharge on Cost	Surcharges on costs	Actual Cost
Applied Overhead	Applied Overhead	Recognized overhead costs	Actual Cost
Stage Payment Invoice	Stage Payment Invoice	Stage Payment Invoice	Actual Cost
CostPegReallocation(ExpenseTax)	Cost Peg Reallocation (Expense Tax)	Payback Variance	Actual Cost
CurrencyGainAndLoss	Currency Gain and Loss		Actual Cost
ActualCosts	N/A (this is the default)		Actual Cost

8. Code list: Project Activity Relationship Types - Relationship types define the dependencies between the predecessor and successor project activities.

Published Value	Infor LN Value	Description
Start to Start	Start to Start	The initiation of the task of the successor depends upon the initiation of the task of the predecessor
Start to Finish	Start to Finish	The completion of the task of the successor depends upon the initiation of the task of the predecessor
Finish to Start	Finish to Start	The initiation of the task of the successor depends upon the completion of the task of the predecessor
Finish to Finish	Finish to Finish	The completion of the task of the successor depends upon the completion of the task of the predecessor

9. Code list: Project Activity Types – Defining activities in the project activity structure.

Published Value	Infor LN Value	Description
WBS Element	WBS Element	Work breakdown structure element used to break down the project scope into smaller pieces
Project Cost Account	Project Cost Account	Activity level that can be related to an organization breakdown structure, and to which level functional responsibility for work and costs can be assigned
Planning Package	Planning Package	Activity level, identified during planning, to time phase major activities within a project cost account
Work Package	Work Package	Activity level for the detailing of short-span jobs in the execution of a project
Milestone	Milestone	Represents an activity of zero days that usually represents a significant event in the project. It can be used at the time of invoicing and the calculation of earned value

10. Code list: Project Budget Status - Budget statuses of project elements and activities.

Published Value	Infor LN Value	Description
Free	Free	The general data for a budget line has been recorded, and can be changed
Actual	Actual	The budget data can still be changed, and control data can be generated; the budget history can be logged
Final	Final	The budget data cannot be changed anymore; budget lines can only be added through a budget adjustment; the actual budget history can be logged

11. Code list: Project Contract Status - Statuses that refer to a formal authorization procedure to begin work on a specific activity.

Published Value	Infor LN Value	Description
Draft	Free	The contract/contract line definition is created, but not executed yet, and changes are still possible
Pending	On Hold	The contract/contract line is put on hold, for specific reasons
Open	Active	The contract/contract line is executed and the cost transactions can be registered
Closed	Closed	The contract/contract line is completed and all cost transactions are closed
Deleted	Canceled	The contract/contract line is canceled
Deleted	<deleted>	The contract/contract line is deleted (ArchiveIndicator set to true)

12. Code list: Project Contract Types - Contract types or billing terms contain the conditions and agreements to invoice contracts/contract lines to the customer.

Published Value	Infor LN Value	Description
Fixed Price	Fixed Price	The contract/contract line is carried out for a fixed amount
Cost Reimbursement	Cost Reimbursement	Invoicing is done periodically, based on the incurred costs
Time and Materials	Time and Materials	The contract/contract line is invoiced for the material and the labor at an agreed sales rate

13. Code list: Project Status - Statuses that refer to a formal authorization procedure to begin work on a specific activity.

Published Value	Infor LN Value	Description
Draft	Free	The project is just registered, and no work has started
Open	Active	Work has started, and the costs and revenues are being booked
Completed	Finished	All logistic transactions have been closed; revenues can still be booked
Closed	Closed	All financial transactions have been closed
Closed	Archived	Work is completed and all related financial transactions are closed

14. Code list: Project Transaction Status - Statuses of cost and revenue transactions. Valid status values are dependent on the value of the project transaction type.

Published Value	Infor LN Value	Description
Open	All types	Transaction open, actual
Approved	Advance, Draft	Transaction approved for billing
Released	Advance	Transaction released for billing
Closed	Advance, Interim	Transaction closed, billed
Canceled	Advance	Transaction canceled
Deleted	All types	Transaction is deleted; in case of a cost forecast (EAC type) transaction, also set when the transaction is unapproved

15. Code list: Project Transaction Types - Codes defining the nature of the cost or revenue transaction.

Published Value	Infor LN Value	Description
Advance	Revenue	Advance, to be billed revenue transaction
Draft	Revenue	Draft, manually entered revenue transaction
Interim	Revenue/ Costs	Interim revenue (revenue recognized) or cost (cost of sales recognized) transaction
Actual	Revenue/ Costs	Actual, billed transaction
EstimateAtCompletion	Costs	Cost forecast transaction that holds EAC data

16. Code list: Project Types - Codes defining the nature of the cost or revenue transaction.

Published Value	Infor LN Value	Description
Standard	TP	Standard project
Internal	TP	Usually larger, internal project
Template	TP	The project is used as a template for other projects
Capital	TP	Project used for internal use in which deliverables can be booked as fixed assets but delivery of goods is not applicable
Manufacture	TI	Internal, usually smaller manufacturing projects; these projects originate from the LN Manufacturing package, and are not applicable for PCL

17. Code list: Project Work Status - Statuses that refer to a formal authorization procedure to begin work on a specific activity.

Published Value	Infor LN Value	Description
Free	Free	Work is not authorized for execution
On Hold	On Hold	Work must be suspended, for example due to some constraints, or issues with the customer
Released	Released	Work is authorized for execution
Finished	Finished	Work is executed
Closed	Closed	Work is completed and all related financial transactions are closed

18. Code list: Revenue Posting Types - Revenue posting types are used to recognize financial revenue transactions and to determine how these must be posted to the general ledger. They can be used to combine revenue data in project history.

Published Value	Infor LN Value	Description
Project Control	Project Control	Manually entered revenue
Invoicing	Invoicing	Any project invoice or advance payment based revenue
Sales Invoice	Sales Invoice (Finance)	Revenue based on an entered sales invoice
Invoice Holdback	Invoicing Holdback	Revenue accounted for, but not yet invoiced

19. Code list: Revenue Types - Revenue types are different sources of contract/project revenue.

Published Value	Infor LN Value	Description
AdvancePaymentRequest	Advance Payment	Invoicing in advance
Installment	Installment	Invoicing an agreed upon part of the contract amount
InstallmentAdditionalWork	Inst Additional Work	Invoicing for additional work that has been performed
CostPlus	Cost Plus	Invoicing based on cost reimbursement or time & material
Extension	Extension	Invoicing of project extensions
UnitRate	UnitRate	Progress invoicing based on a sales rate per unit
Holdback	Holdback	Invoicing of an initially withheld amount - a measure to check the quality of work performed
DeliveryBased	DeliveryBased	Delivery based revenue
ProgressPaymentRequest	Progress Payment Request	Progress payment based revenue
FeesAndPenalties	Fees and Penalties	Positive and negative revenue related to fees and penalties
CreditNote	Credit Note	Negative revenue due to credit note processing