DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID IN (580850463415570432);
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FID IN (580850463415570432);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID IN (580850463415570432);

INSERT INTO T_BAS_IMPORTTEMPLATE
(FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT, FNAME)
VALUES(580850463415570432, {ts'2018-08-08 18:08:08'}, {ts'2021-10-11 15:46:31'},1,'er_bd_kdinvoicecloudcfg_IMPT_S','er_bd_kdinvoicecloudcfg','C',1,'1',' ',580850463415570432,'IMPT','1','发票云配置引入模板');

INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('/TASDCI3IPNH',580850463415570432,'zh_CN','发票云配置','发票云配置引入模板');
INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('/TASDCI3IPNI',580850463415570432,'zh_TW','發票雲配置','發票雲配置引入模板');

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662422240256,0,1,'er_bd_kdinvoicecloudcfg',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662741117952,1264466662422240256,2,'billhead',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662741007360,1264466662741117952,3,'id',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506560,1264466662741117952,4,'org',NULL,'1',' ','1','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395968,1264466662741117952,5,'taxregnum',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506561,1264466662741117952,6,'client_id',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395969,1264466662741117952,7,'client_secret',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506562,1264466662741117952,8,'encrypt_key',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395970,1264466662741117952,9,'reimed_ci',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506563,1264466662741117952,10,'checknotpass_ci',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395971,1264466662741117952,11,'namenotmatch_ci',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506564,1264466662741117952,12,'taxnumnotmatch_ci',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395972,1264466662741117952,13,'sumexpnull',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506565,1264466662741117952,14,'enable',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395973,1264466662741117952,15,'firmname',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506566,1264466662741117952,16,'buyernamele5_ci',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395974,1264466662741117952,17,'clientkey',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749506567,1264466662741117952,18,'clients',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(580850463415570432,1264466662749395975,1264466662741117952,19,'deductibleoftaxpayer',NULL,'1',' ','1','1',' ',' ');