Skip to main content

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.

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

To top