-- 预制库存查询、序列号状态查询、创建预留、释放预留API、预制批量审核生产入库单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;
DELETE FROM T_OPEN_APISERVICE WHERE FID=909381001317308416;

INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',897004592192073728,'0',{ts'2018-08-08  18:08:08'},'0',0,NULL,' ','0',897004592192073728,NULL,' ','A','im_reservation_save_api',0,NULL,1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvReserveCreateApiService","Enabled":true,"rowKey":null}]',{ts'2018-08-08  18:08:08'},'=9Q86DR2P+Q','/app/im/im_reservation_save_api','1',1); 
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',896280174612546560,'0',{ts'2018-08-08  18:08:08'},'0',0,NULL,' ','0',896280174612546560,NULL,' ','A','im_acc_query_api',0,NULL,1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvAccQueryApiService","Enabled":true,"rowKey":null}]',{ts'2018-08-08  18:08:08'},'=9Q86DR2P+Q','/app/im/im_acc_query_api','0',1); 
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',896281037313770496,'0',{ts'2018-08-08  18:08:08'},'0',0,NULL,' ','0',896281037313770496,NULL,' ','A','im_querysnstatus_api',0,NULL,1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvQuerySnStatusApiService","Enabled":true,"rowKey":null}]',{ts'2018-08-08  18:08:08'},'=9Q86DR2P+Q','/app/im/im_querysnstatus_api','0',1); 
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',897881261060678656,'0',{ts'2018-08-08  18:08:08'},'0',0,NULL,' ','0',897881261060678656,NULL,' ','A','im_reservation_delete_api',0,NULL,1,'[{"ClassName":"kd.scmc.im.webapi.InvReserveDeleteApiService","Enabled":true,"RowKey":1}]',{ts'2018-08-08  18:08:08'},'=9Q86DR2P+Q','/app/im/im_reservation_delete_api','1',1); 
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('2',' ',' ',909381001317308416,'0',{ts'2018-08-08  18:08:08'},'0',0,NULL,' ','0',909381001317308416,NULL,' ','A','im_productinbill_batchaudit_api',0,NULL,1,'[{"Type":0,"_Type_":"Plugin","RowKey":1,"ClassName":"kd.scmc.im.webapi.InvProductInBatchApiService","Enabled":true,"rowKey":null}]',{ts'2018-08-08  18:08:08'},'=9Q86DR2P+Q','/app/im/im_productinbill_batchaudit_api','1',1); 



DELETE FROM T_OPEN_APISERVICE_L WHERE FID IN (897004592192073728,896280174612546560,896281037313770496,897881261060678656,909381001317308416);

INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (897004592192073728,'创建预留记录','0T5FF32DO3V+','zh_CN','创建预留记录'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (897004592192073728,'創建預留記錄','0T5FF32DO3V/','zh_TW','創建預留記錄'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (896280174612546560,'获取库存账存余额','0T2+2=58NDFC','zh_CN','库存余额查询服务'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (896280174612546560,'獲取庫存賬存餘額','0T2+2=58NDFD','zh_TW','庫存餘額查詢服務'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (896281037313770496,'查询序列号状态','0T2+8KAX9JCB','zh_CN','查询序列号状态'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (896281037313770496,'查詢序列號狀態','0T2+8KAX9JCC','zh_TW','查詢序列號狀態');
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (897881261060678656,'释放预留记录','0T9N8CSWSGMC','zh_CN','释放预留记录'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (897881261060678656,'釋放預留記錄','0T9N8CSWSGMD','zh_TW','釋放預留記錄');
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (909381001317308416,'生产入库单据批量审核服务','0UOQXSTMY2T=','zh_CN','生产入库单据批量审核服务'); 
INSERT INTO T_OPEN_APISERVICE_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (909381001317308416,'生產入庫單據批量審核服務','0UOQXSTMY2TA','zh_TW','生產入庫單據批量審核服務'); 
 

