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) |