--------------------------------------------------------物料保存API预置数据---------------------------------------------------------------------------------------------

--物料保存API预置数据-基本信息
DELETE FROM t_open_apiservice WHERE fid = 1189204643188619264;
INSERT INTO t_open_apiservice(fid,fapiservicetype,fcustommethod,foperation,fmasterid,fstatus,fcontenttype,fnumber,fcreatetime,fmodifierid,fenable,fplugin,fmodifytime,fappid,furlformat,fhttpmethod,fcreatorid,fallowguest,fbizobject) VALUES (1189204643188619264,'0',' ','batchsave',1189204643188619264,'C','0','bd_material_batchsave',{ts'2018-8-8 18:08:08'},1,'1',' ',{ts'2018-8-8 18:08:08'},'0efa1992000000ac','/sys/bd_material/batchsave','1',1,'0','bd_material'); 
DELETE FROM t_open_apiservice_l WHERE FID = 1189204643188619264;
INSERT INTO t_open_apiservice_l(FPKID,FID,FLOCALEID,FNAME,FDISCRIPTION) VALUES ('1Q1BRWDB61I8',1189204643188619264,'zh_CN','保存物料信息','保存物料信息');
INSERT INTO t_open_apiservice_l(FPKID,FID,FLOCALEID,FNAME,FDISCRIPTION) VALUES ('1Q1BRWDB61I9',1189204643188619264,'zh_TW','保存物料信息','保存物料信息');

--物料保存API预置数据-请求头
DELETE FROM t_open_apiheaderentry WHERE fentryid = 1189204643213785088;
INSERT INTO t_open_apiheaderentry(fid,fheadername,fentryid,fseq,fheaderdes,fheadervalue) VALUES (1189204643188619264,'api',1189204643213785088,1,'固定值','true'); 
DELETE FROM t_open_apiheaderentry WHERE fentryid = 1189204643213785089;
INSERT INTO t_open_apiheaderentry(fid,fheadername,fentryid,fseq,fheaderdes,fheadervalue) VALUES (1189204643188619264,'tenantAlias',1189204643213785089,2,'租户ID，以实际为准','tenant_devother_dev'); 
DELETE FROM t_open_apiheaderentry WHERE fentryid = 1189204643213785090;
INSERT INTO t_open_apiheaderentry(fid,fheadername,fentryid,fseq,fheaderdes,fheadervalue) VALUES (1189204643188619264,'Content-Type',1189204643213785090,3,'固定值','application/json;charset=utf-8'); 
DELETE FROM t_open_apiheaderentry WHERE fentryid = 1189238284602095616;
INSERT INTO t_open_apiheaderentry(fid,fheadername,fentryid,fseq,fheaderdes,fheadervalue) VALUES (1189204643188619264,'access_token',1189238284602095616,4,'认证码，每次需要从苍穹获取','1150102438640877568_vf2lfhqSL7nU9h2HeAR4QbZ0E0hTng'); 

--物料保存API预置数据-请求体
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189627782150272000;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Array',0,'请求数据',' ',1189627782150272000,1,'datas'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189628216353010688;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189627782150272000,'编码','openapi-mt0108',1189628216353010688,2,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189629374903661568;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189627782150272000,'名称','openapi新增测试',1189629374903661568,3,'name'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189629652356871168;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189627782150272000,'创建组织',' ',1189629652356871168,4,'createorg'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189629852123183104;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189629652356871168,'创建组织编码','00',1189629852123183104,5,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189630485546972160;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189627782150272000,'基本单位',' ',1189630485546972160,6,'baseunit'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189630610763724800;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189630485546972160,'基本单位编码','g',1189630610763724800,7,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189630842918450176;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189627782150272000,'物料类型','1',1189630842918450176,8,'materialtype'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189633169565987840;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189627782150272000,'可采购','1',1189633169565987840,9,'enablepur'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189633502425954304;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189627782150272000,'可销售','1',1189633502425954304,10,'enablesale'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189633786866873344;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189627782150272000,'可库存','1',1189633786866873344,11,'enableinv'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189633953707898880;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189627782150272000,'启用辅助属性','1',1189633953707898880,12,'isuseauxpty'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189634233669301248;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','Array',1189627782150272000,'辅助属性分录',' ',1189634233669301248,13,'auxptyentry'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189634552360908800;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189634233669301248,'辅助属性',' ',1189634552360908800,14,'auxpty'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189635319943705600;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189634552360908800,'辅助属性编码','FZSX-0001',1189635319943705600,15,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189635536067803136;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189634233669301248,'影响库存','1',1189635536067803136,16,'isaffectinv'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189635867761751040;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189634233669301248,'影响成本','1',1189635867761751040,17,'isaffectprice'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189636385137539072;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','String',1189634233669301248,'影响计划','1',1189636385137539072,18,'isaffectplan'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189636671683998720;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'0','Array',1189627782150272000,'单位信息分录',' ',1189636671683998720,19,'entryentity'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189637179312224256;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','int',1189636671683998720,'源单位换算系数','1',1189637179312224256,20,'denominator'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189637967992371200;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189636671683998720,'源单位',' ',1189637967992371200,21,'measureunitid'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189638191968203776;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189637967992371200,'源单位编码','cm',1189638191968203776,22,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189638498278225920;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','int',1189636671683998720,'基本单位换算系数','1',1189638498278225920,23,'numerator'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189638775370724352;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189636671683998720,'基本单位',' ',1189638775370724352,24,'desmuid'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189638972654008320;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189638775370724352,'基本单位编码','g',1189638972654008320,25,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189639187217822720;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189636671683998720,'换算类型','1',1189639187217822720,26,'converttype'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189639887012280320;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Array',1189627782150272000,'分类标准分录',' ',1189639887012280320,27,'entry_groupstandard'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189640258560504832;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189639887012280320,'分类标准',' ',1189640258560504832,28,'standardid'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189640461984249856;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189640258560504832,'分类标准编码','JBFLBZ',1189640461984249856,29,'number'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189640674308305920;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','Object',1189639887012280320,'分类',' ',1189640674308305920,30,'groupid'); 
DELETE FROM t_open_apibodyentry WHERE fentryid = 1189640995591993344;
INSERT INTO t_open_apibodyentry(fid,fmust,fparamtype,fparententryid,fbodyparamdes,fexample,fentryid,fseq,fparamname) VALUES (1189204643188619264,'1','String',1189640674308305920,'分类编码','waitgroup',1189640995591993344,31,'number'); 

--物料保存API预置数据-返回体
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083596290;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'data','1','Array',0,1189204010083596290,1,' ','返回数据'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083596291;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'dindex','1','int',1189204010083596290,1189204010083596291,2,'0','下标'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083595264;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'number','1','String',1189204010083596290,1189204010083595264,3,'openapi-mt0108','物料编码'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083595265;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'orgnumber','1','String',1189204010083596290,1189204010083595265,4,'00','组织编码'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083595267;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'success','1','Boolean',1189204010083596290,1189204010083595267,5,'true','保存结果'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083596289;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'id','1','Long',1189204010083596290,1189204010083596289,6,'988210587798386688','保存成功的物料id'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083595266;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'success','1','Boolean',0,1189204010083595266,7,'true','保存结果'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083595268;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'errorCode','0','String',0,1189204010083595268,8,' ','错误码'); 
DELETE FROM t_open_apirespentry WHERE fentryid = 1189204010083596288;
INSERT INTO t_open_apirespentry(fid,frespparamname,frespparammust,frespparamtype,fparententryid,fentryid,fseq,frespexample,frespdes) VALUES (1189204643188619264,'message','0','String',0,1189204010083596288,9,' ','错误信息'); 
