Infor Lawson AGS export mapping - Invoice Line fields

Invoice/LineItem

Root for a line item.

Interface Notes

Invoice/LineItem/Category

Miscellaneous charge category applied to the invoice line item based on the extracted line item description.

N/A

N/A

Invoice/LineItem/Description

Invoice line item description. If the line item is paired, this description is displayed on the purchase order. If the line is unpaired, this field contains the raw text description that was read from the invoice. For third-party freight invoices, service invoices, and MIRA invoices where no line items were required in the TAB section, and line pairing was either unsuccessful for any lines, or was not carried out, the description is set to THIRD PARTY FREIGHT, SERVICE and MIRA respectively.

N/A

N/A

Invoice/LineItem/Discount

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/LineNumber

Line number (1..N).

MAD-LINE-NBRr0

Each line is added to the first Row

Invoice/LineItem/LineType

One of: Item, Sales Tax, Misc. Tax, Freight, Misc. Charge. See IpaLineType below.

N/A

Not mapped, but when used would drive different logic for the line depending on the Type of Line..MISC add on cost vs SPREAD add on cost vs TAX

Invoice/LineItem/MeterialNumber

Invoice line item material number. If the line item is paired, this is populated with the material number from the purchase order line item. If the line is not paired, this is populated with any values read from the invoice.

N/A

N/A

Invoice/LineItem/OriginalLineNumber

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/PoNumber

The purchase order number, and is populated only if line pairing is successful for this item.

AOI-PO-NUMBER

N/A

Invoice/LineItem/Quantity

The invoice line item quantity.

MAD-ENTERED-QTYr0

Each line is added to the first Row - Only used in PO

Invoice/LineItem/Total

The invoice line item total.

N/A

Not mapped - calculated in Infor Lawson based on unit price X quantity

Invoice/LineItem/UnitPrice

The invoice line item unit price and it is only populated for unpaired line items. In all other cases, it has a value of zero.

MAD-ENT-UNIT-CSTr0

Only used on PO invoices

Invoice/LineItem/UnitOfMeasure

Unit of measure.

ENT-BUY-UOM

N/A

Invoice/LineItem/UnitOfQuantity

Unit of quantity.

N/A

N/A

Invoice/LineItem/TaxAmount

Tax amount.

MISC-INV-AOC-AMTr0

Used in Conjunction with an add on cost code - PO Invoice Only

Invoice/LineItem/TaxRate

Tax rate Invoice line item tax rate. The percentage rate of tax applied to the invoice line item. If no percentage tax rate at line item level can be ascertained, then this value is blank.

N/A

N/A

Invoice/LineItem/ChargeCode

Invoice line item charge code. This is lifted from the purchase order line item to which an invoice line is paired.

N/A

N/A

Invoice/LineItem/ChargeCodeId

Invoice line item charge code ID (only for PO-matched lines). This is lifted from the purchase order line item to which an invoice line is paired.

N/A

N/A

Invoice/LineItem/CompanyCode

Company code that corresponds to a line item. This is lifted from the purchase order when an invoice line is paired.

N/A

N/A

Invoice/LineItem/ErpPoType

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/MaterialGroup

This column represents the material group of the purchase order line item material. If available, it can be mapped simply to pass this data to a downstream ERP for a paired line item.

N/A

N/A

Invoice/LineItem/Plant

Plant ID. This is lifted from the purchase order line item with which an invoice line is paired.

N/A

N/A

Invoice/LineItem/PoLineNumber

The purchase order line item number. It is populated only if line pairing has been successful for this item.

MAD-LINE-NBRr0

N/A

Invoice/LineItem/Puom

The order unit of measure and it is populated with the purchase order line item order unit measure if the line item has been paired.

N/A

N/A

Invoice/LineItem/QtyPuom

The quantity in the order price unit of measure. This value is calculated during line pairing if UOM does not correspond to PUOM.

N/A

N/A

Invoice/LineItem/TaxableAmount

Taxable amount.

APD-TAXABLE-AMT

Only mapped on non-po Invoices

Invoice/LineItem/TaxCode

The invoice line item tax code, and it is populated using the tax determination procedure if a line item is paired.

APD-TAX-CODE

Only mapped on non-po Invoices.

Invoice/LineItem/Activity

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

Mapped in GLSegments

Invoice/LineItem/BusinessArea

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

Mapped in GLSegments

Invoice/LineItem/CostCenter

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

Mapped in GLSegments

Invoice/LineItem/DbCrIndicator

The subsequent debit or credit indicator that indicates if the line item is a subsequent debit of a credit line item. If this value is set to X and the document type is INVOICE, then the line item is treated as a subsequent debit, the amount only and not the quantity.

If the value is set to X and the document type is CREDIT then the line item is treated as a subsequent credit. If the value is blank the line item is treated as a regular line item.

N/A

N/A

Invoice/LineItem/InternalOrder

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

N/A

Invoice/LineItem/Network

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

N/A

Invoice/LineItem/ProfitCenter

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

Invoice/LineItem/SalesOrder

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

N/A

Invoice/LineItem/SalesOrderItem

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

N/A

Invoice/LineItem/TaxJurCode

The invoice line tax jurisdiction code. It represents the downstream ERP system ID for the tax office where taxes are paid for this line item. This is used in countries that have tax jurisdictions for their sales tax. It is populated only if the line item is paired.

N/A

N/A

Invoice/LineItem/WbsElement

Not used for export in ERP. Copied from accounting data that was retrieved from ERP. Obviously SAP ECC only so far.

N/A

N/A

Invoice/LineItem/GlAccount

GL account string specified in the AP Agility Workflow Coding activity.

N/A

N/A

Invoice/LineItem/GlSegment

The value of one GL segment in GL account. This tag may repeat for the invoice line. The number of the segments should be equal to the number of segments specified for the account (in GlAccount tag). Each GlSegment tag should have two attributes:

1. segmentNumber - the number of the segment in the account structure that is specified in the Kofax AP Agility > Settings > GL Account Structures.

1. name - the segment name as specified for this segment in the GL structure CSV.

Example: <GlAccount>01-000-1100-0000-000<GlAccount> <GlSegment segmentNumber="1" name="Organization">01<GlSegment> <GlSegment segmentNumber="2" name="Department">000<GlSegment> <GlSegment segmentNumber="3" name="Account">1100<GlSegment> <GlSegment segmentNumber="4" name="SubAccount">0000<GlSegment> <GlSegment segmentNumber="5" name="Project">000<GlSegment>

Non-PO/Credit Invoices :

APD-DIST-COMPANYr0

APD-DIS-ACCT-UNITr0

APD-DIS-ACCOUNTr0

APD-DIS-SUB-ACCTr0

ADD-ON-COST: API-COMPANY

MISC-ACCT-UNITr0

MISC-ACCOUNTr0

MISC-SUB-ACCTr0

PO-Invoices:

N/A

Based on the line type different logic is used to map fields

Invoice/LineItem/ConditionCount

N/A

N/A

Invoice/LineItem/ConditionStepNo

N/A

N/A

Invoice/LineItem/ConditionType

N/A

N/A

Invoice/LineItem/FreightVendor

N/A

N/A

Invoice/LineItem/GrDocItem

The receipt line item number. It is populated only if 3-way line pairing has been successful for this item.

N/A

N/A

Invoice/LineItem/GrDocNo

The receipt number, and is populated only if 3-way line pairing is successful for this item.

N/A

N/A

Invoice/LineItem/GrDocYear

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/SheetItem

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/SheetNo

Not used for export in ERP.

N/A

N/A

Invoice/LineItem/IpaBusinessUnit

N/A

N/A

Invoice/LineItem/IpaLineType

Invoice line item type populated by Invoice Processing (see the Line Type field above). This is lifted from the purchase order line item to which an invoice line is paired.

N/A

N/A