Columns in the PurchaseOrdersItems data set

This data set contains information about order items and is connected with the PurchaseOrders data set via the PONumber key (order number). This data set is used for displaying order items to a Verification Operator.

Name Type Description
PONumber Text, without normalization Required field. Order number. Connects order items with the corresponding records in the PurchaseOrders data set.
Article Text, without normalization Optional field. Order item code.
Description Text, without normalization Optional field. Order item description.
Quantity Integer, without normalization Optional field. Order item quantity.
UnitPrice Double, without normalization Optional field. Order item price.
Discount Double, without normalization Optional field. Order item discount.
TaxSum Double, without normalization Optional field. Order item tax amount.
TotalPriceNetto Double, without normalization Optional field. Order item amount before tax.
TotalPriceBrutto Double, without normalization Optional field. Order item amount.
ItemId Text, without normalization The unique identifier of a purchase order line item. This field should be defined if each invoice line item must be matched with a specific purchase order line item., in which case the result of the matching is the value of the ItemId field which is recorded in one of the fields of the invoice line item.
BUId Text, without normalization Optional field. The identifier of a business unit. This field should be defined if you process invoices issued by different business units of a company. Each business unit may have its own list of PO numbers. The BUId field is used to place the PO numbers of different business units into one data set, in which case the BUId and PONumber fields uniquely identify the order.

11/10/2020 12:08:04 PM


Please leave your feedback about this article