DELETE FROM t_open_apiservice WHERE FID = 1389273844900099072;
INSERT INTO t_open_apiservice(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FISKSQL,FMASTERID,FCONTENTTYPE,FSELECTPARAM,FMUSTPARAM,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FFILTERPARAM,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ','0',1389273844900099072,'0','name,createorg,modifytime',' ',{ts'2022-04-01  00:00:00'},'1',NULL,NULL,' ','0',1389273844900099072,NULL,NULL,'C',' ','bei_elecstatement_save',NULL,NULL,13466739,'[{"FPK":"","Type":0,"Description":"电子对账单导入接口","RowKey":0,"ClassName":"kd.tmc.bei.webapi.openapi.ElecStatementSaveWebApiPlugin","DisplayName":"电子对账单导入接口","Enabled":true,"BizAppId":"","Inherit":false}]',{ts'2022-04-01  00:00:00'},'/LSWHQ7US+Q6','/app/bei/bei_elecstatement_save','1',13466739);

DELETE FROM T_OPEN_APISERVICE_L WHERE FID = 1389273844900099072;
INSERT INTO T_OPEN_APISERVICE_L (fpkid,fid,flocaleid,fdiscription,fname) VALUES ('2BMVUQRJO3ET',1389273844900099072,'zh_CN',' ','电子对账单导入接口');
INSERT INTO T_OPEN_APISERVICE_L	(fpkid,fid,flocaleid,fdiscription,fname) VALUES ('2BMVUQRJO3EU',1389273844900099072,'zh_TW',' ','電子對賬單導入接口');

DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1392795421411158016;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1389273844900099072,'Content-Type',1392795421411158016,1,'application/json','内容格式');
DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1392795421411158017;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1389273844900099072,'accesstoken',1392795421411158017,2,'获取的accesstoken值','请求令牌');

DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870033689263104;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'账户余额',' ',1389870033689263104,25,'acctAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870058494276608;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'对方账号',' ',1389870058494276608,26,'oppositeAcct');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870076991257600;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'对方户名',' ',1389870076991257600,27,'oppositeAcctName');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870094959555584;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'对方开户行',' ',1389870094959555584,28,'oppositeBank');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870131500432384;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'摘要',' ',1389870131500432384,29,'remark');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870151825929216;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'电子回单号',' ',1389870151825929216,30,'elecReceiptNo');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870173141482496;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'业务产品种类',' ',1389870173141482496,31,'bizProduct');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1391895086987589632;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389869084635608064,'0代表借方，1代表贷方',' ',1391895086987589632,22,'balanceDirection');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864112288316416;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389848235094457344,'所属期间，yyyy-mm',' ',1389864112288316416,8,'period');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1392795079894149120;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'文件地址',' ',1392795079894149120,17,'fileServicePath');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1391159460994720768;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389848235094457344,'银企接口bei，识别引入discern，手工新增manual',' ',1391159460994720768,16,'dateSource');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869084635608064;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','Array',1389848235094457344,'对账明细信息',' ',1389869084635608064,18,'statementDetails');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869123265248256;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389869084635608064,'记账流水',' ',1389869123265248256,19,'bookJournal');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869327762633728;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389869084635608064,'记账日期',' ',1389869327762633728,20,'bookDate');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869403964849152;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389869084635608064,'记账时间',' ',1389869403964849152,21,'bookTime');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869421656323072;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'借方金额，和贷方金额其中一个必填',' ',1389869421656323072,23,'debitAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869443072539648;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'贷方金额，和借方金额其中一个必填',' ',1389869443072539648,24,'creditAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870197501899776;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'原始凭证种类',' ',1389870197501899776,32,'sourceDocument');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870220226739200;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'原始凭证号码',' ',1389870220226739200,33,'sourceDocumentNo');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870241458205696;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'交易代码',' ',1389870241458205696,34,'transactionCode');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870281236984832;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'记账柜员',' ',1389870281236984832,35,'bookkeeper');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389870312719531008;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389869084635608064,'其他记账信息',' ',1389870312719531008,36,'otherBookInfo');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389848235094457344;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','Array',0,' ',' ',1389848235094457344,1,'data');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389863913553804288;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389848235094457344,'银行账号',' ',1389863913553804288,2,'accountBank');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389868947943240704;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'期末保留余额',' ',1389868947943240704,12,'endRetainAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389868967941782528;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'期末冻结余额',' ',1389868967941782528,13,'endFreezeAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389868986874770432;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'期末透支余额',' ',1389868986874770432,14,'endOverdraftAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389869006294498304;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'期末可用余额',' ',1389869006294498304,15,'endAvailableAmount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389863965965726720;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389848235094457344,'账户名称',' ',1389863965965726720,3,'accountBankName');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864000266845184;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'签发机构',' ',1389864000266845184,4,'identificationIssuer');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864021557031936;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'营业网点编号',' ',1389864021557031936,5,'bankBranchNumber');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864055321279488;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'银行客户编码',' ',1389864055321279488,6,'bankCustomerCode');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864088464569344;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'1','String',1389848235094457344,'币别',' ',1389864088464569344,7,'currency');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389864134476084224;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','Long',1389848235094457344,'打印次数',' ',1389864134476084224,9,'printCount');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389868908189627392;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'打印日期',' ',1389868908189627392,10,'printDate');
DELETE FROM T_OPEN_APIBODYENTRY WHERE FENTRYID = 1389868925839358976;
INSERT INTO T_OPEN_APIBODYENTRY(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1389273844900099072,'0','String',1389848235094457344,'期末账户余额',' ',1389868925839358976,11,'endAcctAmount');

DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1392795421411158016;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1389273844900099072,'Content-Type',1392795421411158016,1,'application/json','内容格式');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1392795421411158017;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1389273844900099072,'accesstoken',1392795421411158017,2,'获取的accesstoken值','请求令牌');

DELETE FROM t_open_apirespentry WHERE FENTRYID = 1401546563414675456;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1389273844900099072,'message','1','String',0,1401546563414675456,1,'保存电子对账单成功。',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1401546828972860416;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1389273844900099072,'errorCode','1','String',0,1401546828972860416,2,' ',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1401546898061414400;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1389273844900099072,'success','1','Boolean',0,1401546898061414400,3,'true',' ');


