
DELETE FROM t_msplan_adjustsug_entity WHERE FENTRYID = 1406384132526702593;
INSERT INTO t_msplan_adjustsug_entity(FID,FBILLTYPE,FENTRYID,FSEQ,FCHANGEBILL) VALUES (1406384132526702592,'mrp_planorder',1406384132526702593,1,'mrp_xplanorder'); 

DELETE FROM t_msplan_adjustsug_rel WHERE FID = 1406384132526702592;
INSERT INTO t_msplan_adjustsug_rel(FID,FCREATETIME,FRELCONFIGBASEDATA,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FRELEASEPLUGIN,FNUMBER,FSYSTEMPRESET) VALUES (1406384132526702592,{ts'2018-08-08  08:00:00'},'mrp_adjustsuggest',1,'1',{ts'2018-08-08  08:00:00'},1406384132526702592,'C',1,1377382241222525952,'SYS-ADJUST-001','1'); 

DELETE FROM t_msplan_adjustsug_rel_l WHERE FPKID = '2DQUU37PAPTN';
INSERT INTO t_msplan_adjustsug_rel_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1406384132526702592,'2DQUU37PAPTN','zh_CN','预置调整建议配置信息'); 
DELETE FROM t_msplan_adjustsug_rel_l WHERE FPKID = '2DQUU37PAPTO';
INSERT INTO t_msplan_adjustsug_rel_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1406384132526702592,'2DQUU37PAPTO','zh_TW','預置調整建議配置信息'); 

DELETE FROM t_msplan_adjustsug_suben WHERE FDETAILID = 1406384132526703618;
INSERT INTO t_msplan_adjustsug_suben(FDETAILID,FENTRYID,FADJUSTSUGFIELDSIGN,FSEQ,FADJUSTSUGFIELDNAME,FCHANGEBILLFIELDSIGN,FCHANGEBILLFIELDNAME) VALUES (1406384132526703618,1406384132526702593,'qty',1,'单据头.数量','changeqty','单据头.数量'); 
DELETE FROM t_msplan_adjustsug_suben WHERE FDETAILID = 1406384132526703619;
INSERT INTO t_msplan_adjustsug_suben(FDETAILID,FENTRYID,FADJUSTSUGFIELDSIGN,FSEQ,FADJUSTSUGFIELDNAME,FCHANGEBILLFIELDSIGN,FCHANGEBILLFIELDNAME) VALUES (1406384132526703619,1406384132526702593,'adjustdate',2,'单据头.调整可用日期','changedate','单据头.可用日期'); 
DELETE FROM t_msplan_adjustsug_suben WHERE FDETAILID = 1407814772946109440;
INSERT INTO t_msplan_adjustsug_suben(FDETAILID,FENTRYID,FADJUSTSUGFIELDSIGN,FSEQ,FADJUSTSUGFIELDNAME,FCHANGEBILLFIELDSIGN,FCHANGEBILLFIELDNAME) VALUES (1407814772946109440,1406384132526702593,'adjustcause',3,'单据头.调整原因','reason','单据头.变更原因'); 
DELETE FROM t_msplan_adjustsug_suben WHERE FDETAILID = 1411634735314109440;
INSERT INTO t_msplan_adjustsug_suben(FDETAILID,FENTRYID,FADJUSTSUGFIELDSIGN,FSEQ,FADJUSTSUGFIELDNAME,FCHANGEBILLFIELDSIGN,FCHANGEBILLFIELDNAME) VALUES (1411634735314109440,1406384132526702593,'entryseq',4,'单据头.行号','entryseq','单据头.调整行号'); 
DELETE FROM t_msplan_adjustsug_suben WHERE FDETAILID = 1411634735314109441;
INSERT INTO t_msplan_adjustsug_suben(FDETAILID,FENTRYID,FADJUSTSUGFIELDSIGN,FSEQ,FADJUSTSUGFIELDNAME,FCHANGEBILLFIELDSIGN,FCHANGEBILLFIELDNAME) VALUES (1411634735314109441,1406384132526702593,'plannum',5,'单据头.计划运算号','plannum','单据头.调整计划运算号'); 
