PeopleSoft 9
Account Payables

Table Name LINE_WTHD_UPDT

Table Description
LINE_WTHD_UPDT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
NEW_WTHD_SW VARCHAR(1) No No
NEW_WTHD_CLASS VARCHAR(5) No No
WTHD_ENTITY VARCHAR(5) No No
NEW_WTHD_SETID VARCHAR(5) No No
CURRENT_WTHD_SW VARCHAR(1) No No
UPDATE_STATUS_FLG VARCHAR(1) No No
START_DATE PSDATE No No
END_DATE PSDATE No No
NEW_WTHD_TYPE VARCHAR(5) No No
NEW_WTHD_JUR_CD VARCHAR(5) No No
Index
Name Type Unique Member
PS_LINE_WTHD_UPDT PK Yes
PS1LINE_WTHD_UPDT IE10 No
PS0LINE_WTHD_UPDT IE9 No
Member(s) of "PS_LINE_WTHD_UPDT" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
Member(s) of "PS1LINE_WTHD_UPDT" Index
NEW_WTHD_CLASS
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
Member(s) of "PS0LINE_WTHD_UPDT" Index
NEW_WTHD_SW
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007