PeopleSoft 9
Account Payables

Table Name VENDOR

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

Published June 06, 2007