Captured fields

The Order Document Definition includes the following preconfigured 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 following fields will be captured:

  • Name
  • Address

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 following fields will be captured:

  • Name
  • Address

ShipTo (group of fields)

  • Name
  • Address
The delivery address.

BillTo (group of fields)

  • Name
  • Address
The address to which to send an invoice.
LineItems 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 with tax.
TotalPriceBrutto Total amount payable without tax.
Currency The currency used in the line items.
DeliveryDate* The date when the goods should be delivered.
Total The total amount payable for the entire purchase order. Unlike invoices, this field is not obligatory on purchase orders.
Currency The currency of the total amount. If no total amount is indicated on a purchase order, the Currency field will remain 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 these fields, enable the Taxes option:

  1. In the Document Definition Editor, click Document Definition → Document Definition Properties....
  2. 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.

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

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 (see Custom fields for details).

01.12.2020 7:03:59


Please leave your feedback about this article