SCN_TOT_VW

(SQL View)
 Index Back

Contract + total qty/price


SELECT c.setid , l.cntrct_id , l.cntrct_line_nbr , SUM(l.qty_ordered) , SUM(l.extended_list_prc) , %Round(SUM(l.extended_net_price) + SUM(%DecMult(l.extended_net_price, (%DecMult(o.addtl_adjust_pct, .01)))) + o.addtl_adjust_amt ,4) , SUM(l.ext_list_prc_base) , %Round(SUM(l.ext_net_prc_base) + SUM(%DecMult(l.ext_net_prc_base, (%DecMult(o.addtl_adjust_pct, .01)))) + o.addtl_adjust_base ,4) FROM PS_SCON_LINE c , ps_ord_header o , ps_ord_tot_ln_vw l , ps_set_cntrl_rec s WHERE o.business_unit = l.business_unit AND o.order_no = l.order_no AND c.cntrct_id = l.cntrct_id AND c.line_nbr = l.cntrct_line_nbr AND c.product_id = l.product_id AND s.setcntrlvalue = l.business_unit AND s.recname = 'CUSTOMER' GROUP BY c.setid, l.cntrct_id, l.cntrct_line_nbr, o.addtl_adjust_pct, o.addtl_adjust_amt, o.addtl_adjust_base

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 ORDER_TOTAL_QTY Number(20,4) DECIMAL(19,4) NOT NULL Total Order Qty
5 EXTENDED_LIST_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext List Price
6 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
7 EXT_LIST_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended List Price (base)
8 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)