/******  手工银行日记账编码规则 ******/
DELETE FROM t_cr_coderule WHERE FID = '0AR=RGAA2JY3';
INSERT INTO t_cr_coderule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0AR=RGAA2JY3','-','1',' ','1',null,'0AR=RGAA2JY3','C',' ',null,' ',{ts'2019-05-23  13:42:56'},'cas_bankjournal','1',0,'0',{ts'2019-05-23  13:43:00'},0,null);
DELETE FROM t_cr_coderule_l WHERE FID = '0AR=RGAA2JY3';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0AR=RGAA2JY3','0AR=RGAOL7/Y','zh_CN','手工银行日记账编码规则');
DELETE FROM t_cr_coderuleentry WHERE FID = '0AR=RGAA2JY3';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AR=RGAA2JY3',1,'1',' ','0','0BI7W8UTQKZZ',1,'1',' ',0,8,'1','SGRJZB',' ','1',' ','0',' ');
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AR=RGAA2JY3',1,'16','-','0','0BI7W8UTQL++',1,'1','1',1,8,'1',' ',' ','1',' ','1',' ');
/******  手工银行日记账编码规则 ******/

/******  手工现金日记账编码规则 ******/
DELETE FROM t_cr_coderule WHERE FID = '0AR=SGV3JQQZ';
INSERT INTO t_cr_coderule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('0AR=SGV3JQQZ','-','1',' ','1',null,'0AR=SGV3JQQZ','C',' ',null,' ',{ts'2019-05-23  13:42:56'},'cas_cashjournal','1',0,'0',{ts'2019-05-23  13:43:00'},0,null);
DELETE FROM t_cr_coderule_l WHERE FID = '0AR=SGV3JQQZ';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0AR=SGV3JQQZ','0AR=SGV3JRE8','zh_CN','手工现金日记账编码规则');
DELETE FROM t_cr_coderuleentry WHERE FID = '0AR=SGV3JQQZ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AR=SGV3JQQZ',1,'1',' ','0','0BI7WTLDI2UQ',1,'1',' ',0,8,'1','SGRJZB',' ','1',' ','0',' ');
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('0AR=SGV3JQQZ',1,'16','-','0','0BI7WTLDI2UR',1,'1','1',1,8,'1',' ',' ','1',' ','1',' ');
/******  手工现金日记账编码规则 ******/


/******  手工现金日记账报表模版 ******/
DELETE FROM t_bas_importtemplate WHERE FID = 753365526901689344;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (753365526901689344,'1',753365526901689344,'C','cas_manualcashjournal_IMPT_S',' ','IMPT',{ts'2019-11-06  10:40:34'},718773151755927552,'1',{ts'2019-11-06  10:42:49'},' ',718773151755927552,'cas_manualcashjournal'); 
DELETE FROM t_bas_importtemplate_L WHERE FPKID = '0BI=2P1C2704';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (753365526901689344,'0BI=2P1C2704','zh_CN',' ','现金日记账（手工）'); 
DELETE FROM t_bas_importtemplate_L WHERE FPKID = '0BI=2P1C2705';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (753365526901689344,'0BI=2P1C2705','zh_TW',' ','現金日記賬（手工）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395899226112;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','0',' ',0,753364395899226112,'cas_manualcashjournal',1,'0',' ',' ','现金日记账（手工）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780544;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780544,'auditdate',3,'0',' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780545;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780545,'sourcebilltype',5,'0',' ',' ','单据类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780546;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780546,'billstatus',7,'0',' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780547;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932780547,'auditor',9,'0',' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780548;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932780548,'org',11,'0',' ','name','组织'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780549;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932780549,'basecurrency',13,'0',' ','name','本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780550;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780550,'creditsum',15,'0',' ',' ','贷方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780551;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780551,'creditcurrencysum',17,'0',' ',' ','贷方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780552;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780552,'direction',19,'0',' ',' ','方向'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932780553;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932780553,'source',21,'0',' ',' ','来源*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','0',' ',753364395899226112,753364395932781568,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781569;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932781569,'createtime',4,'0',' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781570;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932781570,'billno',6,'0',' ',' ','单据总编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781571;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932781571,'creator',8,'0',' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781572;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1','number',753364395932781568,753364395932781572,'accountcash',10,'1',' ','name','现金账户*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781573;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932781573,'currency',12,'0',' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781574;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932781574,'debitsum',14,'0',' ',' ','借方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781575;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395932781568,753364395932781575,'debitcurrencysum',16,'0',' ',' ','借方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781576;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932781576,'orgid',18,'0',' ','name','临时组织'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781577;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932781577,'cashier',20,'0',' ','name','出纳'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395932781578;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395932781568,753364395932781578,'periodtype',22,'0',' ','name','期间类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169152;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','0',' ',753364395899226112,753364395941169152,'manualentry',23,'0',' ',' ','单据体'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169153;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941169153,'billid',25,'0',' ',' ','单据ID'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169154;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941169154,'description',27,'0',' ',' ','摘要'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169155;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941169155,'bookdate',29,'1',' ',' ','记账日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169156;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941169156,'creditamount',31,'0',' ',' ','贷方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169157;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941169157,'vouchernumber',33,'0',' ',' ','凭证字号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169158;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941169158,'debitcurrency',35,'0',' ',' ','借方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169159;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','0',' ',753364395899226112,753364395941169159,'entry',37,'0',' ',' ','资金用途分录'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169160;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169159,753364395941169160,'e_amount',39,'0',' ',' ','金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169161;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169159,753364395941169161,'e_oppunit',41,'0',' ',' ','对方单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169162;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395941169159,753364395941169162,'e_currency',43,'0',' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941169163;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169159,753364395941169163,'journalid',45,'0',' ',' ','单据ID'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170176;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941170176,'sourcebillnumber',24,'0',' ',' ','单据编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170177;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1','number',753364395941169152,753364395941170177,'settlementtype',26,'0',' ','name','结算方式*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170178;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941170178,'bizdate',28,'1',' ',' ','业务日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170179;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941170179,'debitamount',30,'0',' ',' ','借方金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170180;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1',' ',753364395941169152,753364395941170180,'oppunit',32,'0',' ',' ','对方单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170181;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941170181,'exchangerate',34,'0',' ',' ','汇率'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170182;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169152,753364395941170182,'creditcurrency',36,'0',' ',' ','贷方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170183;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'1','1','number',753364395941169159,753364395941170183,'e_fundflowitem',38,'0',' ','name','资金用途'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170184;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1',' ',753364395941169159,753364395941170184,'e_localamount',40,'0',' ',' ','折本位币金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170185;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395941169159,753364395941170185,'e_org',42,'0',' ','name','组织'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753364395941170186;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753365526901689344,'0','1','number',753364395941169159,753364395941170186,'e_accountcash',44,'0',' ','name','账户'); 



/******  手工银行日记账报表模版 ******/

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  10:58:20'},718773151755927552,'1',{ts'2019-11-06  11:00:01'},' ',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 = 753373331394134016;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134016,'sourcebilltype',3,'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 = 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 = 753373331394134019;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394134019,'org',9,'0',' ','name','组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134020;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394134020,'basecurrency',11,'0',' ','name','本位币'); 
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',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',15,'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',17,'0',' ',' ','方向'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394134024;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331394135040,753373331394134024,'source',19,'0',' ',' ','来源*'); 
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 = 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 = 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 = 753373331394135044;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331394135040,753373331394135044,'currency',10,'0',' ','name','币别'); 
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',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',14,'0',' ',' ','借方金额本位币'); 
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',16,'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',18,'0',' ','name','出纳'); 
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',21,'0',' ',' ','审核日期'); 
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',20,'0',' ','name','期间类型'); 
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',22,'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',23,'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',25,'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',27,'0',' ',' ','摘要'); 
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',29,'1',' ',' ','记账日期*'); 
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',31,'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',33,'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',35,'0',' ',' ','对方单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410911239;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331410911239,'ischeck',37,'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,'0','1',' ',753373331410911232,753373331410912256,'sourcebillnumber',24,'0',' ',' ','单据编号'); 
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',26,'0',' ','name','结算方式*'); 
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',28,'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',30,'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',32,'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',34,'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',36,'0',' ',' ','凭证字号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331410912263;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331410912263,'exchangerate',38,'0',' ',' ','汇率'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331419299840;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331410911232,753373331419299840,'debitcurrency',39,'0',' ',' ','借方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331419299841;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','0',' ',753373331368968192,753373331419299841,'entry',41,'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',40,'0',' ',' ','贷方金额本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427688448;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331419299841,753373331427688448,'e_amount',43,'0',' ',' ','金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427688449;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1',' ',753373331419299841,753373331427688449,'e_oppunit',45,'0',' ',' ','对方单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427688450;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331419299841,753373331427688450,'e_currency',47,'0',' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427688451;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331419299841,753373331427688451,'journalid',49,'0',' ',' ','单据ID'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427689472;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331419299841,753373331427689472,'e_fundflowitem',42,'0',' ','name','资金用途'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427689473;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1',' ',753373331419299841,753373331427689473,'e_localamount',44,'0',' ',' ','折本位币金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427689474;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331419299841,753373331427689474,'e_org',46,'0',' ','name','组织'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331427689475;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'0','1','number',753373331419299841,753373331427689475,'e_accountbank',48,'0',' ','name','账户'); 




