Vendor Interface: Pipe Delimited Method

Owned by Samantha Menzynski
10 20, 2024
13 min read

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

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