PeopleSoft 9
Account Payables

Table Name WTHD_CNTL

Table Description
WTHD_CNTL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
WTHD_CNTL_ID VARCHAR(10) Yes No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
COUNTRY_CODE VARCHAR(3) No No
PHONE VARCHAR(24) No No
EXTENSION VARCHAR(6) No No
FAX VARCHAR(24) No No
TIN VARCHAR(20) No No
WTHD_CONTROL_NAME VARCHAR(4) No No
TRANS_CNTL_CD VARCHAR(5) No No
LAST_FILE_FLG VARCHAR(1) No No
COMBINED_FED_STATE VARCHAR(1) No No
ALL_VENDORS_FLG VARCHAR(1) No No
WTHD_COMBINE_OPT VARCHAR(1) No No
CNTCT_NAME1 VARCHAR(40) No No
CNTCT_EMAIL_ADDR VARCHAR(50) No No
CNTCT_COUNTRY_CODE VARCHAR(3) No No
CNTCT_PHONE VARCHAR(24) No No
CNTCT_EXTENSION VARCHAR(6) No No
CNTCT_FAX VARCHAR(24) No No
VNDR_SFT_INDICATOR VARCHAR(1) No No
MEDIA_NUMBER VARCHAR(6) No No
Index
Name Type Unique Member
PS_WTHD_CNTL PK Yes
Member(s) of "PS_WTHD_CNTL" Index
SETID
WTHD_CNTL_ID

Published June 06, 2007