--  委外BOM引入模板
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1990558430204584960)
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FENABLEIMPORT,FEXCHANGENAMEANDMARK,FMASTERID,FSTATUS,FTEMPLATETYPE,FNUMBER,FCREATETIME,FHIDEFIELDROW,FAPPLYSCOPE,FENABLE,FMODIFIERID,FSPLITSUBENTRIES,FPLUGIN,FFORUPDATEMULTILANGFIELDS,FMODIFYTIME,FCREATORID,FBIZOBJECT) VALUES (1990558430204584960,'1','1','0',1990558430204584960,'C','IMPT','bd_scbom_IMPT_S',{ts'2018-08-08  00:00:00'},'0','0','1',1,'0',' ','0',{ts'2018-08-08  00:00:00'},1,'bd_scbom'); 


IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '48HK=8+ONQ+A')
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1990558430204584960,'48HK=8+ONQ+A','zh_CN','系统预置模板','委外BOM引入模板'); 


IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071803693056)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071803693056,'0','0',' ',' ','0',' ','0',' ',0,'bd_scbom',1,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071803737088)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071803737088,'0','0',' ',' ','0',' ','0',' ',1990557071803693056,'billhead',2,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470272)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820470272,'0','0',' ',' ','0',' ','1',' ',1990557071803737088,'id',3,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820514304)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820514304,'1','0',' ',' ','1',' ','1',' ',1990557071803737088,'number',4,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828858880)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828858880,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'type',5,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828902913)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828902913,'0','0','name',' ','1',' ','1',' ',1990557071803737088,'group',6,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828858881)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828858881,'1','0','name',' ','1',' ','1',' ',1990557071803737088,'createorg',7,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828902914)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071828902914,'0','0',' ',' ','0',' ','1',' ',1990557071803737088,'status',8,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828858882)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071828858882,'0','0',' ',' ','0',' ','1',' ',1990557071803737088,'enable',9,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470277)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071820470277,'1','0','name',' ','1',' ','1',' ',1990557071803737088,'material',11,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828858884)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828858884,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'useorg',23,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072005063680)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072005063680,'0','0',' ',' ','0',' ','0',' ',1990557071803693056,'entry',24,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408256)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408256,'0','0',' ',' ','0',' ','1',' ',1990557072005063680,'entry.id',25,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828902915)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071828902915,'0','0',' ',' ','1',' ','1',' ',1990557071803737088,'description',10,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828902912)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828902912,'1','0','name',' ','1',' ','1',' ',1990557071803737088,'version',12,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470273)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071820470273,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'creator',13,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820514305)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820514305,'0','1',' ',' ','0','dateformat6','1',' ',1990557071803737088,'createtime',15,'yyyy-MM-dd HH:mm:ss',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470274)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071820470274,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'modifier',16,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820514306)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820514306,'0','1',' ',' ','0','dateformat6','1',' ',1990557071803737088,'modifytime',17,'yyyy-MM-dd HH:mm:ss',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470275)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071820470275,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'auditor',18,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820514307)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820514307,'0','1',' ',' ','0','dateformat6','1',' ',1990557071803737088,'auditdate',19,'yyyy-MM-dd HH:mm:ss',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820470276)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071820470276,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'disableuser',20,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071820514308)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071820514308,'0','1',' ',' ','0','dateformat6','1',' ',1990557071803737088,'disabledate',21,'yyyy-MM-dd HH:mm:ss',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828858883)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557071828858883,'0','0','name',' ','0',' ','1',' ',1990557071803737088,'org',22,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557071828902916)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557071828902916,'0','0',' ',' ','0',' ','1',' ',1990557071803737088,'name',14,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408258)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408258,'0','0',' ',' ','1',' ','1',' ',1990557072005063680,'lossformula',32,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452291)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557072013452291,'1','0','name',' ','1',' ','1',' ',1990557072005063680,'entrymaterial',26,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452292)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,'number',1990557072013452292,'0','0','name',' ','0',' ','1',' ',1990557072005063680,'entryunit',28,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408257)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408257,'1','0',' ',' ','1',' ','1',' ',1990557072005063680,'entryqtynumerator',30,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452289)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013452289,'1','0',' ',' ','1',' ','1',' ',1990557072005063680,'entryqtydenominator',31,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452290)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013452290,'1','1',' ',' ','1','dateformat1','1',' ',1990557072005063680,'entryvaliddate',34,'yyyy-MM-dd',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408259)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408259,'1','1',' ',' ','1','dateformat1','1',' ',1990557072005063680,'entryinvaliddate',35,'yyyy-MM-dd',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452293)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013452293,'0','0',' ',' ','1',' ','1',' ',1990557072005063680,'entryremark',36,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408260)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408260,'0','0',' ',' ','1',' ','1',' ',1990557072005063680,'auxpty',27,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013452288)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013452288,'0','0',' ',' ','0',' ','1',' ',1990557072005063680,'entryqtytype',29,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1990557072013408261)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FEXPORTPROP,FDESCRIPTION,FISIMPORT,FEXPORTFORMAT,FISFIELD,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1990558430204584960,0,' ',1990557072013408261,'0','0',' ',' ','1',' ','1',' ',1990557072005063680,'varlossrate',33,' ',' '); 
