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 Detail Record
5 Contact Phone Detail Record
6 UDF Detail Record
7 Valid OU Detail Record

Address Detail Record

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

#	Field	Entry	Value	Description

#	Field	Entry	Value	Description
1	Record Type	Req	C! 5	The value should be ADDRESS.
2	Activity Code	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 Field, 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 Vendor ID and Address #; 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 Field in the existing record.
3	Vendor ID	Req	X	ID of the Vendor.
4	Address #	Req	I 5	ID of the Vendor’s address.
5	Address Name	Opt	C 30	Name associated with the Vendor’s address. A value is required if the Vendor’s Type is M (Miscellaneous).
6	Address line 1	Opt	C 30	First line of the Vendor’s address.
7	Address line 2	Opt	C 30	Second line of the Vendor’s address.
8	Address line 3	Opt	C 30	Third line of the Vendor’s address.
9	City	Req	C 20	The city associated with the Addr #.
10	State/ Province	Req	C! 4	ID of the state associated with the Addr #.
11	Postal Cd	Req	C 10	Postal (ZIP) code associated with the Addr #.
12	Country Cd	Opt	C! 3	ID of the country associated with the Addr #.
13	Address Type	Opt	C! 3	ID of the address type, which classifies the address.
14	Remit Addr	Opt	C! 1	This indicates (with Y (yes) or N (no)) whether this address is allowed for remittances. This defaults as Y.
15	PO Addr	Opt	C! 1	Indicate (with a Y (yes) or N (no)) if this address is allowed for purchase orders. This defaults as Y.
16	Phone Area Code	Opt	C 3	Area code of the phone number associated with the address.
17	Phone #	Opt	C 11	Phone number associated with the address. A value is required if there is a Phone Area Code value.
18	Fax Area Code	Opt	C 3	Area code of the fax number associated with the address.
19	Fax #	Opt	C 11	Fax number associated with the address. A value is required if there is a Fax Area Code value.
20	Sep Check by Inv	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 Remit Addr is N.
21	Website	Opt	C 100	Address (URL) of the Vendor’s website.
22	Vendor Address – Additional Information, line 1	Opt	C 50	First additional line that will print below the vendor address on the AP Check.
23	Vendor Address – Additional Information, line 2	Opt	C 50	Second additional line that will print below the vendor address on the AP Check.
24	Direct Deposit of Payable Amounts?	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 Remit Addr is N. Note: When changing this value to N on an existing vendor address, the Bank Number, Bank Account Number, and Account Type Code Fields will be set to null (i.e., blank) in this vendor address table.
25	Bank Number	Opt	C! 9	Number of the Vendor’s bank to be used for direct deposits for this address. A value is required if Print Direct Deposit Advice Notices value 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.
26	Bank Name	Opt	C30	Name of the Vendor’s Bank. A value is required if Print Direct Deposit Advice Notices value is Y; otherwise you cannot enter a value. This defaults as Default Bank Name.
27	Bank Account Number	Opt	C 17	Account number of the Vendor’s bank to be used for direct deposits for this address. A value is required if the Print Direct Deposit Advice Notices value is Y; otherwise, you cannot enter a value.
28	Account Type Code	Opt	C! 1	The account type/classification for the Bank Account Number. A value is required if the Print Direct Deposit Advice Notices value is Y; otherwise, you cannot enter a value. Valid values are: C (Checking) S (Savings)
29	Print Direct Deposit Advice Notices?	Opt	C! 1	Indicate (with Y (yes) or N (no)) if PENTA should print direct deposit advice notices. This defaults as Y.
30	Email Direct Deposit Disbursement Information?	Opt	C! 1	Indicate (with Y (yes or N (no)) if direct deposit advice notices should be emailed. This defaults as N.
31	Email Address	Opt	C 50	The email address where advice notices should be sent. A value is required if Email Direct Deposit Disbursement Information is Y.

Check Form Detail Record

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

Notes: Entry of at least one check form is required if System Option 260 is Y and the Vendor Detail record's Vendor Type value is E.

#	Field	Entry	Value	Description

#	Field	Entry	Value	Description
1	Record Type	Req	C! 5	The value should be CHECKFORM.
2	Activity Code	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.
3	Vendor ID	Req	X	ID of the Vendor.
4	Check 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

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

#	Field	Entry	Value	Description

#	Field	Entry	Value	Description
1	Record Type	Req	C! 5	The value should be CONTACT.
2	Activity Code	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 Field, 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 a Vendor ID, Addr #, and Contact #; 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 Field in the existing record.
3	Vendor ID	Req	X	ID of the Vendor.
4	Addr #	Req	I 5	ID of the Vendor’s address.
5	Contact #	Req	I 3	ID of the contact person associated with the Vendor/address.
6	Last Name	Opt	C 20	Last name of the Vendor’s contact.
7	First Name	Opt	C 15	First name of the Vendor’s contact.
8	Type	Opt	C! 3	ID that classifies the Vendor’s contact.
9	Title	Opt	I 4	The title # of Vendor’s contact.
10	Email Address	Opt	C 50	Email address of Vendor’s contact.

Detail Record

Address Note (*): The addresses referenced on the VENDOR record must either already exist or be created as part of the same interface request.

#	Field	Entry	Value	Description

#	Field	Entry	Value	Description
1	Record Type	Req	C! 5	The value should be VENDOR.
2	Activity Code	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 Field, 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 Vendor ID; all other fields marked as Req can be left null (i.e., blank). U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied Field in the existing record.
3	Vendor ID	Req	X	The vendor’s ID.
4	Name	Req	C 30	The vendor’s name.
5	Prefix