/**外部系统-西域**/
DELETE FROM t_mal_extsys WHERE FID = 1063003343795826688;
INSERT INTO t_mal_extsys(FID,FCREATETIME,FSYSSOURCEID,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FSYSTYPE,FNUMBER) VALUES (1063003343795826688,{ts'2021-01-06  15:57:21'},1047731226867198976,13466739,'1',{ts'2021-01-06  15:57:54'},1063003343795826688,'C',13466739,'5','SCM-XY'); 

DELETE FROM t_mal_extsys_l WHERE FPKID = '1AJQL5VY473C';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1063003343795826688,'1AJQL5VY473C','zh_CN','西域'); 
DELETE FROM t_mal_extsys_l WHERE FPKID = '1AJQL5VY473D';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1063003343795826688,'1AJQL5VY473D','zh_TW','西域'); 


/**外部系统API-西域**/
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063004075727040512;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727040512,'1',1,'sheetId',' ','售后服务单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438016;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438016,'1',1,'orderId',' ','订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438017;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438017,'1',2,'aftersaleType',' ','服务类型'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438018;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438018,'1',3,'questionDesc',' ','产品问题描述'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438019;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438019,'1',4,'questionPic',' ','问题描述图片'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438020;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438020,'1',5,'address',' ','详细地址,取件方式为4上门取件时，需传该字段，内容为“省+市+区/县（+乡/镇）+详细地址”，举例：江苏省无锡市新区长江南路29号。'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438021;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438021,'1',6,'pickwareType',' ','1客户自发 ，4上门取件。如传其它默认为客户自发'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438022;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438022,'1',7,'pickwareStartTime',' ','预约取件开始时间'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438023;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438023,'1',8,'pickwareEndTime',' ','预约取件截止时间'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438024;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438024,'1',9,'returnwareType',' ','自营配送(10),第三方配送(20);换、修这两种情况必填（默认值）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438025;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438025,'1',10,'returnwareProvince',' ','省'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438026;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438026,'1',11,'returnwareCity',' ','市'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438027;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438027,'1',12,'returnwareCounty',' ','县'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438028;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438028,'1',13,'returnwareVillage',' ','返件乡镇'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438029;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438029,'1',14,'returnwareAddress',' ','最多500字符，换、修这两种情况必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438030;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438030,'1',15,'aftersalePhone',' ','联系电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438031;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438031,'1',16,'customerMobilePhone',' ','联系人手机'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438032;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438032,'1',17,'customerEmail',' ','邮箱'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438033;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438033,'1',18,'customerPostcode',' ','邮编'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438034;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438034,'1',19,'aftersaleName',' ','customerContactName'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1063038627044438035;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044438035,'1',20,'skus',' ','商品集合"detail":[ {"skuId":"ADY811","skuNum":2 }  ]'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069531800704911360;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069531800671356928,'0','string',1069531800704911360,'1',1,'pageNum',' ','商品池编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069531800704911361;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069531800671356928,'0','int',1069531800704911361,'1',2,'pageNo',' ','页码，默认取第一页'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069532093022735360;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022735360,'1',1,'skuId',' ','商品SKU编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069532415296277504;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069532415279500288,'1','string',1069532415296277504,'1',1,'skuIds',' ','商品SKU集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069532640572344320;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069532640563955712,'1','string',1069532640572344320,'1',1,'skuIds',' ','最大支持2000商品同时查，否则抛出异常'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069579354717085696;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069579354616422400,'0','STRUCT',1069579354717085696,'1',1,'skuNums',' ','商品编码_数量Map'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069594838158073856;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069594838149685248,'0','string',1069594838158073856,'1',1,'pageNo',' ','页数'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069594838158073857;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069594838149685248,'0','string',1069594838158073857,'1',2,'endCategoryId',' ','末级分类编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069595041665703936;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'1','string',1069595041665703936,'1',1,'skuIds',' ','商品编码集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1069595041665703937;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665703937,'1',2,'cityId',' ','二级地址ID'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124672;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124672,'1',1,'thirdOrder',' ','第三方单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124673;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124673,'1',2,'orderCompany',' ','下单公司 如集团内分/子公司分别与西域开票结算，该项必填，明确该订单归属于哪个分/子公司'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124674;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'1','string',1071674416452124674,'1',3,'sku',' ','skuId	String	Y	商品编码	 num	Int	Y	商品数量	 price	Double	'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124675;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124675,'1',4,'name',' ','收货人'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124676;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124676,'1',5,'province',' ','一级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124677;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124677,'1',6,'city',' ','二级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124678;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124678,'1',7,'county',' ','三级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124679;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124679,'1',8,'town',' ','四级地址 如无传0'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124680;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124680,'1',9,'address',' ','详细地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124681;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124681,'1',10,'zip',' ','邮编'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124682;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124682,'1',11,'phone',' ','座机号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124683;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124683,'1',12,'mobile',' ','手机号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124684;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124684,'1',13,'email',' ','邮箱'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124685;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124685,'1',14,'remark',' ','备注（少于100字）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124686;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124686,'1',15,'logisticalRemark',' ','物流备注（少于100字）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124687;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124687,'1',16,'promiseDate',' ','配送预约日期 1：工作日送货 2：任意时间送货 不传默认工作日送货'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124688;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124688,'1',17,'invoiceState',' ','开票方式 1随单开票，2集中开票 随单开票以下发票相关信息字段全部必传，“发票类型”只能传1或2；集中开票不要传以下发票相关信息'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124689;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124689,'1',18,'invoiceType',' ','发票类型 1普通发票，2增值税发票，3增值税电子普通发票，默认0不开票 当“开票方式”为1随单开票时，该字段不能传0'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124690;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124690,'1',19,'companyName',' ','发票抬头 当“开票方式”为1随单开票，该字段必传，需与“下单公司”字段一致'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124691;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124691,'1',20,'receiptCompanyTel',' ','增值税发票营业电话 当“开票方式”为1随单开票，“发票类型”为2增值税发票，该字段必传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124692;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124692,'1',21,'receiptCompanyAddr',' ','增值税发票营业地址 当“开票方式”为1随单开票，“发票类型”为2增值税发票，该字段必传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124693;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124693,'1',22,'receiptTaxNo',' ','纳税人识别号 当“开票方式”为1随单开票，该字段必传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124694;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124694,'1',23,'receiptBankName',' ','开户行 当“开票方式”为1随单开票，“发票类型”为2增值税发票，该字段必传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124695;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124695,'1',24,'receiptAccount',' ','开户行账号 当“开票方式”为1随单开票，“发票类型”为2增值税发票，该字段必传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124696;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124696,'1',25,'invoiceName',' ','收票人姓名'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124697;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124697,'1',26,'invoicePhone',' ','收票人电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124698;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124698,'1',27,'invoiceProvice',' ','收票人所在省 一级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124699;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124699,'1',28,'invoiceCity',' ','增值票收票人所在市 二级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124700;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124700,'1',29,'invoiceCounty',' ','增值票收票人所在区/县 三级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124701;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124701,'1',30,'invoiceAddress',' ','增值票收票人所在地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124702;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124702,'1',31,'purchaseId',' ','采购单位ID'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124703;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124703,'1',32,'purchaseName',' ','采购单位名称'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124704;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124704,'1',33,'purchaseAccount',' ','采购单位联系人'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1071674416452124705;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452124705,'1',34,'purchaseMobile',' ','采购单位联系电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1072253193662023680;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1072253193628469248,'0','string',1072253193662023680,'1',1,'orderId',' ','西域商城订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1072445007371193344;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1072445007337638912,'0','string',1072445007371193344,'1',1,'orderId',' ','电商订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1072446303931223040;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1072446303906057216,'0','string',1072446303931223040,'1',1,'orderId',' ','电商订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1073836122993382400;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1073836122959827968,'0','string',1073836122993382400,'1',1,'thirdOrder',' ','西域商城订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615488;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615488,'1',1,'markId',' ','第三方申请单号：申请发票的唯一id标识 (该标记下可以对应多张发票信息)'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615489;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615489,'1',2,'supplierOrder',' ','子订单号，批量以英文逗号分割'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615490;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615490,'1',3,'settlementId',' ','结算单号（一个结算单号可对对应多个第三方申请单号）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615491;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','int',1078163385079615491,'1',4,'invoiceType',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615492;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615492,'1',5,'invoicePrice',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615493;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615493,'1',6,'invoiceDate',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615494;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615494,'1',7,'title',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615495;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615495,'1',8,'enterpriseTaxpayer',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615496;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615496,'1',9,'enterpriseRegAddress',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615497;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615497,'1',10,'enterpriseRegPhone',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615498;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615498,'1',11,'enterpriseBankName',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615499;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615499,'1',12,'enterpriseBankAccount',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615500;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615500,'1',13,'billToParty',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615501;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615501,'1',14,'billToer',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615502;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615502,'1',15,'billToContact',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615503;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615503,'1',16,'billToProvince',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615504;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615504,'1',17,'billToCity',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615505;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615505,'1',18,'billToCounty',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615506;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615506,'1',19,'billToTown',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163385079615507;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163384995729408,'0','string',1078163385079615507,'1',20,'billToAddress',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1078163635236292608;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1078163635202738176,'0','string',1078163635236292608,'1',1,'markId',' ','无'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1079766424580278272;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580278272,'1',1,'startDate',' ','开始日期开始日期(yyyy-MM-dd，开始时间不能晚于结束时间)包含当天，当天的0点0分'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1079766424580278273;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580278273,'1',2,'pageNo',' ','页码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1079766424580278274;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580278274,'1',3,'endDate',' ','结束日期'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1081678662828343296;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1081678662811566080,'0','string',1081678662828343296,'1',1,'packageId',' ','包裹号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1081689772902066176;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1081689772843345920,'0','string',1081689772902066176,'1',1,'orderId',' ','运单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1081689772902066177;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1081689772843345920,'0','string',1081689772902066177,'1',2,'skuOrderMap',' ','key:商品编号，value：orderItemId（订单行号），苏宁必须传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1082406950483833856;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1082406950408336384,'0','string',1082406950483833856,'1',1,'id',' ','消息ID'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1082408702553665536;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1082408702402670592,'0','string',1082408702553665536,'1',1,'type',' ','消息类型'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1082408864353136640;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FREQUIRED,FSEQ,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1082408864294416384,'0','string',1082408864353136640,'1',1,'thirdOrder',' ','电商订单号'); 

DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041537;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041537,1,'sheetId','服务单号,服务单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041538;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041538,2,'customerExpect','服务类型,服务类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041539;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041539,3,'applyTime','服务单申请时间,服务单申请时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041540;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041540,4,'afterSrvStatus','当前售后状态,【xy】驳回(20), 待审核(21), 已审核(31), 已完成(50)'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041541;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041541,5,'pictureCode','图片凭证,【xy】上传图片访问地址，不同图片逗号分割，可能为空'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063004075727041542;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063004075710263296,'0','string',1063004075727041542,6,'orderId','订单号,订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1063038627044439040;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063003800513590272,'0','string',1063038627044439040,1,'serviceId','服务单号,服务单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069531800704912385;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069531800671356928,'0','int',1069531800704912385,1,'pageCount','页数'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069531800704912386;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069531800671356928,'1','string',1069531800704912386,2,'skuIds','商品编码集合'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734337;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734337,1,'skuId','商品SKU'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734338;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734338,2,'name','商品名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734339;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734339,3,'mainpic','商品主图'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734340;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734340,4,'category','商品分类'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734341;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734341,5,'brand','品牌'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734342;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734342,6,'model','规格型号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734343;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734343,7,'introduction','商品详情'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734344;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734344,8,'packList','包装清单'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734345;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734345,9,'param','商品参数'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532093022734346;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532093014346752,'0','string',1069532093022734346,10,'isSelf','自营配送'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532415296276480;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532415279500288,'0','string',1069532415296276480,1,'1','skuId'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532415296276481;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532415279500288,'0','string',1069532415296276481,2,'2','state,1：上架，0：下架'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532640572345345;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532640563955712,'0','string',1069532640572345345,1,'path','图片全路径'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069532640572345346;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069532640563955712,'0','string',1069532640572345346,2,'orderSort','图片排序'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069579354717042688;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069579354616422400,'0','string',1069579354717042688,1,'skuId','商品编码,商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069579354717042689;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069579354616422400,'0','string',1069579354717042689,2,'stockStateId','库存状态编号,库存状态编号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069579354717042690;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069579354616422400,'0','string',1069579354717042690,3,'StockStateDesc','库存状态描述,库存状态描述'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069579354717042691;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069579354616422400,'0','string',1069579354717042691,4,'areaId','地址ID,地址ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660929;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660929,1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660930;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660930,2,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660931;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660931,3,'price','单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660932;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660932,4,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660933;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660933,5,'tax','税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660934;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660934,6,'ecPrice','电商价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1069595041665660935;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1069595041657315328,'0','string',1069595041665660935,7,'discountRate','折扣率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125697;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452125697,1,'orderId','西域商城订单号,西域商城订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125698;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452125698,2,'freight','运费,运费'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125699;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452125699,3,'orderPrice','订单总价格（含税）,订单总价格（含税）'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125700;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452125700,4,'orderNakedPrice','订单裸价（未税）,订单裸价（未税）'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125701;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'0','string',1071674416452125701,5,'orderTaxPrice','订单税额,订单税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1071674416452125702;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1071674416418570240,'1','string',1071674416452125702,6,'sku','skuId	String	Y	商品编码	 num	Int	Y	商品数量	 price	Double	'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1079766424580279296;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'1','string',1079766424580279296,1,'orders','订单信息合集'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1079766424580279297;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580279297,2,'sumPrice','周期内订单行总价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1079766424580279298;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580279298,3,'totalPage','总页数'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1079766424580279299;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580279299,4,'curPage','当前页码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1079766424580279300;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1063005263444882432,'0','string',1079766424580279300,5,'orderSum','订单总数'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1081689772902105089;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1081689772843345920,'0','string',1081689772902105089,1,'porderId','父订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1081689772902105090;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1081689772843345920,'0','string',1081689772902105090,2,'orderTrack','物流详情'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407088216387584;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407088157667328,'0','string',1082407088216387584,1,'id','消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407088216387585;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407088157667328,'0','string',1082407088216387585,2,'result','消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407088216387586;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407088157667328,'0','datetime',1082407088216387586,3,'time','推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407088216387587;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407088157667328,'0','string',1082407088216387587,4,'type','消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407437820014592;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407437794848768,'0','string',1082407437820014592,1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407437820014593;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407437794848768,'0','string',1082407437820014593,2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407437820014594;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407437794848768,'0','datetime',1082407437820014594,3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082407437820014595;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082407437794848768,'0','string',1082407437820014595,4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408070681768960;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408070656603136,'0','string',1082408070681768960,1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408070681768961;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408070656603136,'0','string',1082408070681768961,2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408070681768962;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408070656603136,'0','datetime',1082408070681768962,3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408070681768963;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408070656603136,'0','string',1082408070681768963,4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408195957239808;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408195856576512,'0','string',1082408195957239808,1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408195957239809;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408195856576512,'0','string',1082408195957239809,2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408195957239810;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408195856576512,'0','datetime',1082408195957239810,3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408195957239811;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408195856576512,'0','string',1082408195957239811,4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408474693907456;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408474626798592,'0','string',1082408474693907456,1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408474693907457;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408474626798592,'0','string',1082408474693907457,2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408474693907458;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408474626798592,'0','datetime',1082408474693907458,3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408474693907459;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408474626798592,'0','string',1082408474693907459,4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408702553666561;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408702402670592,'0','string',1082408702553666561,1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408702553666562;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408702402670592,'0','string',1082408702553666562,2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408702553666563;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408702402670592,'0','datetime',1082408702553666563,3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1082408702553666564;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FINPUT_DATA_TYPE,FENTRYID,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1082408702402670592,'0','string',1082408702553666564,4,'type','消息类型,消息类型'); 

DELETE FROM t_mal_extsys_api WHERE FID = 1063003800513590272;
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 (1063003800513590272,'isc_metadata_schema','0','申请售后服务',1063003800513590272,'C',4153326284994928683,'/mall/serviceOrder',1063003343795826688,'SRM_XY_AFTERSALE_serviceOrder',{ts'2021-01-06  15:58:14'},13466739,'1','1',{ts'2021-01-06  17:07:59'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1063004075710263296;
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 (1063004075710263296,'isc_metadata_schema','0','根据售后服务单号，查询服务单的具体信息。',1063004075710263296,'C',5771279699559992018,'/mall/getServiceDetailInfo',1063003343795826688,'SRM_XY_AFTERSALE_getServiceDetailInfo',{ts'2021-01-06  15:58:57'},13466739,'1','1',{ts'2021-01-06  15:59:23'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1063005263444882432;
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 (1063005263444882432,'isc_metadata_schema','0','妥投/部分妥投订单对账接口',1063005263444882432,'C',3111397932766002476,'/mall/checkDlokOrder',1063003343795826688,'SRM_XY_ORDER_checkDlokOrder',{ts'2021-01-06  15:59:27'},13466739,'1','1',{ts'2021-01-29  19:03:08'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069521437301147648;
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 (1069521437301147648,'isc_metadata_schema','0','西域获取商品池编号',1069521437301147648,'C',508382469027325549,'/mall/getPageNum',1063003343795826688,'SRM_XY_GOODS_getPageNum',{ts'2021-01-15  15:47:47'},72202045,'1','1',{ts'2021-01-15  15:59:25'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069531800671356928;
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 (1069531800671356928,'isc_metadata_schema','0','西域获取池内商品编码',1069531800671356928,'C',5797360744176244055,'/mall/getSkuByPage',1063003343795826688,'SRM_XY_GOODS_getSkuByPage',{ts'2021-01-15  16:07:34'},72202045,'1','1',{ts'2021-01-15  16:08:46'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069532093014346752;
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 (1069532093014346752,'isc_metadata_schema','0','西域获取商品详细信息',1069532093014346752,'C',2452518346338670234,'/mall/getDetail',1063003343795826688,'SRM_XY_GOODS_getDetail',{ts'2021-01-15  16:09:00'},13466739,'1','1',{ts'2021-01-21  21:05:38'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069532415279500288;
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 (1069532415279500288,'isc_metadata_schema','0','西域获取商品上下架状态',1069532415279500288,'C',4168210581989432810,'/mall/skuState',1063003343795826688,'SRM_XY_GOODS_skuState',{ts'2021-01-15  16:09:36'},72202045,'1','1',{ts'2021-01-15  16:09:59'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069532640563955712;
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 (1069532640563955712,'isc_metadata_schema','0','西域查询商品图片',1069532640563955712,'C',6064529715319750582,'/mall/skuImage',1063003343795826688,'SRM_XY_GOODS_skuImage',{ts'2021-01-15  16:10:12'},72202045,'1','1',{ts'2021-01-15  16:10:26'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069579354616422400;
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 (1069579354616422400,'isc_metadata_schema','0','西域批量查询商品库存',1069579354616422400,'C',2429124008241305235,'/mall/getNewStockById',1063003343795826688,'SRM_XY_GOODS_getNewStockById',{ts'2021-01-15  17:42:24'},72202045,'1','1',{ts'2021-01-21  15:03:04'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069594838149685248;
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 (1069594838149685248,'isc_metadata_schema','0','西域按末级产线ID获取商品SKU编码',1069594838149685248,'C',4882929330669518397,'/mall/getSkuByEndCategory',1063003343795826688,'SRM_XY_GOODS_getSkuByEndCategory',{ts'2021-01-15  18:13:28'},72202045,'1','1',{ts'2021-01-15  18:14:01'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1069595041657315328;
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 (1069595041657315328,'isc_metadata_schema','1','西域查询商品售卖价',1069595041657315328,'C',4599961271493339549,'/mall/getSellPrice',1063003343795826688,'SRM_XY_GOODS_getSellPrice',{ts'2021-01-15  18:14:17'},13466739,'1','1',{ts'2021-02-02  10:20:54'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1071674416418570240;
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 (1071674416418570240,'isc_metadata_schema','1','西域创建预占库存单接口',1071674416418570240,'C',7304021491407019823,'/mall/submitOrder',1063003343795826688,'SRM_XY_ORDER_submitOrder',{ts'2021-01-18  15:04:29'},13466739,'1','1',{ts'2021-02-02  10:34:35'},89186823); 
DELETE FROM t_mal_extsys_api WHERE FID = 1072253193628469248;
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 (1072253193628469248,'isc_metadata_schema','0','西域查询订单详细信息',1072253193628469248,'C',3728152683982757576,'/mall/qrySubOrder',1063003343795826688,'SRM_XY_ORDER_qrySubOrder',{ts'2021-01-19  10:15:15'},89186823,'1','1',{ts'2021-01-19  10:15:41'},89186823); 
DELETE FROM t_mal_extsys_api WHERE FID = 1072445007337638912;
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 (1072445007337638912,'isc_metadata_schema','0','西域取消未确认预占库存单',1072445007337638912,'C',519588091448132092,'/mall/cancel',1063003343795826688,'SRM_XY_ORDER_cancel',{ts'2021-01-19  16:36:30'},72202045,'1','1',{ts'2021-01-19  16:36:47'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1072446303906057216;
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 (1072446303906057216,'isc_metadata_schema','1','西域预占库存单确认订单',1072446303906057216,'C',3455616347692944120,'/mall/confirmOrder',1063003343795826688,'SRM_XY_ORDER_confirmOrder',{ts'2021-01-19  16:39:01'},13466739,'1','1',{ts'2021-02-02  09:53:33'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1073836122959827968;
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 (1073836122959827968,'isc_metadata_schema','0','西域查询订单信息（根据第三方订单号）',1073836122959827968,'C',6390927718444358669,'/mall/qrySubOrderByThirdOrder',1063003343795826688,'SRM_XY_ORDER_qrySubOrderByThirdOrder',{ts'2021-01-21  14:39:39'},72202045,'1','1',{ts'2021-01-21  14:40:41'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1078163384995729408;
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 (1078163384995729408,'isc_metadata_schema','1','申请发票开具',1078163384995729408,'C',3327329317644097393,'/mall/invoiceApply',1063003343795826688,'SRM_XY_INVOICE_apply',{ts'2021-01-27  13:57:25'},13466739,'1','1',{ts'2021-02-02  10:48:07'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1078163635202738176;
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 (1078163635202738176,'isc_metadata_schema','0','根据开票申请查询发票信息',1078163635202738176,'C',5829899579405621320,'/mall/qryInvoice',1063003343795826688,'SRM_XY_INVOICE_qryInvoice',{ts'2021-01-27  13:58:18'},13466739,'1','1',{ts'2021-02-02  10:46:32'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1081678662811566080;
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 (1081678662811566080,'isc_metadata_schema','0','查询发货单信息接口',1081678662811566080,'C',2076686181755113972,'/mall/package',1063003343795826688,'SRM_XY_ORDER_package',{ts'2021-02-01  10:22:13'},13466739,'1','1',{ts'2021-02-02  10:49:26'},89186823); 
DELETE FROM t_mal_extsys_api WHERE FID = 1081689772843345920;
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 (1081689772843345920,'isc_metadata_schema','0','西域订单物流信息查询',1081689772843345920,'C',1081680116959938560,'/mall/ logistics',1063003343795826688,'SRM_XY_ORDER_logistics',{ts'2021-02-01  10:43:17'},89186823,'1','1',{ts'2021-02-01  10:44:42'},89186823); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082406950408336384;
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 (1082406950408336384,'isc_metadata_schema','0','西域删除信息变更消息',1082406950408336384,'C',5652821005644578652,'/mall/delete',1063003343795826688,'SRM_XY_MESSAGE_del',{ts'2021-02-02  10:29:11'},13466739,'1','1',{ts'2021-02-02  10:31:14'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082407088157667328;
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 (1082407088157667328,'isc_metadata_schema','0','西域查询消息接口-订单拆分发货消息',1082407088157667328,'C',3274692644373563285,'/mall/get_splitorders',1063003343795826688,'SRM_XY_MESSAGE_get_splitorders',{ts'2021-02-02  10:29:31'},13466739,'1','1',{ts'2021-02-02  10:30:49'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082407437794848768;
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 (1082407437794848768,'isc_metadata_schema','0','西域查询消息接口-订单妥投消息',1082407437794848768,'C',63825931236968616,'/mall/get_deliverdorders',1063003343795826688,'SRM_XY_MESSAGE_get_deliverdorders',{ts'2021-02-02  10:30:11'},13466739,'1','1',{ts'2021-02-02  10:30:31'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082408070656603136;
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 (1082408070656603136,'isc_metadata_schema','0','西域查询消息接口-订单取消消息',1082408070656603136,'C',6326210899716088788,'/mall/get_cancelorders',1063003343795826688,'SRM_XY_MESSAGE_get_canceldorders',{ts'2021-02-02  10:31:21'},13466739,'1','1',{ts'2021-02-02  10:31:37'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082408195856576512;
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 (1082408195856576512,'isc_metadata_schema','0','西域查询消息接口-商品消息',1082408195856576512,'C',7937716833271331588,'/mall/get_goods',1063003343795826688,'SRM_XY_MESSAGE_get_goods',{ts'2021-02-02  10:31:46'},13466739,'1','1',{ts'2021-02-02  10:32:08'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082408474626798592;
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 (1082408474626798592,'isc_metadata_schema','0','西域查询消息接口-价格消息',1082408474626798592,'C',2350563985829014233,'/mall/get_price',1063003343795826688,'SRM_XY_MESSAGE_get_price',{ts'2021-02-02  10:32:15'},13466739,'1','1',{ts'2021-02-02  10:32:25'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082408702402670592;
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 (1082408702402670592,'isc_metadata_schema','0','西域获取信息变更消息',1082408702402670592,'C',24368384086207205,'/mall/get',1063003343795826688,'SRM_XY_MESSAGE_get',{ts'2021-02-02  10:32:38'},13466739,'1','1',{ts'2021-02-02  10:32:52'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1082408864294416384;
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 (1082408864294416384,'isc_metadata_schema','0','西域订单反查接口',1082408864294416384,'C',2523606900684657435,'/mall/selectOrderIdByThirdOrder',1063003343795826688,'SRM_XY_ORDER_selectOrderIdByThirdOrder',{ts'2021-02-02  10:33:03'},13466739,'1','1',{ts'2021-02-02  10:33:16'},13466739); 

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1AJQOHINOVJD';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1063003800513590272,'1AJQOHINOVJD','zh_CN','申请售后服务'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1AJQQHN5ULB8';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1063004075710263296,'1AJQQHN5ULB8','zh_CN','根据服务单号查询服务单明细信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1AJQZ56EWQVQ';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1063005263444882432,'1AJQZ56EWQVQ','zh_CN','西域妥投/部分妥投订单对账接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BBZGDV9GJYM';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069521437301147648,'1BBZGDV9GJYM','zh_CN','西域获取商品池编号'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BC/DY0HRSI6';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069531800671356928,'1BC/DY0HRSI6','zh_CN','西域获取池内商品编码'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BC/G13E12N6';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069532093014346752,'1BC/G13E12N6','zh_CN','西域获取商品详细信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BC/IDP89O57';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069532415279500288,'1BC/IDP89O57','zh_CN','西域获取商品上下架状态'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BC/K0Q5Z69S';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069532640563955712,'1BC/K0Q5Z69S','zh_CN','西域查询商品图片'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BC8=FI97B=Y';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069579354616422400,'1BC8=FI97B=Y','zh_CN','西域批量查询商品库存'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BCA69T6247O';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069594838149685248,'1BCA69T6247O','zh_CN','西域按末级产线ID获取商品SKU编码'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BCA7RMRKSKP';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1069595041657315328,'1BCA7RMRKSKP','zh_CN','西域查询商品售卖价'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BM9R4/=7450';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1071674416418570240,'1BM9R4/=7450','zh_CN','西域创建预占库存单接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BP0WO11VA/A';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1072253193628469248,'1BP0WO11VA/A','zh_CN','西域查询订单详细信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BPZQE0HXYXL';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1072445007337638912,'1BPZQE0HXYXL','zh_CN','西域取消未确认预占库存单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BPZZVHYGF65';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1072446303906057216,'1BPZZVHYGF65','zh_CN','西域预占库存单确认订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1BWMNFEX7BTS';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1073836122959827968,'1BWMNFEX7BTS','zh_CN','西域查询订单信息（根据第三方订单号）'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CEC644K8VG8';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1078163384995729408,'1CEC644K8VG8','zh_CN','申请发票开具'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CEC7Z863FEK';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1078163635202738176,'1CEC7Z863FEK','zh_CN','根据开票申请查询发票信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CV7+X4/RYNM';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1081678662811566080,'1CV7+X4/RYNM','zh_CN','查询发货单信息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CV91VIITWJ5';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1081689772843345920,'1CV91VIITWJ5','zh_CN','西域订单物流信息查询'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYP=28P1YU0';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082408070656603136,'1CYP=28P1YU0','zh_CN','西域查询消息接口-订单取消消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYP1XX+6IJ/';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082406950408336384,'1CYP1XX+6IJ/','zh_CN','西域删除信息变更消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYP2Y0J+N39';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082407088157667328,'1CYP2Y0J+N39','zh_CN','西域查询消息接口-订单拆分发货消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYP5GDCFBEK';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082407437794848768,'1CYP5GDCFBEK','zh_CN','西域查询消息接口-订单妥投消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYPA+V67HAR';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082408195856576512,'1CYPA+V67HAR','zh_CN','西域查询消息接口-商品消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYPC01JZLKH';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082408474626798592,'1CYPC01JZLKH','zh_CN','西域查询消息接口-价格消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYPDOU0UKUH';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082408702402670592,'1CYPDOU0UKUH','zh_CN','西域获取信息变更消息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1CYPEVTBPWDS';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1082408864294416384,'1CYPEVTBPWDS','zh_CN','西域订单反查接口'); 


/**外部系统组-西域  初始化时禁用**/
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1063735503733443584)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1022438122593456128,1063005263444882432,1063735503733443584,3,'kd.scm.common.helper.apiconnector.apihandle.CheckOrderHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1069596765423984640)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (988249074580900864,1069595041657315328,1069596765423984640,3,'kd.scm.common.helper.apiconnector.apihandle.PriceHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1069597131653832704)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1001521588543179776,1069532415279500288,1069597131653832704,3,'kd.scm.common.helper.apiconnector.apihandle.SkuStateHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1069597502681964544)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1009300523653847040,1069532093014346752,1069597502681964544,3,'kd.scm.common.helper.apiconnector.apihandle.ProdHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1069597858400843776)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1001655311695620096,1069532640563955712,1069597858400843776,3,'kd.scm.common.helper.apiconnector.apihandle.ImageHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1069598307459807232)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1002829616169140224,1069579354616422400,1069598307459807232,3,'kd.scm.common.helper.apiconnector.apihandle.StockHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1073847387610469376)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1013547746021389312,1072446303906057216,1073847387610469376,3,'kd.scm.common.helper.apiconnector.apihandle.ConfirmOrderHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1073847618272022528)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1023804725428022272,1072445007337638912,1073847618272022528,3,'kd.scm.common.helper.apiconnector.apihandle.CancelOrderHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1078163924282558464)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1005817789182653440,1078163384995729408,1078163924282558464,3,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1078164386746517504)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1010819042207908864,1078163635202738176,1078164386746517504,3,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','0','5'); 
IF NOT EXISTS (SELECT 1 FROM t_mal_ext_apisetentry WHERE FENTRYID = 1081690349803454464)
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1012225225254817792,1081689772843345920,1081690349803454464,3,'kd.scm.common.helper.apiconnector.apihandle.LogisticsHandleProcessor','0','5'); 