Outlet Master Data Processing Validation

Description

Validates location data processing, including errors and processing status.


Query :

select ClientId,convert(char,convert(datetime,CreatedOn at time zone 'UTC' at time zone 'Central Standard Time (Mexico)'),120)'CreatedOn',
	Username,ErrorMessage,ErrorCode,IsProcessed,/*Customer,*/LocationStatus,/*Street,*/
	/*SalesOrganization,SalesOffice,SalesGroup,SalesGroup,*//*BDTerritory,BDTerritoryName,*//*TradeChannel,TradeChannelName,SubChannel,SubChannelName,*/count(*)Counts 
	from locationmdhistory where clientid = 408 -- and IsProcessed = '1' 
	/*and customer IN (
	'600980592' 
	--)*/ /*and Username = 'Oscar_AdminVision'*/
	and CreatedOn >= '2025-10-21' --and CreatedOn <= '2024-10-30'-- and IsProcessed = 1 /*and customer = '600621865'--and ErrorMessage IS NOT NULL*/
	/*and CreatedOn >= '2024-10-21' */ --IsProcessed = 0
	--and locationstatus = 'Active'
	group by /*Customer,*/ClientId,convert(char,convert(datetime,CreatedOn at time zone 'UTC' at time zone 'Central Standard Time (Mexico)'),120),
	Username,ErrorMessage,IsProcessed,LocationStatus,ErrorCode--,SalesOrganization,SalesOffice,SalesGroup/*TradeChannel,TradeChannelName,SubChannel,SubChannelName*/--,BDTerritory,BDTerritoryName
	order by CreatedOn--locationmdhistory.IsProcessed--CreatedOn,SalesOrganization,SalesOffice,*/IsProcessed,LocationStatus--,TradeChannel,TradeChannelName,SubChannel,SubChannelName des