PeopleSoft 9
Account Payables

Table Name VCHRLN_MISC_EC

Table Description
VCHRLN_MISC_EC
Columns
Name Datatype Is PK Is FK
ECTRANSID VARCHAR(15) Yes Yes
ECQUEUEINSTANCE int Yes Yes
ECTRANSINOUTSW VARCHAR(1) Yes No
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes No
VOUCHER_LINE_NUM int Yes No
DST_ACCT_TYPE VARCHAR(4) Yes No
MISC_CHARGE_CODE VARCHAR(10) Yes No
COPY_PO_FLG VARCHAR(1) Yes No
QTY_VCHR decimal(15,4) No No
UNIT_PRICE decimal(15,5) No No
UNIT_PRICE_CNVT decimal(15,5) No No
CURRENCY_CD VARCHAR(3) No No
UNIT_OF_MEASURE VARCHAR(3) No No
UOM_VCHR VARCHAR(3) No No
BASIS_AMT decimal(25,2) No No
MISC_AMT_NP decimal(26,3) No No
MISC_AMT decimal(26,3) No No
PCT_ALLOC SMALLINT No No
PRORATE_FLG VARCHAR(1) No No
MISC_CHG_APPL_FLG VARCHAR(1) No No
LC_COMP_FLAG VARCHAR(1) No No
LC_COMP_ALLOC VARCHAR(3) No No
LC_EXTRCT_STATUS VARCHAR(1) No No
Index
Name Type Unique Member
PS_VCHRLN_MISC_EC PK Yes
Member(s) of "PS_VCHRLN_MISC_EC" Index
ECTRANSID
ECQUEUEINSTANCE
ECTRANSINOUTSW
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
DST_ACCT_TYPE
MISC_CHARGE_CODE
COPY_PO_FLG

Published June 06, 2007