-- 预置冲减维度
-- 编码：001，名称：按物料编码
DELETE FROM t_mds_setoffdim WHERE FID = 1779076730070242304;
INSERT INTO t_mds_setoffdim(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FSYSPRESET,FCREATORID) VALUES (1779076730070242304,0,100000,0,1779076730070242304,100000,'C','5','001','按物料编码',{ts'2018-08-08  00:00:00'},0,1,'1',{ts'2018-08-08  00:00:00'},'1',1);

DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KICUP6ZV88I';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779076730070242304,'3KICUP6ZV88I','zh_CN','按物料编码');
DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KICUP6ZV88J';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779076730070242304,'3KICUP6ZV88J','zh_TW','按物料編碼');

DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779076730254791680;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('materiel',1779076730070242304,'单据头.物料','单据头.物料',1779076730254791680,1,'materiel','1','物料编码','1');

-- 编码：002，名称：按物料编码+项目号
DELETE FROM t_mds_setoffdim WHERE FID = 1779142807823367168;
INSERT INTO t_mds_setoffdim(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FSYSPRESET,FCREATORID) VALUES (1779142807823367168,0,100000,0,1779142807823367168,100000,'C','5','002','按物料编码+项目号',{ts'2018-08-08  00:00:00'},0,1,'1',{ts'2018-08-08  00:00:00'},'1',1);

DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIP66YVKM08';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779142807823367168,'3KIP66YVKM08','zh_CN','按物料编码+项目号');
DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIP66YVKM09';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779142807823367168,'3KIP66YVKM09','zh_TW','按物料編碼+項目號');

DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779142807831755776;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('materiel',1779142807823367168,'单据头.物料','单据头.物料',1779142807831755776,1,'materiel','1','物料编码','1');
DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779142807831755777;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('project',1779142807823367168,'单据头.项目号','单据头.项目号',1779142807831755777,2,'project','1','项目号','1');

-- 编码：003，名称：按物料编码+配置号
DELETE FROM t_mds_setoffdim WHERE FID = 1779143297751627776;
INSERT INTO t_mds_setoffdim(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FSYSPRESET,FCREATORID) VALUES (1779143297751627776,0,100000,0,1779143297751627776,100000,'C','5','003','按物料编码+配置号',{ts'2018-08-08  00:00:00'},0,1,'1',{ts'2018-08-08  00:00:00'},'1',1);

DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIP9S6+9QF9';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779143297751627776,'3KIP9S6+9QF9','zh_CN','按物料编码+配置号');
DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIP9S6+9QF=';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779143297751627776,'3KIP9S6+9QF=','zh_TW','按物料編碼+配置號');

DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779143297760016384;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('materiel',1779143297751627776,'单据头.物料','单据头.物料',1779143297760016384,1,'materiel','1','物料编码','1');
DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779143297760016385;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('configid',1779143297751627776,'单据头.配置号','单据头.配置号',1779143297760016385,2,'configid','1','配置号','1');

-- 编码：004，名称：按物料编码+计划范围
DELETE FROM t_mds_setoffdim WHERE FID = 1779144812860062720;
INSERT INTO t_mds_setoffdim(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FSYSPRESET,FCREATORID) VALUES (1779144812860062720,0,100000,0,1779144812860062720,100000,'C','5','004','按物料编码+计划范围',{ts'2018-08-08  00:00:00'},0,1,'1',{ts'2018-08-08  00:00:00'},'1',1);

DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIPJTROT=T2';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779144812860062720,'3KIPJTROT=T2','zh_CN','按物料编码+计划范围');
DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3KIPJTROT=T3';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779144812860062720,'3KIPJTROT=T3','zh_TW','按物料編碼+計劃範圍');

DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779144812868451328;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('materiel',1779144812860062720,'单据头.物料','单据头.物料',1779144812868451328,1,'materiel','1','物料编码','1');
DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1779144812868451329;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('planscope',1779144812860062720,'单据头.计划范围','单据头.计划范围',1779144812868451329,2,'planscope','1','计划范围','1');

-- 编码：005，名称：按物料编码+辅助属性
DELETE FROM t_mds_setoffdim WHERE FID = 1793520671515527168;
INSERT INTO t_mds_setoffdim(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FSYSPRESET,FCREATORID) VALUES (1793520671515527168,0,100000,0,1793520671515527168,100000,'C','5','005','按物料编码+辅助属性',{ts'2018-08-08  00:00:00'},0,1,'1',{ts'2018-08-08  00:00:00'},'1',1);

DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3M=KMFM5MEH4';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1793520671515527168,'3M=KMFM5MEH4','zh_CN','按物料编码+辅助属性');
DELETE FROM t_mds_setoffdim_l WHERE FPKID = '3M=KMFM5MEH5';
INSERT INTO t_mds_setoffdim_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1793520671515527168,'3M=KMFM5MEH5','zh_TW','按物料編碼+輔助屬性');

DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1793520671674910720;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('materiel',1793520671515527168,'单据头.物料','单据头.物料',1793520671674910720,1,'materiel','1','物料编码','1');
DELETE FROM t_mds_setoffdim_entry WHERE FENTRYID = 1793520671674910721;
INSERT INTO t_mds_setoffdim_entry(FREQFIELDKEY,FID,FPROFIELDNAME,FREQFIELDNAME,FENTRYID,FSEQ,FPROFIELDKEY,FFIXEDDIM,FFIELDNAME,FENABLESTATUS) VALUES ('auxproperty',1793520671515527168,'单据头.辅助属性','单据头.辅助属性',1793520671674910721,2,'auxproperty','0','辅助属性','1');
