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