CREATE VIEW "SBODEMODE"."B1_DocItemView" ( "DocItemType", "DocItemCode", "DocItemName", "DocItemAsInventory" ) AS ((SELECT 4 AS "DocItemType", T0."ItemCode" AS "DocItemCode", T0."ItemName" AS "DocItemName", T0."InvntItem" AS "DocItemAsInventory" FROM  "SBODEMODE"."OITM" T0) UNION ALL (SELECT 290 AS "DocItemType", T0."ResCode" AS "DocItemCode", T0."ResName" AS "DocItemName", 'N' AS "DocItemAsInventory" FROM  "SBODEMODE"."ORSC" T0)) WITH READ ONLY