-- 辅助资料分类预置引出模板脚本

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1987814764083983360;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FCREATETIME,FMODIFYTIME,FMODIFIERID,FNUMBER,FBIZOBJECT,FSTATUS,FCREATORID,FENABLE,FCOMMENT,FMASTERID,FTEMPLATETYPE,FENABLEIMPORT,FNAME,FAPPLYSCOPE,FEXCHANGENAMEANDMARK,FHIDEFIELDROW,FENABLESETNULL,FSPLITSUBENTRIES,FOVERRIDEENTRY,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FISPRESET) VALUES (1987814764083983360,{ts'2024-07-05  00:00:00'},{ts'2024-07-05  00:00:00'},13466739,'bos_assistantdatagroup_IMPT_PRESET','bos_assistantdatagroup','C',13466739,'1',' ',1987814764083983360,'IMPT','1','辅助资料分类预置模板','0','0','0','1','0','0','0',' ','1');

DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '485EN67RU3UP';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID,FID,FLOCALEID,FNAME,FCOMMENT) VALUES ('485EN67RU3UP',1987814764083983360,'zh_CN','辅助资料分类预置模板',' ');
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '485EN67RU3UQ';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID,FID,FLOCALEID,FNAME,FCOMMENT) VALUES ('485EN67RU3UQ',1987814764083983360,'zh_TW','輔助資料分類預置模板',' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706318950400;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706318950400,1987814764083983360,0,1,'bos_assistantdatagroup',NULL,'0',' ','0','0',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706318951424;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706318951424,1987814764083983360,1987773706318950400,2,'billhead',NULL,'0',' ','0','0',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327339008;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327339008,1987814764083983360,1987773706318951424,3,'id',NULL,'0',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327340032;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327340032,1987814764083983360,1987773706318951424,4,'number',NULL,'1',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327339009;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327339009,1987814764083983360,1987773706318951424,5,'name',NULL,'1',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327340033;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327340033,1987814764083983360,1987773706318951424,6,'ctrlstrategy',NULL,'1',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327339010;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327339010,1987814764083983360,1987773706318951424,7,'fbizcloudid',NULL,'1',' ','1','1','number','name','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327340034;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327340034,1987814764083983360,1987773706318951424,8,'createorg',NULL,'1',' ','1','1','number','name','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327339011;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327339011,1987814764083983360,1987773706318951424,9,'description',NULL,'0',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327340035;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327340035,1987814764083983360,1987773706318951424,10,'fissyspreset',NULL,'0',' ','0','1',' ',' ','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327339012;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327339012,1987814764083983360,1987773706318951424,11,'ctrlview',NULL,'1',' ','1','1','number','name','0',' ',' ',' ',' ','0');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1987773706327340036;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FENTRYID,FID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP,FCOLWIDTH,FSOURCEENTITY,FSOURCENAME,FEXPORTFORMATNAME,FEXPORTFORMAT,FISDATE) VALUES (1987773706327340036,1987814764083983360,1987773706318951424,12,'isgroupcontrol',NULL,'0',' ','1','1',' ',' ','0',' ',' ',' ',' ','0');
