CREATE COLUMN VIEW "IMCYC"."ES_IP" WITH PARAMETERS (indexType=6,
joinIndex="IMCYC"."ORCT",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."RCT2",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."RCT4",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OCPR",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OJDT",joinIndexType=0,joinIndexEstimation=0,
joinCondition=('join1_0',"IMCYC"."ORCT", "DocEntry","IMCYC"."RCT2", "DocNum",'',145,0),
joinCondition=('join2_0',"IMCYC"."ORCT", "DocEntry","IMCYC"."RCT4", "DocNum",'',145,1),
joinCondition=('join3_0',"IMCYC"."ORCT", "CntctCode","IMCYC"."OCPR", "CntctCode",'',65809,2),
joinCondition=('join4_0',"IMCYC"."ORCT", "TransId","IMCYC"."OJDT", "TransId",'',65809,3),
joinPath=('JoinPath1','join1_0'),
joinPath=('JoinPath2','join2_0'),
joinPath=('JoinPath3','join3_0'),
joinPath=('JoinPath4','join4_0'),
viewAttribute=('RCT2_DocNum',"IMCYC"."RCT2", "DocNum",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_InvoiceId',"IMCYC"."RCT2", "InvoiceId",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_DocEntry',"IMCYC"."RCT2", "DocEntry",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_InvType',"IMCYC"."RCT2", "InvType",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_SumApplied',"IMCYC"."RCT2", "SumApplied",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_Dcount',"IMCYC"."RCT2", "Dcount",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_DcntSum',"IMCYC"."RCT2", "DcntSum",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT2_WtAppld',"IMCYC"."RCT2", "WtAppld",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('RCT4_DocNum',"IMCYC"."RCT4", "DocNum",'JoinPath2','V_ES_IP','attribute'),
viewAttribute=('RCT4_LineId',"IMCYC"."RCT4", "LineId",'JoinPath2','V_ES_IP','attribute'),
viewAttribute=('RCT4_AcctCode',"IMCYC"."RCT4", "AcctCode",'JoinPath2','V_ES_IP','attribute'),
viewAttribute=('RCT4_SumApplied',"IMCYC"."RCT4", "SumApplied",'JoinPath2','V_ES_IP','attribute'),
viewAttribute=('RCT4_Project',"IMCYC"."RCT4", "Project",'JoinPath2','V_ES_IP','attribute'),
viewAttribute=('OCPR_CntctCode',"IMCYC"."OCPR", "CntctCode",'JoinPath3','V_ES_IP','attribute'),
viewAttribute=('OCPR_Name',"IMCYC"."OCPR", "Name",'JoinPath3','V_ES_IP','attribute'),
viewAttribute=('OJDT_TransId',"IMCYC"."OJDT", "TransId",'JoinPath4','V_ES_IP','attribute'),
viewAttribute=('OJDT_Project',"IMCYC"."OJDT", "Project",'JoinPath4','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocEntry',"IMCYC"."ORCT", "DocEntry",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocNum',"IMCYC"."ORCT", "DocNum",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_CardCode',"IMCYC"."ORCT", "CardCode",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_CardName',"IMCYC"."ORCT", "CardName",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_CounterRef',"IMCYC"."ORCT", "CounterRef",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_TransId',"IMCYC"."ORCT", "TransId",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_PrjCode',"IMCYC"."ORCT", "PrjCode",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocDate',"IMCYC"."ORCT", "DocDate",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocDueDate',"IMCYC"."ORCT", "DocDueDate",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_TaxDate',"IMCYC"."ORCT", "TaxDate",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_Comments',"IMCYC"."ORCT", "Comments",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocType',"IMCYC"."ORCT", "DocType",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_Series',"IMCYC"."ORCT", "Series",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocTotal',"IMCYC"."ORCT", "DocTotal",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_Canceled',"IMCYC"."ORCT", "Canceled",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_PayNoDoc',"IMCYC"."ORCT", "PayNoDoc",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_NoDocSum',"IMCYC"."ORCT", "NoDocSum",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocCurr',"IMCYC"."ORCT", "DocCurr",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_DocTotalFC',"IMCYC"."ORCT", "DocTotalFC",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_WtSum',"IMCYC"."ORCT", "WtSum",'JoinPath1','V_ES_IP','attribute'),
viewAttribute=('ORCT_CntctCode',"IMCYC"."ORCT", "CntctCode",'JoinPath1','V_ES_IP','attribute'),
freeStyleSearchAttribute='RCT2_DocEntry:1:0',
freeStyleSearchAttribute='RCT2_InvType:1:0',
freeStyleSearchAttribute='RCT2_SumApplied:1:0',
freeStyleSearchAttribute='RCT2_Dcount:1:0',
freeStyleSearchAttribute='RCT2_DcntSum:1:0',
freeStyleSearchAttribute='RCT2_WtAppld:1:0',
freeStyleSearchAttribute='RCT4_AcctCode:1:0',
freeStyleSearchAttribute='RCT4_SumApplied:1:0',
freeStyleSearchAttribute='RCT4_Project:1:0',
freeStyleSearchAttribute='OCPR_Name:1:0',
freeStyleSearchAttribute='OJDT_TransId:1:0',
freeStyleSearchAttribute='OJDT_Project:1:0',
freeStyleSearchAttribute='ORCT_DocNum:1:0',
freeStyleSearchAttribute='ORCT_CardCode:1:0',
freeStyleSearchAttribute='ORCT_CardName:1:0',
freeStyleSearchAttribute='ORCT_CounterRef:1:0',
freeStyleSearchAttribute='ORCT_PrjCode:1:0',
freeStyleSearchAttribute='ORCT_DocDate:1:0',
freeStyleSearchAttribute='ORCT_DocDueDate:1:0',
freeStyleSearchAttribute='ORCT_TaxDate:1:0',
freeStyleSearchAttribute='ORCT_Comments:1:0',
freeStyleSearchAttribute='ORCT_DocType:1:0',
freeStyleSearchAttribute='ORCT_Series:1:0',
freeStyleSearchAttribute='ORCT_DocTotal:1:0',
freeStyleSearchAttribute='ORCT_Canceled:1:0',
freeStyleSearchAttribute='ORCT_PayNoDoc:1:0',
freeStyleSearchAttribute='ORCT_NoDocSum:1:0',
freeStyleSearchAttribute='ORCT_DocCurr:1:0',
freeStyleSearchAttribute='ORCT_DocTotalFC:1:0',
freeStyleSearchAttribute='ORCT_WtSum:1:0',
view=('V_ES_IP',"IMCYC"."ORCT"),defaultView='V_ES_IP',OPTIMIZEMETAMODEL=0)