PeopleSoft 9
Account Payables

Table Name WTHD_TO_SND_HDR

Table Description
WTHD_TO_SND_HDR
Columns
Name Datatype Is PK Is FK
WTHD_RPT_ID VARCHAR(10) Yes Yes
WTHD_SETID VARCHAR(5) Yes No
WTHD_CNTL_ID VARCHAR(10) Yes No
WTHD_ENTITY VARCHAR(5) Yes No
CALENDAR_SETID VARCHAR(5) Yes No
CALENDAR_ID VARCHAR(2) Yes No
FISCAL_YEAR SMALLINT Yes No
PERIOD SMALLINT Yes No
PROCESS_DTTM PSDATETIME 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
CNTCT_NAME1 VARCHAR(40) 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
WTHD_AMT_CODES VARCHAR(12) No No
WTHD_FILE_TYPE VARCHAR(1) No No
VNDR_SFT_INDICATOR VARCHAR(1) No No
CNTCT_EMAIL_ADDR VARCHAR(50) No No
MEDIA_NUMBER VARCHAR(6) No No
Index
Name Type Unique Member
PS_WTHD_TO_SND_HDR PK Yes
Member(s) of "PS_WTHD_TO_SND_HDR" Index
WTHD_RPT_ID
WTHD_SETID
WTHD_CNTL_ID
WTHD_ENTITY
CALENDAR_SETID
CALENDAR_ID
FISCAL_YEAR
PERIOD
PROCESS_DTTM

Published June 06, 2007