NAME

String

The name of the vendor.

Address1

String

The vendor street address line 1.

ADDRESS2

String

The vendor street address line 2.

ZIP

String

The vendor zip code or postal code.

ID

String

The unique vendor ID. The unique ID from the point of view of the data extract, where each row must have a unique reference. This is not the unique vendor ID from the point of view of the ERP system if a site ID is also used.

SITEID

String

The vendor site ID.

ExternalSiteID

String

The external site ID.

AlternatePayee

String

The party that receives payment for an invoice.

PermittedPayee

String

A list of parties that are configured to receive payment for an invoice.

TELNO

String

The vendor telephone number.

CITY

String

The vendor city.

STATE

String

The vendor state. For U.S. addresses, the state code is expected here, such as CA = California, or VA = Virginia.

COUNTRY

String

The vendor country. This is a two character ISO-code for the country, such as US = United States of America, DE = Germany, GB = United Kingdom.

POBOX

String

The vendor Post Office (PO) box number.

POBOXZIP

String

The zip code or postal code associated with the vendor Post Office (PO) box.

EUMEMBER

Boolean

The boolean indicator that denotes whether the vendor belongs to an EU member state country.

VATREGNO

String

The vendor VAT registration number. If the vendor is registered for VAT in more than one country, then multiple VAT registration numbers are provided in the form of a comma-separated list.

TAXID1

String

The vendor tax ID 1.

TAXID2

String

The vendor tax ID 2.

TAXJURCODE

String

The ID of the tax office where the vendor is based.

Currency

String

The vendor currency.

INVOICETYPE

String

The vendor invoice type. This is set to a value that denotes either a Purchase Order-supplying vendor or a vendor who submits invoices that legitimately do not reference a purchase order.

If this column is used to determine the invoice type field, the meaning of the values contained in the column must be mapped against the PO Value and NPO Value settings in the Settings > IP Configuration > Capture Profiles > Invoice Type Settings.

For more information on the referenced settings, see the IP Configuration section of the Help for Kofax AP Agility Settings.

PAYMENTMETHODS

String

The comma-separated list of payment method codes appropriate for the vendor.

BANKDETAILS

String

The vendor bank account details. This should be a colon-separated list in the following format:

BankAccount, SortCode, ERPBankAccountCode

A sort code is the U.S. equivalent of a routing number.

IBAN

String

The vendor international bank account number.

UTILITYFLAG

String

The indicator as to whether the vendor is a utility vendor.

PORSUBNO

String

The vendor POR subscriber number used only for Switzerland.

EXTERNALID

String

The ERP system vendor ID if a site ID is used.

ACCOUNTGROUP

String

The ERP system vendor account group.

COMPANYCODES

String

The comma-separated list of company codes that are valid for the vendor.

SIRETID

String

The vendor SIRET ID. This is an ID code used in France that uniquely identifies a single vendor at a single address. It is often found on French invoices.

VENDORIDENTIFIER

String

The unique vendor identifier code, such as a Chinese tax number.

PARTITIONID

String

The vendor partition ID.

Custom1 through Custom5

String

These fields are used to store additional information about the vendor that is specific to your needs.