PurchaseOrder

This page lists the fields which are available to you for exporting purchase orders. 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. PurchaseOrder

Table 1 lists the fields available for exporting purchase orders. Reorders as well as redistributions are subsumed under purchase orders.

Table 1. Fields for exporting purchase orders
Field	Explanation
id	ID of the purchase order
ownerId	ID of the owner of the purchase order
statusId	Status ID of the purchase order
statusName	Name of the current status ID of the order
typeId	ID of the order type Reorder = 12 Redistribution = 15

2. PurchaseOrderAmount

Table 2 lists the fields available for exporting purchase order amounts.

Table 2. Fields for exporting amounts
Field	Explanation
currency	Currency
exchangeRate	Exchange rate of the currency
netTotal	Total net amount of the order

3. PurchaseOrderDate

Table 3 lists the fields available for exporting purchase order dates.

Table 3. Fields for exporting dates
Field	Explanation
PurchaseOrderDate.date
order_entry_at	Date of creation of the purchase order
order_payment_due_date	Payment due date of the purchase order
order_possible_delivery	Delivery date of the purchase order
order_purchase_date	Date on which the purchase order was initiated
order_finish_date	Finish date of the purchase order

4. PurchaseOrderDocument

Table 4 lists the fields available for exporting purchase order documents.

Table 4. Fields for exporting documents
Field	Explanation
id	ID of the document
number	Number of the document
numberWithPrefix	Number and prefix of the document

5. PurchaseOrderProperty

Table 5 lists the fields available for exporting purchase order properties.

Table 5. Fields for exporting properties
Field	Explanation
value	Value of the purchase order property.
PurchaseOrderProperty.value
document_language	Language of the document
external_delivery_numer	External delivery number
external_order_id	External ID of the redistribution or reorder

6. PurchaseOrderReceiverWarehouse

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

Table 6. 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

7. PurchaseOrderReceiverWarehouseAddress

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

Table 7. 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

8. RedistributionSenderWarehouse

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

Table 8. 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

9. RedistributionSenderWarehouseAddress

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

Table 9. 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

10. ReorderSenderSupplier

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

Table 10. 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 of the contact

11. ReorderSenderSupplierPrimaryBillingAddress

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

Table 11. 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

12. Custom_value

Table 12 lists field for exporting custom values.

Table 12. Fields for exporting custom values
Field	Explanation
custom_value	Own value for export

13. Date

[table-field-date] lists the field available for exporting the current date. For further information, refer to this page.

Table 13. Field for exporting the current date
Field	Explanation
Date	Current date