ORDER_DATA

ORDER_DATE

Y

DATE
YYYY-MM-DD

If transmitted by the channel: date on which the customer ordered.
Otherwise: date on which the order was imported into TB.One.

TB_ID

N

INT

Number from TB.One that is unique across all channels. This number allows you to clearly identify the order at any time.

CHANNEL_SIGN

N

CHAR(12)

Indicates the channel

CHANNEL_ID

Y

CHAR(50)

The distribution channel's unique order number

CHANNEL_NO

N

CHAR(50)

Order number of the distribution channel (not necessarily unique, e.g. web shop order number). CHANNEL_ID and CHANNEL_NO may contain the same value (depending on the channel).

BILL_NO

N

CHAR(50)

Invoice number that was assigned by the distribution channel (not available for all channels)

PAID

N

INT(0/1/2)

Paid flag:

0 = not paid (usually a pending order)

1 = paid (confirmed order)

2 = payment loss

APPROVED

Y (or WITHDRAWN)

INT(0/1)

Indicates if the order is released:

0 = pending

1 = confirmed order

WITHDRAWN

Y (or APPROVED)

INT(1)

Can be provided instead of the node APPROVED if the order was withdrawn. The only possible value for WITHDRAWN is "1".

It is not possible for both WITHDRAWN and APPROVED to appear for the same order.

DOCUMENT_URL

N

XML

Currently only used for Tradebyte-internal purposes

CUSTOMER_COMMENT

N

CHAR

Customer's remark on the order

SIGNGROUPS

N

XML

Currently not in use

ITEM_COUNT

Y

INT

Number of order items

TOTAL_ITEM_AMOUNT

Y

FLOAT

Gross total for the order items (without shipping costs)

DATE_CREATED

Y

DATE(UTC)

Creation date (import date) of the order in TB.One
(e.g. 2010-10-19T22:07:21)