DELETE FROM t_open_apiservice WHERE fid=1529040574664376320;

INSERT INTO t_open_apiservice
(fid, fnumber, fcreatorid, fcreatetime, fmodifierid, fmodifytime, fenable, fdisablerid, fdisabledate, fmessagetype, fbizobject, fappid, fstatus, furlformat, furl, fhttpmethod, fcontenttype, freqtype, freptype, fapiservicetype, foperation, fcustommethod, fmasterid, fplugin, fallowguest, fisksql, fselectparam, ffilterparam, fmustparam, fversion, fcustomsort, forder_by_hide, fsaveoperation, fisfailcontinue, isfailcontinue, fisdyobjresult, fcu_limit_tac, faddedinfo, faddedinfo_tag, fisvid, fclassname, fmethodname, fnamespace, fapideftype, finputparam, foutputparam, fwsmethodname, fprescript, fprescript_tag, fisoutparawithoutstatus, fcosmicver, fstdmodifytime, forg_author_filter)
VALUES(1529040574664376320, 'gl_voucher_query', 1, {ts'2022-10-11 15:59:49'}, 1, {ts'2022-10-11 15:59:49'}, '1', NULL, NULL, NULL, ' ', '3815fd110001feac', 'C', '/app/ai/gl_voucher_query', NULL, '1', '0', NULL, NULL, '2', ' ', ' ', 1529040574664376320, '[{"FPK":"","Type":0,"Description":"kd.fi.ai.api.QueryGlVoucherApiService","RowKey":0,"ClassName":"kd.fi.ai.api.QueryGlVoucherApiService","DisplayName":"","Enabled":true,"BizAppId":"","Inherit":false}]', '0', '0', 'name,createorg,modifytime', ' ', ' ', ' ', 0, ' ', NULL, '1', '1', '0', 0, ' ', NULL, ' ', ' ', ' ', ' ', '0', ' ', ' ', ' ', ' ', NULL, '0', '5.0.002', {ts'2022-10-11 15:59:49'}, '0');

DELETE FROM t_open_apiservice_l WHERE fpkid='2STGNHQ6HTZC';
DELETE FROM t_open_apiservice_l WHERE fpkid='2STGNHQ6HTZD';

INSERT INTO t_open_apiservice_l (fpkid, fid, flocaleid, fdiscription, fname) VALUES ('2STGNHQ6HTZC', 1529040574664376320, 'zh_CN', '通过单据id查询总账凭证号', '查询凭证号');
INSERT INTO t_open_apiservice_l (fpkid, fid, flocaleid, fdiscription, fname) VALUES ('2STGNHQ6HTZD', 1529040574664376320, 'zh_TW', '通過單據id查詢總賬憑證號', '查詢憑證號');

DELETE FROM t_open_apiheaderentry
WHERE fentryid=1533903504358248448;
DELETE FROM t_open_apiheaderentry
WHERE fentryid=1533903504358248449;
INSERT INTO t_open_apiheaderentry
(fentryid, fid, fseq, fheadername, fheadervalue, fheaderdes)
VALUES(1533903504358248448, 1529040574664376320, 1, 'Content-Type', 'application/json', '内容格式');
INSERT INTO t_open_apiheaderentry
(fentryid, fid, fseq, fheadername, fheadervalue, fheaderdes)
VALUES(1533903504358248449, 1529040574664376320, 2, 'accesstoken', '获取的accesstoken值', '请求令牌');

DELETE FROM t_open_apibodyentry
WHERE fentryid=1529038246347505664;
DELETE FROM t_open_apibodyentry
WHERE fentryid=1529036124918874112;
INSERT INTO t_open_apibodyentry
(fentryid, fid, fseq, fparamname, fparamtype, fmust, fexample, fbodyparamdes, fparententryid, fobjpropname, fbody_level, fis_body_custom, fis_unique_key, fbody_data_model, fis_mul_value, fdefaultvalue)
VALUES(1529038246347505664, 1529040574664376320, 2, 'billtype', 'String', '1', '"billtype":"test_buildvoucher"', '单据类型', 0, ' ', ' ', '0', '0', ' ', '0', ' ');
INSERT INTO t_open_apibodyentry
(fentryid, fid, fseq, fparamname, fparamtype, fmust, fexample, fbodyparamdes, fparententryid, fobjpropname, fbody_level, fis_body_custom, fis_unique_key, fbody_data_model, fis_mul_value, fdefaultvalue)
VALUES(1529036124918874112, 1529040574664376320, 1, 'sourcebillid', 'Object', '1', '"sourcebillid":[1297088369276225014,1297088369276225013,1297089294866843485]', 'long类型的单据id集合', 0, ' ', ' ', '0', '0', ' ', '0', ' ');

DELETE FROM t_open_apirespentry
WHERE fentryid=1529560856718192640;
DELETE FROM t_open_apirespentry
WHERE fentryid=1529561122226024448;
DELETE FROM t_open_apirespentry
WHERE fentryid=1529561474195115008;
DELETE FROM t_open_apirespentry
WHERE fentryid=1529561476141395968;
INSERT INTO t_open_apirespentry
(fentryid, fid, fseq, frespparamname, frespparamtype, frespparammust, frespexample, frespdes, fparententryid, frespobjpropname, fresp_level, fis_resp_custom, fresp_data_model, fis_resp_mul_value)
VALUES(1529560856718192640, 1529040574664376320, 1, 'data', 'String', '1', '[{"1297089294866843485":"123-1365-00232284"}]', ' ', 0, ' ', ' ', '0', ' ', '0');
INSERT INTO t_open_apirespentry
(fentryid, fid, fseq, frespparamname, frespparamtype, frespparammust, frespexample, frespdes, fparententryid, frespobjpropname, fresp_level, fis_resp_custom, fresp_data_model, fis_resp_mul_value)
VALUES(1529561122226024448, 1529040574664376320, 2, 'success', 'Boolean', '1', 'true', ' ', 0, ' ', ' ', '0', ' ', '0');
INSERT INTO t_open_apirespentry
(fentryid, fid, fseq, frespparamname, frespparamtype, frespparammust, frespexample, frespdes, fparententryid, frespobjpropname, fresp_level, fis_resp_custom, fresp_data_model, fis_resp_mul_value)
VALUES(1529561474195115008, 1529040574664376320, 3, 'status', 'Boolean', '1', 'true', ' ', 0, ' ', ' ', '0', ' ', '0');
INSERT INTO t_open_apirespentry
(fentryid, fid, fseq, frespparamname, frespparamtype, frespparammust, frespexample, frespdes, fparententryid, frespobjpropname, fresp_level, fis_resp_custom, fresp_data_model, fis_resp_mul_value)
VALUES(1529561476141395968, 1529040574664376320, 4, 'errorCode', 'String', '1', 'success', ' ', 0, ' ', ' ', '0', ' ', '0');





