VCH_VAL_ADJ_VW1

(SQL View)
 Index Back

Voucher PO Distrib Line


SELECT a.business_unit , a.po_id , c.line_nbr , d.sched_nbr , d.dst_acct_type , d.misc_charge_code , d.qty_po , d.unit_price_lc , d.unit_price_lc , d.currency_cd , d.unit_of_measure , d.unit_of_measure , %Round(%DecMult(d.qty_po , d.unit_price_lc), 3) , 0 , %Round(d.adj_amt , 3) , 0 , d.misc_prorate_flg , d.lc_comp_alloc , d.lc_comp_on_po , d.X_VENDOR_SETID , d.X_VENDOR_ID FROM PS_PO_HDR a , ps_po_line_fs b , ps_po_line_ship_fs c , ps_po_val_adj d WHERE a.business_unit = b.business_unit AND a.po_id = b.po_id AND ((a.po_status IN ('D','X','PX')) OR ((a.chng_ord_batch > 0) AND (a.po_status IN ('A','PA','O'))) OR ((a.po_status = 'C') AND (a.match_action = 'N'))) AND (a.ers_ACTION = 'N' OR a.ers_ACTION = ' ') AND a.match_status_po IN ('T','P','N') AND b.business_unit = c.business_unit AND b.po_id = c.po_id AND b.line_nbr = c.line_nbr AND c.business_unit = d.business_unit AND c.po_id = d.po_id AND c.line_nbr = d.line_nbr AND c.sched_nbr = d.sched_nbr AND c.match_status_ln_po IN ('N','P') AND c.cancel_status <> 'X' AND d.dst_acct_type <> ' ' AND d.misc_charge_code <> ' ' AND b.cancel_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 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
6 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
7 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
8 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
9 UNIT_PRICE_CNVT Number(16,5) DECIMAL(15,5) NOT NULL Unit Price Converted
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
13 BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
14 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
15 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
16 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
17 PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate
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_COMP_ON_PO Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier
20 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
21 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier