Release 36 & 37: interim releases contained editorial changes to support identification of table resources for IFS efficiency optimisation
Additions
New views to support the implementation of Power BI – Live Order Intake and Pipeline Review – Power BI
Alterations
Customer.Invoice
Change Source: QFACT_BMT_DWH_INVOICE_TAB_IAS$
ADD Pipeline reference for ORDER_NO
Remove Dates and Values to Customer.InvoiceValue (Headline Values and Dates remain)
Calculate GROSS_CURR_AMOUNT
Customer.Orderline
ADD Pipeline reference for OPPORTUNITY_NO (& WORKING_AT _RISK flag)
Remove Dates and Values to Customer.OrderlineValue (Headline Values and Dates remain)
Calculate REVENUE
Add Market Codes
Busopp.Details
Remove old Hash_Item references
Include [CF$_PRU_VALUE] as PRU
ADD basic status and dates
Busopp.Details_Plus
Include [CF$_PRU_VALUE] as PRU
Remove Dates and Values to Busopp.Value (Headline Values and Dates remain)
Calculation of BaseOppValue
Add Market Codes
Notes
File sql/svw/customer/customer_invoicestatus_202409.sql found in DEV but not in PRD.
File sql/svw/customer/archive found in DEV but not in PRD.
File sql/svw/customer/customer_orderlinestatus_202409.sql found in DEV but not in PRD.
File sql/svw/customer/customer_invoicestatus.sql found in DEV but not in PRD.
File sql/svw/customer/customer_orderlinestatus.sql found in DEV but not in PRD.
Files sql/svw/customer/customer_invoice.sql (DEV) and sql/svw/customer/customer_invoice.sql (PRD) are different.
Files sql/svw/customer/customer_orderline.sql (DEV) and sql/svw/customer/customer_orderline.sql (PRD) are different.
File sql/svw/customer/202409/customer_orderlinevalue_202409.sql found in DEV but not in PRD.
File sql/svw/customer/202409/customer_invoicestatus_202409.sql found in DEV but not in PRD.
File sql/svw/customer/202409/customer_invoicevalue_202409.sql found in DEV but not in PRD.
File sql/svw/customer/202409/customer_orderlinestatus_202409.sql found in DEV but not in PRD.
Files sql/svw/customer/202409/customer_orderline_202409.sql (DEV) and sql/svw/customer/202409/customer_orderline_202409.sql (PRD) are different.
Files sql/svw/busopp/busopp (DEV) and sql/svw/busopp/busopp (PRD) are different.
Files sql/svw/busopp/busopp_details_plus.sql (DEV) and sql/svw/busopp/busopp_details_plus.sql (PRD) are different.
Files sql/svw/busopp/busopp_details.sql (DEV) and sql/svw/busopp/busopp_details.sql (PRD) are different.
Files sql/svw/busopp/202409/busopp_details_plus_202409.sql (DEV) and sql/svw/busopp/202409/busopp_details_plus_202409.sql (PRD) are different.
Files sql/svw/busopp/202409/busopp_details_202409.sql (DEV) and sql/svw/busopp/202409/busopp_details_202409.sql (PRD) are different.
Files sql/svw/busopp/202409/busopp_value_202409.sql (DEV) and sql/svw/busopp/202409/busopp_value_202409.sql (PRD) are different.