CREATE VIEW "SBODEMODE"."B1_ElectronicCRWView" ( "AbsEntry", "Code", "ActType", "ActStatus", "ActDesc", "ActMessage", "ActEnv", "Branch", "SrcObjType", "SrcObjAbs", "Submits", "SendDate", "RecvDate", "UserSign", "CreateDate", "CreateTS", "UserSign2", "UpdateDate", "IsRemoved", "Cancelation", "SendData", "RecvData", "ReportID", "AssignedID", "CardCode", "CardName", "Year", "SentMeth", "SentValue", "LastAMeth", "LastAValue" ) AS SELECT T0."AbsEntry", T0."Code", T0."ActType", T0."ActStatus", T0."ActDesc", T0."ActMessage", T0."ActEnv", T0."BPLId" AS "Branch", T0."SrcObjType", T0."SrcObjAbs", T0."Submits", T3."LogOpDate" AS "SendDate", T4."LogOpDate" AS "RecvDate", T0."UserSign", T0."CreateDate", T0."CreateTS", T0."UserSign2", T0."UpdateDate", T0."IsRemoved", T0."Cancel" AS "Cancelation", T3."LogData" AS "SendData", T4."LogData" AS "RecvData", T0."ReportID", T0."AssignedID", T1."CardCode", T2."CardName", T1."Year", T1."SentMeth", T1."SentValue", T1."LastAMeth", T1."LastAValue" FROM  "SBODEMODE"."ECM2" T0   LEFT OUTER  JOIN "SBODEMODE"."OCRW" T1  ON  T0."SrcObjType" = '254000013'  AND  T1."AbsEntry" = T0."SrcObjAbs"   INNER  JOIN "SBODEMODE"."OCRD" T2  ON  T2."CardCode" = T1."CardCode"    LEFT OUTER  JOIN "SBODEMODE"."B1_EDFLatestLogsView" T3  ON  T3."AbsEntry" = T0."AbsEntry"  AND  T3."LogType" = 'S'    LEFT OUTER  JOIN "SBODEMODE"."B1_EDFLatestLogsView" T4  ON  T4."AbsEntry" = T0."AbsEntry"  AND  T4."LogType" = 'R' WITH READ ONLY