Master data: Import specification for Supplier table
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 Kofax ReadSoft 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 Kofax ReadSoft 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 |