ORD_TOTHDTX_VW

(SQL View)
Index Back

Order Header Total tax


SELECT b.business_unit , b.order_no , SUM(b.qty_ordered) , SUM(c.qty_scheduled) , %Round(SUM(%DecDiv(c.tax_amt, c.qty_scheduled)), 3) , %Round(SUM(%DecDiv(c.tax_amt_bse, c.qty_scheduled)), 3) , SUM(c.tax_amt) , SUM(c.tax_amt_bse) , SUM(c.vat_amt) , SUM(c.vat_amt_base) , SUM(c.vat_basis_amt) , SUM(c.vat_basis_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' AND c.qty_scheduled <> 0 GROUP BY b.business_unit, b.order_no

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

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 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
4 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
5 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
6 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
7 EXTENDED_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended Tax Amount
8 EXT_TAX_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended Tax Amt (base)
9 EXT_VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended VAT Amount
10 EXT_VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended VAT Amount (base)
11 EXT_VAT_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended VAT Basis Amount
12 EXT_VAT_BASIS_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Extended VAT Basis Amt (Base)