VCHR_CORR_WS3

(SQL Table)
Index Back

Voucher Line Misc Charge

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
2 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
3 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
4 COPY_PO_FLG Character(1) VARCHAR2(1) NOT NULL Copy PO Flg

Default Value: N

5 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
6 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
7 UNIT_PRICE_CNVT Number(16,5) DECIMAL(15,5) NOT NULL Unit Price Converted
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
11 BASIS_AMT Signed Number(27,2) DECIMAL(25,2) NOT NULL Withholding Basis Amount
12 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
13 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
14 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
15 PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate

Y/N Table Edit

16 MISC_CHG_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Miscellaneous Charges

Y/N Table Edit

Default Value: Y

17 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
18 LC_COMP_ALLOC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
19 LC_EXTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Landed Cost Extract Status

Default Value: N