Order Data Fields (CSV)

TIP:
In the order data, not all item related data (order header) is repeated for each order item (POS_).
The first row of the CSV file is ignored, because it must contain the column headings.

ATTENTION:
Note that the order of the fields in the exported CSV file is not identical with the order in the tables below. The tables are ordered by topic whereas the structure of the CSV file is determined by technical factors.
While the fields listed below are separated into several tables, they all refer to the same type of CSV file.

TB_ORDER_ID

INT

Order ID; a unique order number assigned by TB.One

CHANNEL_KEY

CHAR(12)

Channel sign

CHANNEL_ORDER_ID

CHAR(50)

The channel's order number (unique)

CHANNEL_ORDER_NR

CHAR(50)

The channel's order number (may not be unique for orders that were split)

ORDER_STATUS

CHAR(50)

Indicates the order status (e.g.open, pending...)

ORDER_DATE

DATE(YYYY-mm-dd)

Date on which the customer ordered

IDCODE_SHIP

CHAR(30)

Shipcode of the order (if provided by the channel)

GPLCODE

CHAR(20)

Routing code of the customer's address (if provided by the channel)

TOTAL_AMOUNT

FLOAT

Gross value of the order (excluding shipping)

SHIPPING_COSTS

FLOAT

Shipping costs

PAYMENT_TYPE

CHAR(20)

Payment method.
Possible values: Export keys from "Basic data > Payment > Payment type"

PAYMENT_COSTS

FLOAT

Additional payment costs (if applicable)

PAYMENT_TRANSACTION_ID

CHAR(50)

Transaction number (depending on the method of payment)

PAYMENT_TRANSACTION_NR

CHAR(50)

Additional transaction number (e.g. for credit card numbers)

PAYMENT_TRANSACTION_NAME

CHAR(100)

e.g. name of card holder

PAYMENT_DATA

CHAR

Additional information regarding the payment (usually only used for direct shop connections; upon agreement)

DIRECTDEBIT_ACCOUNTNAME

CHAR(50)

Name of account holder (only direct debit)

DIRECTDEBIT_ACCOUNTNR

CHAR(50)

Account number (only direct debit)

DIRECTDEBIT_BANKNAME

CHAR(50)

Name of the bank (only direct debit)

DIRECTDEBIT_BANKCODE

CHAR(50)

Bank code (only direct debit)

DIRECTDEBIT_IBAN

CHAR(50)

IBAN (only direct debit)

DIRECTDEBIT_BIC

CHAR(50)

BIC (only direct debit)

CUSTOMER_COMMENT

CHAR

Customer's comment on the order

IS_EXPRESS

INT(0/1)

Express shipping tag

0 = no express shipping

1 = express shipping

TB_CUST_SHIP_ID

INT

Customer number from TB.One

CHANNEL_CUST_SHIP_ID

CHAR(50)

Customer number of the consignee (determined by the channel)

CUST_SHIP_SALUTATION

CHAR(50)

Consignee's title (style of address)

CUST_SHIP_SURNAME

CHAR(50)

Consignee's last name

CUST_SHIP_FIRSTNAME

CHAR(50)

Consignee's first name

CUST_SHIP_EXTENSION

CHAR(356)

Additional address components (consignee)

CUST_SHIP_STREET_NO

CHAR(100)

Street and house number of the consignee

CUST_SHIP_ZIP

CHAR(10)

Consignee's ZIP code

CUST_SHIP_CITY

CHAR(50)

Consignee's city

CUST_SHIP_COUNTRY_CODE

CHAR(2)

Country code of the consignee (alpha 2)

CUST_SHIP_TEL_PRIV

CHAR(50)

Consignee's private phone number

CUST_SHIP_TEL_OFFICE

CHAR(50)

Consignee's business phone number

CUST_SHIP_TEL_MOBILE

CHAR(50)

Consignee's mobile phone number

CUST_SHIP_EMAIL

CHAR(80)

Consignee's email address

CUST_SHIP_BIRTHDATE

DATE (YYYY-mm-dd)

Consignee's date of birth (if available)

SERVICE_CODE

CHAR(50)

Code of the service

SERVICE_DESC

CHAR(100)

Designation of the service

SERVICE_PRICE

FLOAT

Cost of the service

TB_SELL_CUST_ID

CHAR(30)

Invoice recipient's customer number from TB.One (if available)

CHANNEL_SELL_CUST_ID

CHAR(50)

Invoice recipient's customer number from the distribution channel

CUST_SELL_SALUTATION

CHAR(50)

Invoice recipient's title (style of address)

CUST_SELL_SURNAME

CHAR(50)

Invoice recipient's last name

CUST_SELL_FIRSTNAME

CHAR(50)

Invoice recipient's first name

CUST_SELL_EXTENSION

CHAR(356)

Additional address components (invoice recipient)

CUST_SELL_STREET_NO

CHAR(100)

Invoice recipient's street and house number

CUST_SELL_ZIP

CHAR(10)

Invoice recipient's ZIP code

CUST_SELL_CITY

CHAR(50)

Invoice recipient's city

CUST_SELL_COUNTRY_CODE

CHAR(2)

Country code of the invoice recipient (Alpha 2)

CUST_SELL_TEL_PRIV

CHAR(50)

Invoice recipient's private phone number

CUST_SELL_TEL_OFFICE

CHAR(50)

Invoice recipient's business phone number

CUST_SELL_TEL_MOBILE

CHAR(50)

Invoice recipient's mobile phone number

CUST_SELL_EMAIL

CHAR(80)

Invoice recipient's email address

CUST_SELL_BIRTHDATE

DATE (YYYY-mm-dd)

Invoice recipient's date of birth (if available)

POS_LFDNR

INT

Sequential number of the item in the order

POS_TB_ID

INT

Unique number of the item (across all orders)

POS_CHANNEL_ID

CHAR(40)

Distribution channel's item number

POS_A_ID

INT

Internal article number (article ID) from TB.One

POS_ANR

CHAR(50)

Article number

POS_ANR_CHANNEL

CHAR(50)

Differing article number for the channel (if available)

POS_EAN

EAN13

EAN (if available)

POS_TEXT

CHAR(200)

Product designation

POS_BILLING_TEXT

CHAR(255)

External billing text from the channel

POS_QUANTITY

INT

Order quantity

OPEN_QUANTITY

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 canceled by the channel. If the feature is active, the corresponding field is always exported.

POS_DELIVERY_TIME

INT

Delivery time in business days that was indicated when the customer ordered (if available)

POS_SALESPRICE

FLOAT

Gross sales price indicated at the time the order was created (price for a quantity of 1)

POS_TRANSFER_PRICE

FLOAT

Channel purchase price (net)

TIP:
The contents of the channel-related fields (e.g. customer number of the channel) cannot be provided for all channels.

An example for a CSV order file can be found here.