CREATE COLUMN VIEW "IMCYC"."ES_GOODSRECEIPTPO" WITH PARAMETERS (indexType=6,
joinIndex="IMCYC"."OPDN",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OCPR",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OSLP",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OHEM",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."PDN1",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OCRD",joinIndexType=0,joinIndexEstimation=0,
joinCondition=('join1_0',"IMCYC"."OPDN", "CntctCode","IMCYC"."OCPR", "CntctCode",'',65809,0),
joinCondition=('join2_0',"IMCYC"."OPDN", "SlpCode","IMCYC"."OSLP", "SlpCode",'',65809,1),
joinCondition=('join3_0',"IMCYC"."OPDN", "OwnerCode","IMCYC"."OHEM", "empID",'',65809,2),
joinCondition=('join5_0',"IMCYC"."OPDN", "DocEntry","IMCYC"."PDN1", "DocEntry",'',145,3),
joinCondition=('join6_0',"IMCYC"."OPDN", "CardCode","IMCYC"."OCRD", "CardCode",'',65809,4),
joinPath=('JoinPath1','join1_0'),
joinPath=('JoinPath2','join2_0'),
joinPath=('JoinPath3','join3_0'),
joinPath=('JoinPath4','join5_0'),
joinPath=('JoinPath5','join6_0'),
viewAttribute=('OCPR_CntctCode',"IMCYC"."OCPR", "CntctCode",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OCPR_Name',"IMCYC"."OCPR", "Name",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OSLP_SlpCode',"IMCYC"."OSLP", "SlpCode",'JoinPath2','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OSLP_SlpName',"IMCYC"."OSLP", "SlpName",'JoinPath2','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OHEM_empID',"IMCYC"."OHEM", "empID",'JoinPath3','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OHEM_firstName',"IMCYC"."OHEM", "firstName",'JoinPath3','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OHEM_lastName',"IMCYC"."OHEM", "lastName",'JoinPath3','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OHEM_middleName',"IMCYC"."OHEM", "middleName",'JoinPath3','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_DocEntry',"IMCYC"."PDN1", "DocEntry",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_LineNum',"IMCYC"."PDN1", "LineNum",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_ItemCode',"IMCYC"."PDN1", "ItemCode",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_Dscription',"IMCYC"."PDN1", "Dscription",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_Quantity',"IMCYC"."PDN1", "Quantity",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_Price',"IMCYC"."PDN1", "Price",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_DiscPrcnt',"IMCYC"."PDN1", "DiscPrcnt",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_LineTotal',"IMCYC"."PDN1", "LineTotal",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_OwnerCode',"IMCYC"."PDN1", "OwnerCode",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('PDN1_Project',"IMCYC"."PDN1", "Project",'JoinPath4','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OCRD_CardCode',"IMCYC"."OCRD", "CardCode",'JoinPath5','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OCRD_OwnerCode',"IMCYC"."OCRD", "OwnerCode",'JoinPath5','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocEntry',"IMCYC"."OPDN", "DocEntry",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_CardCode',"IMCYC"."OPDN", "CardCode",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_CardName',"IMCYC"."OPDN", "CardName",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_CntctCode',"IMCYC"."OPDN", "CntctCode",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_Series',"IMCYC"."OPDN", "Series",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocNum',"IMCYC"."OPDN", "DocNum",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocStatus',"IMCYC"."OPDN", "DocStatus",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocDate',"IMCYC"."OPDN", "DocDate",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocDueDate',"IMCYC"."OPDN", "DocDueDate",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_TaxDate',"IMCYC"."OPDN", "TaxDate",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_SlpCode',"IMCYC"."OPDN", "SlpCode",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_OwnerCode',"IMCYC"."OPDN", "OwnerCode",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_DocTotal',"IMCYC"."OPDN", "DocTotal",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_Comments',"IMCYC"."OPDN", "Comments",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_NumAtCard',"IMCYC"."OPDN", "NumAtCard",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
viewAttribute=('OPDN_Project',"IMCYC"."OPDN", "Project",'JoinPath1','V_ES_GOODSRECEIPTPO','attribute'),
freeStyleSearchAttribute='OCPR_Name:1:0',
freeStyleSearchAttribute='OSLP_SlpName:1:0',
freeStyleSearchAttribute='OHEM_firstName:1:0',
freeStyleSearchAttribute='OHEM_lastName:1:0',
freeStyleSearchAttribute='OHEM_middleName:1:0',
freeStyleSearchAttribute='PDN1_ItemCode:1:0',
freeStyleSearchAttribute='PDN1_Dscription:1:0',
freeStyleSearchAttribute='PDN1_Quantity:1:0',
freeStyleSearchAttribute='PDN1_Price:1:0',
freeStyleSearchAttribute='PDN1_DiscPrcnt:1:0',
freeStyleSearchAttribute='PDN1_LineTotal:1:0',
freeStyleSearchAttribute='PDN1_Project:1:0',
freeStyleSearchAttribute='OCRD_CardCode:1:0',
freeStyleSearchAttribute='OPDN_CardCode:1:0',
freeStyleSearchAttribute='OPDN_CardName:1:0',
freeStyleSearchAttribute='OPDN_DocNum:1:0',
freeStyleSearchAttribute='OPDN_DocStatus:1:0',
freeStyleSearchAttribute='OPDN_DocDate:1:0',
freeStyleSearchAttribute='OPDN_DocDueDate:1:0',
freeStyleSearchAttribute='OPDN_TaxDate:1:0',
freeStyleSearchAttribute='OPDN_DocTotal:1:0',
freeStyleSearchAttribute='OPDN_Comments:1:0',
freeStyleSearchAttribute='OPDN_NumAtCard:1:0',
freeStyleSearchAttribute='OPDN_Project:1:0',
view=('V_ES_GOODSRECEIPTPO',"IMCYC"."OPDN"),defaultView='V_ES_GOODSRECEIPTPO',OPTIMIZEMETAMODEL=0)