Infor Lawson AGS export mapping - Invoice Header fields

Invoice

The root XML tag.

Invoice/AccountNumber

The account number field has a unique identification number for an organization from the vendor point-of-view. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/AlternatePayee

This field is a supplementary field to the Vendor ID. It represents the party that receives invoice payments, and is not necessarily the vendor listed on the invoice. This payee must be on a list of pre-defined permitted payees for the extracted Vendor. See the Kofax AP Agility Configuration Help for additional information.

N/A

Infor Lawson Handles "Payment Vendor" in internal setup and not during Invoice Creation

Invoice/AlternatePayeeAddress

Not used for export in ERP.

N/A

N/A

Invoice/AmtMiscellaneous

Not used for export in ERP.

N/A

N/A

Invoice/AmtWithholdingTax

The withholding tax amount fields capture the portion of the invoice total that is withheld by an organization for legal reasons and not paid back to the vendor.

N/A

N/A

Invoice/AmtPst

This field captures the Provincial Sales Tax (ProvincialSalesTax/QST) component of Canadian tax.

N/A

N/A

Invoice/ApproveTime

Time when the invoice has been approved in Kofax AP Agility.

N/A

N/A

Invoice/ApproverName

Approver name who approved the invoice in Kofax AP Agility.

N/A

N/A

Invoice/BankAccount

The bank account number captures where the vendor wants to be paid.

N/A

Handled in Infor Lawson Vendor Setup not during Invoice Creation

Invoice/BankAccountCode

The bank account code represents the identification of the bank account for that vendor from the point-of-view of the downstream ERP system.

N/A

Handled in Infor Lawson Vendor Setup not during Invoice Creation

Invoice/BIC

The BIC or SWIFT code is an internationally assigned code to identify a unique banking institution.

N/A

N/A

Invoice/BillToName

This field represents the name of the invoice recipient. This field is used to check that the incoming document is intended for a valid company within an organization.

N/A

N/A

Invoice/BillToVatRegNo

The Vendor VAT Registration Number and Bill-to VAT Registration Number are available to satisfy a European legal/fiscal compliance ruling. This law states that if value added tax is charged, the vendor must state their VAT registration number as well as the VAT registration number of the bill-to party on the invoice.

N/A

N/A

Invoice/BusinessUnitID

ID of the invoiced business unit.

API-COMPANY

REQUIRED

Invoice/Currency

This field contains the ISO-code of the invoice currency. (USD, GBP, EUR, etc.)

API-INV-CURRENCY

Invoice/Custom1

Not used for export in ERP.

N/A

Invoice/Custom2

Not used for export in ERP.

N/A

Invoice/Custom3

Not used for export in ERP.

N/A

Invoice/Custom4

Not used for export in ERP.

N/A

Invoice/Custom5

Not used for export in ERP.

N/A

Invoice/DeliveryDate

This field captures the delivery date for the goods or services stated on the invoice.

N/A

Invoice/DeliveryNote

This field captures the vendor delivery note number if one is found on the invoice.

N/A

Invoice/Discount

This field captures a discount given by the vendor. See the Kofax AP Agility Configuration Help for additional information.

N/A

Driven by Payment terms Code logic

Invoice/DiscountDueDate

Not used for export in ERP.

N/A

Invoice/DocumentType

INVOICE, CREDIT. This field indicates if the incoming document is an invoice or a credit memo.

API-INVOICE-TYPE

Logic in export mapping to set this value to "C" if DocumentType = "CREDIT" Other wise Blank (Invoice)

Invoice/DueDate

This field captures the due date for payment.

API-DUE-DATE

If the vendor or location does not have a payment terms code assigned and you do not assign a payment terms code to the invoice, this field is required

Invoice/EmployeeID

This field contains the identification number for the user name of an employee found on the document. This field can be used downstream in the workflow to route the document to the relevant person in your organization. For example, for invoice coding and approval.

N/A

N/A

Invoice/EmployeeIndexNumber

Not used for export in ERP.

N/A

N/A

Invoice/EmployeeName

This field contains the user name of an employee found on the document. This field can be used downstream in the workflow to route the document to the relevant person in your organization. For example, for invoice coding and approval.

N/A

N/A

Invoice/ExchangeRate

Not used for export in ERP.

N/A

N/A

Invoice/Freight

This field captures a freight charge specified by the vendor at the header level. Freight is typically captured at the line-item level.

N/A

Mapped at the Line Level

Invoice/HarmonizedSalesTax

This is a type of sales tax (HarmonisedSalesTax) adopted by many Canadian provinces that combine the traditional Goods and Services Tax (GST) and Provincial Sales Tax (ProvincialSalesTax) into a single tax amount.

N/A

N/A

Invoice/Iban

This number represents the international bank account number invoice payment. It is extracted by the system in partnership with the BIC code.

N/A

N/A

Invoice/Icms

ICMS tax is a form of sales tax that is applied to material items in Brazil. When extracted, the system converts this to a valid amount using a period as the decimal separator. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/InvalidReason

Not used for export in ERP.

N/A

N/A

Invoice/InvoiceDate

Invoice date.

API-DISTRIB-DATE

API-DISTRIB-DATE

Invoice/InvoiceNumber

The invoice number is a unique identifier for a document, from the point-of-view of the supplier.

API-INVOICE

Invoice/InvoiceType

PO, Non-PO. This field indicates if an invoice is a purchase order (PO) or a non-purchase order (Non-PO).

N/A

N/A

Invoice/IpaClientName

Not used for export in ERP.

N/A

N/A

Invoice/IsrRetention

The ISR Retention (Impuestos sobre la Renta) field is used to capture the ISR retention component to withhold tax. This field can appear on Mexican invoices. The IVA retention component is captured in the regular withholding tax field.

N/A

N/A

Invoice/LocalVatAmount

Not used for export in ERP.

N/A

N/A

Invoice/MexicanUuid

This field is an invoice number that is provided by the Mexican SAT authorities. It is displayed as a standard field on electronic documents. It is 36 characters long and must be captured for government reporting purposes.

N/A

N/A

Invoice/NetAmount0

This field contains the extracted amounts on the document that have a tax rate of zero.

N/A

N/A

Invoice/NetAmount1

This field captures an invoice subtotal amount and it forms part of the Invoice Total. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/NetAmount2

These fields contain the extracted amounts on the document that have tax rates specified in TaxRate2-TaxRate4 fields. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/NetAmount3

N/A

N/A

Invoice/NetAmount4

N/A

N/A

Invoice/OrganizationName

The name of the invoiced organization in ERP.

N/A

N/A

Invoice/OrganizationId

ID of the invoiced organization in ERP.

N/A

N/A

Invoice/PaymentReference

This field captures vendor payment references specified on an invoice.

N/A

N/A

Invoice/PoExtension

The PO Extension field is populated in implementations involving JD Edwards or PeopleSoft only. In JD Edwards implementations, this field contains the purchase order type. In PeopleSoft implementations, this field contains the purchasing business unit.

N/A

N/A

Invoice/PoNumber

Purchase order number. Valid only for PO invoices.

API-PO-NUMBER

N/A

Invoice/PorNumber

The payment order reference (POR) number is a 27-character transaction ID applied to the invoice by the Swiss Postal Service. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/PorSubscriberNo

The payment order reference (POR) subscriber number. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/PoType

MATERIAL, SERVICE. This field indicates if an extracted purchase order relates to materials or services. See the Kofax AP Agility Configuration Help for additional information.

N/A

Static Value Used to determine the type of Export. Not Mapped

Invoice/SiteID

Vendor site ID.

API-REMIT-TO-CODE

N/A

Invoice/TaxAmount1

These fields contain the tax amounts for their corresponding Net Amounts. See the Kofax AP Agility Configuration Help for additional information.

API-TRAN-TAX-AMT

N/A

Invoice/TaxAmount2

N/A

N/A

Invoice/TaxAmount3

N/A

N/A

Invoice/TaxAmount4

N/A

N/A

Invoice/TaxRate1

These fields contain the tax rates for their corresponding Net Amounts. See the Kofax AP Agility Configuration Help for additional information.

N/A

N/A

Invoice/TaxRate2

N/A

N/A

Invoice/TaxRate3

N/A

N/A

Invoice/TaxRate4

N/A

N/A

Invoice/InvoiceAmount

This field contains the total amount due for payment on the current invoice.

API-TRAN-INV-AMT

REQUIRED

Invoice/VendorCity

Not used for export in ERP.

N/A

N/A

Invoice/VendorId

Vendor ID.

REQUIRED

Invoice/VendorIndexId

Not used for export in ERP.

N/A

N/A

Invoice/VendorName1

Not used for export in ERP.

N/A

N/A

Invoice/VendorStreet1

Not used for export in ERP.

N/A

N/A

Invoice/VendorStreet2

Not used for export in ERP.

N/A

N/A

Invoice/VendorVat

Not used for export in ERP.

N/A

N/A

Invoice/VendorVatRegNo

The Vendor VAT Registration Number and Bill-to VAT Registration Number are available to satisfy a European legal/fiscal compliance ruling. This law states that if value added tax is charged, the vendor must state their VAT registration number as well as the VAT registration number of the bill-to party on the invoice.

N/A

N/A

Invoice/VendorZip

Vendor ZIP code.

N/A

N/A

Invoice/YourRef

Use this field to capture a reference number specified on the invoice that relates to the billable party. It can often consist of a contact name, a reference number, or a combination of both.

N/A

N/A

Invoice/PasswordCn

This field is used for domestic VAT invoices on Mainland China and refers to the encrypted 4-line coding block that is displayed in the top-right hand quadrant of the invoice document.

N/A

N/A

Invoice/InvoiceCodeCn

This field is used for domestic VAT invoices on Mainland China. It refers to the ten digit numeric code that habitually is displayed in the top-left hand corner of the document.

N/A

N/A

Invoice/EcmDocumentId

Document ID in the enterprise content management system where the document has been exported to (for ECM integration).

N/A

Would be custom mapped for each installation

Invoice/DocumentLink

Document ID in ECM where the invoice was exported to by Kofax AP Agility.

N/A

Would be custom mapped for each installation

Invoice/ErpPoType

Not used for export in ERP.

N/A

N/A

Invoice/ScanDate

Invoice import (or scan) time.

N/A

N/A

Invoice/SubTotal

Not used for export in ERP.

N/A

N/A

Invoice/Urn

Unique archive document ID (for early archiving scenarios).

N/A

N/A

Invoice/IpaInvalidReasonCode

Not used for export in ERP.

N/A

N/A

Invoice/IpaInvalidReasonRule

Not used for export in ERP.

N/A

N/A

Invoice/IpaOrganizationName

Not used for export in ERP.

N/A

N/A

Invoice/IpaOrganizationId

Not used for export in ERP.

N/A

N/A

Invoice/PaymentComments

Not used for export in ERP.

N/A

N/A

Invoice/PaymentMethod

Payment method.

N/A

Defaulted by Vendor in Infor Lawson

Invoice/ImageExtension

Invoice image file name extension (depends on the image type, for example, .tiff, .pdf, etc.)

N/A

Documents are not exported to Infor Lawson

Invoice/ImageBase64

Base64 encoded invoice image.

N/A

Documents are not exported to Infor Lawson