-- 协同计划表默认单据类型脚本
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1302008343056875520;
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 (1302008343056875520,'0','0',NULL,'1',' ','0',1302008343056875520,'C','mrp_collaborativeorder',1,' ',' ','mrp_collaborativeorder',{ts'2021-12-02  00:00:00'},'11GDBAL07Z6Q',NULL,13466739,'1',{ts'2021-12-02  00:00:00'},'1',275188253840125329); 

-- 协同计划表默认单据类型多语言脚本
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '21XSNI6RKGPA';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1302008343056875520,'21XSNI6RKGPA','zh_CN',' ','协同计划单'); 
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '21XSNI6RKGPB';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1302008343056875520,'21XSNI6RKGPB','zh_TW',' ','協同計劃單'); 


-- 协同计划字段控制脚本（只有修改了字段控制的值才会保存到数据库中）
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1302213852192243712;
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 (1302008343056875520,'1','0',1302213852192243712,'0','0','1','1',0,'1',' ','1','1','0',0,'1','1','planoperatenum',1,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1302213852192243713;
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 (1302008343056875520,'1','0',1302213852192243713,'0','0','1','1',0,'1',' ','1','1','0',0,'1','1','planprogram',2,' ',' ','1',0); 
