--计划字段设置

 IF NOT EXISTS (SELECT 1 FROM t_mds_plandatafieldset  WHERE FID = 1550067045331171328)INSERT INTO t_mds_plandatafieldset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1550067045331171328,{ts'2018-08-08  18:08:08'},1,'1','1',{ts'2018-08-08  18:08:08'},1550067045331171328,'C',1,'mds_mdsplandata');

 IF NOT EXISTS (SELECT 1 FROM t_mds_plandatafieldset  WHERE FID = 1551447745405945856)INSERT INTO t_mds_plandatafieldset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1551447745405945856,{ts'2018-08-08  18:08:08'},1,'1','1',{ts'2018-08-08  18:08:08'},1551447745405945856,'C',1,'mds_forecastplandata');

 IF NOT EXISTS (SELECT 1 FROM t_mds_plandatafieldset  WHERE FID = 1551445299908611072)INSERT INTO t_mds_plandatafieldset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1551445299908611072,{ts'2018-08-08  18:08:08'},1,'1','1',{ts'2018-08-08  18:08:08'},1551445299908611072,'C',1,'mds_dpsplandata');

DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VD7C0GT4L3X';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1550067045331171328,'2VD7C0GT4L3X','zh_CN','需求计划数据聚合维度');
DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VD7C0GT4L3Y';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1550067045331171328,'2VD7C0GT4L3Y','zh_TW','需求計劃數據聚合維度');
DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VJUB5VFZCT3';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1551447745405945856,'2VJUB5VFZCT3','zh_CN','预测计划数据聚合维度');
DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VJUB5VFZCT4';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1551447745405945856,'2VJUB5VFZCT4','zh_TW','預測計劃數據聚合維度');
DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VJTWBVSR+LB';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1551445299908611072,'2VJTWBVSR+LB','zh_CN','日生产计划数据聚合维度');
DELETE FROM t_mds_plandatafieldset_l WHERE FPKID = '2VJTWBVSR+LC';
INSERT INTO t_mds_plandatafieldset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1551445299908611072,'2VJTWBVSR+LC','zh_TW','日生產計劃數據聚合維度');


DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1889245938413791232;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1889245938413791232,'projectid','0','1','0','fprojectid','0','0',5,'fprojectid','projectid','项目号','项目号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334465;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334465,'materielnamed','0','0','1',' ','0','0',2,' ','materialname','物料名称','物料名称','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334470;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334470,' ','0','0','0',' ','0','0',8,' ','offering',' ','产品型号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334464;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334464,'materialid','1','0','1','fmaterialid','1','1',1,'fmaterialid','material','物料编码','物料编码','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999682;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999682,'configid','0','1','0','fconfigid','0','0',3,'fconfigid','configid','配置号','配置号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334471;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334471,' ','0','0','0',' ','0','0',9,' ','level0',' ','事业群','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334472;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334472,' ','0','0','0',' ','0','0',10,' ','level1',' ','产品线','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334473;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334473,' ','0','0','0',' ','0','0',11,' ','level2',' ','产品域','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299650;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299650,'baseunit','1','0','1','fbaseunitid','1','1',6,'fbaseunitid','baseunit','计量单位','计量单位','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1580536188370945024;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1580536188370945024,'planscope','0','1','0','fplanscope','0','0',8,'fplanscope','planscope','计划范围','计划范围','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299655;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299655,' ','0','0','0',' ','0','0',12,' ','level1',' ','产品线','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299656;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299656,' ','0','0','0',' ','0','0',13,' ','level2',' ','产品域','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299657;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299657,' ','0','0','0',' ','0','0',14,' ','level3',' ','产品族','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299658;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299658,' ','0','0','0',' ','0','0',15,' ','level4',' ','产品系列','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299659;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299659,'remark','0','0','0','fremark','0','0',16,'fremark','remark','备注','备注','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299660;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299660,' ','0','0','0',' ','0','0',17,' ','edituser',' ','录入人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299661;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299661,' ','0','0','0',' ','0','0',18,' ','editcreatedate',' ','录入时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299662;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299662,' ','0','0','0',' ','0','0',19,' ','entrymodifier',' ','修改人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299663;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299663,' ','0','0','0',' ','0','0',20,' ','editdate',' ','修改时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1873145568784644096;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1873145568784644096,'auxproperty','0','1','0','fauxpropertyid','0','0',4,'fauxpropertyid','auxproperty','辅助属性','辅助属性','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1889248843564902400;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1889248843564902400,'projectid','0','1','0','fprojectid','0','0',5,'fprojectid','projectid','项目号','项目号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334466;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334466,'configid','0','1','0','fconfigid','0','0',3,'fconfigid','configid','配置号','配置号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1840000036402949120;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1840000036402949120,'auxproperty','0','1','0','fauxpropertyid','0','0',4,'fauxpropertyid','auxproperty','辅助属性','辅助属性','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1889249213586357248;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1889249213586357248,'projectid','0','1','0','fprojectid','0','0',5,'fprojectid','projectid','项目号','项目号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550141496525598720;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550141496525598720,'configid','0','1','0','fconfigid','0','0',3,'fconfigid','configid','配置号','配置号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1840002699274284032;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1840002699274284032,'auxproperty','0','1','0','fauxpropertyid','0','0',4,'fauxpropertyid','auxproperty','辅助属性','辅助属性','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999681;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999681,'materielnamed','0','0','1',' ','0','0',2,' ','materialname','物料名称','物料名称','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999680;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999680,'materialid','1','0','1','fmaterialid','1','1',1,'fmaterialid','material','物料编码','物料编码','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299649;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299649,'materielnamed','0','0','1',' ','0','0',2,' ','materialname','物料名称','物料名称','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299648;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299648,'materialid','1','0','1','fmaterialid','1','1',1,'fmaterialid','material','物料编码','物料编码','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999683;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999683,'baseunit','1','0','1','fbaseunitid','1','1',6,'fbaseunitid','baseunit','计量单位','计量单位','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999684;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999684,'prodorg','1','0','1','fprodorg','1','1',7,'fprodorg','prodorg','供应组织','供应组织','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999685;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999685,' ','0','0','1',' ','0','0',8,' ','summary',' ','合计','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999686;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999686,' ','0','0','0',' ','0','0',9,' ','offering',' ','产品型号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999687;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999687,' ','0','0','0',' ','0','0',10,' ','level0',' ','事业群','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999688;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999688,' ','0','0','0',' ','0','0',11,' ','level1',' ','产品线','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999689;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999689,' ','0','0','0',' ','0','0',12,' ','level2',' ','产品域','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999690;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999690,' ','0','0','0',' ','0','0',13,' ','level3',' ','产品族','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999691;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999691,' ','0','0','0',' ','0','0',14,' ','level4',' ','产品系列','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999692;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999692,'remark','0','0','0','fremark','0','0',15,'fremark','remark','备注','备注','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999693;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999693,' ','0','0','0',' ','0','0',16,' ','edituser',' ','创建人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999694;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999694,' ','0','0','0',' ','0','0',17,' ','editcreatedate',' ','创建时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999695;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999695,' ','0','0','0',' ','0','0',18,' ','entrymodifier',' ','修改人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551445299916999696;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551445299908611072,1551445299916999696,' ','0','0','0',' ','0','0',19,' ','editdate',' ','修改时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334467;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334467,'baseunit','1','0','1','fbaseunitid','1','1',6,'fbaseunitid','baseunit','计量单位','计量单位','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334469;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334469,' ','0','0','1',' ','0','0',7,' ','summary',' ','合计','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334474;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334474,' ','0','0','0',' ','0','0',12,' ','level3',' ','产品族','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334475;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334475,' ','0','0','0',' ','0','0',13,' ','level4',' ','产品系列','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334476;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334476,'remark','0','0','0','fremark','0','0',14,'fremark','remark','备注','备注','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334477;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334477,' ','0','0','0',' ','0','0',15,' ','edituser',' ','创建人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334478;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334478,' ','0','0','0',' ','0','0',16,' ','editcreatedate',' ','创建时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334479;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334479,' ','0','0','0',' ','0','0',17,' ','entrymodifier',' ','修改人','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551447745414334480;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551447745414334480,' ','0','0','0',' ','0','0',18,' ','editdate',' ','修改时间','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444608;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444608,' ','0','0','0',' ','0','0',19,' ','hisqty1',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444609;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444609,' ','0','0','0',' ','0','0',20,' ','hisqty2',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444610;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444610,' ','0','0','0',' ','0','0',21,' ','hisqty3',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444611;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444611,' ','0','0','0',' ','0','0',22,' ','hisqty4',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444612;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444612,' ','0','0','0',' ','0','0',23,' ','hisqty5',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444613;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444613,' ','0','0','0',' ','0','0',24,' ','hisqty6',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444614;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444614,' ','0','0','0',' ','0','0',25,' ','hisqty7',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444615;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444615,' ','0','0','0',' ','0','0',26,' ','hisqty8',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1551454592741444616;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1551447745405945856,1551454592741444616,' ','0','0','0',' ','0','0',27,' ','hisqty9',' ',' ','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299651;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299651,'prodorg','1','0','1','fprodorg','1','1',7,'fprodorg','prodorg','供应组织','供应组织','1');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299652;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299652,' ','0','0','1',' ','0','0',9,' ','summary',' ','合计','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299653;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299653,' ','0','0','0',' ','0','0',10,' ','offering',' ','产品型号','0');
DELETE FROM t_mds_plandatafield_entry WHERE FENTRYID = 1550090805350299654;
INSERT INTO t_mds_plandatafield_entry(FID,FENTRYID,FFIELDCODEB,FISUNIQUE,FISNEW,FISFREEZE,FFIELDALIAS,FISCALC,FISSYNC,FSEQ,FFIELDALIASB,FFIELDCODE,FFIELDNAMEB,FFIELDNAME,FISHISTORYDATA) VALUES (1550067045331171328,1550090805350299654,' ','0','0','0',' ','0','0',11,' ','level0',' ','事业群','0');
