[dbo].[e2e_wrm_wrmreporttranmnotrollv]
create view "e2e_wrm_wrmreporttranmnotrollv" AS
SELECT "e2e_wrm_wrmreport"."sourceid", "e2e_wrm_wrmreport"."transactionid", DATEPART([year], timestart) AS y, "e2e_wrm_wrmreport"."identifierid", "e2e_wrm_wrmreport"."typeid"
FROM "e2e_wrm_wrmreport"
WHERE (timefactor = 4) AND (issent = 0 OR issent IS NULL) AND (typeid = 3 OR typeid = 4)
GROUP BY sourceid, transactionid, DATEPART([year], timestart), identifierid, typeid
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmreporttranmnotrollv] TO [apmadmin]
GO
