OMBI_DS_DSUM_VW(SQL View) |
Index Back |
|---|---|
OM Bill Discount Sum VwThis view is used during the Populate Billing background process to sum the levels of discounts and surcharges on an order or order line. |
| SELECT business_unit , intfc_id , intfc_line_num , disc_sur_lvl , process_instance , SUM(amount) FROM PS_OMBI_DS_TMP WHERE disc_sur_indicator = 'D' GROUP BY business_unit, intfc_id, intfc_line_num, disc_sur_lvl, process_instance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 3 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 4 | DISC_SUR_LVL | Number(2,0) | SMALLINT NOT NULL | Discount/Surcharge Level |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | TOTAL_LVL_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Level Discount Total |