OMBI_DS_SSUM_VW

(SQL View)
Index Back

OM Bill Surcharge Sum Vw

OMBILL uses this view to sum the surcharges for a particular order schedule.

SELECT business_unit , intfc_id , intfc_line_num , disc_sur_lvl , process_instance , SUM(amount) FROM PS_OMBI_DS_TMP WHERE disc_sur_indicator = 'S' 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_SUR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Surcharge Total