-- t_open_apiservice
DELETE FROM t_open_apiservice WHERE FID = 1503656646948180992;
INSERT INTO t_open_apiservice(FAPISERVICETYPE,FADDEDINFO,FAPIDEFTYPE,FOPERATION,FMASTERID,FORDER_BY_HIDE,FMUSTPARAM,FCREATETIME,FPRESCRIPT,ISFAILCONTINUE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FISVID,FOUTPUTPARAM,FFILTERPARAM,FCU_LIMIT_TAC,FISOUTPARAWITHOUTSTATUS,FREPTYPE,FPRESCRIPT_TAG,FISDYOBJRESULT,FMODIFIERID,FPLUGIN,FWSMETHODNAME,FURLFORMAT,FCUSTOMMETHOD,FISFAILCONTINUE,FISKSQL,FINPUTPARAM,FCONTENTTYPE,FSELECTPARAM,FMETHODNAME,FENABLE,FID,FVERSION,FADDEDINFO_TAG,FNAMESPACE,FDISABLEDATE,FURL,FSAVEOPERATION,FSTATUS,FNUMBER,FCUSTOMSORT,FMESSAGETYPE,FMODIFYTIME,FCLASSNAME,FAPPID,FHTTPMETHOD,FCREATORID,FCOSMICVER) VALUES ('0',' ',' ','query',1503656646948180992,' ',' ',{ts'2022-09-13 18:08:08'},' ','1',NULL,NULL,'fa_lease_rent_settle','0','kingdee',' ',' ',0,'0',NULL,NULL,'0',1,' ',' ','/v2/fa/fa_lease_rent_settle/getList',' ','0','0',' ','0','name,createorg,modifytime',' ','1',1503656646948180992,'2',' ',' ',NULL,NULL,' ','C','getList',0,NULL,{ts'2022-09-13 18:08:08'},' ','83bfebc800001aac','0',1,'5.0.010');

-- t_open_apiservice_L
DELETE FROM t_open_apiservice_l WHERE FPKID = '2POVS92367XK';
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1503656646948180992,' ','2POVS92367XK','zh_CN','摊销与计息查询');
DELETE FROM t_open_apiservice_l WHERE FPKID = '2POVS92367XL';
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1503656646948180992,' ','2POVS92367XL','zh_TW','攤銷與計息查詢');

-- t_open_apiheaderentry
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1535537936815463424;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1503656646948180992,'Content-Type',1535537936815463424,1,'application/json','内容格式');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1535537936815463425;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1503656646948180992,'accesstoken',1535537936815463425,2,'获取的accesstoken值','请求令牌');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1535537936815463426;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1503656646948180992,'Idempotency-Key',1535537936815463426,3,'1666250354557','可选参数，幂等性参数requestId');

-- t_open_apibodyentry
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1503649958878794752;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1503656646948180992,'"0001"',1503649958878794752,'TextProp','0','org.number','0','0','1','1','String',0,'核算组织.编码',1,' ','org_number');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1503651353711371264;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1503656646948180992,'"2022-09-13"',1503651353711371264,' ','0','start_settledate','1','0','0','1','String',0,'摊销开始日期',2,'"*"','start_settledate');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1503651780490187776;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1503656646948180992,'"2022-09-13"',1503651780490187776,' ','0','end_settledate','1','0','0','1','String',0,'摊销结束日期',3,'"*"','end_settledate');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1503687155912984576;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1503656646948180992,'"BepOd"',1503687155912984576,'TextProp','0','leasecontract.number','0','0','0','1','String',0,'合同号.合同号',4,'"*"','leasecontract_number');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1503709945194129408;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1503656646948180992,'"vkkQO"',1503709945194129408,'TextProp','0','billno','0','0','0','1','String',0,'单据编号',5,'"*"','billno');

-- t_open_apiqueryfilter
delete from t_open_apiqueryfilter where FENTRYID = 1503689211381991425;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, '0', 'EQUAL', 'Boolean', ' ', 'leasecontract.isbak', ' ', 1503689211381991425, '''0''', 4, ' ', '合同号.是否备份');
delete from t_open_apiqueryfilter where FENTRYID = 1503710270252689408;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, ' ', 'EQUAL', 'String', 'billno', 'billno', ' ', 1503710270252689408, ' ', 6, ')', '单据编号');
delete from t_open_apiqueryfilter where FENTRYID = 1503656646981735424;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, '0', 'EQUAL', 'String', 'org.number', 'org.number', ' ', 1503656646981735424, ' ', 1, ' ', '核算组织.编码');
delete from t_open_apiqueryfilter where FENTRYID = 1503691654463408128;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, '1', 'EQUAL', 'String', 'leasecontract.number', 'leasecontract.number', '(', 1503691654463408128, ' ', 5, ' ', '合同号.合同号');
delete from t_open_apiqueryfilter where FENTRYID = 1503656646981735425;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, '0', 'GREATEROREQUAL', 'Date', 'start_settledate', 'settledate', ' ', 1503656646981735425, ' ', 2, ' ', '摊销日期');
delete from t_open_apiqueryfilter where FENTRYID = 1503656646981735426;
insert into t_open_apiqueryfilter ( FID, FFILTERLINK, FFILTERCOMPARE, FFILTER_TYPE, FFILTERVALUE, FFILTERCOLUMN, FFILTERLEFTBRACKET, FENTRYID, FFILTER_CONSTANT, FSEQ, FFILTERRIGHTBRACKET, FFILTERLABEL) values ( 1503656646948180992, '0', 'LESSOREQUAL', 'Date', 'end_settledate', 'settledate', ' ', 1503656646981735426, ' ', 3, ' ', '摊销日期');

-- t_open_apirespentry
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222644003840;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222644003840,'0','"7IQVr"','billno','1',0,'0',2,'单据编号','1','TextProp','billno');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222669165568;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Date',1503656222669165568,'0','"2022-09-13"','settledate','1',0,'0',3,'摊销日期','1','DateProp','settledate');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222669169664;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Decimal',1503656222669169664,'0','"521.93"','rent','1',0,'0',4,'租金','1','AmountProp','rent');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677554176;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'DateTime',1503656222677554176,'0','"2022-09-13 18:08:08"','modifytime','1',0,'0',5,'修改时间','1','ModifyDateProp','modifytime');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677558272;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Integer',1503656222677558272,'0','16','interestdays','1',0,'0',6,'计息天数','1','IntegerProp','interestdays');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677554177;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'DateTime',1503656222677554177,'0','"2022-09-13 18:08:08"','createtime','1',0,'0',7,'创建时间','1','CreateDateProp','createtime');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677558273;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Decimal',1503656222677558273,'0','"387.59"','irr','1',0,'0',8,'实际日利率(%)','1','DecimalProp','irr');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677554178;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Decimal',1503656222677554178,'0','"9.51"','interest','1',0,'0',9,'利息费用','1','AmountProp','interest');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222677558274;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Decimal',1503656222677558274,'0','"514.83"','endleaseliab','1',0,'0',10,'期末租赁负债','1','AmountProp','endleaseliab');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685942784;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222685942784,'0','"1gApF"','org_name','1',0,'0',11,'核算组织.名称','1','MuliLangTextProp','org.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685946880;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222685946880,'0','"XNM3Q"','leasecontract_number','1',0,'0',12,'合同号.合同号','1','TextProp','leasecontract.number');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685942785;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222685942785,'0','"FSKWm"','creator_number','1',0,'0',13,'创建人.工号','1','TextProp','creator.number');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685946881;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Boolean',1503656222685946881,'0','false','leasecontract_isexempt','1',0,'0',14,'合同号.豁免','1','BooleanProp','leasecontract.isexempt');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685942786;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222685942786,'0','"Bsnfn"','creator_name','1',0,'0',15,'创建人.姓名','1','MuliLangTextProp','creator.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222685946882;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222685946882,'0','"6OhKx"','modifier_number','1',0,'0',16,'修改人.工号','1','TextProp','modifier.number');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656222694331392;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656222694331392,'0','"0R8xH"','modifier_name','1',0,'0',17,'修改人.姓名','1','MuliLangTextProp','modifier.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656502336971776;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'String',1503656502336971776,'0','"A"','sourcetype','1',0,'0',18,'来源类型','1','ComboProp','sourcetype');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503656502353744896;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Integer',1503656502353744896,'0','99','settledatemonth','1',0,'0',19,'本次结算月份','1','IntegerProp','settledatemonth');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1503686547982174208;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1503656646948180992,'Long',1503686547982174208,'0','"7654420544994653184"','id','1',0,'0',1,'id','1','LongProp','id');
