InvoiceDocItem

Integer

The invoice line item number from 1-n.

PONumber

String

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

POItem

String

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

DE_CRE_IND

X or blank

The subsequent debit or credit indicator that indicates is 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.

QUANTITY

Double

The invoice line item quantity.

ItemAmount

Double

The invoice line item total.

POUnit

String

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.

PO_PR_UOM

String

The order price unit of measure and is populated with the order price unit of measure from the purchase order line item, if the line item has been paired. In all other cases, it is blank.

PO_PR_QNT

Double

The invoice line item quantity expressed in the order price unit of measure.

TaxCode

String

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

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.

Unit_Price

Double

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

DESCRIPTION

String

Invoice line item description.

If the line item is paired, this description appears 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.

MaterialNo

String

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.

TaxRate

String

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.

LINETYPE

String

Invoice line item type.

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

CHARGECODE

String

Invoice line item charge code.

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

CHARGECODEID

String

Invoice line item charge code ID.

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

MATERIALGROUP

String

Material group.

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

DistillerLine

String

Original Kofax AP Agility line item number.

The original line item number in the Kofax AP Agility table field, as viewed in Validation where the invoice line was drawn. This will always be populated for unpaired line items and is a 1-based, not a zero-based index.

PLANT

String

Plant ID.

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

COMPANYCODE

String

Company code that corresponds to a line item.

This is lifted from the purchase order when an invoice line is paired.

POTYPE

String

This is populated when line pairing is successful for this item.

BUSINESSUNIT

String

This is populated when line pairing is successful for this item.

MISCCHARGE

X or blank

X indicates that this is a miscellaneous charge line item.

The flag is blank if the system has identified the line as a non misc-charge item.