ORD_TOT_LN_VW

(SQL View)
 Index Back

Order Line Total qty/price


SELECT b.business_unit , b.order_no , b.order_int_line_no , b.product_id , b.unit_of_measure , b.cntrct_id , b.cntrct_line_nbr , b.qty_ordered , SUM(c.qty_scheduled) , %Round(SUM(%DecMult(c.qty_scheduled, c.list_price)), 4) , %Round(SUM(%DecMult(c.qty_scheduled, c.net_unit_price)), 4) , %Round(SUM(%DecMult(c.qty_scheduled, c.list_price_base)), 4) , %Round(SUM(%DecMult(c.qty_scheduled, c.net_unit_price_bse)), 4) , SUM(c.vat_amt) , SUM(c.vat_amt_base) , SUM(c.vat_amt_rvc) , SUM(c.vat_amt_rvc_bse) , SUM(c.tax_amt) , SUM(c.tax_amt_bse) FROM PS_ORD_SCHEDULE c , ps_ord_line b WHERE b.business_unit = c.business_unit AND b.order_no = c.order_no AND b.order_int_line_no = c.order_int_line_no AND b.ord_line_status <> 'X' AND c.ord_sch_status <> 'X' GROUP BY b.business_unit, b.order_no, b.order_int_line_no, b.product_id, b.unit_of_measure, b.cntrct_id, b.cntrct_line_nbr, b.qty_ordered, b.list_price_base, b.list_price, b.price_base, b.price

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
6 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
7 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
8 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
9 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
10 EXTENDED_LIST_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext List Price
11 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
12 EXT_LIST_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended List Price (base)
13 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)
14 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
15 VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
16 VAT_AMT_RVC Signed Number(28,3) DECIMAL(26,3) NOT NULL Reverse Charge VAT Amount
17 VAT_AMT_RVC_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Reverse Charge Amount in Base Currency
18 EXTENDED_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended Tax Amount
19 EXT_TAX_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended Tax Amt (base)