-- 外部系统api
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 2005299445755064320;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755064320,'string',1,'1','startDate',' ','开始日期yyyy-mm-dd'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 2005299445755064321;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755064321,'string',2,'1','endDate',' ','结束日期yyyy-mm-dd'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 2005299445755064322;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755064322,'string',3,'1','pageNo',' ','页码,默认1'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 2005299445755064323;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755064323,'string',4,'1','pageSize',' ','页大小，默认20'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 2005299445755064324;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755064324,'string',5,'1','orderItemStatus',' ','目前先仅支持已完成的订单查询，订单状态 1 已完成'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 2005299445755180033;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755180033,'string',1,'1','startDate'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 2005299445755180034;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755180034,'string',2,'2','endDate'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 2005299445755180035;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755180035,'string',3,'3','size'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 2005299445755180036;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755180036,'string',4,'4','page'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 2005299445755180037;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (2005299445679566848,'0',2005299445755180037,'string',5,'5','status'); 
DELETE FROM t_mal_extsys_api WHERE FID = 2005299445679566848;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FPLATFORMAPITYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (2005299445679566848,'isc_metadata_schema',0,'0','客户发起客户自己对账或者初筛，或者其他场景需要查询订单数据的客户',2005299445679566848,'C',4068771689410465562,'/statement/orderList','SRM_ZKH_STATEMENT_ORDERLIST',1777433700020090880,{ts'2024-07-29  00:00:00'},1,'1','1',{ts'2024-07-29  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '4=A6KRKUTJ3Q';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2005299445679566848,'4=A6KRKUTJ3Q','zh_CN','震坤行对账接口'); 

-- 外部系统api组
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 2005299699334411264;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (2005299445679566848,1022438122593456128,2005299699334411264,6,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','9'); 
