CREATE VIEW "SBODEMODE"."B1_DocBranchView" ( "CardCode", "ObjType", "DocEntry", "BPLId" ) AS (((((((((((((((((((((((((((((SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OQUT" T0) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORDR" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ODLN" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORDN" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OINV" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORIN" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ODPI" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OCSI" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OCSV" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORRR" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPQT" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPRQ" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPDN" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORPD" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPCH" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ORPC" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ODPO" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OCPI" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OCPV" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPRR" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OWTR" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OWTQ" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OIGE" T0)) UNION (SELECT T0."CardCode", T0."ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OIGN" T0)) UNION (SELECT T0."CardCode", '203002' AS "ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ODPI" T0  WHERE T0."Posted" = ('N' ))) UNION (SELECT T0."CardCode", '204002' AS "ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."ODPO" T0  WHERE T0."Posted" = ('N' ))) UNION (SELECT T0."CardCode", '13002' AS "ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OINV" T0  WHERE T0."isIns" = ('Y' ))) UNION (SELECT T0."CardCode", '18002' AS "ObjType", T0."DocEntry", T0."BPLId" FROM  "SBODEMODE"."OPCH" T0  WHERE T0."isIns" = ('Y' ))) UNION (SELECT T0."ShortName", T0."TransType", T0."TransId", T0."BPLId" FROM  "SBODEMODE"."JDT1" T0  WHERE T0."TransType" = ('30' ))) WITH READ ONLY