Purchase order items

This page lists the fields which are available to you for exporting purchase order items. Reorders as well as redistributions are subsumed under purchase orders. This is only a reference page and presumes that you already have basic knowledge about the FormatDesigner as well as the Elastic export.

Catalogue for export

Are you already familiar with the catalogue for exporting data formats? Catalogues are gradually replacing the old format types of the Elastic Export and offer you more usage and configuration options. Get all the essential information about catalogue functionalities on the manual page Catalogues: standard formats.

1. PurchaseOrderItem

Table 1 lists the fields available for exporting purchase order items.

Table 1. Fields for exporting purchase order items
Field	Explanation
attributeValues	Attribute values of the purchase order item
id	Purchase order item ID
itemVariationId	Variation ID of the purchase order item
orderItemName	Name of the purchase order item (Item name)
quantity	Quantity
typeId	Purchase order item type ID
warehouseId	ID of the warehouse associated with the purchase order

2. PurchaseOrderItemAmount

Table 2 lists the fields available for exporting data about amounts in purchase orders.

Table 2. Fields for exporting data of amounts
Field	Explanation
currency	Currency of the purchase order item
discount	Discount
exchangeRate	Exchange rate of the currency
isPercentage	Defines whether the discount is indicated in %
priceNet	Actual net price of the purchase order item
priceOriginalNet	Regular net price of the purchase order item
surcharge	Surcharge for the purchase order item

3. PurchaseOrderItemDate

Table 3 lists the field available for exporting the delivery date of purchase orders.

Table 3. Field for exporting the delivery date
Field	Explanation
date	Delivery date of the purchase order

4. PurchaseOrderItemProperty

Table 4 lists the fields available for exporting properties of purchase order items.

Table 4. Fields for exporting properties of purchase order items
Field	Explanation
value	Value of the purchase order item property.
PurchaseOrderItemProperty.value
discount	Discount
external_item_id	External item ID
original_quantity	Original quantity when creating a purchase order
reorder_item_delivery-time_in_days	Delivery time of an item of a reorder in days
reorder_item_minimum_purchase	Minimum purchase of a reorder item
reorder_item_name	Item name of the supplier
reorder_item_package_unit	Packing unit of an item

5. PurchaseOrderItemQuantity

Table 5 lists the fields available for exporting quantities of purchase orders items.

Table 5. Fields for exporting quantities
Field	Explanation
cancelQuantity	Quantity of cancelled items
deliveredQuantity	Quantity of delivered items
openQuantity	Quantity of open items

6. PurchaseOrderItemAmounts

Table 6 lists the fields available for exporting amounts in reference to quantities of purchase order items.

Table 6. Fields for exporting amounts
Field	Explanation
cancelAmount	Resulting amount of cancelled items
deliveredAmount	Resulting amount of delivered items
openAmount	Resulting amount of open items

7. PurchaseOrderReceiverWarehouse

Table 7 lists the fields available for exporting data of the receiver warehouse.

Table 7. Fields for exporting data of receiver warehouse
Field	Explanation
id	ID of the receiver warehouse
name	Name of the receiver warehouse
onStockAvailability	Availability with stock
typeId	Warehouse type

8. PurchaseOrderReceiverWarehouseAddress

Table 8 lists the fields available for exporting address data of the receiver warehouse.

Table 8. Fields for exporting address data of receiver warehouse
Field	Explanation
address 1	Address field 1 (default: street)
address 2	Address field 2 (default: house number)
countryId	Country ID
email	Email
name1	Name (default: Company)
postalcode	Postcode
privatePhone	Telephone number
town	Town

9. RedistributionSenderWarehouse

Table 9 lists the fields available for exporting data of the sender warehouse of a redistribution. These fields are not available for reorders.

Table 9. Fields for exporting data of sender warehouse
Field	Explanation
id	ID of the receiver warehouse
name	Name of the receiver warehouse
onStockAvailability	Availability with stock
typeId	Warehouse type

10. RedistributionSenderWarehouseAddress

Table 10 lists the fields available for exporting address data of a sender warehouse. These fields are not available for reorders.

Table 10. Fields for exporting address data of sender warehouse
Field	Explanation
address 1	Address field 1 (default: street)
address 2	Address field 2 (default: house number)
countryId	Country ID
email	Email
name1	Name (default: Company)
postalcode	Postcode
privatePhone	Telephone number
town	Town

11. ReorderSenderSupplier

Table 11 lists the fields available for exporting supplier data of a reorder. These fields are not available for redistributions.

Table 11. Fields for exporting supplier data
Field	Explanation
firstName	First name
fullname	Full name of the contact, consisting of first and last name
id	ID of the address
lang	Language of the contact
lastName	Last name
number	Number of the contact (previously: Customer number)
typeId	ID pf the contact

12. ReorderSenderSupplierPrimaryBillingAddress

Table 12 lists the fields available for exporting invoice address data of a supplier reorder. These fields are not available for redistributions.

Table 12. Fields for exporting address data of supplier
Field	Explanation
additional	Additional address information
address1	Address field 1 (default: street)
address2	Address field 2 (default: house number)
address3	Address field 3 (default: additional address information)
address4	Address field 4 (freely definable)
birthday	Date of birth
careOf	c/o
checkedAt	Time stamp of the last check of address (Unix timestamp)
companyName	Company name
contactPerson	Contact person
countryId	Country ID
email	Email
entryCertificate	Entry certificate (Gelangensbestätigung)
externalCustomerId	External customer number
externalId	External ID
firstName	Frist name
fsk	Age rating
gender	Gender
houseNumber	House number
id	ID of the address
isPackstation	Flag defining whether a Packstation is used
isPostfiliale	Flag that defines if the address is a post office
lastName	Last name
name1	Name (default: Company)
name2	Name (default: First name)
name3	Name (default: Last name)
name4	Name (freely definable)
packstationNo	Number of the Packstation
personalNumber	Personnel number
phone	Telephone number
postalCode	Postcode
postident	Postident
readOnly	Defines read-only fields
sessionId	Session ID used for creating the address
stateId	ID of the federal state
street	Street
taxIdNumber	Tax ID number
title	Title included in the address data
town	Town

13. Variation

Table 13 lists the fields available for exporting data of variations of purchase order items.

Table 13. Fields for exporting variations
Field	Explanation
externalId	External ID
heightMM	Height in mm
id	Variation ID
itemId	Item ID
lengthMM	Length in mm
mainWarehouseId	ID of the main warehouse
model	Model
name	Name
number	Variation number
weightG	Weight in g
weightNetG	Net weight in g
widthMM	Width in mm