PeopleSoft 9
Account Payables

Table Name WTHD_CNTL_PAYER

Table Description
WTHD_CNTL_PAYER
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
WTHD_CNTL_ID VARCHAR(10) Yes Yes
PAYER_TIN VARCHAR(20) Yes No
WTHD_CONTROL_NAME VARCHAR(4) No No
PAYER_NAME1 VARCHAR(40) No No
PAYER_NAME2 VARCHAR(40) No No
PAYER_ADDRESS1 VARCHAR(35) No No
PAYER_ADDRESS2 VARCHAR(35) No No
PAYER_ADDRESS3 VARCHAR(35) No No
PAYER_CITY VARCHAR(30) No No
PAYER_STATE VARCHAR(6) No No
PAYER_POSTAL VARCHAR(12) No No
PAYER_COUNTRY VARCHAR(3) No No
COUNTRY_CODE VARCHAR(3) No No
PHONE VARCHAR(24) No No
EXTENSION VARCHAR(6) No No
FAX VARCHAR(24) No No
ALL_VENDORS_FLG VARCHAR(1) No No
LAST_FILE_FLG VARCHAR(1) No No
COMBINED_FED_STATE VARCHAR(1) No No
DIRECT_SALES VARCHAR(1) No No
GBR_ACCTS_OFC_NBR VARCHAR(13) No No
GBR_EMPL_REF_NBR VARCHAR(10) No No
GBR_HMRC_NBR SMALLINT No No
Index
Name Type Unique Member
PS_WTHD_CNTL_PAYER PK Yes
Member(s) of "PS_WTHD_CNTL_PAYER" Index
SETID
WTHD_CNTL_ID
PAYER_TIN

Published June 06, 2007