--报表方案定义表头数据
DELETE FROM t_mrp_rptscheme WHERE FID = 1280276031776764928;
INSERT INTO t_mrp_rptscheme(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FRPTTYPE,FMODIFYTIME,FSTARTTIME,FPASSDATE,FCREATORID) VALUES (1280276031776764928,0,100000,0,1280276031776764928,0,'C',' ','002','【交单计划】报表方案',{ts'2021-11-01  00:00:00'},0,1,'1','mrp_documents_plan',{ts'2021-11-01  00:00:00'},'B','0',1);
DELETE FROM t_mrp_rptscheme WHERE FID = 1281140489457787904;
INSERT INTO t_mrp_rptscheme(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FRPTTYPE,FMODIFYTIME,FSTARTTIME,FPASSDATE,FCREATORID) VALUES (1281140489457787904,0,100000,0,1281140489457787904,0,'C',' ','003','【备料预测】报表方案',{ts'2021-11-01  00:00:00'},0,1,'1','mrp_stock_forecast',{ts'2021-11-01  00:00:00'},'B','0',1);
DELETE FROM t_mrp_rptscheme WHERE FID = 1279718250699085824;
INSERT INTO t_mrp_rptscheme(FID,FBITINDEX,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FRPTTYPE,FMODIFYTIME,FSTARTTIME,FPASSDATE,FCREATORID) VALUES (1279718250699085824,0,100000,0,1279718250699085824,0,'C',' ','001','【生产预测】报表方案',{ts'2021-11-01  00:00:00'},0,1,'1','mrp_production_forecast',{ts'2021-11-01  00:00:00'},'B','0',1);

--报表方案定义多语言数据
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/6+V+PKE8O2';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1279718250699085824,'2/6+V+PKE8O2','zh_CN','【生产预测】报表方案');
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/6+V+PKE8O3';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1279718250699085824,'2/6+V+PKE8O3','zh_TW','【生產預測】報表方案');
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/8O1ITT8734';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1280276031776764928,'2/8O1ITT8734','zh_CN','【交单计划】报表方案');
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/8O1ITT8735';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1280276031776764928,'2/8O1ITT8735','zh_TW','【交單計劃】報表方案');
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/BTKU1=2JQE';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1281140489457787904,'2/BTKU1=2JQE','zh_CN','【备料预测】报表方案');
DELETE FROM t_mrp_rptscheme_l WHERE FPKID = '2/BTKU1=2JQF';
INSERT INTO t_mrp_rptscheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1281140489457787904,'2/BTKU1=2JQF','zh_TW','【備料預測】報表方案');

--报表方案定义时间列数据
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1279718250699085827;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1279718250699085824,'month','FirstDay',1279718250699085827,3,0,'0','0');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1279718250699085825;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1279718250699085824,'day',' ',1279718250699085825,1,0,'0','0');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1279718250699085826;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1279718250699085824,'week','Mon',1279718250699085826,2,0,'0','1');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1280276031785153536;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1280276031776764928,'day',' ',1280276031785153536,1,0,'0','1');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1280276031785153537;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1280276031776764928,'week','Mon',1280276031785153537,2,0,'0','0');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1280276031785153538;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1280276031776764928,'month','FirstDay',1280276031785153538,3,0,'0','0');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1281140489457787905;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1281140489457787904,'day',' ',1281140489457787905,1,0,'0','0');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1281140489457787906;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1281140489457787904,'week',' ',1281140489457787906,2,0,'0','1');
DELETE FROM t_mrp_rpt_scheme_time WHERE FENTRYID = 1281140489457787907;
INSERT INTO t_mrp_rpt_scheme_time(FID,FTIMETYPE,FDISPLAYDATE,FENTRYID,FSEQ,FLENGTH,FISSUMLAST,FISSUMLATEST) VALUES (1281140489457787904,'month',' ',1281140489457787907,3,0,'0','0');

--报表方案定义字段查询参数
DELETE FROM t_mrp_rpt_scheme_inv WHERE FENTRYID = 1294925418637357056;
INSERT INTO t_mrp_rpt_scheme_inv(FID,FRPTFIELD,FENTRYID,FSEQ,FFIELDTYPE,FORDERSOURCE) VALUES (1281140489457787904,'weekqty',1294925418637357056,1,'delivery',1292002122606389248);
DELETE FROM t_mrp_rpt_scheme_inv WHERE FENTRYID = 1295644072085728256;
INSERT INTO t_mrp_rpt_scheme_inv(FID,FRPTFIELD,FENTRYID,FSEQ,FFIELDTYPE,FORDERSOURCE) VALUES (1281140489457787904,'monthqty',1295644072085728256,2,'delivery',1292004369184761856);