PeopleSoft 9
Account Payables

Table Name WTHD_SENT_PAY

Table Description
WTHD_SENT_PAY
Columns
Name Datatype Is PK Is FK
PAYER_TIN VARCHAR(20) Yes No
WTHD_CNTL_ID VARCHAR(10) Yes No
PROCESS_DTTM PSDATETIME Yes No
WTHD_CONTROL_NAME VARCHAR(4) No No
LAST_FILE_FLG VARCHAR(1) No No
COMBINED_FED_STATE VARCHAR(1) 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
PAYER_PHONE VARCHAR(24) No No
PAYER_EXTENSION VARCHAR(6) No No
ALL_VENDORS_FLG VARCHAR(1) No No
WTHD_AMT_CODES VARCHAR(12) No No
Index
Name Type Unique Member
PS_WTHD_SENT_PAY PK Yes
Member(s) of "PS_WTHD_SENT_PAY" Index
PAYER_TIN
WTHD_CNTL_ID
PROCESS_DTTM

Published June 06, 2007