Use the Vendor Interface to load vendor information using data from external applications. Information you load using this interface adds to the data already stored in PENTA.

Data files you load must have Request Types assigned to the V Interface Type.

Related System Options

System Option 340 (Reject Vendor Interface on Error) controls whether PENTA rejects a Vendor Interface request when it contains errors. If this is set to:

N – PENTA rejects records in the interface file that generated errors. PENTA loads records that don't generate errors into the database.
Y – PENTA rejects the entire interface file if any record in the file generated an error.

Where to View Loaded Data

You can review interfaced data in the Vendor Information window.

Available Tables

1 Address Detail Record
2 Check Form Detail Record
3 Contact Detail Record
4 Vendor Detail Record
5 Phone Detail Record
6 UDF Detail Record
7 Valid OU Detail Record

Address Detail Record

The following information relates to the INTR_VEN_ADDRESS table, which contains address information for Vendors.

Note: The specified vendor bank account will be created if it doesn’t already exist.

Column Name	Entry	Value	Description

Column Name	Entry	Value	Description
ACTIVITY_CD	Req	C! 1	Required for all activity. Possible values: A (Add) – If a record with the same key already exists, PENTA records an error. C (Change) – Update an existing record. If PENTA cannot update the column, it records an error. D (Delete) – Delete the record. If the record does not exist or was not created by the interface, PENTA records an error. Note: If the Activity Code is (D)elete, you must enter VEN_ID and ADDR_NUM; all other fields marked as Req can be left null/blank. U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.
VEN_ID	Req	X	ID of the Vendor.
ADDR_NUM	Req	I 5	ID of the Vendor’s address.
ADDR_NAME	Opt	C 30	Name associated with the Vendor’s address. A value is required for Miscellaneous vendors (VEN_TYPE_CD is M).
ADDR_1	Opt	C 30	First line of the Vendor’s address.
ADDR_2	Opt	C 30	Second line of the Vendor’s address.
ADDR_3	Opt	C 30	Third line of the Vendor’s address.
CITY	Req	C 20	The city associated with the ADDR_NUM.
ST_CD	Req	C! 4	ID of the state associated with the ADDR_NUM.
POSTAL_CD	Req	C 10	Postal (ZIP) code associated with the ADDR_NUM.
COUNTRY_CD	Opt	C! 3	ID of the country associated with the ADDR_NUM.
VEN_ADDR_TYPE_CD	Opt	C! 3	ID of the address type, which classifies the address.
VALID_REMIT_ADDR_CD	Opt	C! 1	Indicate (with Y (yes) or N (no)) whether this address is allowed for remittances. This defaults as Y.
VALID_PO_ADDR_CD	Opt	C! 1	Indicate (with a Y (yes) or N (no)) whether this address is allowed for purchase orders. This defaults as Y.
PHONE_AREA_CD	Opt	C 3	Area code of the phone number associated with the address.
PHONE_NUM	Opt	C 11	Phone number associated with the address. A value is required if there is a PHONE_AREA_CD value.
FAX_AREA_CD	Opt	C 3	Area code of the fax number associated with the address.
FAX_NUM	Opt	C 11	Fax number associated with the address. A value is required if there is a FAX_AREA_CD value.
SEP_CHK_PER_INVOICE_CD	Opt	C! 1	Indicate (with Y (yes) or N (no) if PENTA should create a separate check for each invoice for this address. This must be N if VALID_REMIT_ADDR_CD is N.
WWW_ADDR	Opt	C 100	Address (URL) of the Vendor’s website.
ADDL_CHECK_LINE_1	Opt	C 50	First additional line that will print below the vendor address on the AP Check.
ADDL_CHECK_LINE_2	Opt	C 50	Second additional line that will print below the vendor address on the AP Check.
DIRECT_DEPOSIT_CD	Opt	C! 1	Indicate (with Y (yes) or N (no)) if payments to this vendor address are directly deposited. This defaults as N. This must be N if VALID_REMIT_ADDR_CD is N. Note: When changing this value to N on an existing vendor address, the VEN_BANK_NUM, VEN_BANK_ACCT_NUM, and BANK_ACCT_TYPE_CD columns will be set to null in this VENDOR_ADDRESS table.
VEN_BANK_NUM	Opt	C! 9	Number of the Vendor’s bank to be used for direct deposits for this address. A value is required if DIRECT_DEPOSIT_CD is Y; otherwise you cannot enter a value. If country is USA or System Option 263 is Y and country is anything other than CAN, this must be a valid U.S. bank number.
VEN_BANK_NAME	Opt	C 30	Name of the Vendor’s Bank. A value is required if DIRECT_DEPOSIT_CD is Y; otherwise you cannot enter a value.
VEN_BANK_ACCT_NUM	Opt	C 17	Account number of the Vendor’s bank to be used for direct deposits for this address. A value is required if DIRECT_DEPOSIT_CD is Y; otherwise, you cannot enter a value.
BANK_ACCT_TYPE_CD	Opt	C! 1	The account type/classification for the VEN_BANK_ACCT_NUM. A value is required if DIRECT_DEPOSIT_CD is Y; otherwise, you cannot enter a value. Valid values are: C (Checking) S (Savings)
PRINT_ADVICE_NOTICE_CD	Opt	C! 1	Indicate (with Y (yes) or N (no)) if PENTA should print direct deposit advice notices. This defaults as Y.
EMAIL_ADVICE_NOTICE_CD	Opt	C! 1	Indicate (with Y (yes or N (no)) if direct deposit advice notices should be emailed. This defaults as N.
EMAIL_ADDR	Opt	C 50	The email address where advice notices should be sent. A value is required if EMAIL_ADVICE_NOTICE_CD is Y.

Check Form Detail Record

The following information relates to the INTR_VEN_CHECKFORM table, which contains default Check Forms for a Vendor.

Note: You must enter at least one check form if System Option 260 is Y and vendor type is E.

Column Name	Entry	Value	Description

Column Name

Entry

Value

Description

ACTIVITY_CD

Req

C! 1

Required for all activity. Possible values:

A (Add) – If a record with the same key already exists, PENTA records an error.
D (Delete) – Delete the record. If the record does not exist or was not created by the interface, PENTA records an error.

VEN_ID

Key

X

ID of the Vendor.

FORM_ID

Req

C! 8

ID of the default form PENTA should use for checks for a particular balance sheet OU/currency combination.

For each vendor, PENTA allows only one form per balance sheet/currency combination.

Contact Detail Record

The following information relates to the INTR_VEN_CONTACT table, which contains contacts for Vendors.

Note: You must enter a value for at least one of the optional fields.

Column Name	Entry	Value	Description

Column Name	Entry	Value	Description
ACTIVITY_CD	Req	C! 1	Required for all activity. Possible values: A (Add) – If a record with the same key already exists, PENTA records an error. C (Change) – Update an existing record. If PENTA cannot update the column, it records an error. D (Delete) – Delete the record. If the record does not exist or was not created by the interface, PENTA records an error. Note: If the Activity Code is (D)elete, you must enter VEN_ID, ADDR_NUM, and CONTACT_NUM; all other fields marked as Req can be left null/blank. U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.
VEN_ID	Key	X	ID of the Vendor.
ADDR_NUM	Req	I 5	ID of the Vendor’s address.
CONTACT_NUM	Req	I 3	ID of the contact person associated with the Vendor/address.
CONTACT_LAST_NAME	Opt	C 20	Last name of the Vendor’s contact.
CONTACT_FIRST_NAME	Opt	C 15	First name of the Vendor’s contact.
CONTACT_TYPE_CD	Opt	C! 3	ID that classifies the Vendor’s contact.
CONTACT_TITLE_NUM	Opt	I 4	The title # of Vendor’s contact.
EMAIL_ADDR	Opt	C 50	Email address of Vendor’s contact.

Vendor Detail Record

The following information relates to the INTR_VEN_VENDOR table, which contains “master information” for Vendors.

Column Name	Entry	Value	Description

Column Name	Entry	Value	Description
ACTIVITY_CD	Req	C! 1	Required for all activity. Possible values: A (Add) – If a record with the same key already exists, PENTA records an error. C (Change) – Update an existing record. If PENTA cannot update the column, it records an error. D (Delete) – Delete the record. If the record does not exist or was not created by the interface, PENTA records an error. Note: If the Activity Code is (D)elete, the only required field is VEN_ID; all other fields marked as Req can be left null/blank. U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied column in the existing record.
VEN_ID	Req	X	The vendor’s ID.
NAME	Req	C 30	The vendor’s name.
NAME_PREFIX	Opt	C 15	Vendor’s name prefix.
MIDDLE_NAME	Opt	C 15	Vendor’s middle name.
VEN_TYPE_CD	Opt	C! 1	Type of vendor. Valid types are: C (Corporation) E (Employee) S (Self employed) I (Intercompany) M (Miscellaneous) Notes: This defaults as C if no type is specified for a new vendor. When changing this value to M on an existing vendor, the DEF_REMIT_ADDR_NUM column will be set to null in the VENDOR table.
VEN_STAT_CD	Opt	C! 1	Status of vendor. Valid statuses are: A (Active) D (Delete) H (Hold) I (Inactive) Notes: This defaults as A (Active) if no Status is specified for a new vendor. When changing the status to or from H for an existing vendor and System Option 87 is Y, then Vendor's status holds will be placed or removed.
EMP_ID	Opt	X	ID of the employee linked to the vendor. A value is required if the VEN_TYPE_CD value is E; otherwise, values are not allowed. Notes You cannot link the same Employee ID to multiple vendors. When you enter an Employee ID, the NAME field will be set to the Employee Last Name, the NAME_PREFIX field will be set to the Employee First Name, and the VEN_ID column in the EMPLOYEE table will be set to the Vendor ID. When changing EMP_ID from null to a non-null value on an existing vendor, the PAR_VEN_ID column will be set to null in the VENDOR table.
RCV_1099_CD	Opt	C! 1	This indicates (with a Y (yes) or N (no)) whether the Vendor receives a 1099. This must be set to: Y if VEN_TYPE_CD is S (Self employed). N if RCV_T5018_CD is Y. Notes: This defaults as N for VEN_TYPE_CDs other than S. When changing RCV_1099_CD to N on an existing vendor, the NAME_CTRL_CD, EARN_CD and FORM_1099_ST_CD columns will be set to null in the VENDOR table.
NAME_CTRL_CD	Opt	C! 4	The Name Control Code is for magnetic media reporting of 1099s. A value is only allowed if RCV_1099_CD = Y; otherwise, this must be blank.
EARN_CD	Opt	C 3	This is the default code for 1099 earnings. A value is required if RCV_1099_CD = Y; otherwise, this must be blank.
FORM_1099_ST_CD	Opt	C! 4	This is the default state code for payments included on 1099s. A value is only allowed if RCV_1099_CD = Y; otherwise, this must be blank.
WH_REQUIRED_CD	Opt	C! 1	Indicates whether PENTA should withhold state income tax from payments to the Vendor. Enter Y if withholding is required on invoices; otherwise enter N. This must be N if RCV_1099_CD is N.