PeopleSoft 9
Account Payables

Table Name WTHD_PERIOD_LOG

Table Description
WTHD_PERIOD_LOG
Columns
Name Datatype Is PK Is FK
BU_REGIST_ID VARCHAR(20) Yes No
VNDR_REGIST_ID VARCHAR(20) Yes No
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 Yes
CALENDAR_SETID VARCHAR(5) Yes No
CALENDAR_ID VARCHAR(2) Yes No
FISCAL_YEAR SMALLINT Yes No
ACCOUNTING_PERIOD SMALLINT Yes No
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
PYMNT_CNT int Yes Yes
PROCESS_INSTANCE decimal(10) Yes No
WTHD_CONT_REF VARCHAR(15) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
SETID VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
WTHD_BASIS_AMT decimal(26,3) No No
WTHD_AMT decimal(26,3) No No
PAYMENT_DT PSDATE No No
WTHD_DECL_DATE PSDATE No No
CURRENCY_CD VARCHAR(3) No No
Index
Name Type Unique Member
PS_WTHD_PERIOD_LOG PK Yes
Member(s) of "PS_WTHD_PERIOD_LOG" Index
BU_REGIST_ID
VNDR_REGIST_ID
WTHD_ENTITY
WTHD_TYPE
WTHD_JUR_CD
WTHD_CLASS
WTHD_RULE
CALENDAR_SETID
CALENDAR_ID
FISCAL_YEAR
ACCOUNTING_PERIOD
BUSINESS_UNIT
VOUCHER_ID
PYMNT_CNT
PROCESS_INSTANCE

Published June 06, 2007