Use these fields when you import master data for suppliers. 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 |
Location |
The location of the supplier. |
1 to 50 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 |
Name1 |
The primary name of the supplier. |
1 to 400 characters |
Yes |
Name2 |
The secondary name of the supplier. |
1 to 350 characters |
No |
Description |
A short description of the supplier. |
1 to 200 characters |
No |
POBox |
The PO Box number of the supplier's mailing address. |
1 to 50 characters |
No |
Street |
The street name of the supplier. |
1 to 400 characters |
No |
StreetSupplement |
Additional street details of the supplier. |
1 to 400 characters |
No |
PostalCode |
The post/ZIP code of the supplier. |
1 to 100 characters |
No |
City |
The city of the supplier. |
1 to 200 characters |
No |
State |
The federal state/territory of the supplier. |
1 to 50 characters |
No |
CountryCoded |
The country code of the supplier. |
2 to 3 alphabetic characters (A-Z) |
Yes |
CountryName |
The country name of the supplier. |
1 to 200 characters |
No |
TelephoneNumber |
The telephone number of the supplier. |
1 to 100 characters |
No |
FaxNumber |
The fax number of the supplier. |
1 to 100 characters |
No |
VATRegistrationNumber |
The tax registration number of the supplier. |
1 to 100 characters |
No |
TaxNumber1 |
A tax number of the supplier. |
1 to 50 characters |
No |
TaxNumber2 |
A tax number of the supplier. |
1 to 50 characters |
No |
PaymentTerm |
The payment term of the supplier (e.g., 30 days) |
1 to 50 characters |
No |
PaymentMethod |
The payment method for the supplier (e.g. cash) |
1 to 50 characters |
No |
Blocked |
Indicates whether the supplier is blocked in INVOICES and cannot be used. |
"x" or "X" |
No |
CustomSupplierField1 |
Any generic text on an invoice, unique to the supplier, that can help to identify it. |
1 to 400 characters |
No |
CustomSupplierField2 |
Any additional generic text on an invoice, unique to the supplier, that can help identify it. |
1 to 400 characters |
No |
EmailAddress |
Unique email address on an email or invoice that identifies the supplier. |
Up to 100 characters |
No |