TB.One > Order Data and Order Processing > Order Processing via XML > XML-Structure: TB.Order > XML Field Descriptions: Order Data

XML Field Descriptions: Order Data

The following data can be transmitted in an order list retrieved from TB.One (click on a node name to access a list of that node's possible contents and an example):

NODE LEVEL 1

NODE LEVEL 2

ORDER_LIST / ORDER

ORDER_DATA

SELL_TO

SHIP_TO

SHIPMENT

PAYMENT

REFERENCES

HISTORY

SERVICES

ITEMS

 

ATTENTION:
The format TB.Order is structured like a tree. Therefore, if there are multiple instances of fields such as <TB_ID> and <CHANNEL_ID>, each is only valid for the node in which it is contained.
An example: the TB_ID within the node ITEM is the unique ID of the article in TB.One while the TB_ID in the node ORDER is the unique ID of the order in TB.One.

Note that the following fields from an order must be referenced in messages concerning the order. The table shows the fields from TB.Order with the corresponding Message fields:

TB.ORDER

MESSAGE

ORDER > ORDER_DATA > TB_ID

MESSAGE > TB_ORDER_ID

ITEMS > ITEM > TB_ID

MESSAGE > TB_ORDER_ITEM_ID

 

The TB_ORDER_ITEM_ID is only required in messages if they refer to an order's items (for example in dispatch advices, cancellation and return messages). Purely order related messages such as payment, delivery or service cost deductions as well as changes of the payment state don't require the TB_ORDER_ITEM_ID.

EXAMPLE:

<?xml version="1.0" encoding="utf-8"?>

<ORDER_LIST>        

<ORDER xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<ORDER_DATA>

<ORDER_DATE>2013-02-10</ORDER_DATE>

<TB_ID>1</TB_ID>

<CHANNEL_SIGN>chxx</CHANNEL_SIGN>

<CHANNEL_ID>303-6862327-6937118</CHANNEL_ID>

<CHANNEL_NO>303-6862327-6937118</CHANNEL_NO>

<PAID>0</PAID>

<APPROVED>1</APPROVED>

<ITEM_COUNT>1</ITEM_COUNT>

<TOTAL_ITEM_AMOUNT>349.00</TOTAL_ITEM_AMOUNT>

<DATE_CREATED>2013-02-11T14:51:47</DATE_CREATED>

</ORDER_DATA>

<SELL_TO>

<TB_ID>1</TB_ID>

<FIRSTNAME>Max</FIRSTNAME>

<LASTNAME>Mustermann</LASTNAME>

<NAME>Max Mustermann</NAME>

<STREET_NO>Teststraße 5</STREET_NO>

<ZIP>85405</ZIP>

<CITY>Musterhausen</CITY>

<COUNTRY>DE</COUNTRY>

<PHONE_PRIVATE>123</PHONE_PRIVATE>

<EMAIL>max@mustermann.de</EMAIL>

</SELL_TO>

<SHIP_TO>

<TB_ID>1</TB_ID>

<FIRSTNAME>Max</FIRSTNAME>

<LASTNAME>Mustermann</LASTNAME>

<NAME>Max Mustermann</NAME>

<STREET_NO>Teststraße 5</STREET_NO>

<ZIP>85405</ZIP>

<CITY>Musterhausen</CITY>

<COUNTRY>DE</COUNTRY>

</SHIP_TO>

<ITEMS>

<ITEM>

<TB_ID>1</TB_ID>

<CHANNEL_ID>1</CHANNEL_ID>

<SKU>4689bls</SKU>

<CHANNEL_SKU>00257241717043</CHANNEL_SKU>

<EAN>1234567891255</EAN>

<QUANTITY>1</QUANTITY>

<BILLING_TEXT>Reinhold bl S</BILLING_TEXT>

<TRANSFER_PRICE>282.69</TRANSFER_PRICE>

<ITEM_PRICE>349.00</ITEM_PRICE>

<DATE_CREATED>2013-02-11T14:51:47</DATE_CREATED>

</ITEM>

</ITEMS>

</ORDER>

<ORDER>

<ORDER_DATA>

<ORDER_DATE>2013-02-10</ORDER_DATE>

<TB_ID>3</TB_ID>

<CHANNEL_SIGN>chxx</CHANNEL_SIGN>

<CHANNEL_ID>4712</CHANNEL_ID>

<CHANNEL_NO>4712</CHANNEL_NO>

<PAID>0</PAID>

<APPROVED>1</APPROVED>

<ITEM_COUNT>1</ITEM_COUNT>

<TOTAL_ITEM_AMOUNT>349.00</TOTAL_ITEM_AMOUNT>

<DATE_CREATED>2013-02-11T14:59:41</DATE_CREATED>

</ORDER_DATA>

<SELL_TO>

<TB_ID>3</TB_ID>

<TITLE>Frau</TITLE>

<FIRSTNAME>Herta</FIRSTNAME>

<LASTNAME>Mustermann</LASTNAME>

<NAME>Herta Mustermann</NAME>

<STREET_NO>Teststraße 5</STREET_NO>

<ZIP>85405</ZIP>

<CITY>Musterhausen</CITY>

<COUNTRY>DE</COUNTRY>

<EMAIL>Herta@mustermann.de</EMAIL>

</SELL_TO>

<SHIP_TO>

<TB_ID>4</TB_ID>

<TITLE>Frau</TITLE>

<FIRSTNAME>Herta</FIRSTNAME>

<LASTNAME>Mustermann</LASTNAME>

<NAME>Herta Mustermann</NAME>

<STREET_NO>Musterstraße 9</STREET_NO>

<ZIP>85405</ZIP>

<CITY>Musterhausen</CITY>

<COUNTRY>DE</COUNTRY>

<PHONE_PRIVATE>123</PHONE_PRIVATE>

</SHIP_TO>

<SHIPMENT>

<IDCODE_SHIP>854051101002</IDCODE_SHIP>

<IDCODE_RETURN>854051101003</IDCODE_RETURN>

<PRICE>3.95</PRICE>

</SHIPMENT>

<PAYMENT>

<COSTS>0</COSTS>

</PAYMENT>

<HISTORY>

<EVENT>

<EVENT_ID>3</EVENT_ID>

<EVENT_TYPE>PRINT_DELIVERY_NOTE</EVENT_TYPE>

<DATE_CREATED>2013-02-11T15:04:38</DATE_CREATED>

</EVENT>

<EVENT>

<EVENT_ID>5</EVENT_ID>

<EVENT_TYPE>MESSAGE_CREATED</EVENT_TYPE>

<DATE_CREATED>2013-02-11T16:04:38</DATE_CREATED>

</EVENT>

</HISTORY>

<ITEMS>

<ITEM>

<TB_ID>3</TB_ID>

<CHANNEL_ID>1</CHANNEL_ID>

<SKU>4689blm</SKU>

<CHANNEL_SKU>00257241717722</CHANNEL_SKU>

<EAN>1234567891231</EAN>

<QUANTITY>1</QUANTITY>

<BILLING_TEXT>Reinhold bl M</BILLING_TEXT>

<TRANSFER_PRICE>282.69</TRANSFER_PRICE>

<ITEM_PRICE>349.00</ITEM_PRICE>

<DATE_CREATED>2013-02-11T14:59:41</DATE_CREATED>

</ITEM>

</ITEMS>

</ORDER>

...

</ORDER_LIST>

For further information, see also:

•Order processing via XML - overview

•XML field descriptions - message data