PeopleSoft 9
Account Payables

Table Name VCHR_PYMT_EC

Table Description
VCHR_PYMT_EC
Columns
Name Datatype Is PK Is FK
ECTRANSID VARCHAR(15) Yes Yes
ECQUEUEINSTANCE int Yes Yes
BUSINESS_UNIT VARCHAR(5) Yes Yes
PYMNT_CNT int Yes No
ECTRANSINOUTSW VARCHAR(1) No No
VOUCHER_ID VARCHAR(8) No 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_GROUP_CD VARCHAR(2) No No
Index
Name Type Unique Member
PS_VCHR_PYMT_EC PK Yes
Member(s) of "PS_VCHR_PYMT_EC" Index
ECTRANSID
ECQUEUEINSTANCE
BUSINESS_UNIT
PYMNT_CNT

Published June 06, 2007