PeopleSoft 9
Account Payables

Table Name VCHRLN_MISC_CHG

Table Description
VCHRLN_MISC_CHG
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
DST_ACCT_TYPE VARCHAR(4) Yes Yes
MISC_CHARGE_CODE VARCHAR(10) Yes Yes
COPY_PO_FLG VARCHAR(1) No 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_CHG PK Yes
Member(s) of "PS_VCHRLN_MISC_CHG" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
DST_ACCT_TYPE
MISC_CHARGE_CODE

Published June 06, 2007