schm-leqee-oms-eapi
schm-leqee-oms-eapi中文文档
接口描述: 代理权限管理api
UAT地址(测试环境): https://schm-api-test.shiseido.cn/schm-leqee-oms-eapi
PROD地址(生产环境): https://schm-api.shiseido.cn/schm-leqee-oms-eapi
请求方法:
要使用HTTP请求,需要传入报头、请求体、请求参数等。
请求头参数
身份认证
所有请求头必须包含以下键值参数作为身份验证信息。您需要向管理员申请这些信息。
client_id: fa98****3452
client_secret: 108b****41f2
appKey、partyId、time、sign等原有的系统参数不需要客户端手工传递,它们由mulesoft自动添加。
测试环境自动灌装系统参数:
partyId: 65653
appKey: oms-server-client
接口总览:
| 请求接口 | 描述 |
|---|---|
| /order/oms/list | Oms列表页面 |
| /order/detail | 订单详情 |
| /getProductMaintenance | Skus映射接口 |
| /getSalePos | SAP销售数据查询返回 |
| /protal/groupProvince/list | 订单重量查询-按打包方式+省市汇总 |
| /protal/groupType/list | 订单重量查询接口(按打包方式汇总) |
| /protal/info/list | 订单重量查询 |
| /sync/service | 库存查询 |
| /oms/sku/inventory/list | 获取可用库存 |
| /getSaleCollectOrder | 领用出库详情 |
| /getProcurementOrder | 入库回传补货接口 |
OMS列表页面
请求接口: /order/oms/list
接口描述: Oms列表页面
请求类型: HTTP POST
请求参数:
| 字段名称 | 类型 | 字段描述 |
|---|---|---|
| orderSns | List | 订单号 |
| startOrderTime | Date | 订单时间 |
| endOrderTime | Date | 订单时间 |
| startPayTime | Date | 付款(付尾款)时间 |
| endPayTime | Date | 付款(付尾款)时间 |
| startShippingTime | Date | 发货时间 |
| endShippingTime | Date | 发货时间 |
| startEarnestTime | Date | 付定金时间 |
| endEarnestTime | Date | 付定金时间 |
| startReceivingTime | Date | 确认收货时间 |
| endReceivingTime | Date | 确认收货时间 |
| pushTimeStart | Date | 订单推送时间 |
| pushTimeEnd | Date | 订单推送时间 |
| refundStatus | String | 退款状态;NONE:'无退款',APPLIED:'已申请',RETURNED:'全部退款',PART_RETURNED:'部分退款' |
| platformOrderStatus | List | 平台订单状态;WAIT_BUYER_PAY:'未付款',PRESELL_NO_PAID:'已付定金未付尾款',PAID_FORBID_CONSIGN:'已付款但禁止发货',WAIT_SELLER_SEND_GOODS:'待发货',SELLER_CONSIGNED_PART:'部分发货',WAIT_BUYER_CONFIRM_GOODS:'已发货',TRADE_BUYER_SIGINED:'已签收',TRADE_FINISHED:'交易成功',TRADE_CLOSED:'交易关闭' |
| orderStatuses | List | OMS订单状态;WAIT_CHECK:'待审核',REJECT:'退货驳回',CHECK_PASS:'待推送',PUSH_FAIL:'推送失败',PUSH:'已推送',OPERATED:'已入库',CANCEL:'已作废' |
| platformRefundStatus | String | 平台退款状态;"ALL_REFUND":"平台已退款","PART_REFUND":"平台部分退款","NOT_REFUND":"平台未退款" |
| orderType | String | 订单类型;"SALE":"销售","EXCHANGE":"换货","SUPPLY":"补寄", |
| orderFrom | String | 订单来源;"DIRECT":"平台下载","MANUAL":"手工建单","HISTORY":"历史订单", |
| startPlatformOrderTime | Date | 拍下时间 |
| endPlatformOrderTime | Date | 拍下时间 |
| preSaleType | String | 预售单类型;"PRE_SALE_ADVANCE":"预售提前单","PRE_SALE_NORMAL":"预售普通单","NORMAL":"正常单", |
| liveType | String | 直播类型;"LIVE":"直播订单","NORMAL":"非直播订单", |
| sampleMarkSearchType | String | 派样订单;ORDER:订单级别,GOODS:商品级别 |
| existSampleMark | String | 派样订单;true:有派样标记,false:无派样标记 |
| estStartTime | Date | 平台发货时效 |
| estEndTime | Date | 平台发货时效 |
| estConTimeType | String | 平台发货时效类型;EST_GOODS:商品维度,EST_ORDER:订单维度,NOT_INCLUDE:无 |
| latestCollectionStartTime | Date | 最晚揽件时效 |
| latestCollectionEndTime | Date | 最晚揽件时效 |
| stockOutStartTime | Date | 仓库出库时效 |
| stockOutEndTime | Date | 仓库出库时效 |
| isCustomization | String | 是否定制;true:是,false:否 |
| shopIdList | List | 店铺名称 |
| warehouseIdList | List | 发货仓库 |
| warehouseType | String | 仓库类型 |
| shippingId | Long | 快递方式 |
| offset | Integer | 偏移量 |
| length | Integer | 页大小 |
响应参数:
| 字段名称 | 类型 | 字段描述 |
|---|---|---|
| totalCount | Integer | 订单总数量 |
| content | List | 订单列表 |
content参数列表:
| 字段名称 | 类型 | 字段描述 |
|---|---|---|
| orderId | Long | 订单ID |
| orderSn | String | OMS订单号 |
| orderType | String | 订单类型 |
| mergeOrSplit | String | 拆合类型 |
| presellType | String | 预售类型 |
| isJOSPreSaleOrder | Boolean | 是否是京东预售 |
| orderStatus | String | 订单状态 |
| liveType | String | 直播类型 |
| sampleType | String | 派样类型 |
| jitOrderType | String | 唯品会jit订单类型 |
| presaleConsign | String | 预售下沉 |
| isSFConsign | Boolean | 是否是顺丰下沉 |
| platformShipper | String | 平台发货仓 |
| deliveryServiceTag | String | 音尊达 |
| strategySnMap | Map<String,Set | 系统标签策略 |
| openUid | String | 买家标识 |
| buyer | String | 买家昵称 |
| shippingStatus | String | 快递状态 |
| receiverName | String | 收件人姓名 |
| receiverMobile | String | 收件人手机号 |
| paytime | Date | 付款时间 |
| sendConditionType | String | 授信方式 |
| partyId | Long | 业务组id |
| receiverStatus | String | 收货状态 |
| esTime | String | 相对到达时间 |
| deliveryTime | Date | 揽件时效 |
| receiverAddress | String | 收件人地址 |
| expandPriceUsed | BigDecimal | 权益金 |
| earnestPaymentTime | Date | 付定金时间 |
| shippingTime | Date | 发货时间 |
| platformRefundStatus | String | 平台退款状态 |
| crossBorderExceptionNote | String | 跨境异常信息 |
| zwyExceptionNote | String | |
| serialExceptionNote | String | 序列号异常信息 |
| orderMergeRelativeOrderSns | List | 订单合并关系 |
| riskControlStatus | Integer | 风控状态 |
| ocFinanceIssueId | String | oc财审流程号 |
| ocFinanceApprovalStatus | String | oc财审流程状态 |
| isCustomization | Boolean | 是否定制单 |
| usedInventoryType | String | 使用冻结库存 |
| statusId | String | 库存状态;所有(默认,ALL),全新,二手 |
| expectedRepaymentTime | Date | 赊账回款时间 |
| preOutTime | Date | 预计出库时间 |
| bookActivateTime | Date | 订单激活时间 |
| emptyPackage | String | 空包发货 |
| isPreSend | Boolean | 是否预发货 |
| presendLogisticsNum | String | 预发货快递单号 |
| preSendStatus | String | 预发货状态 |
| platformShippingType | String | 平台快递类型 |
| consignLogisticsInfo | String | 快递下沉信息 |
| lpStrategyTags | List | lp配送策略标记 |
| checkDelayInfo | String | 延迟审单 |
| buyerMemo | String | 买家留言 |
| sellerMemo | String | 卖家留言 |
| shippingMemo | String | 仓库留言 |
| noteMemo | String | 便签留言 |
| crossBorderExceptionNote | String | 跨界异常信息 |
| latestCollectionTime | Date | 最晚揽件时效 |
| stockOutTime | Date | 仓库出库时效 |
| senTotalFee | String | 应收金额 |
| payStatusValue | String | 付款状态 |
| earnestPaymentTime | Date | 付定金时间 |
| paytime | Date | 付款(付尾款)时间 |
| orderStatus | String | OMS订单状态 |
| platformRefundStatus | String | 平台退款状态 |
| wmsOrder | Object | |
| –pushNote | String | 推送信息 |
| orderFx | Object | |
| –tallyStatus | String | 理货状态 |
| buyerResult | Object | |
| –blackRefused | Boolean | 是否黑名单 |
| –blackReason | String | 黑名单原因 |
| –particularReason | String | 特殊用户原因 |
| –particularUser | Boolean | 是否特殊用户 |
| shop | Object | |
| –shopPlatform | String | 店铺平台 |
| –shopId | Long | 店铺ID |
| –shopType | String | 店铺类型 |
| financeReasons | List | |
| –name | String | 财审原因 |
| packages | List | |
| –logisticsNumber | String | 物流单号 |
| –expressStatus | String | 物流状态 |
| –lastUpdateTime | Date | 最后更新时间 |
| distributor | Object | |
| –distributorName | String | 分销商名称 |
| orderTagInfos | List | 拦截标签 |
| –tagName | String | 标签名 |
| –tagColor | String | 标签颜色 |
| –tagId | Long | 标签id |
| customOrderTags | List | 自定义标签 |
| –tagName | String | 标签名 |
| –tagColor | String | 标签颜色 |
| –tagId | Long | 标签id |
| especialTagInfos | List | 异常标签 |
| –tagName | String | 标签名 |
| –tagColor | String | 标签颜色 |
| –tagId | Long | 标签id |
| originOrders | List | |
| –platformOrderId | String | 原始单号 |
| –orderFrom | String | 订单来源 |
| –platformOrderStatus | String | 平台订单状态 |
| –finalPaymentStatus | String | 付尾款时间 |
| –elseInfo | String | 其他额外信息 |
| receiverProvince | Object | |
| –regionName | String | 顾客地址-省 |
| receiverCity | Object | |
| –regionName | String | 顾客地址-市 |
| receiverDistrict | Object | |
| –regionName | String | 顾客地址-区 |
| receiverStreet | Object | |
| –regionName | String | 顾客地址-街道 |
| orderGoods | List | |
| –group | Object | |
| —-goodsGroupCode | String | 套餐编码 |
| –estConTime | Date | 发货时效 |
| –shortage | Boolean | 缺货 |
| –sku | Object | |
| —-skuCode | String | 商家编码 |
| —-skuName | String | 商品名称 |
| orderProcess | Object | |
| –stopSendStatus | String | 停发状态 |
| –wmsRejectStatus | String | 驳回状态 |
| –reservePriority | Integer | 预定优先级 |
| –priority | Integer | 优先级 |
| –presendStatus | String | 预发货状态 |
| –shortageStatus | String | 缺货状态 |
| –subOrderType | String | 子类型 |
| –financeCheckStatus | String | 财审状态 |
| –prepackReserveStatus | String | 预打包状态 |
| –exceptionTagList | List | 异常标签 |
| –checkTime | Date | 审单时间 |
| –reserveTime | Date | 预定时间 |
| –lockStatus | String | 锁定状态 |
| –lockUser | Object | 锁单用户 |
| —-name | String | 用户名 |
| –checker | Object | 审单用户 |
| —-name | String | 用户名 |
| warehouse | Object | |
| –warehouseName | String | 仓库名称 |
| shipping | Object | |
| –shippingName | String | 快递名称 |
| –isCod | Boolean | 是否COD |
| orderWeight | BigDecimal | 订单重量 |
| workOrders | List | |
| –etWorkOrder | Boolean | 是否et工单 |
| –workOrderSn | String | 工单编号 |
| –workName | String | 工单名称 |
| –status | String | 工单状态 |
| –workOrderId | Long | 工单id |
| orderLogisticsReservation | Object | |
| –status | String | |
| shenbaoInfo | Object | |
| –mftNo | String | 申报编码 |
| –shenbaoStatus | String | 申报状态 |
| liveTagStrategyInfos | List | ELC标签 |
| –packingWays | List | 包装方式 |
| –strategyType | String | 策略类型 |
| partyInventoryOrgDto | Object | |
| –partyInventoryOrgName | String | 库存组织名称 |
| salesman | Object | 业务员 |
| –account | String | 账户 |
| –name | String | 名称 |
json示例
成功
{
"code": "200",
"data": {
"content": [{
"alipayAmount": 21.00,
"buyer": "g***g",
"buyerMemo": "",
"buyerResult": {
"buyer": "ggg",
"buyerLableList": [],
"openUid": "ggg",
"openUserId": 389808,
"status": "NORMAL"
},
"communications": [],
"compensationShippings": [],
"cooperationRelation": "",
"createTime": "2023-01-17 11:07:26",
"currency": "RMB",
"discountFee": 0.00,
"emptyPackage": "N",
"especialTagInfos": [],
"exceptionLogs": [],
"financeReceiptRecordDetails": [],
"goodsFee": 21.00,
"handingFee": 0.00,
"handleOrders": [],
"isCustomization": false,
"isSFConsign": false,
"lastUpdateTime": "2023-01-17 11:07:58",
"liveType": "NORMAL",
"logisticsConsign": 0,
"maskTagInfos": [],
"needLoadingAndUnloading": false,
"needPostCode": false,
"needTally": false,
"noteMemo": "",
"omsMemo": "",
"orderAfterSales": [],
"orderGoodses": [{
"availableQuantity": 460661,
"diffKey": "66c5927350e94f64bd51c86da741b135",
"number": 1,
"orderGoodsId": 101315259481,
"originOrder": {
"platformOrderId": "OMS01202301170101"
},
"sku": {
"skuCode": "207_0",
"skuName": "康师傅金汤肥牛桶*12",
"skuNumberId": "21103931"
}
}],
"orderId": 7830115864689,
"orderProcess": {
"checkStatus": "CHECK_PASS",
"checkTime": "2023-01-17 11:07:48",
"checker": {
"account": "szhou1",
"name": "周赛"
},
"createTime": "2023-01-17 11:07:26",
"exceptionTagList": ["平台退款"],
"exceptionTags": "{\"exceptions\":[\"平台退款\"]}",
"financeCheckStatus": "CHECK_PASS",
"isCainiaoReserved": "I",
"isException": true,
"isMergePossible": false,
"lastUpdateTime": "2023-01-17 11:19:26",
"lockStatus": "UNLOCK",
"orderType": "SALE",
"partyId": 65558,
"presendStatus": "NO_PRESEND",
"priority": 9,
"reservePriority": 1,
"reserveTime": "2023-01-17 11:07:47",
"reserverStatus": "ALL_RESERVED",
"shortageStatus": "",
"stopSendStatus": "NORMAL",
"subOrderType": "NORMAL"
},
"orderSaleInvoices": [],
"orderSn": "XS012301065558081767",
"orderStatus": "CHECK_PASS",
"orderTagInfos": [],
"orderType": "SALE",
"orderTypeValue": "销售",
"orderVolume": 6.00,
"orderWeight": 4.00,
"originOrder": {
"basicPriceUsed": "",
"bizLogs": [],
"expandPriceUsed": "",
"id": 2019126314501,
"mergeOrders": [],
"orderGoodses": [],
"orderSaleInvoices": [],
"orders": [],
"originOrderRefunds": [],
"tcInfos": []
},
"originOrders": [{
"elseInfo": "{\"receiverMobileAddress\":\"中国大陆\"}",
"finalPaymentStatus": "DONTCARE",
"orderFrom": "DIRECT",
"platform": "KUAISHOU",
"platformOrderId": "OMS01202301170101",
"platformOrderStatus": "WAIT_BUYER_PAY",
"platformOrderTime": "2023-01-17 11:07:19"
}],
"packages": [{
"createTime": "2023-01-17 11:07:58",
"expressStatus": "INIT",
"expressStatusValue": "无揽收记录",
"lastUpdateTime": "2023-01-17 11:07:58",
"lastestShippingTime": "2023-01-17 11:07:58",
"logisticsNumber": "kstest011700001",
"shippingCode": "44",
"wmsActualPackageDetails": [],
"wmsActualPackageId": 396216682121497,
"wmsOrder": {
"wmsOrderId": 126523628
}
}],
"party": {
"partyId": 65558
},
"partyId": 65558,
"partyInventoryOrgDto": {
"partyInventoryOrgId": 0,
"partyInventoryOrgName": "默认组织",
"status": "NORMAL"
},
"partyInventoryOrgId": 0,
"payInfo": "{\"payId\":1,\"payNumber\":\"\"}",
"payNo": "",
"payStatus": "PAID",
"payStatusValue": "已付款",
"payment": 21.00,
"paytime": "2023-01-17 00:00:00",
"platformOrderId": "OMS01202301170101",
"platformOrderIds": ["OMS01202301170101"],
"platformOrderTime": "2023-01-17 11:07:19",
"platformRefundStatus": "ALL_REFUND",
"platformTalentFee": 0.00,
"postFee": 0.00,
"presellType": "NORMAL",
"priority": 9,
"receiptFee": 0.00,
"receivableFee": 21.00,
"receiverAddress": "******",
"receiverCity": {
"regionId": 48,
"regionName": "太原"
},
"receiverCountry": {
"regionId": 1
},
"receiverDistrict": {
"regionId": 1943,
"regionName": "小店区"
},
"receiverMobile": "******",
"receiverMobileAddress": "中国大陆",
"receiverName": "******",
"receiverPhone": "******",
"receiverProvince": {
"regionId": 5,
"regionName": "山西"
},
"receiverZip": "",
"refundStatus": "NONE",
"riskControlStatus": 0,
"salesman": {
"account": "szhou1",
"createTime": "2019-05-08 15:22:16",
"id": 123456793,
"lastUpdateTime": "2023-01-17 09:33:54",
"merchantId": 1,
"name": "周赛",
"station": "部门普通员工",
"uiVersion": "{\"saleOrdersManage\":\"OLD\"}"
},
"sellerMemo": "",
"senTotalFee": "21.00",
"sendConditionType": "PAID",
"shipping": {
"defaultShipping": false,
"isCod": 0,
"shippingCode": "SF",
"shippingId": 44,
"shippingName": "顺丰快递",
"shippingType": "SF"
},
"shippingMemo": "",
"shippingStatus": "OPERATED",
"shippingStatusValue": "仓库已操作",
"shippingTime": "2023-01-17 11:07:59",
"shop": {
"platform": "KUAISHOU",
"shopId": 1000001310,
"shopName": "fjin 快手测试店铺",
"shopNick": "fjin 快手测试店铺",
"shopPlatform": "KUAISHOU",
"shopType": "DIRECT"
},
"statusId": "INV_STTS_AVAILABLE",
"taxFee": 0.00,
"totalAmount": 21.00,
"totalFee": 21.00,
"totalGoodsValue": "21.00",
"warehouse": {
"warehouseName": "乐其东莞仓1122"
},
"workOrders": [{
"etWorkOrder": true,
"ewsClosed": false,
"historyInterceptWorkResults": [],
"lastUpdateTime": "2023-01-17 11:28:20",
"orderAfterSales": [],
"orderId": 7830115864689,
"orderSn": "XS012301065558081767",
"otherWorkOrders": [],
"partyId": 65558,
"relatedSaleOrders": [],
"status": "CANCEL",
"updateUserId": 0,
"workId": 0,
"workName": "快递拦截",
"workOrderActions": [],
"workOrderId": 29391,
"workOrderSn": "GD0000019854"
}]
}],
"totalCount": 1
},
"msg": "success",
"success": true
}错误
{
"code": "sys.biz-error",
"msg": "biz error",
"subCode": "sys.biz-error-order-transferred",
"subMsg": "error",
"success": false
}OMS 订单详情
请求接口: /order/detail
接口描述: oms 订单详情
请求类型: HTTP POST
请求参数:
| 字段名称 | 类型 | 是否必填 | 示例 | 字段描述 |
|---|---|---|---|---|
| orderId | long | 是 | 57302 | 订单id,唯一 |
相应参数:
| 字段名称 | 类型 | 字段描述 |
|---|---|---|
| orderSn | string | 订单号,例如XS102301065653061887 |
| party | struct | party |
| —partyName | string | 业务组名称 |
| sampleType | string | 派样标记,SAMPLE:打标“派样” |
| liveType | string | 直播标记,LIVE:打标“直播” |
| orderRelationType | string | 拆合单标记;拆单:SPLIT_ORDER_TARGET,合单:MERGE_ORDER_TARGET |
| orderStatus和shippingStatus | string | 订单状态;待审核:orderStatus=WAIT_CHECK&&shippingStatus=INIT,待推送:orderStatus=CHECK_PASS&&shippingStatus=INIT,已推送:orderStatus=CHECK_PASS&&shippingStatus=PUSH,已发货:orderStatus=CHECK_PASS&&shippingStatus=OPERATED,已作废:orderStatus=CLOSE_PLATFORM/CLOSE_PLATFORM_PAID/CLOSED_MANUAL,确认收货:orderStatus=CHECK_PASS&&shippingStatus=RECEIVED |
| sendConditionType | string | 授信方式;PAID(先款后货),GUARANTEE_PAID(担保已付款),COD_SHIP(货到付款,快递代收),COD(货到付款),PART_PAID(赊销有定金),UNPAID(赊销无定金) |
| payStatusValue | string | 付款状态.UNPAID(未付款),PAID(已付款),PART_PAID(部分付款),GUARANTEE_PAID(担保已付款),EARNEST_PAID(已付定金) |
| isCustomization | boolean | 特殊需求.是否定制 |
| orderLogisticsReservation | struct | 特殊需求.是否需要oc物流 |
| usedInventoryType | string | 特殊需求.usedInventoryType='FROZEN'表示使用冻结库存 |
| orderProcess | struct | orderProcess |
| —priority | int | 特殊需求.priority<=3表示已加急 |
| —reservePriority | int | 特殊需求.reservePriority=5显示库存优先 |
| —presendStatus | string | 特殊需求.预发货状态 |
| —wmsRejectStatus | string | 特殊需求.wmsRejectStatus='Pending'显示订单pending中.wmsRejectStatus='Intercepted'显示仓内拦截可退款 |
| —stopSendStatus | string | 特殊需求.stopSendStatus='AUTO_STOP'或'MANUAL_STOP'显示停发拦截 |
| —lockStatus | string | 特殊需求.lockStatus='LOCK'显示已锁定 |
| —subOrderType | string | 特殊需求.subOrderType='BOOK'时显示预订单释放时间:bookActivateTime |
| statusId | string | 特殊需求.statusId='INV_STTS_USED'二手销售,statusId='SALE_PACK'耗材销售 |
| sendConditionType | string | 特殊需求.sendConditionType='SELL_ON_CREDIT'时,expectedRepaymentTime为预计收款时间 |
| sampleType | string | 特殊需求.sampleType='SAMPLE'显示派样单 |
| platformShippingType | string | 特殊需求.京东配送方式 |
| checkDelayInfo | string | 特殊需求.延迟审核 |
| especialTagInfos | struct | especialTagInfos |
| —tagName | string | 特殊需求.聚划算,下沉成功,改过地址,改过仓库,改过商品明细,物流升级,送货上门 |
| presellType | string | 特殊需求,延迟预定,presellType=PRESELL |
| orderProcess | struct | orderProcess |
| —reserverStatus | string | 特殊需求,延迟预定,reserverStatus=UNRESERVED |
| —reserveTime | datetime | 特殊需求,延迟预定,reserveTime>当前时间+35秒 |
| —shortageStatus | string | 拦截标签.缺货 |
| customOrderTags | struct | customOrderTags |
| —tagName | string | 订单标签 |
| shop | struct | shop 资生堂官方旗舰店-天猫 |
| —shopName | string | 店铺名称,例如:shiseido |
| —shopPlatformValue | string | 平台.例如:天猫 |
| pay | struct | pay |
| —payName | string | 支付方式.例如在线支付,网银转账,调拨销售专用,微信支付,支付宝,银联支付,COD收款,跨主体调拨 |
| currency | string | 币种.RMB(人民币),USD(美元)等 |
| paytime | datetime | 付款时间.例如2023-01-16 14:09:21 14:09:17 |
| platformOrderTime | datetime | 拍下时间.例如2023-01-16 |
| latestCollectionTime | datetime | 最晚揽收时效.例如2023-02-06 14:09:21 |
| deliveryTime | datetime | 最晚发货时效.例如2023-02-06 14:09:21 |
| stockOutTime | datetime | 仓库出库时效.例如2023-02-06 08:09:21 |
| orderProcess | struct | orderProcess |
| —reserveTime | datetime | 预定时间 |
| —lastestPushTime | datetime | 最晚推送时间 |
| buyerMemo | string | 顾客留言 |
| sellerMemo | string | 小二留言 |
| shippingMemo | string | 仓库留言 |
| noteMemo | string | 便签留言 |
| originOrders | struct | originOrders |
| —platformOrderId | string | 原始单号 |
| —elseInfo中flagId | int | 插旗备注颜色,解析elseInfo(json格式)中key为flagId的字段 |
| —sellerMemo | string | 插旗备注内容 |
| —blackDeliveryCps | string[] | 快递黑白名单.黑名单列表 |
| —whiteDeliveryCps | string[] | 快递黑白名单.白名单列表 |
| —platformOrderStatus | string | 平台订单状态 |
| warehouse | struct | warehouse |
| —warehouseName | string | 仓库名称 |
| —warehouseType | string | 仓库类型 |
| shipping | struct | shipping |
| —shippingName | string | 快递名称 |
| packages | struct | packages |
| —logisticsNumber | string | 快递单号,示例:SF1620083894610 |
| usedInventoryType | string | 是否使用冻结库存.FROZEN表示使用冻结库存 |
| needPostCode | boolean | 需要贴码.true表示需要,false表示不需要 |
| needLoadingAndUnloading | boolean | 需要装卸货.true表示需要,false表示不需要 |
| needTally | boolean | 需要理货.true表示需要,false表示不需要 |
| orderOcFinanceInfo | struct | oc审批流程结构,不为空则需要oc审批流程 |
| —orderPurpose | string | 订单用途 |
| —sendBack | string | 是否需要寄回 |
| —feeAssume | string | 费用承担方 |
| —diffClaimSettlementWorkOrder | string | 差异理赔结算工单,订单用途选择差异理赔时必填 |
| orderGoods | struct | orderGoods |
| —groupNum或—number | int | 套餐数量或sku数量的平台发货时效 |
| —number | int | 拍下数 |
| —number | int | orderGoods.number结合订单发货状态.如果订单已发货或确认收货,则取orderGoods.number,否则为0 |
| —inventoryQuantity | int | 系统库存 |
| —availableQuantity | int | 可审库存 |
| —availableInventory | int | 可用库存 |
| —senPrice | string | 单价 |
| —senDiscountFee | string | 商品优惠 |
| —senDivideDiscountFee | string | 订单优惠分摊 |
| —senTariff | string | 商品关税 |
| —senGoodsFee | string | 货款小计 |
| —senTotalFee | string | 应收小计 |
| —divideExpandPriceUsed和—divideBasicPriceUsed | string | 购物金分摊 |
| —produceDateNum | int | 效期个数 |
| —produceDateStart和—produceDateEnd | datetime | 指定效期范围 |
| —batchNoNum | int | 批次个数 |
| —batchNos | string | 指定批次号 |
| —sku | struct | sku |
| ——barcode | string | 商家条码 |
| ——skuName | string | 单品名称 |
| ——goods | struct | goods |
| ———saleTaxRate | decimal | 销售税率 |
| —group | struct | group |
| ——goodsGroupCode | string | 套餐编码 |
| ——groupNum | int | 套餐数量 |
| orderVolume | decimal | 订单预估体积 |
| orderWeight | decimal | 订单预估重量 |
| senPostFee | string | 邮费 |
| totalGoodsValue | string | 商品总价值 |
| senGoodsFee | string | 货款总额 |
| senDiscountFee | string | 订单优惠 |
| senTotalDiscountFee | string | 总优惠金额 |
| senActualTotalFee | string | 应收金额 |
json示例
{
"code": "200",
"data": {
"alipayAmount": 9.9,
"buyer": "t****",
"buyerMemo": "",
"checkDelayInfo": "延迟审核,2023-01-29 00:00:21 可审核",
"communications": [],
"compensationShippings": [],
"cooperationRelation": "",
"createTime": "2023-01-16 14:41:30",
"currency": "RMB",
"deliveryTime": "2023-02-06 14:09:21",
"discountFee": 0,
"emptyPackage": "N",
"fenxiaoTotalFee": 0,
"goodsFee": 9.9,
"handingFee": 0,
"isCustomization": false,
"isSFConsign": false,
"lastUpdateTime": "2023-01-16 14:41:30",
"latestCollectionTime": "2023-02-06 14:09:21",
"liveType": "NORMAL",
"logisticsConsign": 0,
"maskTagInfos": [],
"needLoadingAndUnloading": false,
"needPostCode": false,
"needTally": false,
"omsMemo": "",
"openUid": "AAEoxLETAA96lSymD2zbyzNk",
"orderAfterSales": [],
"orderId": 57302,
"orderRelationType": "SPLIT_ORDER_TARGET",
"orderSaleInvoices": [],
"orderSn": "XS102301065653061366",
"orderStatus": "WAIT_CHECK",
"orderTagInfos": [],
"orderType": "SALE",
"orderTypeValue": "销售",
"orderVolume": 15.7,
"orderWeight": 38,
"partyId": 65653,
"partyInventoryOrgDto": {
"createTime": "2021-02-01 12:07:55",
"merchantId": 0,
"partyInventoryOrgId": 0,
"partyInventoryOrgName": "默认组织",
"status": "NORMAL",
"updateTime": "2021-02-01 12:07:55"
},
"partyInventoryOrgId": 0,
"payInfo": "{\"payId\":1}",
"payNo": "",
"payStatus": "PAID",
"payStatusValue": "已付款",
"payment": 9.9,
"paytime": "2023-01-16 14:09:21",
"platformDiscount": 0,
"platformOrderId": "3156817680761511656",
"platformOrderIds": [
"3156817680761511656"
],
"platformOrderTime": "2023-01-16 14:09:17",
"platformTalentFee": 0,
"postFee": 0,
"prePayment": 0,
"presaleConsign": "NORMAL",
"presellType": "NORMAL",
"priority": 9,
"receiptFee": 0,
"receivableFee": 9.9,
"receiverAddress": "******",
"receiverMobile": "******",
"receiverMobileAddress": "中国大陆",
"receiverName": "******",
"receiverPhone": "******",
"receiverZip": "000000",
"refundStatus": "NONE",
"relatedOrderIds": [],
"riskControlStatus": 0,
"sampleType": "SAMPLE",
"sellerAttach": [],
"senActualTotalFee": "",
"senDiscountFee": "******",
"senGoodsFee": "******",
"senPlatformDiscount": "******",
"senPlatformShopFee": "******",
"senPlatformTalentFee": "******",
"senPostFee": "******",
"senSumDiscountFee": "******",
"senSumDivideDiscountFee": "******",
"senSumGoodsFee": "******",
"senSumTariff": "******",
"senSumTotalFee": "******",
"senTotalDiscountFee": "******",
"senTotalFee": "******",
"sendConditionType": "PAID",
"shippingAttach": [],
"shippingServiceType": "APPOINT",
"shippingStatus": "INIT",
"shippingStatusValue": "待推送",
"statusId": "INV_STTS_AVAILABLE",
"stockOutTime": "2023-02-06 08:09:21",
"taxFee": 0,
"totalAmount": 101,
"totalFee": 9.9,
"totalGoodsValue": "******",
"workOrders": []
},
"msg": "success",
"success": true
}Skus 映射接口
请求接口: /getProductMaintenance
接口描述: Skus 映射接口
请求类型: HTTP POST
请求参数:
| 字段名称 | 是否必填 | 类型 | 字段描述 |
|---|---|---|---|
| page | Y | int | 页数为空默认1 |
| pageSize | Y | int | 每页数量,为空默认100 |
| SkuId | Y | Array int | oms商品ID 不为空 则忽略返回数量(page, pageSize) |
json示例
{
"SkuId": [
6367,
6368
],
"page": 1,
"pageSize": 100
}响应参数:
| 字段名称 | 是否必填 | 类型 | 字段描述 |
|---|---|---|---|
| partyId | N | string | 业务组ID |
| skuCode | N | string | oms中sku的商家编码 |
| barcode | N | string | 商品条码 |
| goodsName | N | string | 商品名称 |
| determineCode | N | string | 物料确定号 |
| sapLongCode | N | string | SAP长代码 |
| sapShortCode | N | string | SAP短代码 |
| sapName | N | string | SAP名称 |
| goodsType | N | string | Sales 正品,Sample小样 Supplies 耗材 |
| sapGoodsType | N | string | SAP商品类型 |
| updateTime | N | string | 最后更新时间 |
json示例
{
"code": 200,
"msg": "SUCCESS",
"data": [
{
"partyId": "65653",
"skuCode": "190325_0",
"barcode": "730852103016",
"goodsName": "资生堂盼丽风姿 抗皱洁面膏125ml",
"determineCode": "15143244111CN",
"sapLongCode": "82000352101CN",
"sapShortCode": "gergber",
"sapName": "测试商品名称",
"goodsType": "Sales",
"sapGoodsType": "tewst",
"updateTime": "2023-02-20 15:02:00"
},
{
"partyId": "65653",
"skuCode": "190325_0",
"barcode": "730852103016",
"goodsName": "资生堂盼丽风姿 抗皱洁面膏125ml",
"determineCode": "15143244111CN",
"sapLongCode": "82000352101CN",
"sapShortCode": "gergber",
"sapName": "测试商品名称",
"goodsType": "Sales",
"sapGoodsType": "tewst",
"updateTime": "2023-02-20 15:02:00"
}
]
}SAP 销售数据查询返回
请求接口: /getSalePos
接口描述: SAP 销售数据查询返回
请求类型: HTTP POST
请求参数:
| 字段名称 | 是否必填 | 类型 | 字段描述 |
|---|---|---|---|
| page | Y | int | 页数为空默认1 |
| pageSize | Y | int | 每页数量,为空默认100 |
| shopId | Y | string | 店铺ID,多个值以英文逗号连接 |
| shippingTime | Y | string | 出入库时间区间,最大跨度40天,syncTime为空时必填 |
| syncTime | Y | string | 回传时间区间,最大跨度40天,shippingTime为空时必填 |
| order_sn | N | string | OMS订单号, 多个值以英文逗号连接 |
| apply_no | N | string | 回传单号,多个值以英文逗号连接 |
| apply_type | N | string | 业务类型,多个值以英文逗号连接 |
| free_goods | N | string | free_goods,多个值以英文逗号连接 |
| determine_code | N | string | 商家编码,多个值以英文逗号连接 |
| sap_customercd | N | string | SAP店铺代码,多个值以英文逗号连接 |
json示例
{
"shopId": "188,189",
"page": 1,
"pageSize": 100,
"shippingTime": "2023-01-01 00:00:00,2023-02-28 23:59:59",
"syncTime": "2023-01-01 00:00:00,2023-02-28 23:59:59",
"sap_customercd": "2200004137,2200004138"
}响应参数:
| 字段名称 | 是否必填 | 类型 | 字段描述 |
|---|---|---|---|
| sap_customercd | N | string | 店铺编码 |
| order_sn | N | string | OMS订单号 |
| platform_order_id | N | string | 平台单号 |
| RMIAID | Y | string | RMIAID |
| pay_type | N | string | 支付方式 |
| order_status | N | string | 订单状态 |
| goods_type | N | string | 商品类型 |
| apply_type | N | string | 业务类型 |
| shipped_time | N | string | 发货时间/退货时间 |
| nature_day | N | string | 自然日 |
| determine_code | N | string | 商品编码 |
| sku_code | N | string | LQ商家编码 |
| prod_name | N | string | 商品名称 |
| apply_qty | N | string | 产品数量 |
| actual_mny | N | string | 实付金额 |
| retail_price | N | string | 建议零售单价 |
| total_fee | N | string | 建议零售总价 |
| sync_status | N | string | 回传状态 |
| sync_time | N | string | 回传时间 |
| apply_no | N | string | 回传订单编码 |
| reason_code | Y | string | Reasoncd |
| charg | Y | string | 批次 |
| lgort | Y | string | 库存地点 |
| tst_no | Y | string | 支付宝平台交易流水号 |
| sync_filename | N | string | 回传文件 |
| standby_field1 | Y | string | 备用字段1 |
| standby_field2 | Y | string | 备用字段2 |
| standby_field3 | Y | string | 备用字段3 |
| standby_field4 | Y | string | 备用字段4 |
| standby_field5 | Y | string | 备用字段5 |
| shop_name | Y | string | 店铺名称 |
| free_goods | Y | string | FREEGOODS |
json示例
{
"code": 200,
"msg": "SUCCESS",
"data": {
"total": "103",
"currentPage": "1",
"pageSize": "2",
"lastPage": "52",
"data": [
{
"sap_customercd": "2200004137",
"order_sn": "XS012307065653002008",
"platform_order_id": "202307060001000018",
"RMIAID": "",
"pay_type": "alipay",
"order_status": "发货",
"goods_type": "Z001",
"apply_type": "门店销售",
"shipped_time": "2023-07-07 10:50:25",
"nature_day": "7",
"determine_code": "10111986803CN",
"sku_code": "S1000139402",
"prod_name": "资生堂 百优丰盈提拉紧致面霜",
"apply_qty": "1",
"actual_mny": "600.00",
"retail_price": "600.00",
"total_fee": "600.00",
"sync_status": "回传成功",
"sync_time": "2023-07-07 10:54:50",
"apply_no": "XS012307065653002008",
"reason_code": "",
"charg": "common",
"tst_no": "",
"lgort": "W001",
"sync_filename": "Surrounding_OMS_3_20_XS012307065653002008_20230707105450",
"standby_field1": "",
"standby_field2": "",
"standby_field3": "",
"standby_field4": "",
"standby_field5": "",
"shop_name": "shiseido资生堂官方旗舰店-天猫",
"free_goods": "销售品"
},
{
"sap_customercd": "2200004137",
"order_sn": "XS012307065653002009",
"platform_order_id": "202307060001000018",
"RMIAID": "",
"pay_type": "alipay",
"order_status": "发货",
"goods_type": "Z002",
"apply_type": "免费销售单",
"shipped_time": "2023-07-07 10:50:25",
"nature_day": "7",
"determine_code": "10380860000CN",
"sku_code": "S1000139403",
"prod_name": "SHI 悦薇智感紧塑焕白霜 试用品",
"apply_qty": "1",
"actual_mny": "0.00",
"retail_price": "0.00",
"total_fee": "0.00",
"sync_status": "回传成功",
"sync_time": "2023-07-07 10:54:52",
"apply_no": "XS012307065653002009",
"reason_code": "561",
"charg": "common",
"tst_no": "",
"lgort": "W001",
"sync_filename": "Surrounding_OMS_3_30_XS012307065653002009_20230707105452",
"standby_field1": "",
"standby_field2": "",
"standby_field3": "",
"standby_field4": "",
"standby_field5": "",
"shop_name": "shiseido资生堂官方旗舰店-天猫",
"free_goods": "免费品"
}
]
}
}订单重量查询-按打包方式+省市汇总
请求接口: /protal/groupProvince/list
接口描述: 订单重量查询-按打包方式+省市汇总
请求类型: HTTP POST
请求参数json示例:
{
"shopIds": [
1
],
"warehouseIds": [
1
],
"startShippingTime": "2023-12-19 09:33:05",
"endShippingTime": "2023-12-19 09:33:05",
"provinceId": 1,
"offset": 1,
"length": 1
}响应参数示例:
{
"total": 1,
"protalInfoList": [
{
"shopName": "demoData",
"province": "demoData",
"city": "demoData",
"zzNum": 1,
"xyNum": 1,
"otherNum": 1,
"packageNum": 1
}
]
}订单重量查询接口(按打包方式汇总)
请求接口: /protal/groupType/list
接口描述: 订单重量查询接口(按打包方式汇总)
请求类型: HTTP POST
请求参数json示例:
{
"shopIds": [
1
],
"warehouseIds": [
1
],
"startShippingTime": "2023-12-19 09:33:05",
"endShippingTime": "2023-12-19 09:33:05",
"offset": 1,
"length": 1
}响应参数示例:
{
"total": 1,
"protalInfoList": [
{
"shopName": "demoData",
"zzNum": 1,
"xyNum": 1,
"otherNum": 1,
"packageNum": 1
}
]
}订单重量查询
请求接口: /info/list
接口描述: 订单重量查询
请求类型: HTTP POST
请求参数json示例:
{
"shopIds": [
1
],
"warehouseIds": [
1
],
"startShippingTime": "2023-12-19 09:33:05",
"endShippingTime": "2023-12-19 09:33:05",
"offset": 1,
"length": 1
}响应参数示例:
{
"total": 1,
"protalInfoList": [
{
"shopName": "demoData",
"orderSn": "demoData",
"platformOrderId": "demoData",
"outerOrderSn": "demoData",
"paytime": "2023-12-18 17:50:12",
"shippingTime": "2023-12-18 17:50:12",
"shippingTypeName": "demoData",
"weight": "demoData",
"packingMethod": "demoData",
"orderType": "demoData",
"zzNum": 1,
"xyNum": 1,
"otherNum": 1,
"province": "demoData",
"city": "demoData",
"district": "demoData",
"checkTime": "2023-12-18 17:50:12",
"receiptTime": "2023-12-18 17:50:12",
"signedTime": "2023-12-18 17:50:12",
"payToCheck": 1,
"checkToShipping": 1,
"shippingToReceipt": 1,
"payToReceipt": 1,
"logisticsNumber": "demoData"
}
]
}库存查询
请求接口: /sync/service
接口描述: 库存查询
请求类型: HTTP POST
请求参数json示例:
{
"type": "测试2",
"statusList": [
"NORMAL",
"DEFECTIVE"
],
"customerCode": "65553",
"warehouseCodeList": [
"20006"
]
}Mulesoft会根据参数body.type来判定需要实际访问哪个仓库的地址。
具体对应:
测试环境:
测试1: "https://test-wms-sync-1.leqee.com/api/sync/service"
测试2: "https://test-wms-sync-2.leqee.com/api/sync/service"
生产环境:
乐其上海阳乐2仓: "https://wms-sync.leqee.com/api/sync/service"
涨引力太仓美妆2仓: "https://wmswai1-sync.leqee.com/api/sync/service"
涨引力太仓美妆仓: "https://wmswai2-sync.leqee.com/api/sync/service"
响应参数示例:
{
"code": "000",
"msg": "成功",
"inventoryDetails": [
{
"plId": 123,
"skuCode": "skuCode123456",
"barcode": "123",
"locationType": "STOCK_LOCATION",
"locationTypeDesc": "拣货区",
"qtyAvailable": 456,
"qtyTotal": 234,
"productionDate": 123456789,
"expiryDate": 123456789,
"validityStatus": "NORMAL",
"batchSn": "123",
"isMaintainValidity": true,
"validity": 20,
"validityUnit": "MONTH",
"warrantyWarningDays": 23,
"warrantyUnsalableDays": 34
}
]
}获取可用库存
请求接口: /oms/sku/inventory/list
接口描述: 库存查询
请求类型: HTTP POST
请求参数说明:
| 参数名称 | 是否为空 | 类型 | 参数说明 |
|---|---|---|---|
| partyId | 否 | bigint | 业务组id |
| warehouseId | 否 | bigint | 仓库id |
| statusId | 是 | string | 库存状态:NORMAL全新,DEFECTIVE二手 |
| skuCodeList | 是 | array | 商品对应商家编码列表,最多支持100个商品 |
| pageSize | 否 | int | 分页字段,每页数据量,默认为20,最大数量200 |
| pageNum | 否 | int | 分页字段,第几页,默认为1 |
请求参数json示例:
{
"partyId": 166622,
"warehouseId": 13213213,
"statusId": "NORMAL",
"skuCodeList": [
"S1111",
"S2222"
],
"pageSize": 20,
"pageNum": 1
}响应参数说明:
| 参数名称 | 类型 | 参数说明 |
|---|---|---|
| inventoryDetailList | array | inventoryDetail对象数组,具体字段见下表 |
| totalCount | int | 总的记录数,根据该字段来判断总页数 |
| skuCode | string | 商品商家编码 |
| barcode | string | 商品的条码 |
| skuName | string | 商品名称 |
| warehouseId | bigint | 仓库id |
| statusId | string | 库存状态 |
| quantity | int | 库存总数 |
| availableQuantity | int | 可用库存数 |
响应参数示例:
{
"code": "200",
"data": {
"inventoryDetailList": [
{
"skuCode": "S11111",
"skuName": "商品xxx",
"barcode": "0JYH910000-name",
"warehouseId": 1705473605000,
"statusId": "NORMAL",
"quantity": 100,
"availableQuantity": 3
},
{
"skuCode": "S12221",
"skuName": "商品ddd",
"barcode": "0J2220000-name",
"warehouseId": 1705473605000,
"statusId": "NORMAL",
"quantity": 100,
"availableQuantity": 31
}
],
"totalCount": 200
},
"msg": "success",
"success": true
}领用出库详情
请求接口: /getSaleCollectOrder
接口描述: 库存报表
请求类型: HTTP POST
请求参数说明:
| 参数名称 | 是否为空 | 类型 | 参数说明 |
|---|---|---|---|
| page | 是 | int | 页数为空默认1 |
| pageSize | 是 | int | 每页数量,为空默认100 |
| shippingTime | 是 | Array | 查询参数发货时间 |
| shopIds | 是 | Array | 店铺ID |
请求参数json示例:
{
"shippingTime": [
"2023-12-01",
"2024-03-06"
],
"shopIds": [
1000001781,
188
],
"page": 1,
"pageSize": 10
}响应参数说明:
| 字段名称 | 是否可为空 | 类型 | 参数说明 |
|---|---|---|---|
| date_time | 否 | string | 日期 |
| sap_customer_cd | 否 | string | 店铺代码 |
| shop_name | 否 | string | 店铺名称 |
| total_number | 否 | string | 汇总数量 |
| total_amount | 否 | string | 汇总金额 |
| sale_amount | 否 | string | 销售金额 |
| sale_number | 否 | string | 销售数量 |
| return_amount | 否 | string | 退货金额 |
| return_number | 是 | string | 退货数量 |
响应参数示例:
{
"code": 200,
"msg": "SUCCESS",
"data": {
"orderList": [
{
"date_time": "2024-02-21",
"sap_customer_cd": "2200004137",
"shop_name": "shiseido资生堂官方旗舰店-抖音",
"total_number": "3",
"total_amount": "0.00",
"sale_amount": "0.00",
"sale_number": "3",
"return_amount": "0.00",
"return_number": "0"
},
{
"date_time": "2024-02-23",
"sap_customer_cd": "2200003133",
"shop_name": "shiseido资生堂官方旗舰店-天猫",
"total_number": "9",
"total_amount": "0.00",
"sale_amount": "0.00",
"sale_number": "9",
"return_amount": "0.00",
"return_number": "0"
},
{
"date_time": "2024-02-24",
"sap_customer_cd": "2200003133",
"shop_name": "shiseido资生堂官方旗舰店-天猫",
"total_number": "17",
"total_amount": "0.00",
"sale_amount": "0.00",
"sale_number": "17",
"return_amount": "0.00",
"return_number": "0"
}
],
"total": 3
}
}入库回传补货接口
请求接口: /getProcurementOrder
接口描述: 入库回传补货接口
请求类型: HTTP POST
请求参数说明:
| 参数名称 | 是否为空 | 类型 | 参数说明 |
|---|---|---|---|
| page | 是 | int | 页数为空默认1 |
| pageSize | 是 | int | 每页数量,为空默认100 |
| finishTime | 是 | Array | 查询参数入库时间 |
| listType | 是 | String | 查询类型,枚举型: detail 按明细查询, group 按汇总查询 |
| channel | 是 | String | 渠道:wx_video:微信视频号 tmall:天猫 tiktok:抖音 dewu:得物 |
| brand | 是 | String | 品牌 BS:资生堂 TG:TG 御银座 SDK:侍刻 |
请求参数json示例:
{
"finishTime": [
"2023-07-01",
"2024-04-06"
],
"listType": "group",
"channel": "tmall",
"brand": "BS",
"page": 1,
"pageSize": 10
}响应参数说明:
| 字段名称 | 是否可为空 | 类型 | 参数说明 |
|---|---|---|---|
| brand_detail_id | 否 | int | Detail primary key |
| sku_id | 否 | int | sku主键 |
| in_stc_no | 否 | string | scm单号 |
| sku_name | 否 | string | 产品名称 |
| scm_order_sn | 否 | string | SCM 单号 |
| scm_finish_time | 否 | string | 入库完成时间 |
| in_qnty | 否 | string | 申请入库数量 |
| actually_number | 否 | string | 实际入库数量 |
| material_number | 否 | string | 物料确定号 |
| warehouse_channel | 否 | string | 渠道 |
| brand_name | 否 | string | 品牌 |
| cost_center_code | 否 | string | 成本中心 |
| file_name | 否 | string | 回传文件 |
响应参数示例:(按明细查询):
{
"code": 200,
"msg": "SUCCESS",
"data": {
"data": [
{
"brand_detail_id": "272",
"sku_id": "121533",
"in_stc_no": "41001219003",
"sku_name": "测试商品1",
"party_id": "1001267",
"scm_order_sn": "SCG231219042688",
"scm_finish_time": "2023-12-19 17:33:56",
"in_qnty": "10.000",
"actually_number": "10",
"material_number": "10118093101CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20231219_173454_924.xml"
},
{
"brand_detail_id": "255",
"sku_id": "121186",
"in_stc_no": "41001101006",
"sku_name": "资生堂联调-第一批-普通正装03",
"party_id": "65653",
"scm_order_sn": "SCG231116041146",
"scm_finish_time": "2023-11-16 14:35:00",
"in_qnty": "10.000",
"actually_number": "10",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20231116_151254_595.xml"
},
{
"brand_detail_id": "255",
"sku_id": "122261",
"in_stc_no": "41001101006",
"sku_name": "资生堂联调-第一批-普通正装04",
"party_id": "65653",
"scm_order_sn": "SCG231116041146",
"scm_finish_time": "2023-11-16 14:35:00",
"in_qnty": "10.000",
"actually_number": "10",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20231116_151254_595.xml"
},
{
"brand_detail_id": "256",
"sku_id": "121190",
"in_stc_no": "41001101006",
"sku_name": "资生堂联调-第二批-普通正装01",
"party_id": "65653",
"scm_order_sn": "SCG231116041146",
"scm_finish_time": "2023-11-16 14:35:00",
"in_qnty": "20.000",
"actually_number": "20",
"material_number": "10213916801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20231116_151254_595.xml"
},
{
"brand_detail_id": "96",
"sku_id": "121186",
"in_stc_no": "410007250002",
"sku_name": "资生堂联调-第一批-普通正装03",
"party_id": "65653",
"scm_order_sn": "SCG230725036284",
"scm_finish_time": "2023-07-25 10:52:29",
"in_qnty": "27.000",
"actually_number": "27",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230725_105328_187_01.xml"
},
{
"brand_detail_id": "96",
"sku_id": "122261",
"in_stc_no": "410007250002",
"sku_name": "资生堂联调-第一批-普通正装04",
"party_id": "65653",
"scm_order_sn": "SCG230725036284",
"scm_finish_time": "2023-07-25 10:52:29",
"in_qnty": "27.000",
"actually_number": "27",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230725_105328_187_01.xml"
},
{
"brand_detail_id": "93",
"sku_id": "121219",
"in_stc_no": "41000717001",
"sku_name": "资生堂联调-采购商品03",
"party_id": "65653",
"scm_order_sn": "SCG230717035871",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "84.000",
"actually_number": "84",
"material_number": "10114386802CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230717_101850_714.xml"
},
{
"brand_detail_id": "89",
"sku_id": "121186",
"in_stc_no": "41000717001",
"sku_name": "资生堂联调-第一批-普通正装03",
"party_id": "65653",
"scm_order_sn": "SCG230717035871",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "27.000",
"actually_number": "27",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230717_101850_714.xml"
},
{
"brand_detail_id": "89",
"sku_id": "122261",
"in_stc_no": "41000717001",
"sku_name": "资生堂联调-第一批-普通正装04",
"party_id": "65653",
"scm_order_sn": "SCG230717035871",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "27.000",
"actually_number": "27",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230717_101850_714.xml"
},
{
"brand_detail_id": "90",
"sku_id": "121190",
"in_stc_no": "41000717001",
"sku_name": "资生堂联调-第二批-普通正装01",
"party_id": "65653",
"scm_order_sn": "SCG230717035871",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "9.000",
"actually_number": "9",
"material_number": "10213916801CN",
"warehouse_channel": "天猫",
"brand": "BS",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02",
"file_name": "4000004061_785A_20230717_101850_714.xml"
}
],
"total": "12"
}
}响应参数示例:(按汇总查询):
{
"code": 200,
"msg": "SUCCESS",
"data": {
"data": [
{
"sku_id": "121219",
"sku_name": "资生堂联调-采购商品03",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "90",
"actually_number": "90",
"material_number": "10114386802CN",
"warehouse_channel": "天猫",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02"
},
{
"sku_id": "121186",
"sku_name": "资生堂联调-第一批-普通正装03",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "64",
"actually_number": "64",
"material_number": "10114940801CN",
"warehouse_channel": "天猫",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02"
},
{
"sku_id": "121190",
"sku_name": "资生堂联调-第二批-普通正装01",
"scm_finish_time": "2023-07-17 10:17:52",
"in_qnty": "29",
"actually_number": "29",
"material_number": "10213916801CN",
"warehouse_channel": "天猫",
"brand_name": "资生堂",
"cost_center_code": "785J2D1A02"
}
],
"total": "3"
}
}