Release 28

by

Alterations

Busopp.Details_Plus (&202407)

Remove CONVERT(NVARCHAR(32),HashBytes(‘MD5’, CONCAT_WS(‘|’,src.COMPANY,src.OPPORTUNITY_NO)),2) as busopp_item_id, as this is now generated in get.myView

Created dvw.customer_item_202406 as part of removing Company reference from customer (& Supplier)

Customer.Details

Removed reference to COMPANY (and the associated check of customer.invoice)

Customer (and Supplier) COMPANY defaults to 9900

Check for Alterations to

Customer.Invoice
Cutomer.Orderline
Project.CustomerInvoice
Project.CustomerOrderline
Project.ActivityDetails

get.myView

COMPANY now included as variable, with 9900, in the creation of the item_id
Note Item_id is now CONCAT_WS and not HASHBYTES

	DECLARE @myCompany varchar(64)
	
	SELECT @myCompany = CASE 
		WHEN @myValue IN ('Supplier','Customer') THEN '9900'
	ELSE 'src.COMPANY' END
...
	SET @myClause = 'LEFT JOIN dvw.'+ @myValue + '_' + @martVersion + ' as '+ @myValue + '_item on
    CONCAT_WS(''|'','+ @myCompany + ',src.'+ @myParameter + ') = '+ @myValue + '_item.'+ @myValue + '_item

Additions

Resource.Capacity (202407)

For the calculation of Resource Utilisation (Resource.Capacity)

Supplier.Details (&202407)

Initial View (Supplier.Details) (set as 202407 to allow for additional in month acceptance testing)

Notes

[‘Files 20240805/svw_dev_flat\\busopp_details_plus.sql and 20240805/svw_prd_flat\\busopp_details_plus.sql are different.’,
‘Files 20240805/svw_dev_flat\\busopp_details_plus_202407.sql and 20240805/svw_prd_flat\\busopp_details_plus_202407.sql are different.’,
‘Files 20240805/svw_dev_flat\\busopp_details_short.sql and 20240805/svw_prd_flat\\busopp_details_short.sql are different.’,
‘Files 20240805/svw_dev_flat\\customer_details.sql and 20240805/svw_prd_flat\\customer_details.sql are different.’,
‘Files 20240805/svw_dev_flat\\customer_details_short.sql and 20240805/svw_prd_flat\\customer_details_short.sql are different.’,
‘File resource_capacity_202407.sql found in 20240805/svw_dev_flat but not in 20240805/svw_prd_flat.’,
‘File supplier_details.sql found in 20240805/svw_dev_flat but not in 20240805/svw_prd_flat.’,
‘File supplier_details_202407.sql found in 20240805/svw_dev_flat but not in 20240805/svw_prd_flat.’]

Leave a Comment