DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 539650586916698112;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (539650586916698112,'1',539650586916698112,'A','cas_bankstatement_IMPT_S','null','IMPT',{ts'2018-08-08  18:08:08'},13466739,'1',{ts'2019-11-06  21:49:54'},'null',1,'cas_bankstatement'); 

DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '/O9DCKGYYOZC';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (539650586916698112,'/O9DCKGYYOZC','zh_CN',' ','银行对账单导入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '/O9DCKGYYOZD';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (539650586916698112,'/O9DCKGYYOZD','zh_TW',' ','銀行對賬單導入模板'); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279168;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','0',' ',753699548941111296,753699548966279168,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277120;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1','number',753699548966279168,753699548966277120,'org',3,'1',' ','name','组织*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279169;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1','number',753699548966279168,753699548966279169,'accountbank',4,'1',' ','name','银行账户'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277121;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1','number',753699548966279168,753699548966277121,'currency',5,'1',' ','name','币别'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279170;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1','number',753699548966279168,753699548966279170,'period',6,'0',' ','name','期间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277122;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277122,'bizdate',7,'1',' ',' ','日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279171;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1','number',753699548966279168,753699548966279171,'settlementtype',8,'0',' ','name','结算方式'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277123;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277123,'settlementnumber',9,'0',' ',' ','结算号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279172;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966279172,'debitamount',10,'0',' ',' ','借方金额'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277124;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277124,'creditamount',11,'0',' ',' ','贷方金额'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279173;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966279173,'sequencenumber',12,'0',' ',' ','顺序号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277125;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277125,'tradenumber',13,'0',' ',' ','交易号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279174;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966279174,'cashier',14,'0',' ',' ','柜员'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277126;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277126,'vouchernumber',15,'0',' ',' ','凭证号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279175;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966279175,'oppunit',16,'0',' ',' ','对方单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277127;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277127,'oppaccountnumber',17,'0',' ',' ','对方账号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279176;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966279176,'oppbank',18,'0',' ',' ','对方银行'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277128;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277128,'description',19,'0',' ',' ','摘要'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279177;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279177,'biztype',20,'0',' ',' ','业务类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277129;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277129,'auditdate',21,'0',' ',' ','审核日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279178;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279178,'createtime',22,'0',' ',' ','创建时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277130;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1','number',753699548966279168,753699548966277130,'creator',23,'0',' ','name','创建人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279179;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1','number',753699548966279168,753699548966279179,'auditor',24,'0',' ','name','审核人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277131;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277131,'sourcebillid',25,'0',' ',' ','源单ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279180;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279180,'billno',26,'0',' ',' ','单据编号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277132;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277132,'billstatus',27,'0',' ',' ','单据状态'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279181;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279181,'direction',28,'0',' ',' ','方向'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277133;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1',' ',753699548966279168,753699548966277133,'balanceamt',29,'0',' ',' ','余额'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279182;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279182,'source',30,'0',' ',' ','来源'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277134;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277134,'ischeck',31,'0',' ',' ','是否勾对'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279183;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279183,'bankcheckflag',32,'0',' ',' ','对账标识码'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277135;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277135,'bankvouvherno',33,'0',' ',' ','银行流水号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966279184;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966279184,'imageno',34,'0',' ',' ','影像编号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277136;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','1',' ',753699548966279168,753699548966277136,'isarchive',35,'0',' ',' ','是否归档'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548941111296;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'0','0',' ',0,753699548941111296,'cas_bankstatement',1,'0',' ',' ','银行对账单'); 
