DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 864968750032642048;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FBIZOBJECT,FCREATORID) VALUES (864968750032642048,'1',864968750032642048,'C','cas_bankstatement_manual_IMPT_S',' ','IMPT',{ts'2020-04-08  10:15:42'},13466739,'1',{ts'2020-04-22  14:29:49'},' ','cas_bankstatement_manual',13466739);

DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0P7ZOGC349U5';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FNAME,FCOMMENT) VALUES (864968750032642048,'0P7ZOGC349U5','zh_CN','银行对账单_分录导入模板','出纳-银行对账单-分录导入模板');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0P7ZOGC349U6';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FNAME,FCOMMENT) VALUES (864968750032642048,'0P7ZOGC349U6','zh_TW','銀行對賬單_分錄導入模板','出納-銀行對賬單-分錄導入模板');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020725028864;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','0',' ',0,875233020725028864,'cas_bankstatement_manual',1,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020783628288;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','0',' ',875233020725028864,875233020783628288,'billhead',2,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020800526336;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020800526336,'billno',3,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020808794112;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020808794112,'billstatus',4,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020817303552;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1','number',875233020783628288,875233020817303552,'creator',5,'0',' ','name',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020833959936;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1','number',875233020783628288,875233020833959936,'auditor',6,'0',' ','name',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020842469376;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020842469376,'sourcebilltype',7,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020859125760;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1','number',875233020783628288,875233020859125760,'org',8,'0',' ','name',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020867635200;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1','number',875233020783628288,875233020867635200,'accountbank',9,'0',' ','name',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020884291584;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1','number',875233020783628288,875233020884291584,'currency',10,'0',' ','name',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020892801024;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020892801024,'debitamounttotal',11,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020901068800;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020901068800,'creditamounttotal',12,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020917966848;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020917966848,'auditdate',13,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233020926234624;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233020783628288,875233020926234624,'createtime',14,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021236733952;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','0',' ',875233020725028864,875233021236733952,'entryentity',15,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021253390336;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021253390336,'bizdate',16,'1',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021270288384;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021270288384,'description',17,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021278556160;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021278556160,'debitamount',18,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021295454208;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021295454208,'creditamount',19,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021303721984;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021303721984,'balanceamt',20,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021312231424;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021312231424,'oppunitname',21,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021328887808;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021328887808,'oppbank',22,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021337397248;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021337397248,'oppaccountnumber',23,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021354053632;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233021236733952,875233021354053632,'settlementtype',24,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021362563072;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233021236733952,875233021362563072,'settlementnumber',25,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021379219456;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021379219456,'bankcheckflag',26,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021387728896;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021387728896,'bankvouvherno',27,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021404385280;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233021236733952,875233021404385280,'sequencenumber',28,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021421283328;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'1','1',' ',875233021236733952,875233021421283328,'cashier',29,'0',' ',' ',null);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 875233021429551104;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (864968750032642048,'0','1',' ',875233021236733952,875233021429551104,'tradenumber',30,'0',' ',' ',null);
