CREATE COLUMN VIEW "IMCYC"."ES_FIXEDASSETS" WITH PARAMETERS (indexType=6,
joinIndex="IMCYC"."OITM",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."ITM7",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."ITM5",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."ITM6",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OACS",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OAGS",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OADG",joinIndexType=0,joinIndexEstimation=0,
joinCondition=('join1_0',"IMCYC"."OITM", "ItemCode","IMCYC"."ITM7", "ItemCode",'',145,0),
joinCondition=('join2_0',"IMCYC"."OITM", "ItemCode","IMCYC"."ITM5", "ItemCode",'',145,1),
joinCondition=('join3_0',"IMCYC"."OITM", "ItemCode","IMCYC"."ITM6", "ItemCode",'',145,2),
joinCondition=('join4_0',"IMCYC"."OITM", "AssetClass","IMCYC"."OACS", "Code",'',65809,3),
joinCondition=('join5_0',"IMCYC"."OITM", "AssetGroup","IMCYC"."OAGS", "Code",'',65809,4),
joinCondition=('join6_0',"IMCYC"."OITM", "DeprGroup","IMCYC"."OADG", "Code",'',65809,5),
joinPath=('JoinPath1','join1_0'),
joinPath=('JoinPath2','join2_0'),
joinPath=('JoinPath3','join3_0'),
joinPath=('JoinPath4','join4_0'),
joinPath=('JoinPath5','join5_0'),
joinPath=('JoinPath6','join6_0'),
viewAttribute=('ITM7_ItemCode',"IMCYC"."ITM7", "ItemCode",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM7_UsefulLife',"IMCYC"."ITM7", "UsefulLife",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM7_RemainLife',"IMCYC"."ITM7", "RemainLife",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM5_ItemCode',"IMCYC"."ITM5", "ItemCode",'JoinPath2','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM5_Project',"IMCYC"."ITM5", "Project",'JoinPath2','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM6_ItemCode',"IMCYC"."ITM6", "ItemCode",'JoinPath3','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM6_OcrCode',"IMCYC"."ITM6", "OcrCode",'JoinPath3','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM6_ValidFrom',"IMCYC"."ITM6", "ValidFrom",'JoinPath3','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('ITM6_ValidTo',"IMCYC"."ITM6", "ValidTo",'JoinPath3','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OACS_Code',"IMCYC"."OACS", "Code",'JoinPath4','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OACS_Name',"IMCYC"."OACS", "Name",'JoinPath4','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OAGS_Code',"IMCYC"."OAGS", "Code",'JoinPath5','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OAGS_Descr',"IMCYC"."OAGS", "Descr",'JoinPath5','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OADG_Code',"IMCYC"."OADG", "Code",'JoinPath6','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OADG_Descr',"IMCYC"."OADG", "Descr",'JoinPath6','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_ItemCode',"IMCYC"."OITM", "ItemCode",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_ItemName',"IMCYC"."OITM", "ItemName",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_ItemType',"IMCYC"."OITM", "ItemType",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_FrgnName',"IMCYC"."OITM", "FrgnName",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_AsstStatus',"IMCYC"."OITM", "AsstStatus",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_AssetClass',"IMCYC"."OITM", "AssetClass",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_AssetGroup',"IMCYC"."OITM", "AssetGroup",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_DeprGroup',"IMCYC"."OITM", "DeprGroup",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_InventryNo',"IMCYC"."OITM", "InventryNo",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_AssetSerNo',"IMCYC"."OITM", "AssetSerNo",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_Location',"IMCYC"."OITM", "Location",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
viewAttribute=('OITM_CapDate',"IMCYC"."OITM", "CapDate",'JoinPath1','V_ES_FIXEDASSETS','attribute'),
freeStyleSearchAttribute='ITM7_UsefulLife:1:0',
freeStyleSearchAttribute='ITM7_RemainLife:1:0',
freeStyleSearchAttribute='ITM5_Project:1:0',
freeStyleSearchAttribute='ITM6_OcrCode:1:0',
freeStyleSearchAttribute='ITM6_ValidFrom:1:0',
freeStyleSearchAttribute='ITM6_ValidTo:1:0',
freeStyleSearchAttribute='OACS_Name:1:0',
freeStyleSearchAttribute='OAGS_Descr:1:0',
freeStyleSearchAttribute='OADG_Descr:1:0',
freeStyleSearchAttribute='OITM_ItemCode:1:0',
freeStyleSearchAttribute='OITM_ItemName:1:0',
freeStyleSearchAttribute='OITM_FrgnName:1:0',
freeStyleSearchAttribute='OITM_AsstStatus:1:0',
freeStyleSearchAttribute='OITM_InventryNo:1:0',
freeStyleSearchAttribute='OITM_AssetSerNo:1:0',
freeStyleSearchAttribute='OITM_Location:1:0',
freeStyleSearchAttribute='OITM_CapDate:1:0',
view=('V_ES_FIXEDASSETS',"IMCYC"."OITM"),defaultView='V_ES_FIXEDASSETS',OPTIMIZEMETAMODEL=0)