-- 接口
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1310262221648984064;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1310262221430880256,'0',1310262221648984064,'string',1,'1','startDate',' ','开始日期yyyy-MM-dd HH:mm:ss'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1310262221648984065;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1310262221430880256,'0',1310262221648984065,'string',2,'1','endDate',' ','结束日期yyyy-MM-dd HH:mm:ss'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1310262221648984066;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1310262221430880256,'0',1310262221648984066,'string',3,'1','pageNo','1','页码,默认1'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1310262221648984067;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1310262221430880256,'0',1310262221648984067,'string',4,'1','pageSize','20','页大小，默认20'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1310262221648984068;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1310262221430880256,'0',1310262221648984068,'string',5,'1','orderItemStatus',' ','1：妥投，2：完成，可多选1,2'); 


DELETE FROM t_mal_extsys_api WHERE FID = 1310262221430880256;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (1310262221430880256,'isc_metadata_schema','0','采购平台向供应商系统提交对账时调用本接口',1310262221430880256,'C',1493313088657264357,'/checkOrder','SRM_DL_ORDER_checkOrder',1292006463543236608,{ts'2021-12-13  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-15  00:00:00'},'0',1172968486918422528); 

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '22YAVD26MWHD';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1310262221430880256,'22YAVD26MWHD','zh_CN','得力对账接口'); 

-- 接口组
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1310262887066926080;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1310262221430880256,1022438122593456128,1310262887066926080,4,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','4'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1063735503733443584;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1063005263444882432,1022438122593456128,1063735503733443584,3,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','5'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1022438122627010561;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985474683329577984,1022438122593456128,1022438122627010561,2,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1022438122627010560;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985460029018604544,1022438122593456128,1022438122627010560,1,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','1','2'); 

DELETE FROM t_mal_extapiset WHERE FID = 1022438122593456128;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1022438122593456128,{ts'2020-11-11  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-15  00:00:00'},'电商对账接口组',1022438122593456128,'C',13466739,'SRM_EC_CHECKORDER'); 

DELETE FROM t_mal_extapiset_l WHERE FPKID = '16KD52SBSO24';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1022438122593456128,'16KD52SBSO24','zh_CN','电商对账接口组'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '16KD52SBSO25';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1022438122593456128,'16KD52SBSO25','zh_TW','電商對賬接口組'); 

