--------------------------------------------------------生成物料和物料业务信息(自定义服务)API预置数据---------------------------------------------------------------------------------------------

--基本信息
DELETE FROM t_open_apiservice WHERE FID = 1229795730957289472;
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 (1229795730957289472,'2',' ',' ',1229795730957289472,'C','0','bd_material_bizinfo_generate',{ts'2018-08-08 18:08:08'},1,'1','[{"FPK":"","Type":0,"Description":"生成物料和物料业务信息API插件","RowKey":0,"ClassName":"kd.bd.master.GenerateMaterialAndBizInfoApiService","DisplayName":"生成物料和物料业务信息API插件","Enabled":true,"BizAppId":"","Inherit":false}]',{ts'2018-08-08 18:08:08'},'0efa1992000000ac','/app/basedata/bd_material_bizinfo_generate','1',1,'0',' '); 
DELETE FROM t_open_apiservice_l WHERE FID = 1229795730957289472;
INSERT INTO t_open_apiservice_l(FPKID,FID,FLOCALEID,FNAME,FDISCRIPTION) VALUES ('1V0U0FB2V2+F',1229795730957289472,'zh_CN','生成物料和物料业务信息','生成物料和物料业务信息');
INSERT INTO t_open_apiservice_l(FPKID,FID,FLOCALEID,FNAME,FDISCRIPTION) VALUES ('1V0U0FB2V2+G',1229795730957289472,'zh_TW','生成物料和物料業務信息','生成物料和物料業務信息');

--请求头
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1229795730965678080;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1229795730957289472,'Content-Type',1229795730965678080,2,'内容格式','application/json;charset=utf-8'); 
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1229795730965678081;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1229795730957289472,'access_token',1229795730965678081,3,'认证码，每次需要从苍穹获取','1150102438640877568_vf2lfhqSL7nU9h2HeAR4QbZ0E0hTng'); 
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1229806505637726208;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1229795730957289472,'api',1229806505637726208,1,'固定值','true'); 

--请求体
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747400;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Array',0,'请求数据',' ',1229772315122747400,1,'data'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731017;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'主键，更新时需赋值','1229729199061747712',1229772315122731017,2,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731030;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'编码','zcw202006806',1229772315122731030,3,'number'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747404;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'名称','测试物料01',1229772315122747404,4,'name'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747393;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747400,'创建人',' ',1229772315122747393,5,'creator'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747425;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122731015,'默认税率(%)id','1',1229772315122747425,56,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731038;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Array',1229772315122747400,'分类标准',' ',1229772315122731038,57,'entry_groupstandard'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747424;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122731038,'分类标准',' ',1229772315122747424,58,'standardid'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747402;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747424,'分类标准id','730148448254487552',1229772315122747402,59,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731023;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122731038,'分类',' ',1229772315122731023,60,'groupid'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747420;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122731023,'分类id','1',1229772315122747420,61,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731034;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'启用版本管理','0',1229772315122731034,62,'isenablematerialversion'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731018;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'备件','0',1229772315122731018,63,'sparepart'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731022;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'辅助单位',' ',1229772315122731022,64,'auxptyunit'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731020;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122731022,'辅助单位id','10',1229772315122731020,65,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731031;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'换算方向','A',1229772315122731031,66,'unitconvertdir'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747392;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'简拼','wl',1229772315122747392,67,'simplepinyin'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731009;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'整机标识','0',1229772315122731009,68,'completetag'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731019;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'Offering',' ',1229772315122731019,69,'offeringcode'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731036;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122731019,'Offering编码','MATE40-ST',1229772315122731036,70,'number'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731012;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可质检','0',1229772315122731012,71,'enableinspect'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747401;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747410,'源单位',' ',1229772315122747401,72,'measureunitid'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731025;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747401,'源单位id','1',1229772315122731025,73,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731037;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747393,'创建人id','403700558952663057',1229772315122731037,6,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747411;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747400,'修改人',' ',1229772315122747411,7,'modifier'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747403;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747411,'修改人id','403700558952663057',1229772315122747403,8,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747422;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'创建时间，格式yyyy-mm-dd hh:mm:ss','2020-07-12 21:05:36',1229772315122747422,9,'createtime'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731040;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'修改时间，格式yyyy-mm-dd hh:mm:ss','2020-08-08 21:05:36',1229772315122731040,10,'modifytime'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747421;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747400,'创建组织',' ',1229772315122747421,11,'createorg'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731026;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747421,'创建组织id','100000',1229772315122731026,12,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747396;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'控制策略','5',1229772315122747396,13,'ctrlstrategy'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731024;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747400,'基本单位',' ',1229772315122731024,14,'baseunit'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731014;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122731024,'基本单位id','1',1229772315122731014,15,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747395;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'描述','描述',1229772315122747395,16,'description'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731041;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'助记码','助记码',1229772315122731041,17,'helpcode'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747394;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'规格型号','V1',1229772315122747394,18,'modelnum'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747410;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Array',1229772315122747400,'单位信息分录',' ',1229772315122747410,19,'entryentity'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747413;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747410,'源单位换算系数','1',1229772315122747413,20,'denominator'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747408;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747410,'基本单位换算系数','1',1229772315122747408,21,'numerator'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747429;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747410,'换算类型','1',1229772315122747429,22,'converttype'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747409;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747400,'物料类型，默认值：常规','1',1229772315122747409,23,'materialtype'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731044;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'物料危险性','2',1229772315122731044,24,'hazardous'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731011;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可采购','0',1229772315122731011,25,'enablepur'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731043;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可销售','0',1229772315122731043,26,'enablesale'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747423;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可库存','0',1229772315122747423,27,'enableinv'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747405;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可生产','0',1229772315122747405,28,'enableproduct'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731010;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可资产','0',1229772315122731010,29,'enableasset'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731029;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可委外','0',1229772315122731029,30,'enableoutsource'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747406;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可受托','0',1229772315122747406,31,'enabletrustee'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731035;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可寄售','0',1229772315122731035,32,'enableconsign'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747427;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'可VMI','0',1229772315122747427,33,'enablevmi'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731021;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'启用辅助属性','1',1229772315122731021,34,'isuseauxpty'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747428;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Array',1229772315122747400,'辅助属性分录',' ',1229772315122747428,35,'auxptyentry'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747398;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747428,'辅助属性分录id，更新需要传入',' ',1229772315122747398,36,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747397;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','Object',1229772315122747428,'辅助属性',' ',1229772315122747397,37,'auxpty'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747419;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747397,'辅助属性id','649003565213309952',1229772315122747419,38,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747426;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747428,'组合控制','0',1229772315122747426,39,'iscomcontrol'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731033;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747428,'影响库存','1',1229772315122731033,40,'isaffectinv'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747417;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747428,'影响成本','0',1229772315122747417,41,'isaffectprice'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731039;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747428,'影响计划','0',1229772315122731039,42,'isaffectplan'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747418;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'重量单位',' ',1229772315122747418,43,'weightunit'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731013;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747418,'重量单位id','4',1229772315122731013,44,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747412;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'净重','5',1229772315122747412,45,'netweight'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731027;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'毛重','10',1229772315122731027,46,'grossweight'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731016;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'高度','5',1229772315122731016,47,'height'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731028;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'宽度','5',1229772315122731028,48,'width'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731042;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'长度','5',1229772315122731042,49,'length'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747416;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'尺寸单位',' ',1229772315122747416,50,'lengthunit'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731032;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747416,'尺寸单位id','5',1229772315122731032,51,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747399;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'体积单位',' ',1229772315122747399,52,'volumnunit'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747415;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'1','String',1229772315122747399,'体积单位id','6',1229772315122747415,53,'id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122747414;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','String',1229772315122747400,'体积','125',1229772315122747414,54,'volume'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1229772315122731015;
INSERT INTO t_open_apibodyentry(FID,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FEXAMPLE,FENTRYID,FSEQ,FPARAMNAME) VALUES (1229795730957289472,'0','Object',1229772315122747400,'默认税率(%)',' ',1229772315122731015,55,'taxrate'); 

--返回体
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229772315131119616;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'data','1','Array',0,1229772315131119616,1,' ','返回结果'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229772315131119620;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'message','0','String',0,1229772315131119620,11,' ','错误信息'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229772315131136000;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'errorCode','1','String',0,1229772315131136000,12,'success','错误码'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229772315131136002;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'success','1','Boolean',0,1229772315131136002,13,'true','总执行结果'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229797570830665728;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'success','1','Boolean',1229772315131119616,1229797570830665728,2,'true','当前记录执行结果'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798063602665472;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialmftinfoid','1','String',1229772315131119616,1229798063602665472,3,'1229797928705460224','物料生产信息id，若生成成功则返回值，否则返回0或空'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798296604641280;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialid','1','String',1229772315131119616,1229798296604641280,4,'1229797928705460224','物料id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798319077738496;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialsaleinfoid','1','String',1229772315131119616,1229798319077738496,5,'1229797928705460224','物料销售信息id，若生成成功则返回值，否则返回0或空'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798343580846080;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialinspectcfgid','1','String',1229772315131119616,1229798343580846080,6,'1229797928705460224','物料质检信息id，若生成成功则返回值，否则返回0或空'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798364669822976;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'message','1','String',1229772315131119616,1229798364669822976,7,' ','错误信息'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798391748233216;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialinventoryinfoid','1','String',1229772315131119616,1229798391748233216,8,'1229797928705460224','物料库存信息id，若生成成功则返回值，否则返回0或空'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798413030148096;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialnumber','1','String',1229772315131119616,1229798413030148096,9,'zcw202006806','物料编码'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1229798430201612288;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1229795730957289472,'materialpurchaseinfoid','1','String',1229772315131119616,1229798430201612288,10,'1229797928705460224','物料采购信息id，若生成成功则返回值，否则返回0或空'); 
