Captured fields for purchase orders

Catalogs the fields in the Order Document Definition: order number and date, business unit, issuer, ship-to and bill-to, line items, and taxes.

The Order Document Definition includes the following preconfigured fields.

Order fields

Field	Description
OrderNumber	The number of the purchase order.
OrderDate	The date when the purchase order was created.
BU (group of fields): BUId, Street, City, Country, VATID, Name, State, IBAN, BankCode, BankAccount, Address, PostalCode	The company that sells the goods (i.e. the recipient of the purchase order). You can use a database of business units. To do this, associate your database of business units with the data set named “BusinessUnits”. When no database is used, only the Name and Address fields are captured.
Issuer (group of fields): IssuerId, Name, Street, PostalCode, City, Address, IBAN, BankCode, BankAccount, VATID, Country, State	The entity or individual that ordered the goods (i.e. the creator of the purchase order). You can use a database of buyers. To do this, associate your database of buyers with the data set named “Variants”. When no database is used, only the Name and Address fields are captured.
ShipTo (group of fields): Name, Address	The delivery address.
BillTo (group of fields): Name, Address	The address to which to send an invoice.
LineItems	A repeating group of line items. For its fields, see LineItems fields.
Total	The total amount payable for the entire purchase order. Unlike invoices, this field is not required on purchase orders.
Currency	The currency of the total amount. If no total amount is indicated on a purchase order, the Currency field remains empty.
DeliveryDate	The date when the goods should be delivered.
AdditionalCost	Additional amounts charged besides the order amount.
Amounts (group of fields): TotalTaxAmount, TotalNetAmount, NetAmount, TaxAmount, TaxRate, Additional Tax Groups	This group of fields is used for detecting taxes. By default, these fields are disabled in the Order Document Definition. To enable them, see Enable the tax fields.

If only one delivery date is stated on a purchase order, this date is extracted into the DeliveryDate field. If a delivery date is indicated for each line item, these dates are extracted as columns in the LineItems table.

LineItems fields

The LineItems repeating field group contains the following fields.

Field	Description
Position	The number of a line item.
ArticleNumber	The article number in the buyer’s database.
ArticleNumberBU	The article number in the business unit’s database.
Description	A description of the goods.
Quantity	The quantity of the ordered goods.
UnitOfMeasurement	The unit used for counting, weighing, etc. the goods.
UnitPrice	The price charged for a unit of goods.
UnitPriceDenomination	The number or amount of goods in each unit. If the goods are priced per package or per crate, for example, the unit price denominator indicates the weight of the package, the number of bottles in the crate, etc.
DiscountPercentage	The applicable discount (stated as a percentage).
DiscountValue	The applicable discount (stated as an amount in the currency of the purchase order).
TotalPriceNetto	Total amount payable without tax.
TotalPriceBrutto	Total amount payable with tax.
Currency	The currency used in the line items.
DeliveryDate	The date when the goods should be delivered.

Enable the tax fields

The Amounts fields are used for detecting taxes and are disabled by default.

To enable them, turn on the Taxes option:

1. Open Document Definition Properties

   In the Document Definition Editor, click Document Definition → Document Definition Properties….

2. Open Additional Fields and Features

   In the dialog box that opens, click the Document Definition Settings tab and then click the Edit… button in the Additional Fields and Features group.

Add custom fields

You can also add your own custom fields to the Order Document Definition. Before the program can capture data from a custom field, you must train the program to capture this field or create a separate FlexiLayout for this field. For more information, see Custom fields.