
--Be sure that your email is not being blocked
--Type 1  (Passed) 

SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%Transfer%'  --passed
--
SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%TransferDecline%'  

--Type 2


SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%MonthlyCountApplied%' 

SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%DailySalesReportBankingClose%'  


--Type 3 (passed)

SELECT	VendorID
,		*
FROM	tbAutoNotification
WHERE NoticeType like '%ElectronicSupplyOrderFailure%'  


--Type 4
SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%BankingCloseUnfinalizedDays%'

SELECT	*
FROM	tbAutoNotification
WHERE NoticeType like '%SupplyOrderNotification%'  


SELECT	top 10 *
FROM	tbAuditlog
WHERE AuditType='Auto Notification'
ORDER By 1 DESC



--Error since 2018:
-- .Error: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.
   --at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   --at System.Collections.Generic.List`1.Enumerator.MoveNe

   SELECT	Contact_Email
 ,			*
 FROM	tbEntity 

exec MXC_Administration_GetActiveLanguages


