-- 6、获取物料信息
DELETE FROM t_open_apiservice WHERE FID = 1269554418773147648;
DELETE FROM t_open_apiservice_l WHERE FPKID = '1ZY=SALESG1Z';
DELETE FROM t_open_apiservice_l WHERE FPKID = '1ZY=SALESG2+';
DELETE FROM t_open_apiservice_aicmd WHERE FID = 1269554418773147648;
DELETE FROM t_open_apiservice_aicmd_l WHERE FPKID = '1ZY=SALESG2/';
DELETE FROM t_open_apiservice_aicmd_l WHERE FPKID = '1ZY=SALESG20';

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)
VALUES(1269554418773147648, 'getMaterial', 1, {ts'2018-08-08 18:08:08'}, 1, {ts'2018-08-08 18:08:08'}, '1', NULL, NULL, NULL, ' ', '0efa1992000000ac', 'C', '/ai/do', ' ', '0', '0', 0, 0, '1', ' ', ' ', 1269554418773147648, '[{"FPK":"","Type":0,"Description":"AI平台同步物料","RowKey":0,"ClassName":"kd.bd.master.GetMaterialApiPlugin","DisplayName":"AI平台同步物料","Enabled":true,"BizAppId":"","Inherit":false}]', '0', '0', NULL, NULL, NULL);

INSERT INTO t_open_apiservice_l
(fpkid, fid, flocaleid, fdiscription, fname)
VALUES('1ZY=SALESG1Z', 1269554418773147648, 'zh_CN', ' ', '同步物料');
INSERT INTO t_open_apiservice_l
(fpkid, fid, flocaleid, fdiscription, fname)
VALUES('1ZY=SALESG2+', 1269554418773147648, 'zh_TW', ' ', '同步物料');

INSERT INTO t_open_apiservice_aicmd
(fid, fentryid, fseq, fainumber)
VALUES(1269554418773147648, 1269554418789924864, 1, 'getMaterialInfo');

INSERT INTO t_open_apiservice_aicmd_l
(fpkid, fentryid, flocaleid, fainame, faidescription)
VALUES('1ZY=SALESG2/', 1269554418789924864, 'zh_CN', '同步物料', 'AI平台同步物料主数据');
INSERT INTO t_open_apiservice_aicmd_l
(fpkid, fentryid, flocaleid, fainame, faidescription)
VALUES('1ZY=SALESG20', 1269554418789924864, 'zh_TW', '同步物料', 'AI平台同步物料主數據');
