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"
}
}