PeopleSoft 9
Account Payables

Table Name WTHD_EXCEPTIONS

Table Description
WTHD_EXCEPTIONS
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
PYMNT_CNT int Yes Yes
VOUCHER_LINE_NUM int Yes Yes
WTHD_ENTITY VARCHAR(5) Yes Yes
WTHD_TYPE VARCHAR(5) Yes Yes
WTHD_JUR_CD VARCHAR(5) Yes Yes
WTHD_CLASS VARCHAR(5) Yes Yes
WTHD_RULE VARCHAR(5) Yes No
DESCR254_MIXED VARCHAR(254) No No
Index
Name Type Unique Member
PS_WTHD_EXCEPTIONS PK Yes
Member(s) of "PS_WTHD_EXCEPTIONS" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
BUSINESS_UNIT
VOUCHER_ID
PYMNT_CNT
VOUCHER_LINE_NUM
WTHD_ENTITY
WTHD_TYPE
WTHD_JUR_CD
WTHD_CLASS
WTHD_RULE

Published June 06, 2007