CREATE VIEW "SBODEMODE"."VBIN" ( "AbsEntry", "BinCode", "WhsCode", "SysBin", "SL1Abs", "SL1Code", "SL2Abs", "SL2Code", "SL3Abs", "SL3Code", "SL4Abs", "SL4Code", "Attr1Abs", "Attr1Val", "Attr2Abs", "Attr2Val", "Attr3Abs", "Attr3Val", "Attr4Abs", "Attr4Val", "Attr5Abs", "Attr5Val", "Attr6Abs", "Attr6Val", "Attr7Abs", "Attr7Val", "Attr8Abs", "Attr8Val", "Attr9Abs", "Attr9Val", "Attr10Abs", "Attr10Val", "Disabled", "Descr", "BarCode", "AltSortCod", "ItmRtrictT", "SpcItmCode", "SpcItmGrpC", "SngBatch", "RtrictType", "RtrictResn", "RtrictDate", "DataSource", "UserSign", "Transfered", "Instance", "LogInstanc", "CreateDate", "UserSign2", "UpdateDate", "Deleted", "MinLevel", "MaxLevel", "ReceiveBin", "NoAutoAllc", "MaxWeight1", "Wght1Unit", "MaxWeight2", "Wght2Unit", "UoMRtrict", "SpcUoMCode", "SpcUGPCode", "SngUoMCode", "BinAbs", "ItemQty", "ItemsNum", "SnBNum", "ItemWeight" ) AS SELECT "T0"."AbsEntry" , "T0"."BinCode" , "T0"."WhsCode" , "T0"."SysBin" , "T0"."SL1Abs" , "T0"."SL1Code" , "T0"."SL2Abs" , "T0"."SL2Code" , "T0"."SL3Abs" , "T0"."SL3Code" , "T0"."SL4Abs" , "T0"."SL4Code" , "T0"."Attr1Abs" , "T0"."Attr1Val" , "T0"."Attr2Abs" , "T0"."Attr2Val" , "T0"."Attr3Abs" , "T0"."Attr3Val" , "T0"."Attr4Abs" , "T0"."Attr4Val" , "T0"."Attr5Abs" , "T0"."Attr5Val" , "T0"."Attr6Abs" , "T0"."Attr6Val" , "T0"."Attr7Abs" , "T0"."Attr7Val" , "T0"."Attr8Abs" , "T0"."Attr8Val" , "T0"."Attr9Abs" , "T0"."Attr9Val" , "T0"."Attr10Abs" , "T0"."Attr10Val" , "T0"."Disabled" , "T0"."Descr" , "T0"."BarCode" , "T0"."AltSortCod" , "T0"."ItmRtrictT" , "T0"."SpcItmCode" , "T0"."SpcItmGrpC" , "T0"."SngBatch" , "T0"."RtrictType" , "T0"."RtrictResn" , "T0"."RtrictDate" , "T0"."DataSource" , "T0"."UserSign" , "T0"."Transfered" , "T0"."Instance" , "T0"."LogInstanc" , "T0"."CreateDate" , "T0"."UserSign2" , "T0"."UpdateDate" , "T0"."Deleted" , "T0"."MinLevel" , "T0"."MaxLevel" , "T0"."ReceiveBin" , "T0"."NoAutoAllc" , "T0"."MaxWeight1" , "T0"."Wght1Unit" , "T0"."MaxWeight2" , "T0"."Wght2Unit" , "T0"."UoMRtrict" , "T0"."SpcUoMCode" , "T0"."SpcUGPCode" , "T0"."SngUoMCode" , "T1"."BinAbs" , "T1"."ItemQty" , "T1"."ItemsNum" , "T1"."SnBNum" , "T1"."ItemWeight" FROM "OBIN" T0 
		LEFT OUTER JOIN "VBIN_Qty" T1 ON T1."BinAbs" = T0."AbsEntry" WITH READ ONLY