CREATE VIEW "IMCYC"."B1_JournalEntryVendorView" ( "TransId", "CardCodeMin", "CardCodeMax" ) AS SELECT T0."TransId" AS "TransId", MIN(T1."CardCode") AS "CardCodeMin", MAX(T1."CardCode") AS "CardCodeMax" FROM  "IMCYC"."JDT1" T0  INNER  JOIN "IMCYC"."OCRD" T1  ON  T0."ShortName" <> T0."Account"  AND  T1."CardCode" = T0."ShortName"  AND  T1."CardType" = 'S'   GROUP BY T0."TransId" WITH READ ONLY