PeopleSoft 9
Account Payables

Table Name VENDOR_CONTROL

Table Description
VENDOR_CONTROL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
VENDOR_NUM_OPTION VARCHAR(1) No No
VNDR_ID_LAST_ASSGN decimal(10) No No
PRENOTE_WAIT_DAYS SMALLINT No No
WTHD_SW VARCHAR(1) No No
VAT_SW VARCHAR(1) No No
COUNTRY VARCHAR(3) No Yes
STD_ID_NUM_QUAL VARCHAR(3) No No
TIN_MSG_OPT VARCHAR(1) No No
WTHD_TIN_MSG_OPT VARCHAR(1) No No
VAT_RGSTRN_MSG_OPT VARCHAR(1) No No
VNDR_NAME_MSG_OPT VARCHAR(1) No No
VNDR_SNAME_MSG_OPT VARCHAR(1) No No
WTHD_NAME_MSG_OPT VARCHAR(1) No No
SAVE_CHECK VARCHAR(1) No No
INACTIVE_VNDR_OPT VARCHAR(1) No No
VNDR_CI_LOAD_OPT VARCHAR(1) No No
OFAC_SAVE_EDIT VARCHAR(1) No No
OFAC_INACTIVE_OPT VARCHAR(1) No No
OFAC_VEND_CI_OPT VARCHAR(1) No No
Index
Name Type Unique Member
PS_VENDOR_CONTROL PK Yes
Member(s) of "PS_VENDOR_CONTROL" Index
SETID

Published June 06, 2007