PeopleSoft 9
Account Payables

Table Name WTHD_SENT_DTL

Table Description
WTHD_SENT_DTL
Columns
Name Datatype Is PK Is FK
WTHD_RPT_ID VARCHAR(10) Yes Yes
WTHD_SETID VARCHAR(5) Yes Yes
WTHD_CNTL_ID VARCHAR(10) Yes Yes
WTHD_ENTITY VARCHAR(5) Yes Yes
WTHD_TYPE VARCHAR(5) Yes Yes
CALENDAR_SETID VARCHAR(5) Yes Yes
CALENDAR_ID VARCHAR(2) Yes Yes
FISCAL_YEAR SMALLINT Yes Yes
PERIOD SMALLINT Yes Yes
PROCESS_DTTM PSDATETIME Yes Yes
VENDOR_SETID VARCHAR(5) Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
VNDR_LOC VARCHAR(10) Yes Yes
PAYER_TIN VARCHAR(20) Yes Yes
ADDRESS_SEQ_NUM INT Yes Yes
LINE_NO SMALLINT Yes Yes
SEND_STATUS VARCHAR(1) No No
ACTIVE_STATUS VARCHAR(1) No No
DESCR VARCHAR(30) No No
CURRENCY_CD VARCHAR(3) No No
WTHD_BASIS_AMT decimal(26,3) No No
WTHD_LIABILITY_AMT decimal(26,3) No No
PAID_AMT decimal(26,3) No No
SEX VARCHAR(1) No No
BIRTHDATE PSDATE No No
BIRTHPLACE VARCHAR(30) No No
NUM_CHILDREN SMALLINT No No
COMPANY_FLG VARCHAR(1) No No
TAX_DIST_REF VARCHAR(13) No No
CERTIFICATE_TYPE VARCHAR(1) No No
CERTIFICATE_NUM VARCHAR(15) No No
CERTIFICATE_EXP_DT PSDATE No No
DIRECT_SALES VARCHAR(1) No No
SECOND_TIN VARCHAR(1) No No
STATE_TAX_WH decimal(15,2) No No
TIN_TYPE VARCHAR(1) No No
TIN VARCHAR(20) No No
WTHD_CONTROL_NAME VARCHAR(4) No No
PROFESSION VARCHAR(30) No No
WTHD_PAN_NUM VARCHAR(15) No No
WTHD_PAN_WARD VARCHAR(30) No No
TRADE_BUS_INC VARCHAR(1) No No
COUNTRY_PAID VARCHAR(40) No No
FOREIGN_TAX_PAID decimal(13) No No
GBR_VENDOR_TYPE VARCHAR(1) No No
GBR_REG_NO VARCHAR(9) No No
GBR_VERIFY VARCHAR(1) No No
GBR_VERIFY_NBR VARCHAR(13) No No
GBR_VERIFY_DATE datetime No 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
Index
Name Type Unique Member
PS_WTHD_SENT_DTL PK Yes
PSWWTHD_SENT_DTL IE1 No
Member(s) of "PS_WTHD_SENT_DTL" Index
WTHD_RPT_ID
WTHD_SETID
WTHD_CNTL_ID
WTHD_ENTITY
WTHD_TYPE
CALENDAR_SETID
CALENDAR_ID
FISCAL_YEAR
PERIOD
PROCESS_DTTM
VENDOR_SETID
BUSINESS_UNIT
VENDOR_ID
VNDR_LOC
PAYER_TIN
ADDRESS_SEQ_NUM
LINE_NO
Member(s) of "PSWWTHD_SENT_DTL" Index
WTHD_RPT_ID
WTHD_SETID
WTHD_CNTL_ID
WTHD_ENTITY
WTHD_TYPE
CALENDAR_SETID
CALENDAR_ID
FISCAL_YEAR
PERIOD
PROCESS_DTTM
VENDOR_SETID
BUSINESS_UNIT
VENDOR_ID
VNDR_LOC
PAYER_TIN
ADDRESS_SEQ_NUM

Published June 06, 2007