VCHR_LMCRRCT_VW

(SQL View)
 Index Back

Voucher Line Misc Chrg View


SELECT BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , DST_ACCT_TYPE , MISC_CHARGE_CODE , COPY_PO_FLG , UNIT_PRICE , BASIS_AMT , MISC_AMT , PCT_ALLOC , MISC_CHG_APPL_FLG , LC_COMP_FLAG , LC_COMP_ALLOC , LC_EXTRCT_STATUS , PRORATE_FLG FROM PS_VCHRLN_MISC_CHG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 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
5 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
6 COPY_PO_FLG Character(1) VARCHAR2(1) NOT NULL Copy PO Flg

Y/N Table Edit

Default Value: N

7 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
8 BASIS_AMT Signed Number(27,2) DECIMAL(25,2) NOT NULL Withholding Basis Amount
9 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
10 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage

Default Value: 0

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

Y/N Table Edit

Default Value: Y

12 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
13 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
14 LC_EXTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Landed Cost Extract Status

Default Value: N

15 PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate

Y/N Table Edit