--发票类型
DELETE FROM t_mal_invoicetype WHERE FID = 1769695962974221312;
INSERT INTO t_mal_invoicetype(FID,FMALINVOICETYPE,FBDINVOICETYPE,FAUDITORID,FMASTERID,FSTATUS,FNUMBER,FEMALINVOICETYPE,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FEMALTYPE,FEMALINVOICENUMBER,FCREATORID) VALUES (1769695962974221312,' ',961639799666521088,0,1769695962974221312,'C','fplx-1016','5',NULL,{ts'2023-09-08  00:00:00'},1,'1',{ts'2023-09-08  00:00:00'},'1','9','1',1); 
DELETE FROM t_mal_invoicetype WHERE FID = 1769696649631864832;
INSERT INTO t_mal_invoicetype(FID,FMALINVOICETYPE,FBDINVOICETYPE,FAUDITORID,FMASTERID,FSTATUS,FNUMBER,FEMALINVOICETYPE,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FEMALTYPE,FEMALINVOICENUMBER,FCREATORID) VALUES (1769696649631864832,' ',961640097369875456,0,1769696649631864832,'C','fplx-1017','6',NULL,{ts'2023-09-08  00:00:00'},1,'1',{ts'2023-09-08  00:00:00'},'1','9','2',1); 
DELETE FROM t_mal_invoicetype WHERE FID = 1769697286352377856;
INSERT INTO t_mal_invoicetype(FID,FMALINVOICETYPE,FBDINVOICETYPE,FAUDITORID,FMASTERID,FSTATUS,FNUMBER,FEMALINVOICETYPE,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FEMALTYPE,FEMALINVOICENUMBER,FCREATORID) VALUES (1769697286352377856,' ',961634333825754112,0,1769697286352377856,'C','fplx-1018','2',NULL,{ts'2023-09-08  00:00:00'},1,'1',{ts'2023-09-08  00:00:00'},'1','9','3',1); 

DELETE FROM t_mal_invoicetype_l WHERE FID = 1769695962974221312 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769695962974221312,'3JCF273JMMDJ','zh_CN','增值税普通发票'); 
DELETE FROM t_mal_invoicetype_l WHERE FID = 1769695962974221312 AND FLOCALEID = 'zh_TW';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769695962974221312,'3JCF273JMMDK','zh_TW','增值稅普通發票'); 
DELETE FROM t_mal_invoicetype_l WHERE FID = 1769696649631864832 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769696649631864832,'3JCF777XZRMN','zh_CN','增值税专用发票'); 
DELETE FROM t_mal_invoicetype_l WHERE FID = 1769696649631864832 AND FLOCALEID = 'zh_TW';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769696649631864832,'3JCF777XZRMO','zh_TW','增值稅專用發票'); 
DELETE FROM t_mal_invoicetype_l WHERE FID = 1769697286352377856 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769697286352377856,'3JCFAV5C6FZO','zh_CN','电子发票'); 
DELETE FROM t_mal_invoicetype_l WHERE FID = 1769697286352377856 AND FLOCALEID = 'zh_TW';
INSERT INTO t_mal_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769697286352377856,'3JCFAV5C6FZP','zh_TW','電子發票'); 


--电商支付方式
DELETE FROM t_mal_emalpaytype WHERE FID = 1769671781637003264;
INSERT INTO t_mal_emalpaytype(FID,FAUDITORID,FPAYTYPENUMBER,FMASTERID,FSTATUS,FNUMBER,FAUDITDATE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FPRESET,FEMALTYPE,FCREATORID) VALUES (1769671781637003264,0,'ZKH01',1769671781637003264,'C','dszf-1013',NULL,{ts'2023-09-08  00:00:00'},1,'1',{ts'2023-09-08  00:00:00'},'1','9',1); 

DELETE FROM t_mal_emalpaytype_l WHERE FID = 1769671781637003264 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalpaytype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769671781637003264,'3JCAK/2LWVF4','zh_CN','账期支付'); 
DELETE FROM t_mal_emalpaytype_l WHERE FID = 1769671781637003264 AND FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalpaytype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1769671781637003264,'3JCAK/2LWVF5','zh_TW','賬期支付'); 

--商城支付方式
DELETE FROM t_mal_paytyperelentry WHERE FENTRYID = 1769674943563658240;
INSERT INTO t_mal_paytyperelentry(FID,FENTRYID,FSEQ,FEMALPAYTYPEID) VALUES (932481097596481536,1769674943563658240,8,1769671781637003264); 

--外部系统-震坤行

DELETE FROM t_mal_extsys WHERE FID = 1777433700020090880;
INSERT INTO t_mal_extsys(FID,FCREATETIME,FSYSSOURCEID,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FSYSTYPE,FNUMBER) VALUES (1777433700020090880,{ts'2023-09-19  00:00:00'},1761746692245366784,1,'1',{ts'2023-09-19  00:00:00'},1777433700020090880,'C',1,'9','SCM_ZKH'); 

DELETE FROM t_mal_extsys_l WHERE FID = 1777433700020090880 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777433700020090880,'3KAHUZS0KTVT','zh_CN','震坤行'); 
DELETE FROM t_mal_extsys_l WHERE FID = 1777433700020090880 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777433700020090880,'3KAHUZS0KTVU','zh_TW','震坤行'); 


-- 外部系统API
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1799936481926693888;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1798633069402529792,'0',1799936481926693888,'string',1,'1','orderId',' ','电商订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1799936481926692864;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1798633069402529792,'0',1799936481926692864,'string',1,'porderId','父订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1799936481926692865;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1798633069402529792,'0',1799936481926692865,'string',2,'orderTrack','物流详情'); 
DELETE FROM t_mal_extsys_api WHERE FID = 1798633069402529792;
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 (1798633069402529792,'isc_metadata_schema',0,'1','震坤行物流信息查询接口',1798633069402529792,'C',205899387868663268,'/package/list_orderTrack','SRM_ZKH_ORDER_orderTrack',1777433700020090880,{ts'2023-10-18  00:00:00'},1,'1','1',{ts'2023-10-20  00:00:00'},'0',1); 
 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1798633069402529792 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798633069402529792,'3MY1VDY=GVS/','zh_CN','震坤行物流信息查询接口'); 

DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1809377616709444608;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1809377616709444608,'int',17,'1','isBatching','0','0：否 非分批发货 ，1：是 分批发货'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977792;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977792,'string',1,'1','thirdOrder',' ','必填  客户商城系统订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977793;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'1',1778886041650977793,'string',2,'1','sku',' ','必填 skuId  String Y  商品编号 num  Int  Y  数量  price Double  Y 	含税协议价格 	保留2位小数 nakedPrice Double 	Y 	未税协议价格 	保留2位小数（如果客户以未税方式对接，该字段必填） thirdSkuId String N 物料号 thirdSkuName  String  N  物料名称  thirdLineNum  String  N  订单行号 originalPrice BigDecimal skuRemark '); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977794;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'1',1778886041650977794,'string',3,'1','invoiceInfo',' ','必填 type Int Y 发票类型 1-增值税普通发票 2-增值税专⽤发票 3-电子发票 content 	String 	Y 	发票内容 	例如:"明细"、 "办公⽤用品"、"劳保用品"、"耗材" title 	String 	Y 	发票抬头 	必填   （以下字段 当type=2时，该字段必填）enterpriseTaxpayer 	String 	N 	纳税人识别号    bank 	String    account 	String    tel 	String  address 	'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977795;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977795,'string',4,'1','purchaseAccount',' ','必填  下单人（或者采购人）姓名；请务必填写；否则使用默认对接账号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977796;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977796,'string',5,'1','purchaseMobile',' ','必填  下单人（或者采购人）手机号；请务必填写；否则使用默认对接账号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977797;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977797,'string',6,'1','name',' ','必填   收货人'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977798;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977798,'string',7,'1','address',' ','必填  详细地址请务必包含省市区信息，涉及发货地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977799;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977799,'string',8,'1','mobile',' ','必填  格式必须是国内手机号 例如：138xxxxxxxx'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977800;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977800,'string',9,'1','phone',' ','格式必须是座机号 027-xxxxxxxx'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977801;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977801,'string',10,'1','email',' ','收货人邮箱'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977802;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'1',1778886041650977802,'string',11,'1','region',' ','必填 province 	String 	Y 	省 	中文省名 city 	String Y 市 中文市名 county String 	Y 	区/县 	中文区名 town 	String 	N 	镇 	中文镇名'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977803;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977803,'string',12,'1','remark',' ','备注（少于100字）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1778886041650977804;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1778886041650977804,'int',13,'1','orderType',' ','订单类型   	1：EVM自营订单， 2：标准订单（默认）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1782664494023967744;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1782664494023967744,'string',14,'1','invoiceName',' ','必填    收票人姓名'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1782664494023967745;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1782664494023967745,'string',15,'1','invoicePhone',' ','必填    收票人电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1782664494023967746;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886041239936000,'0',1782664494023967746,'string',16,'1','invoiceAddress',' ','必填    收票人所在地址    详细地址请务必包含省市区信息，涉及收票地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1782687411751355392;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1782687408421078016,'0',1782687411751355392,'string',1,'1','orderId',' ','震坤行电商订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791987215652360192;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652360192,'string',1,'1','sku',' ','商品SKU编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791987622676131840;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'1',1791987622676131840,'string',1,'1','skuIds',' ','商品SKU编码集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791987867707371520;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'1',1791987867707371520,'string',1,'1','skuIds',' ','商品SKU编码集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791988372525412352;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777439459369908224,'0',1791988372525412352,'string',1,'1','pageNum',' ','池编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791988372525412353;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777439459369908224,'0',1791988372525412353,'int',2,'1','pageNo',' ','⻚码（默认取第一⻚;每⻚最多1000条数据，品类商品池可能存 在多⻚数据，具体根据返回的⻚总数判断是否有下一⻚数据）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989097175191552;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777437657530465280,'0',1791989097175191552,'string',1,'1','pageNum',' ','池编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989097175191553;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777437657530465280,'0',1791989097175191553,'int',2,'1','pageNo',' ','⻚码（默认取第一⻚;每⻚最多1000条数据，品类商品池可能存 在多⻚数据，具体根据返回的⻚总数判断是否有下一⻚数据）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989291514195968;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514195968,'string',1,'1','skuId',' ','商品SKU编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989487186866176;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'1',1791989487186866176,'string',1,'1','skuNums',' ','商品编码_数量List，必填 例子 [ { "skuId":"AX4528", "num":"1" } ]'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989487186866177;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186866177,'string',2,'1','provinceId',' ','省编码，必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989487186866178;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186866178,'string',3,'1','cityId',' ','市编码，必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989487186866179;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186866179,'string',4,'1','countyId',' ','区编码，必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989487186866180;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186866180,'string',5,'1','townId',' ','乡镇编码，非必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795328;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795328,'string',1,'1','orderNumber',' ','震坤行订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989667768307712;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438918464076800,'0',1791989667768307712,'string',1,'1','skuIds',' ','商品编号,必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989667768307713;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438918464076800,'0',1791989667768307713,'string',2,'1','province',' ','省份名称必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989667768307714;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438918464076800,'0',1791989667768307714,'string',3,'1','city',' ','城市名称,必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989667768307715;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438918464076800,'0',1791989667768307715,'string',4,'1','county',' ','区县名称,非必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989667768307716;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438918464076800,'0',1791989667768307716,'string',5,'1','town',' ','乡镇名称,非必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791989851101335552;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777438605996816384,'1',1791989851101335552,'string',1,'1','skuIds',' ','最大支持20商品同时查，否则抛出异常'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791990183139340288;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1777437335667963904,'1',1791990183139340288,'string',1,'1','skuIds',' ','1	skuIds	List		商品sku集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791990394423209984;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886220512877568,'0',1791990394423209984,'string',1,'1','orderId',' ','必填  ZKH订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791990394423209985;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886220512877568,'0',1791990394423209985,'string',2,'1','referenceNumber',' ','客户参考号（或者叫执行单号）  用于发运单面单中显示'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791990588585807872;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886776736308224,'0',1791990588585807872,'string',1,'1','packageId',' ','发货单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791990753287860224;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886559135788032,'0',1791990753287860224,'string',1,'1','orderId',' ','电商订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791991098797723648;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1778886347994524672,'0',1791991098797723648,'string',1,'1','orderId',' ','电商订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795329;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795329,'string',2,'1','shipmentNumber',' ','震坤行运单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795330;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795330,'int',3,'1','serviceType',' ','售后类型	1：退货；2：仅退款'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795331;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795331,'string',4,'1','description',' ','售后申请原因'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795332;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795332,'string',5,'1','returnType',' ','售后方式'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795333;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795333,'string',6,'1','applicant',' ','申请人名称'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795334;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795334,'string',7,'1','applicationPhone',' ','申请人电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795335;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437171773795335,'string',8,'1','applicationTime',' ','申请时间'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791437171773795336;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'1',1791437171773795336,'string',9,'1','detail',' ','商品集合[ { "skuId": "061089"，"num": 10 } ]'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1791955686180114432;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1791955685567746048,'0',1791955686180114432,'string',1,'1','serviceId',' ','售后单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1783433931484300288;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1783433929571696640,'0',1783433931484300288,'string',1,'1','orderId',' ','震坤行订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1792124432140065792;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1792124431225707520,'0',1792124432140065792,'string',1,'1','serviceId',' ','售后单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483073;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483073,'string',1,'skuId','商品SKU'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483074;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483074,'string',2,'name','商品名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483075;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483075,'string',3,'mainpic','商品主图'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483076;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483076,'string',4,'category','商品分类'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483077;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483077,'string',5,'unit','计量单位'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483078;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483078,'string',6,'brand','品牌'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483079;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483079,'string',7,'model','规格型号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483080;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483080,'string',8,'platform','电商平台'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987215652483081;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438239104269312,'0',1791987215652483081,'string',9,'barcode','69码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008961;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008961,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008962;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008962,'string',2,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008963;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008963,'string',3,'price','单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008964;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008964,'string',4,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008965;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008965,'string',5,'tax','税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008966;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008966,'string',6,'ecPrice','电商价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987622676008967;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1779765989978789888,'0',1791987622676008967,'string',7,'discountRate','折扣率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248641;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248641,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248642;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248642,'string',2,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248643;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248643,'string',3,'price','单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248644;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248644,'string',4,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248645;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248645,'string',5,'tax','税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248646;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248646,'string',6,'ecPrice','电商价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791987867707248647;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439115529254912,'0',1791987867707248647,'string',7,'discountRate','折扣率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073089;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073089,'string',1,'skuId','商品SKU'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073090;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073090,'string',2,'name','商品名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073091;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073091,'string',3,'mainpic','商品主图'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073092;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073092,'string',4,'category','商品分类'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073093;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073093,'string',5,'unit','计量单位'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073094;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073094,'string',6,'brand','品牌'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073095;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073095,'string',7,'model','规格型号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073096;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073096,'string',8,'platform','电商平台'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073097;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073097,'string',9,'otherImg','其他图片'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073098;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073098,'string',10,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073099;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073099,'string',11,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073100;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073100,'string',12,'minOrderQty','最小订货量'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989291514073101;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777439293652958208,'0',1791989291514073101,'string',13,'barcode','69码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989487186743297;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186743297,'string',1,'1','skuId'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989487186743298;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186743298,'string',2,'2','areaId'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989487186743299;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186743299,'string',3,'3','stockStateId,33 有货现货-预计需要x日发货 34 无货 36 预订'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989487186743300;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777436174969830400,'0',1791989487186743300,'string',4,'4','StockStateDesc,33 有货现货-预计需要x日发货 34 无货 36 预订'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989851101458433;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438605996816384,'0',1791989851101458433,'string',1,'path','图片全路径'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791989851101458434;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777438605996816384,'0',1791989851101458434,'string',2,'orderSort','图片排序'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791990183139217409;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777437335667963904,'0',1791990183139217409,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791990183139217410;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1777437335667963904,'0',1791990183139217410,'string',2,'state','上下架状态,1：上架，0：下架'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1791437388820637696;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1791437170867825664,'0',1791437388820637696,'string',1,'serviceId','售后单号'); 
DELETE FROM t_mal_extsys_api WHERE FID = 1778886041239936000;
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 (1778886041239936000,'isc_metadata_schema',0,'1','预订单，下单时需要按照下单价格模式要求做价格校验，价格不一致不能下单，以免后续订单确认失败。统一下单接口中的发票信息只做参考使用，实际的开票信息需要按照发票申请接口确定。下单结果需要返回订单中单个商品明细价税分离信息，包括裸价、税率、税额和总价，并满足税额=裸价*税率、总价=裸价+税额的关系。',1778886041239936000,'C',950677920790873752,'/submitOrder','SRM_ZKH_ORDER_submitOrder',1777433700020090880,{ts'2023-09-21  00:00:00'},1,'1','1',{ts'2023-09-26  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1782687408421078016;
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 (1782687408421078016,'isc_metadata_schema',0,'1','根据订单号查询该订单下面所有发货单明细信息，不包含物流信息。',1782687408421078016,'C',4187992566518064586,'/package/list_detail','SRM_ZKH_ORDER_get_packagelist',1777433700020090880,{ts'2023-09-26  00:00:00'},1,'1','1',{ts'2023-09-26  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1778886347994524672;
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 (1778886347994524672,'isc_metadata_schema',0,'0','根据电商的订单号，查询订单详细信息。',1778886347994524672,'C',5393394074363445069,'/qrySubOrder','SRM_ZKH_ORDER_qrySubOrder',1777433700020090880,{ts'2023-09-21  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1778886776736308224;
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 (1778886776736308224,'isc_metadata_schema',0,'1','商城通过发货单确认收货接口通知震坤行发货单已确收货。',1778886776736308224,'C',6670007718435537904,'/confirmPackage','SRM_ZKH_ORDER_confirmPackage',1777433700020090880,{ts'2023-09-21  00:00:00'},1,'1','1',{ts'2023-10-10  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1778886559135788032;
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 (1778886559135788032,'isc_metadata_schema',0,'1','根据订单号查询该订单下面所有发货单明细信息，不包含物流信息',1778886559135788032,'C',159992104173378993,'/package/list','SRM_ZKH_ORDER_confirmReceipt',1777433700020090880,{ts'2023-09-21  00:00:00'},1,'1','1',{ts'2023-10-10  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1779765989978789888;
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 (1779765989978789888,'isc_metadata_schema',0,'1','根据sku编码批量查询电商价和协议价。批量查询默认SKU上限数量20。',1779765989978789888,'C',4797392562019643739,'/getSellPrice_forGroup','SRM_ZKH_GOODS_getPrice_forGroup',1777433700020090880,{ts'2023-09-22  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1778886220512877568;
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 (1778886220512877568,'isc_metadata_schema',0,'1','商城会通过确认订单接口进行预订单确认，确认后的订单，电商可以开始执行订单配货物流操作。',1778886220512877568,'C',13895295150483550,'/confirmOrder','SRM_ZKH_ORDER_confirmOrder',1777433700020090880,{ts'2023-09-21  00:00:00'},1,'1','1',{ts'2023-10-10  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1791955685567746048;
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 (1791955685567746048,'isc_metadata_schema',0,'0','根据售后单号查询售后单当前状态',1791955685567746048,'C',5965126655788256687,'/serviceOrder/fetch','SRM_ZKH_AFTERSALE_serviceOrder_fetch',1777433700020090880,{ts'2023-10-09  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1792124431225707520;
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 (1792124431225707520,'isc_metadata_schema',0,'1','申请后取消售后单。 在未审核售后单之前，商城可以发起售后取消动作',1792124431225707520,'C',5979482147486638662,'/serviceOrder/cancel','SRM_ZKH_AFTERSALE_serviceOrder_cancel',1777433700020090880,{ts'2023-10-09  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777438239104269312;
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 (1777438239104269312,'isc_metadata_schema',0,'0','通过sku编码查询sku的详细信息，包括商品名称、品牌、条形码、商品介绍等信息。',1777438239104269312,'C',8397734211264409801,'/getDetail_init','SRM_ZKH_GOODS_getDetail_init',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777437657530465280;
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 (1777437657530465280,'isc_metadata_schema',0,'0','通过商品池编号获取商品池内的SKU编码',1777437657530465280,'C',8965548011691618253,'/getSkuByPage_init','SRM_ZKH_GOODS_getSkuByPage_init',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777436174969830400;
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 (1777436174969830400,'isc_metadata_schema',0,'1','根据sku编码、欲购买地址和数量，批量查询商品精确交期和库存，用于展现商品的精确交期和库存信息。批量查询默认SKU上限数量20',1777436174969830400,'C',2130229956444119024,'/product/inventory','SRM_ZKH_GOODS_getStock',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777438918464076800;
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 (1777438918464076800,'isc_metadata_schema',0,'0','通过sku编码查询商品是否有区域购买限制。批量查询默认SKU上限数量20。',1777438918464076800,'C',3396975525257482738,'/product/region/purchase_restriction_query','SRM_ZKH_GOODS_purchase_restriction',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777438605996816384;
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 (1777438605996816384,'isc_metadata_schema',0,'0','通过sku编码查询该sku的所有图片信息。批量查询默认SKU上限数量20。',1777438605996816384,'C',8473627024849577009,'/skuImage','SRM_ZKH_GOODS_skuImage',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777437335667963904;
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 (1777437335667963904,'isc_metadata_schema',0,'0','通过sku编码该SKU当前的上下架状态。批量查询默认SKU上限数量20',1777437335667963904,'C',1219849242186575664,'/skuState','SRM_ZKH_GOODS_skuState',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1783433929571696640;
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 (1783433929571696640,'isc_metadata_schema',0,'1','在订单未确认前，商城可以主动取消订单。确认订单后，不允许商城主动取消订单。  对于电商主动取消的订单需要在消息通知接口告知电商，取消订单必须按照订单维度取消。',1783433929571696640,'C',7916692736808066482,'/cancel','SRM_ZKH_ORDER_cancel',1777433700020090880,{ts'2023-09-27  00:00:00'},1,'1','1',{ts'2023-10-10  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777439625481124864;
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 (1777439625481124864,'isc_metadata_schema',0,'0',' ',1777439625481124864,'C',1761749161532795904,'/getPageNum','SRM_ZKH_GOODS_getPageNum',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777439115529254912;
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 (1777439115529254912,'isc_metadata_schema',0,'1','根据sku编码批量查询电商价和协议价。批量查询默认SKU上限数量20。',1777439115529254912,'C',3559807375001069956,'/getSellPrice','SRM_ZKH_GOODS_getSellPrice',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777439459369908224;
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 (1777439459369908224,'isc_metadata_schema',0,'0',' ',1777439459369908224,'C',2316891660894501959,'/getSkuByPage','SRM_ZKH_GOODS_getSkuByPage',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1777439293652958208;
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 (1777439293652958208,'isc_metadata_schema',0,'0','通过sku编码查询sku的详细信息，包括商品名称、品牌、条形码、商品介绍等信息。',1777439293652958208,'C',558371060152588471,'/getDetail','SRM_ZKH_GOODS_getSkuInfo',1777433700020090880,{ts'2023-09-19  00:00:00'},1,'1','1',{ts'2023-10-09  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1791437170867825664;
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 (1791437170867825664,'isc_metadata_schema',0,'1','售后单申请',1791437170867825664,'C',4909609960275833409,'/serviceOrder','SRM_ZKH_AFTERSALE_serviceOrder',1777433700020090880,{ts'2023-10-08  00:00:00'},1,'1','1',{ts'2023-10-08  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1778886041239936000 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1778886041239936000,'3KZK6O5=PS/9','zh_CN','震坤行统一下单'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1782687408421078016 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1782687408421078016,'3KZOGO6Z86W+','zh_CN','震坤行查询所有发货单明细信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1783433929571696640 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1783433929571696640,'3L18ZJD5BG7O','zh_CN','震坤行取消订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1792124431225707520 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792124431225707520,'3M3WR20PADX5','zh_CN','震坤行售后单取消'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1791955685567746048 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1791955685567746048,'3M327EQVYORD','zh_CN','震坤行售后单查询'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777438239104269312 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777438239104269312,'3M38365TJQ1C','zh_CN','震坤行获取商品详细信息(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777439625481124864 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777439625481124864,'3M3850QP+ZJA','zh_CN','震坤行获取商品池编号'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1779765989978789888 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1779765989978789888,'3M3864V14C65','zh_CN','震坤行查询商品价格'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777439115529254912 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777439115529254912,'3M387YGVH82N','zh_CN','震坤行批量查询商品价格'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1791437170867825664 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1791437170867825664,'3M0LB/XY7IYG','zh_CN','售后单申请'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777439459369908224 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777439459369908224,'3M38ALZ/D=RO','zh_CN','震坤行获取商品池内的SKU编码'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777437657530465280 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777437657530465280,'3M38FWWO31FF','zh_CN','震坤行获取商品池内的SKU编码(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777439293652958208 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777439293652958208,'3M38HA3M=UG6','zh_CN','震坤行获取商品详细信息 '); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777436174969830400 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777436174969830400,'3M38IQQC2OX8','zh_CN','震坤行批量查询商品交期和库存'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777438918464076800 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777438918464076800,'3M38K10UPOKH','zh_CN','震坤行商品区域购买限制'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777438605996816384 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777438605996816384,'3M38LD4TLSN6','zh_CN','震坤行获取所有图片信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1777437335667963904 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1777437335667963904,'3M38NTHZ3+SW','zh_CN','震坤行获取商品上下架状态'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1778886220512877568 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1778886220512877568,'3M38PBJPYIQ=','zh_CN','震坤行确认订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1778886776736308224 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1778886776736308224,'3M38QRQQ2Q9T','zh_CN','震坤行发货单确认收货'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1778886559135788032 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1778886559135788032,'3M38RZJ6ILPR','zh_CN','震坤行订单确认收货接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1778886347994524672 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1778886347994524672,'3M38UGQNIRTK','zh_CN','震坤行查询订单信息'); 

--发票相关--
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267648;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267648,'string',1,'1','settlementId',' ','结算单号（一个结算单号可对对应多个第三方申请单号）如果一对一可以是markId'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267649;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267649,'string',2,'1','markId',' ','发票申请单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267650;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267650,'string',3,'1','settlementNum',' ','结算单订单总数'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267651;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267651,'string',4,'1','amount',' ','结算单不含税总金额'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267652;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267652,'string',5,'1','tax',' ','结算单总税额'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267653;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267653,'string',6,'1','invoiceType',' ','发票类型  1-增值税普通发票 2-增值税专用发票 3-电子发票'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267654;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267654,'string',7,'1','invoiceDate',' ','期望开票时间  格式：2020-11-11 00:00:00'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267655;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267655,'string',8,'1','title',' ','发票抬头'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267656;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267656,'string',9,'1','enterpriseTaxpayer',' ','纳税人识别号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267657;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267657,'string',10,'1','enterpriseBankName',' ','开户行'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267658;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267658,'string',11,'1','enterpriseBankAccount',' ','开户行银行账户'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267659;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267659,'string',12,'1','billToParty',' ','收票单位/组织'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267660;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267660,'string',13,'1','billToer',' ','收票人  专票必须'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267661;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267661,'string',14,'1','billToContact',' ','收票人联系方式'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267662;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267662,'string',15,'1','billToAddress',' ','收票人地址    详细地址，请务必包含省市区中文信息'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267663;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'1',1808017619786267663,'string',16,'1','supplierOrderList',' ','申请开票订单信息'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267664;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'1',1808017619786267664,'string',17,'1','billToRegion',' ','收票人省市区   专票必须'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267665;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267665,'string',18,'1','invoicePrice',' ','含税总金额'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267666;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267666,'string',19,'1','enterpriseRegAddress',' ','企业注册地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267667;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267667,'string',20,'1','enterpriseRegPhone',' ','企业注册电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017619786267668;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017619534609408,'0',1808017619786267668,'string',21,'1','remark',' ','备注'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808017907045635072;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808017907012080640,'0',1808017907045635072,'string',1,'1','markId',' ','markId'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1808018029041286144;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1808018029007731712,'0',1808018029041286144,'string',1,'1','markId',' ','发票申请单号'); 
DELETE FROM t_mal_extsys_api WHERE FID = 1808017619534609408;
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 (1808017619534609408,'isc_metadata_schema',0,'1','订单完结之后，依据订单申请开票（开票订单数上限1000）',1808017619534609408,'C',1257783700597128190,'/invoice/apply','SRM_ZKH_INVOICE_apply',1777433700020090880,{ts'2023-10-31  00:00:00'},1,'1','1',{ts'2023-10-31  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1808017907012080640;
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 (1808017907012080640,'isc_metadata_schema',0,'0','震坤行发票查询',1808017907012080640,'C',4613171825365205496,'/invoice/query','SRM_ZKH_INVOICE_query',1777433700020090880,{ts'2023-10-31  00:00:00'},1,'1','1',{ts'2023-10-31  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api WHERE FID = 1808018029007731712;
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 (1808018029007731712,'isc_metadata_schema',0,'0','震坤行发票物流查询',1808018029007731712,'C',6774133593424152176,'/invoice/tracking','SRM_ZKH_INVOICE_tracking',1777433700020090880,{ts'2023-10-31  00:00:00'},1,'1','1',{ts'2023-10-31  00:00:00'},'0',1); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1808017619534609408 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808017619534609408,'3O20AG428NUU','zh_CN','震坤行发票申请'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1808017907012080640 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808017907012080640,'3O20CJRY2QM4','zh_CN','震坤行发票查询'); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 1808018029007731712 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1808018029007731712,'3O20DFF1DU+T','zh_CN','震坤行发票物流查询');  


-- 外部系统接口组
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1798633418150502400;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1798633069402529792,1012225225254817792,1798633418150502400,8,'kd.scm.common.helper.apiconnector.apihandle.ZkhLogisticsHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1777448411298102272;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1777437335667963904,1001521588543179776,1777448411298102272,8,'kd.scm.common.helper.apiconnector.apihandle.SkuStateHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1777448720284088320;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1777438605996816384,1001655311695620096,1777448720284088320,8,'kd.scm.common.helper.apiconnector.apihandle.ImageHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1777449998816999424;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1777439293652958208,1009300523653847040,1777449998816999424,8,'kd.scm.common.helper.apiconnector.apihandle.ZkhProdHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1777449334967729152;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1777436174969830400,1002829616169140224,1777449334967729152,8,'kd.scm.common.helper.apiconnector.apihandle.ZkhStockHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1777446934416553984;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1779765989978789888,988249074580900864,1777446934416553984,8,'kd.scm.common.helper.apiconnector.apihandle.ZkhPriceHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1783272269024445440;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1778886220512877568,1013547746021389312,1783272269024445440,8,'kd.scm.common.helper.apiconnector.apihandle.ConfirmOrderHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1783291022671987712;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1778886347994524672,1094953071928150016,1783291022671987712,7,'kd.scm.common.helper.apiconnector.apihandle.DefaultHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1783434480300589056;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1783433929571696640,1023804725428022272,1783434480300589056,8,'kd.scm.common.helper.apiconnector.apihandle.CancelOrderHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1783460917082588160;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1778886559135788032,1031918509333995520,1783460917082588160,7,'kd.scm.common.helper.apiconnector.apihandle.ConfirmReceivedHandleProcessor','0','9'); 

DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1808018530361277440;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1808017619534609408,1005817789182653440,1808018530361277440,7,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1808018827762596864;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1808018029007731712,1297768642041141248,1808018827762596864,5,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceLogistHandleProcessor','0','9'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1808033495277239296;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1808017907012080640,1010819042207908864,1808033495277239296,7,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','0','9'); 
--业务扩展配置--
DELETE FROM t_pbd_extensionentry WHERE FENTRYID = 1794840236698747904;
INSERT INTO t_pbd_extensionentry(FID,FENTRYID,FSEQ,FKEY,FIMPL,FDEFAULT,FVALID) VALUES (1779098004486198272,1794840236698747904,8,'9','kd.scm.mal.business.placeorder.service.impl.MalZkhSubmitOrderServiceImpl','0','1');

--电商状态--
DELETE FROM t_mal_emalstatus WHERE FID = 1792112123065786368;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1792112123065786368,'2','2','9','审核中','1','A'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1792113347307627520;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1792113347307627520,'2','2','9','售后完成','5','B'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1792114062931386368;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1792114062931386368,'2','2','9','审核驳回','3','C'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1792114460308135936;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1792114460308135936,'2','2','9','客户取消','6','E'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1792112624981369856;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1792112624981369856,'2','2','9','审核通过','4','B'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112123065786368 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112123065786368,'3M3UFCX8QP9M','zh_CN','待确认'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112123065786368 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112123065786368,'3M3UFCX8QP9N','zh_TW','待確認'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112624981369856 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112624981369856,'3M3UJ0J802LZ','zh_CN','已确认'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112624981369856 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112624981369856,'3M3UJ0J802M+','zh_TW','已確認'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792113347307627520 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792113347307627520,'3M3UO=U49S4X','zh_CN','已确认'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792113347307627520 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792113347307627520,'3M3UO=U49S4Y','zh_TW','已確認'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114062931386368 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114062931386368,'3M3UTI6RAQFC','zh_CN','已打回'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114062931386368 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114062931386368,'3M3UTI6RAQFD','zh_TW','已打回'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114460308135936 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114460308135936,'3M3UWE42/ZU6','zh_CN','取消'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114460308135936 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114460308135936,'3M3UWE42/ZU7','zh_TW','取消'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112123065786368 and FLOCALEID = 'en_US';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112123065786368,'3M4DI/=XOF9F','en_US','^en_US待确认^'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114460308135936 and FLOCALEID = 'en_US';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114460308135936,'3M4DI/=XOFYP','en_US','^en_US取消^'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792113347307627520 and FLOCALEID = 'en_US';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792113347307627520,'3M4DI/=XOF9G','en_US','^en_US已确认^'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792112624981369856 and FLOCALEID = 'en_US';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792112624981369856,'3M4DI/=XOFYQ','en_US','^en_US已确认^'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1792114062931386368 and FLOCALEID = 'en_US';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1792114062931386368,'3M4DI/=XOF9H','en_US','^en_US已打回^');
DELETE FROM t_mal_emalstatus WHERE FID = 1798631057134941184;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631057134941184,'4','4','9','有货现货-预计需要x日发货','33','1'); 

DELETE FROM t_mal_emalstatus WHERE FID = 1798631090714539008;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631090714539008,'3','3','9','待申请','0','1'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1798631090714416128;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631090714416128,'4','4','9','预定','36','1'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1798631090714539009;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631090714539009,'4','4','9','无货','34','2'); 

DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631057134941184 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631057134941184,'3MY1GZXXMA+5','zh_CN','有货'); 

DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631090714539008 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631090714539008,'3MY1H+NXWS=E','zh_CN','待申请'); 

DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631090714416128 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631090714416128,'3MY1H+NXWS=F','zh_CN','有货'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631090714539009 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631090714539009,'3MY1H+NXWS=G','zh_CN','无货'); 

DELETE FROM t_mal_emalstatus WHERE FID = 1799447755517719552;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1799447755517719552,'1','1','9','新建','0','1'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1799447755954052096;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1799447755954052096,'1','1','9','妥投','1','1'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1799447762639647744;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1799447762639647744,'1','1','9','部分妥投','3','1'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1799447762639772672;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1799447762639772672,'1','1','9','拒收','2','3'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1799447755517719552 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1799447755517719552,'3N0+20NZWLV+','zh_CN','已生成'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1799447755954052096 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1799447755954052096,'3N0+20NZWLV/','zh_CN','已生成'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1799447762639647744 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1799447762639647744,'3N0+21HECI1Z','zh_CN','已生成'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1799447762639772672 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1799447762639772672,'3N0+21HECI2+','zh_CN','已取消'); 

DELETE FROM t_mal_emalstatus WHERE FID = 1798631090722804736;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631090722804736,'3','3','9','已寄出','2','6'); 
DELETE FROM t_mal_emalstatus WHERE FID = 1798631090722927616;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1798631090722927616,'3','3','9','已开票','1','6'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631090722927616 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631090722927616,'3MY1H+NXWS=K','zh_CN','开票成功'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1798631090722804736 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1798631090722804736,'3MY1H+NXWS=L','zh_CN','开票成功'); 

DELETE FROM t_mal_emalstatus WHERE FID = 1813700319914352640;
INSERT INTO t_mal_emalstatus(FID,FSTATUSTYPENUMBER,FSTATUSTYPE,FEMALTYPE,FEMALSTATUSNAME,FEMALSTATUSNUMBER,FNUMBER) VALUES (1813700319914352640,'3','3','9','待审核','3001','2'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1813700319914352640 and FLOCALEID = 'zh_CN';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1813700319914352640,'3OS936YN84HB','zh_CN','待审核'); 
DELETE FROM t_mal_emalstatus_l WHERE FID = 1813700319914352640 and FLOCALEID = 'zh_TW';
INSERT INTO t_mal_emalstatus_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1813700319914352640,'3OS936YN84HC','zh_TW','待審核');

