Release 47

Alterations

Busopp.Details_Plus (beta)

Complete the CTE (modular array) to include Dates and Measures/Values

Busopp.Value

Full version of CTE (modular array)

Busopp.Dates

Add New SEQ (Link sequence style)

Customer.Orderline_202409

Include Project ID from QFACT_PRE_ACCOUNTING_OL$ as coalesce(cfv.CF$_PROJECT_ID,precfv.CODENO_D,src.DIM_PROJECT_ID) as PROJECT_ID,

Notes

1. ⚠️ DIFFERENT:
   • busopp_dates.sql
   • busopp_details_plus.sql
   • busopp_value.sql
2. ⚠️ DIFFERENT: customer_orderline_202409.sql
3. 🔴 MISSING IN PRD CONTAINER: dates_DIM_DATE.sql
4. 🔴 MISSING IN PRD CONTAINER: dates_mydate.sql

Total number of different files: 2
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 2