ITEMS / ITEM

TB_ID

Y

INT

Unique item number across all orders from TB.One

CHANNEL_ID

Y

CHAR(50)

Item number of the distribution channel (if transmitted) or serial number of the item within the order

SKU

Y

CHAR(50)

Article number from TB.One

CHANNEL_SKU

N

CHAR(50)

Distribution channel's article number

EAN

N

INT(13)

13-digit EAN

QUANTITY

Y

INT

Order quantity

OPEN_QUANTITY

N

INT

Open item quantities
This feature is available upon request. Contact Tradebyte Support.
If the number of open items is greater than the total number of items, the remaining items have been cancelled by the channel. If the feature is active, the corresponding field is always exported.

BILLING_TEXT

N

CHAR(255)

The order item's invoice text (if not transmitted by the channel, the article name from TB.One is used)

TRANSFER_PRICE

N

FLOAT

Net article price after deduction of the sales channel's commission (if this value is not supplied, the calculation is done by TB.One); this number indicates the price per piece (quantity 1)

ITEM_PRICE

Y

FLOAT

Gross retail price per piece (quantity 1)

DELIVERY_TIME

N

INT

Delivery time in business days indicated at the time of the customer's order (if transmitted by the channel)

DATE_CREATED

Y

DATE(UTC)

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

SERVICES

N

XML (typeService)

Item-related services (e.g. gift packaging)