PeopleSoft 9
Account Payables

Table Name VCHR_PYMT_QV

Table Description
VCHR_PYMT_QV
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
PYMNT_CNT int Yes No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
PYMNT_METHOD VARCHAR(3) No No
PYMNT_MESSAGE VARCHAR(70) No No
PYMNT_VCHR_PCT DECIMAL(31,15) No No
PYMNT_HANDLING_CD VARCHAR(2) No No
PYMNT_HOLD VARCHAR(1) No No
PYMNT_HOLD_REASON VARCHAR(3) No No
MESSAGE_CD VARCHAR(6) No No
PYMNT_GROSS_AMT decimal(26,3) No No
PYMNT_SEPARATE VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
SCHEDULED_PAY_DT PSDATE No No
PYMNT_ACTION VARCHAR(1) No No
PYMNT_ID_REF VARCHAR(20) No No
PYMNT_GROUP_CD VARCHAR(2) No No
TXN_CURRENCY_CD VARCHAR(3) No No
EFT_LAYOUT_CD VARCHAR(10) No No
Index
Name Type Unique Member
PS_VCHR_PYMT_QV PK Yes
Member(s) of "PS_VCHR_PYMT_QV" Index
BUSINESS_UNIT
VOUCHER_ID
PYMNT_CNT

Published June 06, 2007