BUSINESS_UNITORDER_NOORDENT_PPRC_CLC(SQL View) |
Index Back |
|---|---|
Sales order entry pricing viewUsed to calculate sales order prices. |
| SELECT s.business_unit , s.order_no , os.eoep_rule_id , SUM(s.qty_scheduled) , %Round(SUM(%DecMult(s.list_price, s.qty_scheduled)), 4) FROM ps_set_cntrl_rec sc , ps_eoep_rule ps , ps_ord_pprc_set os , PS_ORD_SCHEDULE s WHERE os.business_unit = s.business_unit AND os.order_no = s.order_no AND os.order_int_line_no = s.order_int_line_no AND os.sched_line_nbr = s.sched_line_nbr AND sc.recname = 'EOEP_RULE' AND sc.setcntrlvalue = s.business_unit AND ps.setid = sc.setid AND os.eoep_rule_id = ps.eoep_rule_id AND ps.eoep_ptd_flg = 'N' GROUP BY s.business_unit, s.order_no, os.eoep_rule_id |
| # | 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 | EOEP_RULE_ID | Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 4 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 5 | TOT_LIST | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total List Price |