--------------------------------------------
----          租赁合同付款计划保存API          ----
--------------------------------------------

-- 主表
DELETE FROM t_open_apiservice WHERE FID = 1271009903799960576;
INSERT INTO t_open_apiservice(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,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 ('0',' ','save',1271009903799960576,'0','name,createorg,modifytime',' ',{ts'2018-08-08 18:08:08'},'1',NULL,NULL,'fa_lease_pay_plan','0',1271009903799960576,NULL,NULL,'C',' ','fa_update_payplan',NULL,NULL,1,' ', {ts'2018-08-08 18:08:08'},'83bfebc800001aac','/sys/fa_lease_pay_plan/save','1',1244720647309918208);

-- 多语言表
DELETE FROM t_open_apiservice_l WHERE FID = 1271009903799960576;
INSERT INTO t_open_apiservice_l (fpkid,fid,flocaleid,fdiscription,fname) VALUES ('2+39QE=2G7EQ',1271009903799960576,'zh_CN',' ','更新付款计划');
INSERT INTO t_open_apiservice_l (fpkid,fid,flocaleid,fdiscription,fname) VALUES ('2+39QE=2G7ER',1271009903799960576,'zh_TW',' ','更新付款計劃');

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

-- 请求体
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1271008792762385408;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1271009903799960576,'1','String',0,'实际未付金额',' ',1271008792762385408,2,'real_unpay');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1271021161186190336;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1271009903799960576,'1','Long',0,'id',' ',1271021161186190336,1,'id');

-- 返回参数
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236195252184845312;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'data','1','Array',0,1236195252184845312,1,' ',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236195404203202560;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'dindex','1','int',1236195252184845312,1236195404203202560,2,'0',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236196990472195072;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'number','1','String',1236195252184845312,1236196990472195072,3,'ZLHT-F01-0001',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236197113004595200;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'orgnumber','1','String',1236195252184845312,1236197113004595200,4,'Org-00027',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236197463547743232;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'success','1','Boolean',1236195252184845312,1236197463547743232,5,'true',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236197600735041536;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'id','1','Long',1236195252184845312,1236197600735041536,6,'1236194235921766400',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236198250105572352;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'success','1','Boolean',0,1236198250105572352,7,'true',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236198427524634624;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'errorCode','1','String',0,1236198427524634624,8,'success',' ');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1236198526526983168;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1236161240766647296,'message','1','String',0,1236198526526983168,9,' ',' ');