DELETE FROM t_bas_importtemplate WHERE FID = 753374185035661312;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (753374185035661312,'1',753374185035661312,'C','cas_manualbankjournal_IMPT_S','银行日记账（手工）','IMPT',{ts'2019-11-06  00:00:00'},13466739,'1',{ts'2022-03-30  00:00:00'},' ',718773151755927552,'cas_manualbankjournal'); 

DELETE FROM t_bas_importtemplate_L WHERE FPKID = '0BIAPSJ5P0OA';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (753374185035661312,'0BIAPSJ5P0OA','zh_CN',' ','银行日记账（手工）'); 
DELETE FROM t_bas_importtemplate_L WHERE FPKID = '0BIAPSJ5P0OB';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (753374185035661312,'0BIAPSJ5P0OB','zh_TW',' ','銀行日記賬（手工）'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331368968192;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','0',' ',0,753373331368968192,'cas_manualbankjournal',1,'0',' ',' ','银行日记账（手工）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135042;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394135042,'creator',6,'0',' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134018;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394134018,'auditor',7,'0',' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135043;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331394135040,753373331394135043,'accountbank',8,'1',' ','name','银行账户*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134019;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331394135040,753373331394134019,'org',9,'1',' ','name','组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135044;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331394135040,753373331394135044,'currency',10,'1',' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135047;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394135047,'orgid',15,'0',' ','name','组织临时'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135048;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394135048,'cashier',17,'0',' ','name','出纳'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331402523648;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331402523648,'periodtype',18,'0',' ','name','期间类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912257;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331410911232,753373331410912257,'settlementtype',28,'0',' ','name','结算方式*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135040;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','0',' ',753373331368968192,753373331394135040,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135041;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394135041,'billno',4,'0',' ',' ','单据总编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134017;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134017,'billstatus',5,'0',' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135045;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394135045,'debitsum',11,'0',' ',' ','借方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134021;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134021,'creditsum',12,'0',' ',' ','贷方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135046;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394135046,'debitcurrencysum',13,'0',' ',' ','借方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134022;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134022,'creditcurrencysum',14,'0',' ',' ','贷方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134023;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134023,'direction',16,'0',' ',' ','方向'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331402522624;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331402522624,'auditdate',19,'0',' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331402523649;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331402523649,'createtime',20,'0',' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911232;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','0',' ',753373331368968192,753373331410911232,'manualentry',24,'0',' ',' ','单据体'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912256;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410912256,'sourcebillnumber',26,'0',' ',' ','单据编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911233;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331410911233,'billid',27,'0',' ',' ','单据ID'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911234;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410911234,'description',29,'0',' ',' ','摘要'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912258;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410912258,'bizdate',30,'1',' ',' ','业务日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911235;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410911235,'bookdate',31,'1',' ',' ','记账日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912259;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410912259,'debitamount',32,'0',' ',' ','借方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911236;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410911236,'creditamount',33,'0',' ',' ','贷方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912260;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410912260,'settlementnumber',34,'0',' ',' ','结算号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911237;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410911237,'oppbank',35,'0',' ',' ','对方银行'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912261;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410912261,'oppacctnumber',36,'0',' ',' ','对方账号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911238;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331410911232,753373331410911238,'oppunit',37,'0',' ',' ','对方单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912262;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331410912262,'vouchernumber',38,'0',' ',' ','凭证字号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331419300864;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331419300864,'creditcurrency',39,'0',' ',' ','贷方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205761214464;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,1387485205761214464,'id',3,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205761214473;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,1387485205761214473,'batchno',21,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205761215498;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,1387485205761215498,'modifytime',22,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205761214474;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,1387485205761214474,'modifier',23,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205811547136;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,1387485205811547136,'manualentry.id',25,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205811546119;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,1387485205811546119,'localamount',40,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1387485205811547144;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331410911232,1387485205811547144,'fundflowitem',41,'0',' ','name',NULL); 
