--流程生产领料单  单据类型新增
--表头
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1924033538219326464;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1924033538219326464,'0',' ','0',1924033538219326464,'C',1,'im_mdc_mftproorder',' ','im_mdc_propmftproorder_BT_S',{ts'2024-04-08  00:00:00'},'40DOYGT+U0AS',1770243028569566208,'1',{ts'2024-04-09  00:00:00'},'1',1770243028569566208); 

--分录
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251520;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251520,'0','0','1','0','1','1','0','0','project',0,'0','0','project',1,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251521;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251521,'0','0','1','1','1','1','0','0','tracknumber',0,'0','1','tracknumber',2,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251522;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251522,'0','0','1','0','1','1','0','0','tracknumber',0,'0','0','basedatafield10',3,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251523;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251523,'0','0','1','0','1','1','0','0','tracknumber',0,'0','0','basedatafield12',4,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251524;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251524,'0','0','1','1','1','1','0','0','isrework',0,'0','1','isrework',5,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251525;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251525,'0','0','1','1','1','1','0','0','configuredcode',0,'0','1','configuredcode',6,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251526;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251526,'0','0','1','0','1','1','0','0','isrework',0,'0','0','checkboxfield2',7,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251527;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251527,'0','0','1','0','1','1','0','0','configuredcode',0,'0','0','basedatafield11',8,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1924736514374251528;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924033538219326464,'0','0',1924736514374251528,'0','0','1','1','1','1','0','0','processseq',0,'0','1','processseq',9,' ',' ','0'); 

--多语言
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '40AVDK2YE98K';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1924033538219326464,'40AVDK2YE98K','zh_CN',' ','流程生产领料单'); 
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '40AVDK2YE98L';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1924033538219326464,'40AVDK2YE98L','zh_TW',' ','流程生產領料單'); 

--流程生产领料申请单  单据类型新增
--表头
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1924789089278641152;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1924789089278641152,'0',' ','0',1924789089278641152,'C',1,'im_mdc_mftomreqapplybill',' ','im_mdc_propmftreqapplybil_BT_S',{ts'2024-04-09  00:00:00'},'40H21N=WDD0T',1770243028569566208,'1',{ts'2024-04-10  00:00:00'},'1',1770243028569566208); 


DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777792;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777792,'0','0','1','1','1','1','0','0','rework',0,'0','1','rework',1,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777793;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'1','0',1925350613839777793,'0','1','1','1','1','1','1','1','materialtype',0,'1','1','materialtype',2,'E',' ','1'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777794;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777794,'0','0','1','0','1','1','0','0','tracknumber',0,'0','0','tracknumber',3,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777795;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777795,'0','0','1','0','1','1','0','0','configuredcode',0,'0','0','configuredcode',4,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777796;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777796,'0','0','1','0','1','1','0','0','project',0,'0','0','project',5,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777797;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777797,'0','0','1','0','1','0','0','0','supplier',0,'0','0','supplier',6,' ',' ','0'); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 1925350613839777798;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FAUDITENABLED,FVINIT,FVSUBMIT,FVNEW,FENTITYFIELDKEY,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT) VALUES (1924789089278641152,'0','0',1925350613839777798,'0','0','1','1','1','1','0','0','processseq',0,'0','1','processseq',7,' ',' ','0'); 


DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '40EGK5JO2/++';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1924789089278641152,'40EGK5JO2/++','zh_CN',' ','流程生产领料申请'); 
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '40EGK5JO2/+/';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1924789089278641152,'40EGK5JO2/+/','zh_TW',' ','流程生產領料申請'); 
