
--数据源配置
DELETE FROM t_mrp_rsdataconfig WHERE FID = 1221566656925419520;
INSERT INTO t_mrp_rsdataconfig(FID,FTYPE,FLARGETEXTFIELD,FAUDITORID,FCREATEORGID,FMASTERID,FSTATUS,FNUMBER,FAUDITDATE,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FISSYSTEMDESIGN,FCGNUMBER,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1221566656925419520,' ',' ',0,0,1221566656925419520,'C','Closed Sales Order',NULL,1220338850094645248,{ts'2021-08-08  00:00:00'},1,'1',{ts'2021-08-08  00:00:00'},'0',0,'mds',1,'{"filterRow":[{"id":"1UO9=5392L=/","leftBracket":"","compareType":"67","fieldName":"biztype.number","rightBracket":"","logic":"0","value":[{"id":"4E9G4YJ8=P24","value":"210"}],"baseDataIds":[{"id":"1UO9=53BQ/GI","value":"422876630176775168"}]},{"id":"1UO9=53BO6SM","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"1UO9=53BQ/GJ","value":"C"}],"baseDataIds":[]},{"id":"1UO9=53BO6SN","leftBracket":"","compareType":"10","fieldName":"auditdate","rightBracket":"","logic":"0","value":[{"id":"1UO9=53BQ/GK","value":""}],"baseDataIds":[]},{"id":"1UO9=53BO6SO","leftBracket":"","compareType":"9","fieldName":"mainbillnumber","rightBracket":"","logic":"0","value":[{"id":"1UO9=53BQ/GL","value":""}],"baseDataIds":[]}],"forList":false}');

DELETE FROM t_mrp_rsdataconfig WHERE FID = 1221565392980297728;
INSERT INTO t_mrp_rsdataconfig(FID,FTYPE,FLARGETEXTFIELD,FAUDITORID,FCREATEORGID,FMASTERID,FSTATUS,FNUMBER,FAUDITDATE,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FISSYSTEMDESIGN,FCGNUMBER,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1221565392980297728,' ',' ',0,0,1221565392980297728,'C','Open Sales Order',NULL,1220330065393353728,{ts'2021-08-08  00:00:00'},1,'1',{ts'2021-08-08  00:00:00'},'0',0,'mds',1,'{"filterRow":[{"id":"1UO9RMLD=2JQ","leftBracket":"","compareType":"67","fieldName":"biztype.number","rightBracket":"","logic":"0","value":[{"id":"4E9G4YJ8=P24","value":"210"}],"baseDataIds":[{"id":"1UO9RMLD=2JR","value":"422876630176775168"}]},{"id":"1UO9RMLDAX8O","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"1UO9RMLD=2JS","value":"C"}],"baseDataIds":[]},{"id":"1UO9RMLDAX8P","leftBracket":"","compareType":"105","fieldName":"closestatus","rightBracket":"","logic":"0","value":[{"id":"1UO9RMLD=2JT","value":"A"}],"baseDataIds":[]},{"id":"1UO9RMLDAX8Q","leftBracket":"","compareType":"105","fieldName":"rowclosestatus","rightBracket":"","logic":"0","value":[{"id":"1UO9RMLD=2JU","value":"A"}],"baseDataIds":[]},{"id":"1UO9RMLDAX8R","leftBracket":"","compareType":"105","fieldName":"rowterminatestatus","rightBracket":"","logic":"0","value":[{"id":"1UO9RMLD=2JV","value":"A"}],"baseDataIds":[]}],"forList":false}');


--冲减顺序定义
DELETE FROM t_mds_setofforder WHERE FID = 1220322184170307584;
INSERT INTO t_mds_setofforder(FID,FCREATEORGID,FORDERTYPE,FORGID,FMASTERID,FTAILS,FSTATUS,FCTRLSTRATEGY,FAHEADS,FNUMBER,FCREATETIME,FMODIFIERID,FQTYPE,FENABLE,FMODIFYTIME,FCREATORID) VALUES (1220322184170307584,100000,'B',100000,1220322184170307584,100,'C','5',100,'CJSX',{ts'2018-08-08  18:08:08'},1,'A','1',{ts'2018-08-08  18:08:08'},1);

--冲减顺序定义多语言
DELETE FROM t_mds_setofforder_l WHERE FPKID = '1TWEYW+MN0TR';
INSERT INTO t_mds_setofforder_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1220322184170307584,'1TWEYW+MN0TR','zh_CN','CJSX');


----数据源配置
DELETE FROM t_mrp_rsdataconfig WHERE FID = 1287701855035574272;
INSERT INTO t_mrp_rsdataconfig(FID,FTYPE,FLARGETEXTFIELD,FAUDITORID,FCREATEORGID,FMASTERID,FSTATUS,FNUMBER,FAUDITDATE,FBILLFIELDTRANSFERID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FISSYSTEMDESIGN,FCGNUMBER,FSOURCETYPE,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1287701855035574272,' ',' ',0,0,1287701855035574272,'C','Closed Sales Order-1',NULL,1220338850094645248,{ts'2018-08-08  18:08:08'},1,'1',{ts'2018-08-08  18:08:08'},'0',0,'mds',1,'{"filterRow":[{"id":"2058M3D/OQCS","leftBracket":"","compareType":"67","fieldName":"biztype.number","rightBracket":"","logic":"0","value":[{"id":"4E9G4YJ8=P24","value":"210"}],"baseDataIds":[]},{"id":"2058M3D/OQCT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2058M3D/MO9=","value":"C"}],"baseDataIds":[]},{"id":"2058M3D/OQCU","leftBracket":"","compareType":"61","fieldName":"auditdate","rightBracket":"","logic":"0","value":[{"id":"2058M3D/MO9A","value":""}],"baseDataIds":[]},{"id":"2058M3D/OQCV","leftBracket":"","compareType":"9","fieldName":"mainbillnumber","rightBracket":"","logic":"0","value":[{"id":"2058M3D/MO9B","value":""}],"baseDataIds":[]}],"forList":false}');


--冲减顺序定义
DELETE FROM t_mds_setofforder WHERE FID = 1220322184170307584;
INSERT INTO t_mds_setofforder(FID,FCREATEORGID,FORDERTYPE,FORGID,FMASTERID,FTAILS,FSTATUS,FCTRLSTRATEGY,FAHEADS,FNUMBER,FCREATETIME,FMODIFIERID,FQTYPE,FENABLE,FMODIFYTIME,FCREATORID) VALUES (1220322184170307584,100000,'B',100000,1220322184170307584,100,'C','5',100,'CJSX',{ts'2021-08-08  00:00:00'},1,'A','1',{ts'2021-08-08  00:00:00'},1);

--冲减顺序定义多语言
DELETE FROM t_mds_setofforder_l WHERE FPKID = '1TWEYW+MN0TR';
INSERT INTO t_mds_setofforder_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1220322184170307584,'1TWEYW+MN0TR','zh_CN','CJSX');



