PeopleSoft 9
Account Payables

Table Name WTHD_CERT_DTL

Table Description
WTHD_CERT_DTL
Columns
Name Datatype Is PK Is FK
PROCESS_INSTANCE decimal(10) Yes No
WTHD_RPT_ID VARCHAR(10) Yes Yes
WTHD_ENTITY VARCHAR(5) Yes Yes
VENDOR_SETID VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes No
VNDR_LOC VARCHAR(10) Yes No
ADDRESS_SEQ_NUM INT Yes No
BUSINESS_UNIT VARCHAR(5) Yes No
LINE_NO SMALLINT Yes No
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes No
BANK_ACCT_KEY VARCHAR(4) Yes No
PYMNT_METHOD VARCHAR(3) Yes No
PYMNT_ID VARCHAR(10) Yes 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
PYMNT_DT PSDATE No No
WTHD_SURCHRG_AMT decimal(26,3) No No
Index
Name Type Unique Member
PS_WTHD_CERT_DTL PK Yes
Member(s) of "PS_WTHD_CERT_DTL" Index
PROCESS_INSTANCE
WTHD_RPT_ID
WTHD_ENTITY
VENDOR_SETID
VENDOR_ID
VNDR_LOC
ADDRESS_SEQ_NUM
BUSINESS_UNIT
LINE_NO
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_METHOD
PYMNT_ID

Published June 06, 2007