-- 预制库存查询、序列号状态查询、创建预留、释放预留API
DELETE FROM T_OPEN_APISERVICE WHERE FID=897004592192073728;
DELETE FROM T_OPEN_APISERVICE WHERE FID=896280174612546560;
DELETE FROM T_OPEN_APISERVICE WHERE FID=896281037313770496;
DELETE FROM T_OPEN_APISERVICE WHERE FID=897881261060678656;
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)
VALUES(897004592192073728, 'im_reservation_save_api', 13466739,  {ts'2020-05-22 15:06:44'}, 13466739,  {ts'2020-05-22 15:08:01'}, '1', NULL, NULL, NULL, ' ', '=9Q86DR2P+Q', 'C', '/app/im/im_reservation_save_api', ' ', '1', '0', 0, 0, '2', ' ', ' ', 897004592192073728, '[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvReserveCreateApiService","Enabled":true,"rowKey":null}]', '0');
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)
VALUES(896280174612546560, 'im_acc_query_api', 13466739,  {ts'2020-05-21 15:07:19'}, 13466739,  {ts'2020-05-21 15:08:42'}, '1', NULL, NULL, NULL, ' ', '=9Q86DR2P+Q', 'C', '/app/im/im_acc_query_api', ' ', '1', '0', 0, 0, '2', ' ', ' ', 896280174612546560, '[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvAccQueryApiService","Enabled":true,"rowKey":null}]', '0');
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)
VALUES(896281037313770496, 'im_querysnstatus_api', 13466739,  {ts'2020-05-21 15:10:01'}, 13466739,  {ts'2020-05-21 17:26:37'}, '1', NULL, NULL, NULL, ' ', '=9Q86DR2P+Q', 'C', '/app/im/im_querysnstatus_api', ' ', '1', '0', 0, 0, '2', ' ', ' ', 896281037313770496, '[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvQuerySnStatusApiService","Enabled":true,"rowKey":null}]', '0');
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)
VALUES(897881261060678656, 'im_reservation_delete_api', 13466739,  {ts'2020-05-23 20:09:05'}, 13466739,  {ts'2020-05-23 20:17:34'}, '1', NULL, NULL, NULL, ' ', '=9Q86DR2P+Q', 'C', '/app/im/im_reservation_delete_api', ' ', '1', '0', 0, 0, '2', ' ', ' ', 897881261060678656,'[{"ClassName":"kd.scmc.im.webapi.InvReserveDeleteApiService","Enabled":true,"RowKey":1}]', '0');


DELETE FROM T_OPEN_APISERVICE_L WHERE FID IN (897004592192073728,896280174612546560,896281037313770496,897881261060678656);
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T2+2=58NDFC', 896280174612546560, 'zh_CN', '获取库存账存余额', '库存余额查询服务API');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T2+2=58NDFD', 896280174612546560, 'zh_TW', '獲取庫存賬存餘額', '庫存餘額查詢服務API');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T2+8KAX9JCB', 896281037313770496, 'zh_CN', '查询序列号状态', '查询序列号状态');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T2+8KAX9JCC', 896281037313770496, 'zh_TW', '查詢序列號狀態', '查詢序列號狀態');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T5FF32DO3V+', 897004592192073728, 'zh_CN', '创建预留记录', '创建预留记录');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T5FF32DO3V/', 897004592192073728, 'zh_TW', '創建預留記錄', '創建預留記錄');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T9N8CSWSGMC', 897881261060678656, 'zh_CN', '释放预留记录', '释放预留记录');
INSERT INTO T_OPEN_APISERVICE_L (FPKID, FID, FLOCALEID, FDISCRIPTION, FNAME) VALUES('0T9N8CSWSGMD', 897881261060678656, 'zh_TW', '釋放預留記錄', '釋放預留記錄');
