-- 计划建议
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1226619024197025792;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1226619024197025792,'0','0',NULL,'1',' ','0',1226619024197025792,'C','mrp_planorder',1,' ',' ','mrp_planorder',{ts'2021-08-20  00:00:00'},'0SFS10CINKTX',NULL,275188253840125329,'1',{ts'2021-08-20  00:00:00'},'1',275188253840125329); 

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1UNLGUMQ9X2A';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1226619024197025792,'1UNLGUMQ9X2A','zh_CN','计划建议','计划建议'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '1UNLGUMQ9X2B';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1226619024197025792,'1UNLGUMQ9X2B','zh_TW','計劃建議','計劃建議'); 



DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413248;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'0','0',1226821459167413248,'0','0','1','0',0,'1',' ','1','0','0',0,'0','0','dropstatus',1,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413249;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'0','0',1226821459167413249,'0','0','1','1',0,'1',' ','1','0','0',0,'0','1','droptime',2,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413250;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'0','0',1226821459167413250,'0','0','1','1',0,'1',' ','1','0','0',0,'0','1','schedule',3,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413251;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'1','0',1226821459167413251,'0','0','1','1',0,'1',' ','1','1','0',0,'1','1','planprogram',4,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413252;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'1','0',1226821459167413252,'0','0','1','1',0,'1',' ','1','1','0',0,'1','1','planoperatenum',5,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1226821459167413253;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVINIT,FVSUBMIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (1226619024197025792,'0','0',1226821459167413253,'0','0','1','1',0,'1',' ','1','0','0',0,'0','1','dropqty',6,' ',' ','1',0); 
