PeopleSoft 9
Account Payables

Table Name PYMNT_VCHR_WTHD

Table Description
PYMNT_VCHR_WTHD
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
PYMNT_CNT int Yes Yes
WTHD_ENTITY VARCHAR(5) Yes No
WTHD_TYPE VARCHAR(5) Yes No
WTHD_JUR_CD VARCHAR(5) Yes No
WTHD_CLASS VARCHAR(5) Yes No
WTHD_RULE VARCHAR(5) Yes No
WTHD_BASIS_AMT decimal(26,3) No No
WTHD_AMT decimal(26,3) No No
ORG_WTHD_BASIS_ENT decimal(26,3) No No
TXN_CURRENCY_CD VARCHAR(3) No No
POSTING_DATE PSDATE No No
POST_STATUS_WTHD VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
CREATE_PAY_FLG VARCHAR(1) No No
BASE_CURRENCY VARCHAR(3) No No
WTHD_BASIS_AMT_BSE decimal(26,3) No No
WTHD_AMT_BSE decimal(26,3) No No
WTHD_DECL_DATE PSDATE No No
WTHD_AMT_ENT decimal(26,3) No No
ENT_CURRENCY_CD VARCHAR(3) No No
ENT_RT_TYPE VARCHAR(5) No No
ENT_RATE_MULT decimal(15,8) No No
ENT_RATE_DIV decimal(15,8) No No
WTHD_BASIS_AMT_ENT decimal(26,3) No No
BU_REGIST_ID VARCHAR(20) No No
VNDR_REGIST_ID VARCHAR(20) No No
APPL_VENDOR_SETID VARCHAR(5) No No
APPL_VENDOR_ID VARCHAR(10) No No
APPL_VNDR_LOC VARCHAR(10) No No
APPL_ADDR_SEQ_NUM INT No No
WTHD_PYMNT_CNT int No No
WTHD_SURCHRG_AMT decimal(26,3) No No
ADDL_SRCHRG_AMT DECIMAL(26,3) No No
Index
Name Type Unique Member
PS_PYMNT_VCHR_WTHD PK Yes
Member(s) of "PS_PYMNT_VCHR_WTHD" Index
BUSINESS_UNIT
VOUCHER_ID
PYMNT_CNT
WTHD_ENTITY
WTHD_TYPE
WTHD_JUR_CD
WTHD_CLASS
WTHD_RULE

Published June 06, 2007