-- 预置存货分类导入模板

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 2076980472604269568;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FISPRESET,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCREATORID,FAPPLYLAYOUT,FBIZOBJECT) VALUES (2076980472604269568,'1','1',2076980472604269568,'0','C','bd_matcategory_group_IMPT_S','存货分类导入模板','IMPT',{ts'2018-08-08  00:00:00'},'0',1,'1','0','0','0','0',' ',{ts'2018-08-08  00:00:00'},1,' ','bd_matcategory_group');

DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '4I3LW5X3WMXE';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (2076980472604269568,'4I3LW5X3WMXE','zh_CN','系统预置模板','存货分类导入模板');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067543554048;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067543554048,'0','0',' ',' ','0','0',' ',' ',0,'bd_matcategory_group',1,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067585498114;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067585498114,'0','0',' ',' ','0','0',' ',' ',2076980067543554048,'billhead',2,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067602275331;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067602275331,'0','0',' ',' ','0','1',' ',' ',2076980067585498114,'id',3,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067602275333;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067602275333,'1','0',' ',' ','1','1',' ',' ',2076980067585498114,'number',4,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067610662914;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067610662914,'1','0',' ',' ','1','1',' ',' ',2076980067585498114,'name',5,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067619052544;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067619052544,'0','0',' ',' ','1','1',' ',' ',2076980067585498114,'remark',6,' ',' ');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 2076980067627440128;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (2076980472604269568,0,' ',2076980067627440128,'0','0',' ',' ','0','1',' ',' ',2076980067585498114,'enable',7,' ',' ');

-- 存货类别导入模版名称 修改为 导入
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1479702448388965376;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FISPRESET,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCREATORID,FAPPLYLAYOUT,FBIZOBJECT) VALUES (1479702448388965376,'1','1',1479702448388965376,'0','C','bd_materialcategory_IMPT_S','存货类别导入模板','IMPT',{ts'2018-08-08  00:00:00'},'0',13466739,'1','0','0','0','0',' ',{ts'2024-11-05  00:00:00'},1,' ','bd_materialcategory');


DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '2MR30EHUYLFS';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1479702448388965376,'2MR30EHUYLFS','zh_CN','系统预置模板','存货类别导入模板');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '2OU37MX1L2=M';
