Skip to main content

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.

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

To top