Additions:
customer_order
The customer_order view serves as a document header for the customer_orderline views, providing essential summarised information about customer orders.
USD
New Project views for North America (USD)
project_revenue_USDmyBMTproject_details_plus_USDmyBMTproject_roleassignment_USDmyBMTproject_details_USDmyBMTproject_cost_USDmyBMT
myBMT Link for data perusal
These are planned to be delivered as APPEND/UNION to get.myview
Alterations:
Order Pipeline
Further improvements to the ‘array version’ of Customer Pipeline
customer_orderlinecustomer_orderlinevaluecustomer_orderlinestatuscustomer_invoice- customer_invoicevalue
customer_invoicestatusbusopp_detailsbusopp_dates.sqlbusopp_valuebusopp_details_plus
North America Improvements
Improvements reflected from introduction of North America
Notes
sql/svw/customer/customer_order_details.sql found in DEV but not in PRD. Files sql/svw/customer/customer_orderlinevalue.sql (DEV) and sql/svw/customer/customer_orderlinevalue.sql (PRD) are different. Files sql/svw/customer/customer_invoicevalue.sql (DEV) and sql/svw/customer/customer_invoicevalue.sql (PRD) are different. Files sql/svw/customer/customer_invoice.sql (DEV) and sql/svw/customer/customer_invoice.sql (PRD) are different. Files sql/svw/customer/customer_orderlinestatus.sql (DEV) and sql/svw/customer/customer_orderlinestatus.sql (PRD) are different. Files sql/svw/customer/customer_orderline.sql (DEV) and sql/svw/customer/customer_orderline.sql (PRD) are different. Files sql/svw/customer/customer_invoicestatus.sql (DEV) and sql/svw/customer/customer_invoicestatus.sql (PRD) are different. Files sql/svw/busopp/busopp_dates.sql (DEV) and sql/svw/busopp/busopp_dates.sql (PRD) are different. Files sql/svw/busopp/busopp_value.sql (DEV) and sql/svw/busopp/busopp_value.sql (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. File sql/svw/project/project_roleassignment._202410.sql found in DEV but not in PRD. File sql/svw/project/project_revenue_USD.sql found in DEV but not in PRD. File sql/svw/project/project_details_plus_USD.sql found in DEV but not in PRD. File sql/svw/project/project_roleassignment_USD.sql found in DEV but not in PRD. File sql/svw/project/project_details_USD.sql found in DEV but not in PRD. File sql/svw/project/project_cost_USD.sql found in DEV but not in PRD. Files sql/svw/project/project_cost_CAD.sql (DEV) and sql/svw/project/project_cost_CAD.sql (PRD) are different. Files sql/svw/project/project_revenue.sql (DEV) and sql/svw/project/project_revenue.sql (PRD) are different.