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:Open Document Definition Properties
In the Document Definition Editor, click Document Definition → Document Definition Properties….
