
/**外部系统-晨光**/

DELETE FROM t_mal_extsys WHERE FID = 1150541456767723520;
INSERT INTO t_mal_extsys(FID,FCREATETIME,FSYSSOURCEID,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FSYSTYPE,FNUMBER) VALUES (1150541456767723520,{ts'2021-05-07  00:00:00'},1084020250686539776,13466739,'1',{ts'2021-05-07  00:00:00'},1150541456767723520,'C',13466739,'6','SCM-CG'); 

DELETE FROM t_mal_extsys_l WHERE FPKID = '1LA3PX7TWX+G';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150541456767723520,'1LA3PX7TWX+G','zh_CN','晨光'); 
DELETE FROM t_mal_extsys_l WHERE FPKID = '1LA3PX7TWX+H';
INSERT INTO t_mal_extsys_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150541456767723520,'1LA3PX7TWX+H','zh_TW','晨光'); 

/**外部系统API-晨光**/

DELETE FROM t_mal_extsys_api WHERE FID = 1150542093765060608;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542093765060608,'isc_metadata_schema','1','晨光预下订单',1150542093765060608,'C',5776790953889886325,'/api/restful/order','SRM_CG_ORDER_order',1150541456767723520,{ts'2021-05-07  00:00:00'},72202045,'1','1',{ts'2021-06-26  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542210534483968;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542210534483968,'isc_metadata_schema','0','晨光获取商品SKU集合(初始化)',1150542210534483968,'C',632873935282197189,'/api/restful/categories_init','SRM_CG_GOODS_categories_init',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542312313487360;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542312313487360,'isc_metadata_schema','0','晨光获取商品详细信息',1150542312313487360,'C',2827778809920589240,'/api/restful/product/#{skuId}/detail','SRM_CG_GOODS_detail',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542548008206336;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542548008206336,'isc_metadata_schema','0','晨光获取二级地址',1150542548008206336,'C',905004230789007919,'/api/restful/area/province/#{id}/cities','SRM_CG_ADDRESS_getCities',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542616635408384;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542616635408384,'isc_metadata_schema','0','晨光获取三级地址',1150542616635408384,'C',6270365417817565229,'/api/restful/area/city/#{id}/counties','SRM_CG_ADDRESS_getCounties',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542698885709824;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542698885709824,'isc_metadata_schema','0','晨光获取一级地址(初始化)',1150542698885709824,'C',173624557811430586,'/api/restful/area/provinces_init','SRM_CG_ADDRESS_getProvince_init',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150542789935638528;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150542789935638528,'isc_metadata_schema','0','晨光获取商品上下架状态(初始化)',1150542789935638528,'C',1636115857871301918,'/api/restful/products/status_init','SRM_CG_GOODS_status_init',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150543501549666304;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150543501549666304,'isc_metadata_schema','1','晨光获取商品价格',1150543501549666304,'C',1698821374299893052,'/api/restful/products/prices','SRM_CG_GOODS_prices',1150541456767723520,{ts'2021-05-07  00:00:00'},72202045,'1','1',{ts'2021-06-26  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150543642025295872;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150543642025295872,'isc_metadata_schema','0','晨光获取商品价格(初始化)',1150543642025295872,'C',7666401478402412327,'/api/restful/products/prices_init','SRM_CG_GOODS_prices_init',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150543724997017600;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150543724997017600,'isc_metadata_schema','0','晨光获取分类下Sku',1150543724997017600,'C',3870489595507244286,'/api/restful/category/#{id}/skus','SRM_CG_GOODS_skus',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150543799647217664;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150543799647217664,'isc_metadata_schema','0','晨光获取商品分类',1150543799647217664,'C',8372556155636818424,'/api/restful/categories','SRM_CG_GOODS_Categories',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1150543941959952384;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1150543941959952384,'isc_metadata_schema','0','晨光获取一级地址',1150543941959952384,'C',3323111074165650535,'/api/restful/area/provinces','SRM_CG_ADDRESS_getProvince',1150541456767723520,{ts'2021-05-07  00:00:00'},13466739,'1','1',{ts'2021-05-07  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1151372701072392192;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1151372701072392192,'isc_metadata_schema','0','晨光批量获取商品库存',1151372701072392192,'C',143613875870883620,'/api/restful/products/areastocks','SRM_CG_GOODS_getNewStockById',1150541456767723520,{ts'2021-05-08  00:00:00'},72202045,'1','1',{ts'2021-06-21  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1151436500957691904;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1151436500957691904,'isc_metadata_schema','0','晨光查询商品图片',1151436500957691904,'C',7283446731797244354,'/api/restful/products/images','SRM_CG_GOODS_skuImage',1150541456767723520,{ts'2021-05-08  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1154894376149748736;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1154894376149748736,'isc_metadata_schema','0','晨光获取商品上下架状态',1154894376149748736,'C',2564154353208067072,'/api/restful/products/status','SRM_CG_GOODS_status',1150541456767723520,{ts'2021-05-13  00:00:00'},13466739,'1','1',{ts'2021-05-13  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1155818674553129984;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1155818674553129984,'isc_metadata_schema','0','晨光获取订单信息',1155818674553129984,'C',8633325904498283736,'/api/restful/order/#{order_id}/query','SRM_CG_ORDER_query',1150541456767723520,{ts'2021-05-14  00:00:00'},89186823,'1','1',{ts'2021-05-20  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167900902124716032;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167900902124716032,'isc_metadata_schema','0','晨光退换货申请',1167900902124716032,'C',2167422833648574758,'/api/restful/refund/apply','SRM_CG_AFTERSALE_refundApply',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167901091841474560;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167901091841474560,'isc_metadata_schema','0','晨光退换货申请',1167901091841474560,'C',1248637732525657119,'/api/restful/refund/query','SRM_CG_AFTERSALE_refundQuery',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167901344548268032;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167901344548268032,'isc_metadata_schema','0','晨光客户取消退换货调用接口',1167901344548268032,'C',4760006342398154726,'/api/restful/refund/cancle','SRM_CG_AFTERSALE_refundCancel',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167901452350291968;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167901452350291968,'isc_metadata_schema','0','晨光退货完成',1167901452350291968,'C',3473973189350476103,'/api/restful/refund/finish','SRM_CG_AFTERSALE_refundFinish',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167901792441214976;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167901792441214976,'isc_metadata_schema','1','晨光结算单申请',1167901792441214976,'C',3719471309876506890,'/api/restful/apiBill','SRM_CG_INVOICE_apiBill',1150541456767723520,{ts'2021-05-31  00:00:00'},72202045,'1','1',{ts'2021-06-26  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167901938990219264;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167901938990219264,'isc_metadata_schema','0','晨光开票查询',1167901938990219264,'C',287127204651937119,'/api/restful/apiBill/#{mark_id}/invoice','SRM_CG_INVOICE_invoice',1150541456767723520,{ts'2021-05-31  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167902191411800064;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167902191411800064,'isc_metadata_schema','0','晨光查询电子发票',1167902191411800064,'C',1538114691539723965,'/api/restful/getEInvoiceList','SRM_CG_INVOICE_getEInvoiceList',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1167902326787178496;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1167902326787178496,'isc_metadata_schema','0','晨光发票物流接口',1167902326787178496,'C',8533492487124063669,'/api/restful/invoice/logistics','SRM_CG_INVOICE_logistics',1150541456767723520,{ts'2021-05-31  00:00:00'},13466739,'1','1',{ts'2021-05-31  00:00:00'},13466739); 
DELETE FROM t_mal_extsys_api WHERE FID = 1174722384242964480;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1174722384242964480,'isc_metadata_schema','1','晨光确认订单',1174722384242964480,'C',8358020018845868144,'/api/restful/order/#{order_id}/confirmation','SRM_CG_ORDER_confirmation',1150541456767723520,{ts'2021-06-09  00:00:00'},72202045,'1','1',{ts'2021-06-26  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180935791644275712;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180935791644275712,'isc_metadata_schema','0','晨光查询开票信息消息接口',1180935791644275712,'C',76370649358649483,'/api/restful/paged/messages_invoice','SRM_CG_MESSAGE_invoice',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180936084238921728;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180936084238921728,'isc_metadata_schema','0','晨光删除消息接口',1180936084238921728,'C',1744308397592549080,'/api/restful/messages_del','SRM_CG_MESSAGE_del',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180938513336528896;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180938513336528896,'isc_metadata_schema','0','晨光查询订单状态消息接口',1180938513336528896,'C',5677242504459012463,'/api/restful/paged/messages_orderstate','SRM_CG_MESSAGE_orderstate',1150541456767723520,{ts'2021-06-18  00:00:00'},89186823,'1','1',{ts'2021-06-21  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180940840898424832;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180940840898424832,'isc_metadata_schema','0','晨光批量获取订单状态',1180940840898424832,'C',2366296112170488596,'/api/restful/order/states/query','SRM_CG_ORDER_statusQuery',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180944800103298048;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180944800103298048,'isc_metadata_schema','0','晨光获取订单状态',1180944800103298048,'C',3487194416054108979,'/api/restful/order/#{order_id}/status','SRM_CG_ORDER_status',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180945802751668224;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180945802751668224,'isc_metadata_schema','0','晨光订单对账',1180945802751668224,'C',9213189682804930612,'/api/restful/order/statement','SRM_CG_ORDER_statement',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180946409164141568;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180946409164141568,'isc_metadata_schema','0','晨光订单对账查询',1180946409164141568,'C',8949714470807850347,'/api/restful/order/signstatus','SRM_CG_ORDER_signstatus',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180946597731659776;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180946597731659776,'isc_metadata_schema','1','晨光订单确认收货',1180946597731659776,'C',4722558952513186283,'/api/restful/order/receiveConfirm','SRM_CG_ORDER_receiveConfirm',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-26  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180946960161469440;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180946960161469440,'isc_metadata_schema','0','晨光订单物流接口',1180946960161469440,'C',5082426058440569553,'/api/restful/order/#{order_id}/logistics','SRM_CG_ORDER_logistics',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-19  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180947622098137088;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180947622098137088,'isc_metadata_schema','0','晨光取消订单',1180947622098137088,'C',6783377554916050669,'/api/restful/order/#{order_id}/cancellation','SRM_CG_ORDER_cancellation',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1180948888199131136;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1180948888199131136,'isc_metadata_schema','0','晨光获取商品详细信息(初始化)',1180948888199131136,'C',4000040264025972143,'/api/restful/product/#{skuId}/detail_init','SRM_CG_GOODS_INIT',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181077025847276544;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181077025847276544,'isc_metadata_schema','0','晨光查询订单退货状态变化消息接口',1181077025847276544,'C',7611625587370550193,'/api/restful/paged/messages_returnstate','SRM_CG_MESSAGE_returnstate',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181077146324463616;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181077146324463616,'isc_metadata_schema','0','晨光查询订单退货申请状态变化消息接口',1181077146324463616,'C',890109204871804866,'/api/restful/paged/messages_returnreqstate','SRM_CG_MESSAGE_returnreqstate',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181077338868183040;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181077338868183040,'isc_metadata_schema','0','晨光查询价格消息接口',1181077338868183040,'C',4072219583190708645,'/api/restful/paged/messages_price','SRM_CG_MESSAGE_price',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181077685628072960;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181077685628072960,'isc_metadata_schema','0','晨光查询商品上下架消息接口',1181077685628072960,'C',2012427721519316127,'/api/restful/paged/messages_goodstate','SRM_CG_MESSAGE_goodstate',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181078016684486656;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181078016684486656,'isc_metadata_schema','0','晨光查询商品变更消息接口',1181078016684486656,'C',6739975189477230296,'/api/restful/paged/messages_good','SRM_CG_MESSAGE_goods',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181078182233665536;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181078182233665536,'isc_metadata_schema','0','晨光查询订单妥投消息接口',1181078182233665536,'C',5972285282842744939,'/api/restful/paged/messages_deliverdorders','SRM_CG_MESSAGE_deliverdorders',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 
DELETE FROM t_mal_extsys_api WHERE FID = 1181078329017529344;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1181078329017529344,'isc_metadata_schema','0','晨光查询订单取消消息接口',1181078329017529344,'C',8909078059866302871,'/api/restful/paged/messages_canceldorders','SRM_CG_MESSAGE_canceldorders',1150541456767723520,{ts'2021-06-18  00:00:00'},72202045,'1','1',{ts'2021-06-18  00:00:00'},72202045); 

/**外部系统API参数分录-晨光**/

DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226432;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226432,'string',1,'1','yggc_order',' ','订单单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226433;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'1',1150542093790226433,'string',2,'1','sku',' ','[{ "sku": "商品编号", "num": 商品数量, "price": 价格, "naked_price": 商品裸价, "tax_price": 商品税率, "naked_price_total": 商品裸价合计 "tax_price_total": 商品税额合计 "price_total": 商品协议价合计 }]'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226434;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226434,'string',3,'1','receiverName',' ','收货人姓名'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226435;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226435,'string',4,'1','provinceId',' ','一级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226436;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226436,'string',5,'1','cityId',' ','二级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226437;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226437,'string',6,'1','countyId',' ','三级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226438;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226438,'string',7,'1','address',' ','收货人详细地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226439;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226439,'string',8,'1','mobile',' ','手机号 （与phone其中一个有值即可）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226440;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226440,'string',9,'1','email',' ','邮箱'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226441;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226441,'string',10,'1','zip',' ','邮编'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226442;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226442,'string',11,'1','remark',' ','备注（少于100字）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226443;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226443,'string',12,'1','invoiceType',' ','发票类型'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226444;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226444,'string',13,'1','invoiceTitle',' ','发票抬头'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226445;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226445,'string',14,'1','paymentType',' ','支付方式 9：账期支付（默认值）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226446;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226446,'string',15,'1','amount',' ','订单金额（包含运费）'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226447;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226447,'string',16,'1','servFee',' ','运费'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226448;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226448,'string',17,'1','regCode',' ','专票纳税人识别号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226449;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226449,'string',18,'1','regBank',' ','发票开户行 发票类型为“增票” 必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226450;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226450,'string',19,'1','regBankAccount',' ','发票开户行账号 发票类型为“增票” 必填'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226451;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226451,'string',20,'1','invoicePhone',' ','收票人电话'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226452;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226452,'string',21,'1','invoiceAddress',' ','增专票收票人所在地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226453;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226453,'string',22,'1','purchaser',' ','采购人'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226454;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226454,'string',23,'1','dep_name',' ','采购单位名称'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542093790226455;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790226455,'string',24,'1','phone',' ','座机号 (与mobile其中一个有值即可)'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542312321875968;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321875968,'string',1,'1','skuId',' ','商品SKU编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542548008206337;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008206337,'string',1,'1','id',' ','省编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542616635408385;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635408385,'string',1,'1','id',' ','省编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150542789935638529;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150542789935638528,'1',1150542789935638529,'string',1,'1','skuIds',' ','多个商品编号; 支持批量，以英文逗号分隔'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150543501549666305;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'1',1150543501549666305,'string',1,'1','skuIds',' ','商品编码集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150543642033684480;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'1',1150543642033684480,'string',1,'1','skuIds',' ','商品编码集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150543642033684481;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'1',1150543642033684481,'string',2,'1','skuTaxrateList',' ','商品编码税率集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1150543724997017601;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1150543724997017600,'0',1150543724997017601,'string',1,'1','id',' ','商品分类编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1151372701072392193;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072392193,'STRUCT',1,'1','skuNums',' ','商品编码_数量Map'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1151372701072392194;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072392194,'string',2,'1','provinceId',' ','一级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1151372701072392195;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072392195,'string',3,'1','cityId',' ','二级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1151372701072392196;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072392196,'string',4,'1','countyId',' ','三级地址'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1151436500957691905;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1151436500957691904,'1',1151436500957691905,'string',1,'1','skuIds',' ','最大支持2000商品同时查，否则抛出异常'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1154894376183303168;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1154894376149748736,'1',1154894376183303168,'string',1,'1','skuIds',' ','多个商品编号; 支持批量，以英文逗号分隔'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1155818674586684416;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1155818674553129984,'0',1155818674586684416,'string',1,'1','orderId',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901091849863168;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901091841474560,'0',1167901091849863168,'string',1,'1','sheetId',' ','退换货申请编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901091849863169;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901091841474560,'0',1167901091849863169,'string',2,'1','orderId',' ','订单编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901344556656640;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901344548268032,'0',1167901344556656640,'string',1,'1','sheetId',' ','退换货申请编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901344556656641;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901344548268032,'0',1167901344556656641,'string',2,'1','orderId',' ','订单编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901344556656642;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901344548268032,'0',1167901344556656642,'string',3,'1','operator',' ','操作人'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901452350291969;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901452350291968,'0',1167901452350291969,'string',1,'1','apply_code',' ','退换货申请编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167901452350291970;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901452350291968,'0',1167901452350291970,'string',2,'1','order_id',' ','订单编号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167902191420188672;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167902191411800064,'0',1167902191420188672,'string',1,'1','order_ids',' ','订单编号，多个订单以英文逗号分隔'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167902326795567104;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167902326787178496,'0',1167902326795567104,'string',1,'1','invoiceNo',' ','发票号码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167902326795567105;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167902326787178496,'0',1167902326795567105,'string',2,'1','invoiceCode',' ','发票代码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882944;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882944,'string',1,'1','orderId',' ','订单号order_id  必录'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882945;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882945,'string',2,'1','aftersaleType',' ','服务类型apply_type'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882946;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882946,'string',3,'1','questionDesc',' ','产品问题描述apply_reason'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882947;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882947,'string',4,'1','address',' ','地址(默认订单中的地址)address'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882948;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882948,'string',5,'1','pickwareType',' ','上门取件、第三方物流（上门=1，第三方=2）默认上门取件pickup_way'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882949;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882949,'string',6,'1','provinceId',' ','省province_code'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882950;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882950,'string',7,'1','cityId',' ','市city_code'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882951;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882951,'string',8,'1','countyId',' ','县county_code'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882952;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882952,'string',9,'1','aftersalePhone',' ','联系电话apply_telephone'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882953;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882953,'string',10,'1','customerMobilePhone',' ','联系人手机apply_mobile'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882954;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882954,'string',11,'1','customerEmail',' ','邮箱apply_email'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882955;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882955,'string',12,'1','aftersaleName',' ','退换货联系人（默认订单收货人），不为空时收货人相关信息字段信息必填apply_name'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882956;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'1',1167947821068882956,'string',13,'1','skus',' ','[{"sku":商品编号, "num":商品数量, "price”:价格}] 若为null则表示整单退 skus'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882957;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882957,'string',14,'1','applyTime',' ','退换货申请时间（2017-12-18 09:22:07）apply_time'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882958;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882958,'string',15,'1','townId',' ','退货人乡镇编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1167947821068882959;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068882959,'string',16,'1','fullAddress',' ','退货人详细地址(默认订单中的地址)例如 1_10_100_1000'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017472;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017472,'string',1,'1','settlementId',' ','结算单号bill_no'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017473;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017473,'string',2,'1','supplierOrder',' ','发票请求子订单号批量以 ,号分割order_ids'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017474;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017474,'string',3,'1','markId',' ','第三方申请发票的唯一id标识mark_id'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017475;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017475,'string',4,'1','settlementNum',' ','结算单子订单总数settle_num'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017476;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017476,'string',5,'1','settleNakedPrice',' ','结算单不含税总金额（裸价）settle_naked_price'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017477;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017477,'string',6,'1','invoiceTaxPrice',' ','结算单总税价settle_tax_price'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017478;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017478,'string',7,'1','invoiceType',' ','发票类型 1：增票 2：普票invoice_type'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017479;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017479,'string',8,'1','bizInvoiceContent',' ','开票内容： 明细 办公用品 电脑配件 耗材（需要业务部门确认）invoice_content'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017480;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017480,'string',9,'1','invoiceDate',' ','期望开票时间 yyyy-MM-dd  invoice_date'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017481;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017481,'string',10,'1','title',' ','发票抬头invoice_title'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017482;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017482,'string',11,'1','invoicePhone',' ','发票电话invoice_phone'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017483;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017483,'string',12,'1','enterpriseTaxpayer',' ','税号invoice_tax_num'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017484;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017484,'string',13,'1','enterpriseBankName',' ','发票开户行invoice_bank'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017485;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017485,'string',14,'1','enterpriseBankAccount',' ','银行账号invoice_bank_accout'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017486;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017486,'string',15,'1','billToParty',' ','收票单位invoice_company_name'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017487;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017487,'string',16,'1','billToer',' ','收票人bill_toer'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017488;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017488,'string',17,'1','billToContact',' ','收票人联系方式bill_to_contact'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017489;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017489,'string',18,'1','billToProvince',' ','收票人地址（省）bill_to_province'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017490;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017490,'string',19,'1','billToCity',' ','收票人地址（市）bill_to_city'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017491;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017491,'string',20,'1','billToCounty',' ','收票人地址（区）bill_to_county'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017492;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017492,'string',21,'1','billToTown',' ','收票人地址（镇）bill_to_town'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017493;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017493,'string',22,'1','billToAddress',' ','收票人全量地址bill_to_address'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017494;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017494,'string',23,'1','repaymentDate',' ','预计还款时间repayment_date'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168809656471017495;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901792441214976,'0',1168809656471017495,'string',24,'1','invoiceAddress',' ','发票地址invoice_address'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1168816845298359296;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1167901938990219264,'0',1168816845298359296,'string',1,'1','markId',' ','第三方申请发票唯一标识'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1174722384293296128;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1174722384242964480,'0',1174722384293296128,'string',1,'1','orderId',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180936084238921729;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180936084238921728,'1',1180936084238921729,'string',1,'1','value',' ','消息ID集合'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180940840898424833;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180940840898424832,'1',1180940840898424833,'string',1,'1','value',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180944800103298049;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180944800103298048,'0',1180944800103298049,'string',1,'1','orderId',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180945802751668225;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180945802751668224,'1',1180945802751668225,'string',1,'1','value',' ','订单编号组'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180946409164141569;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946409164141568,'0',1180946409164141569,'string',1,'1','order_id',' ','订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180946409164141570;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946409164141568,'0',1180946409164141570,'string',2,'1','start_date',' ','开始时间yyyy-MM-dd'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180946409164141571;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946409164141568,'0',1180946409164141571,'string',3,'1','end_date',' ','结束时间yyyy-MM-dd'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180947622098137089;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180947622098137088,'0',1180947622098137089,'string',1,'1','orderId',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1180948888207519744;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207519744,'string',1,'1','skuId',' ','商品SKU编码'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1181839718556397568;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946960161469440,'0',1181839718556397568,'string',1,'1','orderId',' ','预下订单号'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1181839718556397569;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946960161469440,'0',1181839718556397569,'STRUCT',2,'1','skuOrderMap',' ','key:商品编号，value：orderItemId（订单行号），京东不需要传，苏宁必须传'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1183379094008507392;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1180946597731659776,'0',1183379094008507392,'string',1,'1','orderId',' ','订单号'); 

/**外部系统API结果分录-晨光**/

DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542093790248961;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790248961,'string',1,'yggc_order','订单单号,京东订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542093790248962;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790248962,'string',2,'orderPrice','订单总金额,订单总金额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542093790248963;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790248963,'string',3,'orderNakedPrice','订单未税金额,订单未税金额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542093790248964;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'0',1150542093790248964,'string',4,'orderTaxPrice','订单税额,订单税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542093790248965;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542093765060608,'1',1150542093790248965,'string',5,'sku','订单商品,[{ "sku": "商品编号", "num": 商品数量, "price": 价格, "naked'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542210534483969;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542210534483968,'0',1150542210534483969,'string',1,'id','分类编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542210534483970;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542210534483968,'0',1150542210534483970,'string',2,'name','分类名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853441;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853441,'string',1,'skuId','商品SKU'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853442;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853442,'string',2,'name','商品名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853443;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853443,'string',3,'mainpic','商品主图'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853444;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853444,'string',4,'category','商品分类'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853445;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853445,'string',5,'unit','计量单位'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853446;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853446,'string',6,'brand','品牌'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853447;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853447,'string',7,'model','规格型号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853448;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853448,'string',8,'platform','电商平台'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542312321853449;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542312313487360,'0',1150542312321853449,'string',9,'taxrate','商品税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183809;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183809,'string',1,'name','地址名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183810;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183810,'string',2,'number','地址编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183811;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183811,'string',3,'level','地址级次'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183812;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183812,'string',4,'longnumber','长编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183813;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183813,'string',5,'isleaf','是否叶子'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183814;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183814,'string',6,'fullname','长名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542548008183815;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542548008206336,'0',1150542548008183815,'string',7,'parent','上级'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385857;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385857,'string',1,'name','地址名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385858;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385858,'string',2,'number','地址编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385859;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385859,'string',3,'level','地址级次'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385860;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385860,'string',4,'longnumber','长编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385861;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385861,'string',5,'isleaf','是否叶子'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385862;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385862,'string',6,'fullname','长名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542616635385863;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542616635408384,'0',1150542616635385863,'string',7,'parent','上级'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709825;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709825,'string',1,'name','地址名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709826;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709826,'string',2,'number','地址编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709827;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709827,'string',3,'level','地址级次'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709828;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709828,'string',4,'longnumber','长编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709829;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709829,'string',5,'isleaf','是否叶子'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709830;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709830,'string',6,'fullname','长名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542698885709831;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542698885709824,'0',1150542698885709831,'string',7,'parent','上级'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542789935661057;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542789935638528,'0',1150542789935661057,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150542789935661058;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150542789935638528,'0',1150542789935661058,'string',2,'state','上下架状态,1：上架，0：下架'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643777;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643777,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643778;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643778,'string',2,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643779;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643779,'string',3,'price','单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643780;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643780,'string',4,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643781;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643781,'string',5,'tax','税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643782;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643782,'string',6,'ecPrice','电商价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543501549643783;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543501549666304,'0',1150543501549643783,'string',7,'discountRate','折扣率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661953;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661953,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661954;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661954,'string',2,'taxPrice','含税单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661955;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661955,'string',3,'price','单价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661956;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661956,'string',4,'taxRate','税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661957;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661957,'string',5,'tax','税额'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661958;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661958,'string',6,'ecPrice','电商价'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543642033661959;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543642025295872,'0',1150543642033661959,'string',7,'discountRate','折扣率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543799647217665;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543799647217664,'0',1150543799647217665,'string',1,'id','分类编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543799647217666;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543799647217664,'0',1150543799647217666,'string',2,'name','分类名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952385;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952385,'string',1,'name','地址名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952386;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952386,'string',2,'number','地址编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952387;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952387,'string',3,'level','地址级次'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952388;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952388,'string',4,'longnumber','长编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952389;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952389,'string',5,'isleaf','是否叶子'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952390;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952390,'string',6,'fullname','长名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1150543941959952391;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1150543941959952384,'0',1150543941959952391,'string',7,'parent','上级'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151372701072369665;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072369665,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151372701072369666;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072369666,'string',2,'areaId','区域码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151372701072369667;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072369667,'string',3,'stockStateId','库存状态编号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151372701072369668;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151372701072392192,'0',1151372701072369668,'string',4,'StockStateDesc','库存状态描述'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151436500957669377;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151436500957691904,'0',1151436500957669377,'string',1,'path','图片全路径'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1151436500957669378;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1151436500957691904,'0',1151436500957669378,'string',2,'orderSort','图片排序'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1154894376183280641;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1154894376149748736,'0',1154894376183280641,'string',1,'skuId','商品编码'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1154894376183280642;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1154894376149748736,'0',1154894376183280642,'string',2,'state','上下架状态,1：上架，0：下架'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1167947821068860416;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1167900902124716032,'0',1167947821068860416,'string',1,'serviceId','服务单号,退货申请单编码apply_code'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180935791677830144;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180935791644275712,'0',1180935791677830144,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180935791677830145;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180935791644275712,'0',1180935791677830145,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180935791677830146;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180935791644275712,'0',1180935791677830146,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180935791677830147;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180935791644275712,'0',1180935791677830147,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520769;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520769,'string',1,'skuId','商品SKU'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520770;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520770,'string',2,'name','商品名称'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520771;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520771,'string',3,'mainpic','商品主图'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520772;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520772,'string',4,'category','商品分类'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520773;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520773,'string',5,'unit','计量单位'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520774;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520774,'string',6,'brand','品牌'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520775;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520775,'string',7,'model','规格型号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520776;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520776,'string',8,'platform','电商平台'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1180948888207520777;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180948888199131136,'0',1180948888207520777,'string',9,'taxrate','商品税率'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077025889219584;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077025847276544,'0',1181077025889219584,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077025889219585;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077025847276544,'0',1181077025889219585,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077025889219586;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077025847276544,'0',1181077025889219586,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077025889219587;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077025847276544,'0',1181077025889219587,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077146349629440;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077146324463616,'0',1181077146349629440,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077146349629441;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077146324463616,'0',1181077146349629441,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077146349629442;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077146324463616,'0',1181077146349629442,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077146349629443;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077146324463616,'0',1181077146349629443,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077338901737472;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077338868183040,'0',1181077338901737472,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077338901737473;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077338868183040,'0',1181077338901737473,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077338901737474;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077338868183040,'0',1181077338901737474,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077338901737475;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077338868183040,'0',1181077338901737475,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077685644850176;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077685628072960,'0',1181077685644850176,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077685644850177;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077685628072960,'0',1181077685644850177,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077685644850178;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077685628072960,'0',1181077685644850178,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181077685644850179;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181077685628072960,'0',1181077685644850179,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078016801927168;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078016684486656,'0',1181078016801927168,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078016801927169;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078016684486656,'0',1181078016801927169,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078016801927170;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078016684486656,'0',1181078016801927170,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078016801927171;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078016684486656,'0',1181078016801927171,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078182267219968;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078182233665536,'0',1181078182267219968,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078182267219969;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078182233665536,'0',1181078182267219969,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078182267219970;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078182233665536,'0',1181078182267219970,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078182267219971;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078182233665536,'0',1181078182267219971,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078329067860992;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078329017529344,'0',1181078329067860992,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078329067860993;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078329017529344,'0',1181078329067860993,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078329067860994;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078329017529344,'0',1181078329067860994,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181078329067860995;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1181078329017529344,'0',1181078329067860995,'string',4,'type','消息类型,消息类型'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181839718556398592;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180946960161469440,'0',1181839718556398592,'string',1,'porderId','父订单号'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1181839718556398593;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180946960161469440,'0',1181839718556398593,'string',2,'orderTrack','物流详情'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1183310452529059840;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180938513336528896,'0',1183310452529059840,'string',1,'id','消息ID,消息ID'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1183310452529059841;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180938513336528896,'0',1183310452529059841,'string',2,'result','消息体,消息体'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1183310452529059842;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180938513336528896,'0',1183310452529059842,'datetime',3,'time','推送时间,推送时间'); 
DELETE FROM t_mal_extsysapi_outputs WHERE FENTRYID = 1183310452529059843;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (1180938513336528896,'0',1183310452529059843,'string',4,'type','消息类型,消息类型'); 

/**外部系统API多语言-晨光**/

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3UJ91SM7I';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542093765060608,'1LA3UJ91SM7I','zh_CN','晨光预下订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3VDF/8X4F';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542210534483968,'1LA3VDF/8X4F','zh_CN','晨光获取商品SKU集合(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3W4C5HHSC';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542312313487360,'1LA3W4C5HHSC','zh_CN','晨光获取商品详细信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3XVBDFV2K';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542548008206336,'1LA3XVBDFV2K','zh_CN','晨光获取二级地址'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3YBV0/K0Z';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542616635408384,'1LA3YBV0/K0Z','zh_CN','晨光获取三级地址'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3YZ7N8JV5';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542698885709824,'1LA3YZ7N8JV5','zh_CN','晨光获取一级地址(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA3ZM2T6GIZ';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150542789935638528,'1LA3ZM2T6GIZ','zh_CN','晨光获取商品上下架状态(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA42TB++K9D';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150543501549666304,'1LA42TB++K9D','zh_CN','晨光获取商品价格'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA43U903VBL';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150543642025295872,'1LA43U903VBL','zh_CN','晨光获取商品价格(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA44EUJK4ID';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150543724997017600,'1LA44EUJK4ID','zh_CN','晨光获取分类下Sku'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA45+0YMBLM';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150543799647217664,'1LA45+0YMBLM','zh_CN','晨光获取商品分类'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LA46/H984OM';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1150543941959952384,'1LA46/H984OM','zh_CN','晨光获取一级地址'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LE305GPWAJ3';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1151372701072392192,'1LE305GPWAJ3','zh_CN','晨光批量获取商品库存'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LEDZ1XTH7CI';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1151436500957691904,'1LEDZ1XTH7CI','zh_CN','晨光查询商品图片'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LV+0JJB0V09';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1154894376149748736,'1LV+0JJB0V09','zh_CN','晨光获取商品上下架状态'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1LZDQX1IB/OD';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1155818674553129984,'1LZDQX1IB/OD','zh_CN','晨光获取订单信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF==9EFQC74';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167901091841474560,'1NF==9EFQC74','zh_CN','晨光获取退货单信息'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=8WI=5SP9';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167900902124716032,'1NF=8WI=5SP9','zh_CN','晨光退换货申请'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=B38AXI6H';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167901344548268032,'1NF=B38AXI6H','zh_CN','晨光客户取消退换货调用接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=BWW1DDRL';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167901452350291968,'1NF=BWW1DDRL','zh_CN','晨光退货完成'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=ECIFYNF/';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167901792441214976,'1NF=ECIFYNF/','zh_CN','晨光结算单申请'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=FF5QOR+B';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167901938990219264,'1NF=FF5QOR+B','zh_CN','晨光开票查询'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=H9XFKSE9';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167902191411800064,'1NF=H9XFKSE9','zh_CN','晨光查询电子发票'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1NF=I9D+28K0';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1167902326787178496,'1NF=I9D+28K0','zh_CN','晨光发票物流接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1O9ZTXF2A63/';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1174722384242964480,'1O9ZTXF2A63/','zh_CN','晨光确认订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0QRX615U89';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180935791644275712,'1P0QRX615U89','zh_CN','晨光查询开票信息消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0QU0ANM7=N';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180936084238921728,'1P0QU0ANM7=N','zh_CN','晨光删除消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0R9QNNK=E3';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180938513336528896,'1P0R9QNNK=E3','zh_CN','晨光查询订单状态消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0RPP42T/GC';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180940840898424832,'1P0RPP42T/GC','zh_CN','晨光批量获取订单状态'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0SFJ=Z+M61';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180944800103298048,'1P0SFJ=Z+M61','zh_CN','晨光获取订单状态'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0SMV8T=XQ6';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180945802751668224,'1P0SMV8T=XQ6','zh_CN','晨光订单对账'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0SR9L+1DQQ';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180946409164141568,'1P0SR9L+1DQQ','zh_CN','晨光订单对账查询'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0SSN618/W6';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180946597731659776,'1P0SSN618/W6','zh_CN','晨光订单确认收货'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0SV=5Z93VU';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180946960161469440,'1P0SV=5Z93VU','zh_CN','晨光订单物流接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0T+3=IPU=8';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180947622098137088,'1P0T+3=IPU=8','zh_CN','晨光取消订单'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P0T7B3FS5=9';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1180948888199131136,'1P0T7B3FS5=9','zh_CN','晨光获取商品详细信息(初始化)'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1E51VKKYWY';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181077025847276544,'1P1E51VKKYWY','zh_CN','晨光查询订单退货状态变化消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1E5Z2PD5U=';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181077146324463616,'1P1E5Z2PD5U=','zh_CN','晨光查询订单退货申请状态变化消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1E7BTV=KLK';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181077338868183040,'1P1E7BTV=KLK','zh_CN','晨光查询价格消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1E9WC+9OJR';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181077685628072960,'1P1E9WC+9OJR','zh_CN','晨光查询商品上下架消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1EB=GC2CYM';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181078016684486656,'1P1EB=GC2CYM','zh_CN','晨光查询商品变更消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1ECHH=J3P/';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181078182233665536,'1P1ECHH=J3P/','zh_CN','晨光查询订单妥投消息接口'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '1P1EDK7C2053';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1181078329017529344,'1P1EDK7C2053','zh_CN','晨光查询订单取消消息接口'); 

/**外部系统API组**/

DELETE FROM t_mal_extapiset WHERE FID = 1094950691669018624;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1094950691669018624,{ts'2021-02-19  00:00:00'},13466739,'1','1',{ts'2021-02-19  00:00:00'},' ',1094950691669018624,'C',13466739,'SRM_EC_ORDER_STATUS'); 
DELETE FROM t_mal_extapiset WHERE FID = 1094953071928150016;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1094953071928150016,{ts'2021-02-19  00:00:00'},13466739,'1','1',{ts'2021-02-19  00:00:00'},' ',1094953071928150016,'C',13466739,'SRM_EC_ORDER_DETAIL'); 

/**外部系统API组多语言-晨光**/

DELETE FROM t_mal_extapiset_l WHERE FPKID = '1EGSTZ+F/=E2';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1094950691669018624,'1EGSTZ+F/=E2','zh_CN','电商获取订单状态'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '1EGSTZ+F/=E3';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1094950691669018624,'1EGSTZ+F/=E3','zh_TW','電商獲取訂單狀態'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '1EGT9=EVAVEC';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1094953071928150016,'1EGT9=EVAVEC','zh_CN','电商获取订单详情'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '1EGT9=EVAVED';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1094953071928150016,'1EGT9=EVAVED','zh_TW','電商獲取訂單詳情'); 


/**外部系统API组分录**/
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1150547155233024000;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1009300523653847040,1150542312313487360,1150547155233024000,4,'kd.scm.common.helper.apiconnector.apihandle.ProdHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1151436616737236992;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1001655311695620096,1151436500957691904,1151436616737236992,4,'kd.scm.common.helper.apiconnector.apihandle.ImageHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1153640539896162304;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (988249074580900864,1150543501549666304,1153640539896162304,4,'kd.scm.common.helper.apiconnector.apihandle.CgPriceHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1154894672242422784;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1001521588543179776,1154894376149748736,1154894672242422784,4,'kd.scm.common.helper.apiconnector.apihandle.SkuStateHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1168760446497347584;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1005817789182653440,1167901792441214976,1168760446497347584,4,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1168814653967456256;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1010819042207908864,1167901938990219264,1168814653967456256,4,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1174722671879944192;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1013547746021389312,1174722384242964480,1174722671879944192,4,'kd.scm.common.helper.apiconnector.apihandle.ConfirmOrderHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1181716899772264448;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1023804725428022272,1180947622098137088,1181716899772264448,4,'kd.scm.common.helper.apiconnector.apihandle.CancelOrderHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1181852357311362048;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1012225225254817792,1180946960161469440,1181852357311362048,4,'kd.scm.common.helper.apiconnector.apihandle.LogisticsHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1182012615728066560;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1031918509333995520,1180946597731659776,1182012615728066560,3,'kd.scm.common.helper.apiconnector.apihandle.ConfirmReceivedHandleProcessor','0','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1151372904756160512;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1002829616169140224,1151372701072392192,1151372904756160512,4,'kd.scm.common.helper.apiconnector.apihandle.StockHandleProcessor','0','6'); 

DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1094950691710961664;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1094950691669018624,1015877603568929792,1094950691710961664,1,'kd.scm.common.helper.apiconnector.apihandle.DefaultHandleProcessor','0','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1094953071953315840;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1094953071928150016,985476041839476736,1094953071953315840,1,'kd.scm.common.helper.apiconnector.apihandle.DefaultHandleProcessor','0','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1094953071953315841;
INSERT INTO t_mal_ext_apisetentry(FID,FEXTSYSAPI,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1094953071928150016,1072253193628469248,1094953071953315841,2,'kd.scm.common.helper.apiconnector.apihandle.DefaultHandleProcessor','0','5'); 

