Master data: Import specification for SupplierBank table

Use these fields when you import master data for supplier banks. The master data import formats are described here.

Field

Description

Format

Required?

SupplierNumber

The buyer's internal number/ID for the supplier.

1 to 100 characters

Yes

CorporateGroupID

The buyer corporate group ID that the supplier is associated with.

1 to 100 characters (changed from integer in INVOICES 5-6)

Yes

Name

The primary name of the supplier.

1 to 100 characters

No

CountryCoded

The country code of the supplier.

2 to 3 alphabetic characters (A-Z)

No

CountryName

The country name of the supplier.

1 to 200 characters

No

BankNumber *

The bank number of the supplier's bank.

1 to 50 characters

No

AccountNumber *

The bank account number of the supplier.

1 to 50 characters

No

IBAN

The International Bank Account Number of the supplier.

1 to 50 characters

No

*   Note that these fields are required when used in connection with an Oracle database.