BUSINESS_UNITORDER_NOORD_TOT_EXS_DVW(SQL View) |
Index Back |
|---|---|
Order Total ExciseTaxDate Initials Issue Description 052302 dms EIND802 New dynamic view for total excise tax |
| SELECT o.business_unit , o.order_no , SUM(d.exs_tax_amt) , SUM(d.exs_tax_amt_bse) , SUM(d.exs_tax_amt_rpt) FROM ps_ord_header o , ps_ord_exs_tax_dtl d , ps_ord_line l , PS_ORD_SCHEDULE s WHERE o.business_unit = d.business_unit AND o.order_no = d.order_no AND d.exs_tax_type = 'E' AND l.business_unit = d.business_unit AND l.order_no = d.order_no AND l.order_int_line_no = d.order_int_line_no AND l.ord_line_status <> 'X' AND s.business_unit = d.business_unit AND s.order_no = d.order_no AND s.order_int_line_no = d.order_int_line_no AND s.sched_line_nbr = d.sched_line_nbr AND s.ord_sch_status <> 'X' GROUP BY o.business_unit, o.order_no |
| # | 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 | EXS_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount |
| 4 | EXS_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount Base Currency |
| 5 | EXS_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Sales Tax Amount Reporting Currency |