UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

VENDOR

Contains all the vendor information, including name(s), tax ID number, class of vendor, but not the addresses.
Further details are in this record's child: VENDOR_ADDR.

SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
VENDOR_ID Vendor ID Example: 0000000001
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Identifier of the vendor.
.
NAME1 Name 1 Example: VERIZON
Type: character Format: lowercase Length: 40 Decimals: 0
The first line of the vendor name.
.
VENDOR_CLASS Classification Example: R, S
Type: character Format: uppercase Length: 1 Decimals: 0
Classification of the vendor (eg. student, employee, etc.)
.
VENDOR_STATUS Vendor Status Example: A=Approved, I=Inactive, U=Unapproved
Type: character Format: uppercase Length: 1 Decimals: 0
Whether a vendor is approved or not.
.
VNDR_TIN Vendor Tax Id Number Example: 51-9999999
Type: character Format: uppercase Length: 1 Decimals: 0
Vendor's SSN or TaxID.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
ADDR_SEQ_NUM_ORDR Ordering Location
AR_NUM Our Customer Number
BUSINESS_UNIT Business Unit
CORPORATE_SETID SetID
CORPORATE_VENDOR Corporate Vendor
CUST_ID Customer ID
CUST_SETID Customer SetID
DEFAULT_LOC Default Location
EEO_CERTIF_DT EEO Certification Date
ENTERED_BY Entered by
HRMS_CLASS Human Resources Classification
HUB_ZONE HUB Zone
IN_PROCESS_FLG In Process
INTERUNIT_VNDR_FLG InterUnit Vendor
LAST_ACTIVITY_DT Last Activity Date
NAME1_AC Name 1 Alternate Char Set
NAME2 Name 2
NAME2_AC Name 2 Alternate Char Set
OLD_VENDOR_ID Old Vendor ID
PRIM_ADDR_SEQ_NUM Invoicing Location
PRIMARY_VENDOR Invoice Vendor
PROCESS_INSTANCE Process Instance
REMIT_ADDR_SEQ_NUM Remitting Location
REMIT_LOC Remit to Location
REMIT_SETID Remit SetID
REMIT_VENDOR Remit Vendor
VAT_SW Display VAT Flag
VENDOR_NAME_SHORT Short Vendor Name
VENDOR_PERSISTENCE Persistence
VNDR_AFFILIATE Vendor Affiliate
VNDR_NAME_SEQ_NUM Sequence Number
VNDR_NAME_SHRT_USR Short Vendor Name
VNDR_STATUS_PO Open For Ordering
WITHHOLD_LOC Withholding Location
WTHD_SW Withholding Applicable