--BOM批量正反查模型，增加WBS及查询WBS两个字段
--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001604139276106752;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001604139276106752) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1759389678651401216,2001604139276106752,'基础资料','1','rootwbs',' ',' ','0',' ',' ',22,'查询WBS','0','1',' '); 

--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001604139276106753;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001604139276106753) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1759389678651401216,2001604139276106753,'基础资料','1','wbs',' ',' ','0',' ',' ',23,'WBS','0','1',' '); 


--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001604545142083584;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001604545142083584) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1759389934193566720,2001604545142083584,'基础资料','1','rootwbs',' ',' ','0',' ',' ',33,'查询WBS','0','1',' '); 

--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001604545142083585;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001604545142083585) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1759389934193566720,2001604545142083585,'基础资料','1','wbs',' ',' ','0',' ',' ',34,'WBS','0','1',' '); 


--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001605044415298560;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001605044415298560) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1754285651630507008,2001605044415298560,'基础资料','1','rootwbs',' ',' ','0',' ',' ',22,'查询WBS','0','1',' '); 

--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001605044415298561;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001605044415298561) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1754285651630507008,2001605044415298561,'基础资料','1','wbs',' ',' ','0',' ',' ',23,'WBS','0','1',' '); 


--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001605376067260416;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001605376067260416) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1754286130653578240,2001605376067260416,'基础资料','1','rootwbs',' ',' ','0',' ',' ',36,'查询WBS','0','1',' '); 

--DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 2001605376067260417;
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextcolumn WHERE FENTRYID =  2001605376067260417) 
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FSHOWSUMMARY,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1754286130653578240,2001605376067260417,'基础资料','1','wbs',' ',' ','0',' ',' ',37,'WBS','0','1',' '); 

