SELL_TO and SHIP_TO

TB_ID

N

INT

Customer number from TB.One (unique across all channels). If the delivery address differs from the invoicing address, a separate TB_ID is assigned.

CHANNEL_NO

N

CHAR(50)

The customer number used by the distribution channel

TITLE

N

CHAR(20)

Title (e.g. form of address/honorific)

FIRSTNAME

Y

CHAR(50)

Customer's first name. While the field itself is mandatory, it can be empty

LASTNAME

Y

CHAR(50)

Customer's last name. While the field itself is mandatory, it can be empty

NAME

N

CHAR(100)

Customer's full name (if the channel does not provide first and last name separately, TB.One will try to fill those fields automatically)

This field can be empty

NAME_EXTENSION

N

CHAR(100)

Name suffix

STREET_NO

Y

CHAR(100)

Street and house number

STREET_EXTENSION

N

CHAR(255)

Address supplement

ZIP

Y

CHAR(10)

Postal code

CITY

Y

CHAR(50)

City

COUNTRY

Y

CHAR(5)

Country code ALPHA 2 (e.g. "GB")

PHONE_PRIVATE

N

CHAR(50)

Private phone number

PHONE_OFFICE

N

CHAR(50)

Business phone number

PHONE_MOBILE

N

CHAR(50)

Cell phone number

EMAIL

N

CHAR(80)

E-mail address

BIRTHDAY

N

DATE
YYYY-MM-DD

The customer's date of birth (only supported by few channels)

VAT_ID

N

CHAR(20)

The customer's value added tax identification number (only supported by few channels)