Bank

Bank

Column heading

Description

Mandatory field

Example value

Data type (length)

Import

Export

SupplierNr

Unique supplier number (NrIntern) of the supplier at organization level to which the optional bank details refer.

yes

ONV000001

varchar(35)

yes

yes

BankNr

Unique number for the optional bank details within a supplier

yes

000001

varchar(35)

yes

yes

Name

Bank name

yes

Demo Bank Stuttgart

varchar(50)

yes

yes

Street

Street of the optional bank account

no

Stuttgart Street 1

varchar(100)

yes

yes

ZIPCity

Postcode of the optional bank account

no

70563

varchar(20)

yes

yes

City

Location of the optional bank account

no

Stuttgart

varchar(50)

yes

yes

Country

Country of the optional bank details as ISO code – examples:

DE = Germany
AT = Austria
EN = England

EN

ISO code

yes

yes

Region

Region of optional bank details as ISO code – examples:

BW = Baden Württemberg
BY = Bavaria
BE = Berlin
…

Only available for Germany, Austria and USA

no

BW

ISO code

yes

yes

Currency

Currency of the bank account as ISO code – examples:

EUR = Euro
USD = US Dollar
GBP = British Pound

no

EUR

ISO code

yes

yes

Account

Account number of the optional bank account

• Mandatory field if no IBAN is given

yes*

648489890

varchar(50)

yes

yes

Number

Bank code/Bank number of the optional bank account

no

50010517

varchar(50)

yes

yes

IBAN

IBAN of the optional bank account

• Mandatory field if no account number is specified

yes*

DE89370400440532013000

varchar(35)

yes

yes

BIC

BIC/SWIFT of the optional bank details

no

HASPDEHH

varchar(20)

yes

yes