PeopleSoft 9
Account Payables

Table Name VCHR_PYMT_STG

Table Description
VCHR_PYMT_STG
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VCHR_BLD_KEY_C1 VARCHAR(25) Yes Yes
VCHR_BLD_KEY_C2 VARCHAR(25) Yes Yes
VCHR_BLD_KEY_N1 decimal(10) Yes Yes
VCHR_BLD_KEY_N2 decimal(10) 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
SCHEDULED_PAY_DT datetime No No
PYMNT_ACTION VARCHAR(1) No No
PYMNT_ID_REF VARCHAR(20) No No
PYMNT_GROUP_CD VARCHAR(2) No No
EFT_LAYOUT_CD VARCHAR(10) No No
Index
Name Type Unique Member
PS_VCHR_PYMT_STG PK Yes
Member(s) of "PS_VCHR_PYMT_STG" Index
BUSINESS_UNIT
VCHR_BLD_KEY_C1
VCHR_BLD_KEY_C2
VCHR_BLD_KEY_N1
VCHR_BLD_KEY_N2
VOUCHER_ID
PYMNT_CNT

Published June 06, 2007