PeopleSoft 9
Asset Management

Table Name VENDOR

Table Description
VENDOR
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
VENDOR_ID char(10) Yes No
VENDOR_NAME_SHORT char(14) No No
VNDR_NAME_SHRT_USR char(10) No No
VNDR_NAME_SEQ_NUM smallint No No
NAME1 char(40) No No
NAME2 char(40) No No
VENDOR_STATUS char(1) No No
VENDOR_CLASS char(1) No No
VENDOR_PERSISTENCE char(1) No No
REMIT_ADDR_SEQ_NUM INT No No
PRIM_ADDR_SEQ_NUM INT No No
ADDR_SEQ_NUM_ORDR INT No No
REMIT_SETID char(5) No No
REMIT_VENDOR char(10) No No
CORPORATE_SETID char(5) No No
CORPORATE_VENDOR char(10) No No
CUST_SETID char(5) No No
CUST_ID char(15) No No
ENTERED_BY char(30) No No
AR_NUM char(15) No No
OLD_VENDOR_ID char(15) No No
WTHD_SW char(1) No No
VAT_SW char(1) No No
VNDR_STATUS_PO char(1) No No
REMIT_LOC char(10) No No
DEFAULT_LOC char(10) No No
NAME1_AC char(40) No No
NAME2_AC char(40) No No
PRIMARY_VENDOR char(10) No No
LAST_ACTIVITY_DT PSDATE No No
WITHHOLD_LOC char(10) No No
IN_PROCESS_FLG char(1) No No
PROCESS_INSTANCE decimal(10) No No
HUB_ZONE char(1) No No
EEO_CERTIF_DT PSDATE No No
HRMS_CLASS char(1) No No
INTERUNIT_VNDR_FLG char(1) No No
VNDR_AFFILIATE char(5) No No
BUSINESS_UNIT char(5) No No
VNDR_TIN char(1) No No
ARCHIVED_BY char(30) No No
CREATED_DTTM PSDATETIME No No
CREATED_BY_USER char(30) No No
LAST_MODIFIED_DATE PSDATETIME No No
VNDR_FIELD_C30_A char(30) No No
VNDR_FIELD_C30_B char(30) No No
VNDR_FIELD_C30_C char(30) No No
VNDR_FIELD_C30_D char(30) No No
VNDR_FIELD_C30_E char(30) No No
VNDR_FIELD_C30_F char(30) No No
VNDR_FIELD_C30_G char(30) No No
VNDR_FIELD_C30_H char(30) No No
VNDR_FIELD_C30_I char(30) No No
VNDR_FIELD_C30_J char(30) No No
VNDR_CCR_STATUS char(1) No No
OFAC_STATUS CHAR(1) No No
OFAC_STATUS_DT PSDATE No No
OFAC_MOD_USER CHAR(30) No No
OFAC_LAG_DAYS SMALLINT No No
OFAC_SKIP_VAL CHAR(1) No No
SDN_PUBLISH_DATE PSDATE No No
Index
Name Type Unique Member
PS_VENDOR PK Yes
PS0VENDOR IE1 No
Member(s) of "PS_VENDOR" Index
SETID
VENDOR_ID
Member(s) of "PS0VENDOR" Index
VENDOR_NAME_SHORT
SETID
VENDOR_ID

Published December 16, 2006