Variants data set

Id

Text, not normalized

Required

Identifies the vendor in an external information system.

Note: This is the unique ID of the entry in the data set if all of the vendor’s business units use the same customer database. Otherwise, the entry in the data set is uniquely identified by a combination of Id and BusinessUnitId.

Vendor ID

Name

Text, normalized to Text

Optional

Contains the name of the vendor’s company.

Name

Street

Text, normalized to Text

Optional

Contains the street portion of the vendor’s address.

Street

City

Text, normalized to Text

Optional

Contains the city portion of the vendor’s address.

City

State

Text, not normalized

Optional

Contains the state portion of the vendor’s address.

State or Province

ZIP

Text, normalized to Alphanumeric code

Optional

Contains the postal code portion of the vendor’s address.

Postal Code

CountryCode

Text, normalized to Alphanumeric code

Required

Contains the country portion of the vendor’s address.

Country

BusinessUnitId

Text, not normalized

Optional

The ID of the vendor’s business unit (i.e. the recipeint of the order).

Note: If the vendor’s business units use different customer databases, this data set field must be filled in, as the unique key of the entry in the data set will be a combination of BusinessUnitId and Id.

The Commercial Invoice Document Definition has no corresponding field. You can add one if required.

VATID

Text, normalized to Alphanumeric code

Optional

The vendor’s tax ID.

Tax ID

NationalVATID

Text, normalized to Alphanumeric code

Optional

The vendor’s national tax ID.

National Tax ID

IBAN

Text, normalized to Alphanumeric code

Optional

The vendor’s International Bank Account Number.

IBAN

BankAccount

Text, normalized to Alphanumeric code

Optional

The vendor’s bank account.

Bank Account

BankCode

Text, normalized to Alphanumeric code

Optional

The code of the vendor’s bank.

Bank Code