--更新发票云配置(集团)模板
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID IN (1264499683473099776);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499217947298816,0,1,'er_bd_kdinvoicecloudcfgct',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397576,1264499218316286976,24,'creator',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286985,1264499218316286976,25,'useorg',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397579,1264499218316286976,30,'modifier',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286988,1264499218316286976,31,'org',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286976,1264499217947298816,2,'billhead',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397568,1264499218316286976,3,'id',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397569,1264499218316286976,17,'reimed_ci',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397582,1264499218316286976,8,'createorg',NULL,'1',' ','1','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286980,1264499218316286976,4,'number',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397572,1264499218316286976,5,'name',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286981,1264499218316286976,6,'taxregnum',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397573,1264499218316286976,7,'firmname',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286991,1264499218316286976,9,'ctrlstrategy',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286977,1264499218316286976,10,'deductibleoftaxpayer',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286982,1264499218316286976,14,'client_id',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397574,1264499218316286976,15,'clients',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286983,1264499218316286976,16,'clientkey',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286978,1264499218316286976,18,'namenotmatch_ci',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397570,1264499218316286976,19,'taxnumnotmatch_ci',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286979,1264499218316286976,20,'buyernamele5_ci',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397571,1264499218316286976,21,'checknotpass_ci',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397575,1264499218316286976,22,'status',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286984,1264499218316286976,23,'enable',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397577,1264499218316286976,26,'client_secret',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286986,1264499218316286976,27,'encrypt_key',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397578,1264499218316286976,28,'createtime',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286987,1264499218316286976,29,'modifytime',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397580,1264499218316286976,32,'sourcedata',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286989,1264499218316286976,33,'bitindex',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316397581,1264499218316286976,34,'srcindex',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1264499218316286990,1264499218316286976,35,'sync',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1267935187472252929,1264499218316286976,11,'offsetonlyfrominvoice',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1267935187472246785,1264499218316286976,12,'nonoffsetcomputoutaount',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1264499683473099776,1267935187472252930,1264499218316286976,13,'nonoffsetimporttaxamout',NULL,'1',' ','1','1',' ',' ');


--更新发票云配置模板
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID IN (580850463415570432);
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,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,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,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,1264466662749395973,1264466662741117952,6,'firmname',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(580850463415570432,1264466662749395975,1264466662741117952,7,'deductibleoftaxpayer',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,11,'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,12,'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,13,'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,14,'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,1264466662749395971,1264466662741117952,15,'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,16,'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,1264466662749506563,1264466662741117952,17,'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,1264466662749506566,1264466662741117952,18,'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,1264466662749395972,1264466662741117952,19,'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,20,'enable',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(580850463415570432,1264466662749395974,1264466662741117952,21,'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,22,'clients',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(580850463415570432,1267933116996020233,1264466662741117952,8,'nonoffsetcomputoutaount',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(580850463415570432,1267933116996026377,1264466662741117952,9,'nonoffsetimporttaxamout',NULL,'1',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(580850463415570432,1267933117004408832,1264466662741117952,10,'offsetonlyfrominvoice',NULL,'1',' ','1','1',' ',' ');