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 |