PeopleSoft 9
Account Payables

Table Name VCHR_WTHD_UPDT

Table Description
VCHR_WTHD_UPDT
Columns
Name Datatype Is PK Is FK
WITHHOLD_UPDATE_ID VARCHAR(30) Yes Yes
VENDOR_SETID VARCHAR(5) Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes No
VNDR_LOC VARCHAR(10) Yes No
START_DATE datetime Yes Yes
END_DATE datetime Yes Yes
WTHD_ENTITY VARCHAR(5) No No
CURRENT_WTHD_SW VARCHAR(1) No No
NEW_WTHD_SW VARCHAR(1) No No
NEW_WTHD_SETID VARCHAR(5) No No
NEW_WTHD_CLASS VARCHAR(5) No No
WTHD_TYPE VARCHAR(5) No No
PROCESS_INSTANCE DECIMAL(10) No No
UPDATE_STATUS_FLG VARCHAR(1) No No
WTHD_JUR_CD VARCHAR(5) No No
Index
Name Type Unique Member
PS_VCHR_WTHD_UPDT PK Yes
Member(s) of "PS_VCHR_WTHD_UPDT" Index
WITHHOLD_UPDATE_ID
VENDOR_SETID
BUSINESS_UNIT
VENDOR_ID
VNDR_LOC
START_DATE
END_DATE

Published June 06, 2007