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