/**外部系统API-京东售后接口**/

DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1021808588206639104;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1021808588072421376,'0','string',1021808588206639104,'1',1,'jdOrderId',' ','京东子单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1021808588206639105;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1021808588072421376,'0','string',1021808588206639105,'1',2,'skuId',' ','商品编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073161851916833792;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073161851447071744,'0','string',1073161851916833792,'1',1,'serviceIdList',' ','京东售后服务单集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073161851916833793;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073161851447071744,'0','string',1073161851916833793,'1',2,'approveNotes',' ','审核意见'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162249629127681;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162249629127680,'0','string',1073162249629127681,'1',1,'orderId',' ','京东订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162249629127682;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162249629127680,'0','string',1073162249629127682,'1',2,'sku',' ','商品sku'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162813670739969;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162813670739968,'0','string',1073162813670739969,'1',1,'orderId',' ','京东订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162813670739970;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162813670739968,'0','int',1073162813670739970,'1',2,'refId',' ','服务单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162979916174337;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162979916174336,'0','long',1073162979916174337,'1',1,'sheetId',' ','京东售后服务单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073162979916174338;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073162979916174336,'0','string',1073162979916174338,'1',2,'appendInfoSteps',' ','获取信息模块： 不设置数据表示只获取服务单主信息、商品明细以及客户信息； 1、代表增加获取售后地址信息； 2、代表增加获取客户发货信息； 3、代表增加获取退款明细； 4、代表增加获取跟踪信息； 5、代表增加获取允许的操作信息'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073163186628252672;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073163186619864064,'0','string',1073163186628252672,'1',1,'orderId',' ','京东订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073163186628252673;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073163186619864064,'0','int',1073163186628252673,'1',2,'pageIndex',' ','页码，1代表第一页'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073163186628252674;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073163186619864064,'0','int',1073163186628252674,'1',3,'pageSize',' ','每页记录数, 大小取值范围[1,100]'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073163322112659456;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073163321995218944,'0','string',1073163322112659456,'1',1,'orderId',' ','京东订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073163322112659457;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073163321995218944,'0','string',1073163322112659457,'1',2,'sku',' ','商品编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073170191728301056;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073170191694746624,'0','string',1073170191728301056,'1',1,'param',' ','申请售后参数'); 


DELETE FROM t_mal_extsys_api WHERE FID = 1021808588072421376;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1021808588072421376,'isc_metadata_schema','0',' ',1021808588072421376,'C',6198033560106864590,'/api/afterSale/getCustomerExpectComp',980468997621341184,'SRM_JD_AFTERSALE_getCustomerExpectComp',{ts'2020-11-10  19:50:46'},72202045,'1','1',{ts'2020-11-23  15:35:32'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073161851447071744;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073161851447071744,'isc_metadata_schema','0','取消已经生成的服务单。',1073161851447071744,'C',4892150654304497017,'/api/afterSale/auditCancel',980468997621341184,'SRM_JD_AFTERSALE_auditCancel',{ts'2021-01-20  16:20:39'},13466739,'1','1',{ts'2021-01-20  16:21:02'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073162249629127680;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073162249629127680,'isc_metadata_schema','0','9.1 查询可售后商品',1073162249629127680,'C',5611838876647418992,'/api/afterSale/getAvailableNumberComp',980468997621341184,'SRM_JD_AFTERSALE_getAvailableNumberComp',{ts'2021-01-20  16:21:33'},13466739,'1','1',{ts'2021-01-20  16:21:49'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073162813670739968;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073162813670739968,'isc_metadata_schema','0','查询退款明细',1073162813670739968,'C',3764248472598097993,'/api/afterSale/getOrderPayByOrderId',980468997621341184,'SRM_JD_AFTERSALE_getOrderPayByOrderId',{ts'2021-01-20  16:21:57'},13466739,'1','1',{ts'2021-01-20  16:22:57'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073162979916174336;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073162979916174336,'isc_metadata_schema','0','9.7 查询服务单明细',1073162979916174336,'C',7195205028055661,'/api/afterSale/getServiceDetailInfo',980468997621341184,'SRM_JD_AFTERSALE_getServiceDetailInfo',{ts'2021-01-20  16:23:00'},13466739,'1','1',{ts'2021-01-20  16:23:16'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073163186619864064;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073163186619864064,'isc_metadata_schema','0','9.6 查询服务单概要',1073163186619864064,'C',5748413097455905372,'/api/afterSale/getServiceListPage',980468997621341184,'SRM_JD_AFTERSALE_getServiceListPage',{ts'2021-01-20  16:23:21'},13466739,'1','1',{ts'2021-01-20  16:23:41'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073163321995218944;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073163321995218944,'isc_metadata_schema','0','根据订单号、商品编号查询支持的商品返回京东方式',1073163321995218944,'C',1016853658558125372,'/api/afterSale/getWareReturnJdComp',980468997621341184,'SRM_JD_AFTERSALE_getWareReturnJdComp',{ts'2021-01-20  16:23:45'},13466739,'1','1',{ts'2021-01-20  16:23:57'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073170191694746624;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FGROUPID,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1073170191694746624,'isc_metadata_schema','0','京东申请售后',1073170191694746624,'C',8418781762216860664,'/api/afterSale/createAfsApply',980468997621341184,'SRM_JD_AFTERSALE_createAfsApplyForInvoke',{ts'2021-01-20  16:36:13'},13466739,'1','1',{ts'2021-01-20  16:37:36'},13466739); 

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '16HCIOY+/G2E';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1021808588072421376,'16HCIOY+/G2E','zh_CN','根据订单号、商品编号查询支持的服务类型'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDO0RR9K=Z';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073161851447071744,'1BTDO0RR9K=Z','zh_CN','取消服务单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDQYST/ED=';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073162249629127680,'1BTDQYST/ED=','zh_CN','京东查询可售后商品'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDV12BOSR2';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073162813670739968,'1BTDV12BOSR2','zh_CN','查询退款明细'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDW9AYC3QX';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073162979916174336,'1BTDW9AYC3QX','zh_CN','查询服务单明细'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDXS20/COU';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073163186619864064,'1BTDXS20/COU','zh_CN','查询服务单概要'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTDYRKO07MN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073163321995218944,'1BTDYRKO07MN','zh_CN','京东查询商品逆向配送'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BTF7TW1A65D';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073170191694746624,'1BTF7TW1A65D','zh_CN','京东申请售后（参数简化）'); 

