--1.供应商管理



DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1468175107733334016;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1468176043994137600,'["C","Z"]',1468175107733334016,'BillStatusProp','0','auditstatus','0','0','0','1','Array<String>',0,'审批状态',4,'"*"','auditstatus'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1468175230106223616;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1468176043994137600,'"*"',1468175230106223616,'BillStatusProp','0','enable','0','0','0','1','Array<String>',0,'使用状态',5,'"*"','enable'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1468180698975323136;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1468176043994137600,'["DL-220725-0003","ZC-220721-0002"]',1468180698975323136,'TextProp','0','number','0','0','0','1','Array<String>',0,'编码',1,'"*"','number'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1478868740954187776;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1468176043994137600,'"TEST0725"',1478868740954187776,'MuliLangTextProp','0','name','0','0','0','1','String',0,'名称',2,'"*"','name'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1478868481469480960;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FIS_MUL_VALUE,FMUST,FBODY_LEVEL,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1468176043994137600,'"00"',1478868481469480960,'TextProp','0','createorg.number','0','0','1','1','String',0,'创建组织.编码',3,' ','createorg_number'); 

DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1478871043669131264;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERCOMPARE,FFILTERLINK,FFILTERLEFTBRACKET,FFILTERCOLUMN,FFILTERVALUE,FFILTER_TYPE,FENTRYID,FSEQ,FFILTER_CONSTANT,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1468176043994137600,'LIKE','0',' ','name','name','String',1478871043669131264,5,' ',' ','名称'); 
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1468179055311595521;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERCOMPARE,FFILTERLINK,FFILTERLEFTBRACKET,FFILTERCOLUMN,FFILTERVALUE,FFILTER_TYPE,FENTRYID,FSEQ,FFILTER_CONSTANT,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1468176043994137600,'IN','0',' ','auditstatus','auditstatus','String',1468179055311595521,2,' ',' ','审批状态'); 
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1468181755369505792;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERCOMPARE,FFILTERLINK,FFILTERLEFTBRACKET,FFILTERCOLUMN,FFILTERVALUE,FFILTER_TYPE,FENTRYID,FSEQ,FFILTER_CONSTANT,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1468176043994137600,'IN','0',' ','number','number','String',1468181755369505792,4,' ',' ','编码'); 
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1468179055311595520;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERCOMPARE,FFILTERLINK,FFILTERLEFTBRACKET,FFILTERCOLUMN,FFILTERVALUE,FFILTER_TYPE,FENTRYID,FSEQ,FFILTER_CONSTANT,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1468176043994137600,'EQUAL','0',' ','createorg.number','createorg.number','String',1468179055311595520,1,' ',' ','创建组织.编码'); 
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1468179055311595522;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERCOMPARE,FFILTERLINK,FFILTERLEFTBRACKET,FFILTERCOLUMN,FFILTERVALUE,FFILTER_TYPE,FENTRYID,FSEQ,FFILTER_CONSTANT,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1468176043994137600,'IN','0',' ','enable','enable','String',1468179055311595522,3,' ',' ','使用状态'); 

DELETE FROM t_open_apiorderby WHERE FENTRYID = 1470153378251452416;
INSERT INTO t_open_apiorderby(FORDER_FIELD,FID,FORDER_MODE,FENTRYID,FSEQ,FORDER_DESC) VALUES ('id',1468176043994137600,'desc',1470153378251452416,1,'id'); 



DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478872357551636480;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'Long',1478872357551636480,'0','"6643083672689769472"','id','1',0,'0',1,'id','1','LongProp','id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478872357568309248;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478872357568309248,'0','"fsLVA"','number','1',0,'0',2,'编码','1','TextProp','number'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478872357576802304;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478872357576802304,'0','"XMb1o"','name','1',0,'0',3,'名称','1','MuliLangTextProp','name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478874217616408576;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478874217616408576,'0','"zqecT"','createorg_number','1',0,'0',4,'创建组织.编码','1','TextProp','createorg.number'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478874217633081344;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478874217633081344,'0','"mLRAW"','createorg_name','1',0,'0',5,'创建组织.名称','1','MuliLangTextProp','createorg.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478874619288125440;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478874619288125440,'0','"Rkg0y"','supplier_number','1',0,'0',6,'正式供应商.编码','1','TextProp','supplier.number'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478874619304798208;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478874619304798208,'0','"Cj8fE"','supplier_name','1',0,'0',7,'正式供应商.名称','1','MuliLangTextProp','supplier.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478874977095706624;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478874977095706624,'0','"C"','auditstatus','1',0,'0',8,'审批状态','1','BillStatusProp','auditstatus'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478875199620415488;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478875199620415488,'0','"1"','enable','1',0,'0',9,'使用状态','1','BillStatusProp','enable'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478875380503865344;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'DateTime',1478875380503865344,'0','"2022-08-03 11:01:13"','createtime','1',0,'0',10,'创建时间','1','CreateDateProp','createtime'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478875629385580544;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478875629385580544,'0','"1"','biztype','1',0,'0',11,'业务类型','1','ComboProp','biztype'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478875898424911872;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478875898424911872,'0','"tKFTN"','regaddress','1',0,'0',12,'注册地址','1','MuliLangTextProp','regaddress'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478876228332191744;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'Date',1478876228332191744,'0','"2022-08-03"','regdate','1',0,'0',13,'企业成立日期','1','DateProp','regdate'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478876367985737728;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478876367985737728,'0','"N6kVM"','linkman','1',0,'0',14,'联系人','1','MuliLangTextProp','linkman'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478876642200944640;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'DateTime',1478876642200944640,'0','"2022-08-03 11:03:47"','modifytime','1',0,'0',15,'修改时间','1','ModifyDateProp','modifytime'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478876974297442304;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478876974297442304,'0','"Fg5Yl"','group_number','1',0,'0',16,'供应商分类.编码','1','TextProp','group.number'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478876974314323968;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478876974314323968,'0','"p34Bb"','group_name','1',0,'0',17,'供应商分类.名称','1','MuliLangTextProp','group.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1478877143285950464;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FIS_RESP_MUL_VALUE,FSEQ,FRESPDES,FRESP_LEVEL,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1468176043994137600,'String',1478877143285950464,'0','"5"','ctrlstrategy','1',0,'0',18,'控制策略','1','ComboProp','ctrlstrategy'); 

DELETE FROM t_open_apiservice WHERE FID = 1468176043994137600;
INSERT INTO t_open_apiservice(FAPISERVICETYPE,FCUSTOMMETHOD,FADDEDINFO,FISFAILCONTINUE,FAPIDEFTYPE,FOPERATION,FISKSQL,FINPUTPARAM,FORDER_BY_HIDE,FMASTERID,FSELECTPARAM,FMUSTPARAM,FCREATETIME,FMETHODNAME,FENABLE,FBIZOBJECT,FALLOWGUEST,FISVID,FID,FVERSION,FADDEDINFO_TAG,FNAMESPACE,FSAVEOPERATION,FOUTPUTPARAM,FSTATUS,FFILTERPARAM,FISOUTPARAWITHOUTSTATUS,FNUMBER,FCUSTOMSORT,FISDYOBJRESULT,FMODIFIERID,FPLUGIN,FWSMETHODNAME,FMODIFYTIME,FCLASSNAME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('0',' ',' ','0',' ','query','0',' ','id desc',1468176043994137600,'name,createorg,modifytime',' ',{ts'2022-07-19  00:00:00'},' ','1','srm_supplier','0','kingdee',1468176043994137600,'2',' ',' ',' ',' ','C',' ','0','getList',0,'0',1,' ',' ',{ts'2022-08-03  00:00:00'},' ','XV1IC150UR4','/v2/srm/srm_supplier/getList','0',1); 

DELETE FROM t_open_apiservice_l WHERE FID = 1468176043994137600 AND FLOCALEID='zh_CN';
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1468176043994137600,' ','2LAWCPQFCBLA','zh_CN','供应商库查询'); 
DELETE FROM t_open_apiservice_l WHERE FID = 1468176043994137600 AND FLOCALEID='zh_TW';
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1468176043994137600,' ','2LAWCPQFCBLB','zh_TW','供應商庫查詢'); 
