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 |