schm-leqee-oms-eapi

(0 reviews)

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/listOms列表页面
/order/detail订单详情
/getProductMaintenanceSkus映射接口
/getSalePosSAP销售数据查询返回
/protal/groupProvince/list订单重量查询-按打包方式+省市汇总
/protal/groupType/list订单重量查询接口(按打包方式汇总)
/protal/info/list订单重量查询
/sync/service库存查询
/oms/sku/inventory/list获取可用库存
/getSaleCollectOrder领用出库详情
/getProcurementOrder入库回传补货接口

OMS列表页面

请求接口: /order/oms/list
接口描述: Oms列表页面
请求类型: HTTP POST

请求参数:

字段名称类型字段描述
orderSnsList订单号
startOrderTimeDate订单时间
endOrderTimeDate订单时间
startPayTimeDate付款(付尾款)时间
endPayTimeDate付款(付尾款)时间
startShippingTimeDate发货时间
endShippingTimeDate发货时间
startEarnestTimeDate付定金时间
endEarnestTimeDate付定金时间
startReceivingTimeDate确认收货时间
endReceivingTimeDate确认收货时间
pushTimeStartDate订单推送时间
pushTimeEndDate订单推送时间
refundStatusString退款状态;NONE:'无退款',APPLIED:'已申请',RETURNED:'全部退款',PART_RETURNED:'部分退款'
platformOrderStatusList平台订单状态;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:'交易关闭'
orderStatusesListOMS订单状态;WAIT_CHECK:'待审核',REJECT:'退货驳回',CHECK_PASS:'待推送',PUSH_FAIL:'推送失败',PUSH:'已推送',OPERATED:'已入库',CANCEL:'已作废'
platformRefundStatusString平台退款状态;"ALL_REFUND":"平台已退款","PART_REFUND":"平台部分退款","NOT_REFUND":"平台未退款"
orderTypeString订单类型;"SALE":"销售","EXCHANGE":"换货","SUPPLY":"补寄",
orderFromString订单来源;"DIRECT":"平台下载","MANUAL":"手工建单","HISTORY":"历史订单",
startPlatformOrderTimeDate拍下时间
endPlatformOrderTimeDate拍下时间
preSaleTypeString预售单类型;"PRE_SALE_ADVANCE":"预售提前单","PRE_SALE_NORMAL":"预售普通单","NORMAL":"正常单",
liveTypeString直播类型;"LIVE":"直播订单","NORMAL":"非直播订单",
sampleMarkSearchTypeString派样订单;ORDER:订单级别,GOODS:商品级别
existSampleMarkString派样订单;true:有派样标记,false:无派样标记
estStartTimeDate平台发货时效
estEndTimeDate平台发货时效
estConTimeTypeString平台发货时效类型;EST_GOODS:商品维度,EST_ORDER:订单维度,NOT_INCLUDE:无
latestCollectionStartTimeDate最晚揽件时效
latestCollectionEndTimeDate最晚揽件时效
stockOutStartTimeDate仓库出库时效
stockOutEndTimeDate仓库出库时效
isCustomizationString是否定制;true:是,false:否
shopIdListList店铺名称
warehouseIdListList发货仓库
warehouseTypeString仓库类型
shippingIdLong快递方式
offsetInteger偏移量
lengthInteger页大小

响应参数:

字段名称类型字段描述
totalCountInteger订单总数量
contentList订单列表

content参数列表:

字段名称类型字段描述
orderIdLong订单ID
orderSnStringOMS订单号
orderTypeString订单类型
mergeOrSplitString拆合类型
presellTypeString预售类型
isJOSPreSaleOrderBoolean是否是京东预售
orderStatusString订单状态
liveTypeString直播类型
sampleTypeString派样类型
jitOrderTypeString唯品会jit订单类型
presaleConsignString预售下沉
isSFConsignBoolean是否是顺丰下沉
platformShipperString平台发货仓
deliveryServiceTagString音尊达
strategySnMapMap<String,Set系统标签策略
openUidString买家标识
buyerString买家昵称
shippingStatusString快递状态
receiverNameString收件人姓名
receiverMobileString收件人手机号
paytimeDate付款时间
sendConditionTypeString授信方式
partyIdLong业务组id
receiverStatusString收货状态
esTimeString相对到达时间
deliveryTimeDate揽件时效
receiverAddressString收件人地址
expandPriceUsedBigDecimal权益金
earnestPaymentTimeDate付定金时间
shippingTimeDate发货时间
platformRefundStatusString平台退款状态
crossBorderExceptionNoteString跨境异常信息
zwyExceptionNoteString
serialExceptionNoteString序列号异常信息
orderMergeRelativeOrderSnsList订单合并关系
riskControlStatusInteger风控状态
ocFinanceIssueIdStringoc财审流程号
ocFinanceApprovalStatusStringoc财审流程状态
isCustomizationBoolean是否定制单
usedInventoryTypeString使用冻结库存
statusIdString库存状态;所有(默认,ALL),全新,二手
expectedRepaymentTimeDate赊账回款时间
preOutTimeDate预计出库时间
bookActivateTimeDate订单激活时间
emptyPackageString空包发货
isPreSendBoolean是否预发货
presendLogisticsNumString预发货快递单号
preSendStatusString预发货状态
platformShippingTypeString平台快递类型
consignLogisticsInfoString快递下沉信息
lpStrategyTagsListlp配送策略标记
checkDelayInfoString延迟审单
buyerMemoString买家留言
sellerMemoString卖家留言
shippingMemoString仓库留言
noteMemoString便签留言
crossBorderExceptionNoteString跨界异常信息
latestCollectionTimeDate最晚揽件时效
stockOutTimeDate仓库出库时效
senTotalFeeString应收金额
payStatusValueString付款状态
earnestPaymentTimeDate付定金时间
paytimeDate付款(付尾款)时间
orderStatusStringOMS订单状态
platformRefundStatusString平台退款状态
wmsOrderObject
–pushNoteString推送信息
orderFxObject
–tallyStatusString理货状态
buyerResultObject
–blackRefusedBoolean是否黑名单
–blackReasonString黑名单原因
–particularReasonString特殊用户原因
–particularUserBoolean是否特殊用户
shopObject
–shopPlatformString店铺平台
–shopIdLong店铺ID
–shopTypeString店铺类型
financeReasonsList
–nameString财审原因
packagesList
–logisticsNumberString物流单号
–expressStatusString物流状态
–lastUpdateTimeDate最后更新时间
distributorObject
–distributorNameString分销商名称
orderTagInfosList拦截标签
–tagNameString标签名
–tagColorString标签颜色
–tagIdLong标签id
customOrderTagsList自定义标签
–tagNameString标签名
–tagColorString标签颜色
–tagIdLong标签id
especialTagInfosList异常标签
–tagNameString标签名
–tagColorString标签颜色
–tagIdLong标签id
originOrdersList
–platformOrderIdString原始单号
–orderFromString订单来源
–platformOrderStatusString平台订单状态
–finalPaymentStatusString付尾款时间
–elseInfoString其他额外信息
receiverProvinceObject
–regionNameString顾客地址-省
receiverCityObject
–regionNameString顾客地址-市
receiverDistrictObject
–regionNameString顾客地址-区
receiverStreetObject
–regionNameString顾客地址-街道
orderGoodsList
–groupObject
—-goodsGroupCodeString套餐编码
–estConTimeDate发货时效
–shortageBoolean缺货
–skuObject
—-skuCodeString商家编码
—-skuNameString商品名称
orderProcessObject
–stopSendStatusString停发状态
–wmsRejectStatusString驳回状态
–reservePriorityInteger预定优先级
–priorityInteger优先级
–presendStatusString预发货状态
–shortageStatusString缺货状态
–subOrderTypeString子类型
–financeCheckStatusString财审状态
–prepackReserveStatusString预打包状态
–exceptionTagListList异常标签
–checkTimeDate审单时间
–reserveTimeDate预定时间
–lockStatusString锁定状态
–lockUserObject锁单用户
—-nameString用户名
–checkerObject审单用户
—-nameString用户名
warehouseObject
–warehouseNameString仓库名称
shippingObject
–shippingNameString快递名称
–isCodBoolean是否COD
orderWeightBigDecimal订单重量
workOrdersList
–etWorkOrderBoolean是否et工单
–workOrderSnString工单编号
–workNameString工单名称
–statusString工单状态
–workOrderIdLong工单id
orderLogisticsReservationObject
–statusString
shenbaoInfoObject
–mftNoString申报编码
–shenbaoStatusString申报状态
liveTagStrategyInfosListELC标签
–packingWaysList包装方式
–strategyTypeString策略类型
partyInventoryOrgDtoObject
–partyInventoryOrgNameString库存组织名称
salesmanObject业务员
–accountString账户
–nameString名称

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

请求参数:

字段名称类型是否必填示例字段描述
orderIdlong57302订单id,唯一

相应参数:

字段名称类型字段描述
orderSnstring订单号,例如XS102301065653061887
partystructparty
—partyNamestring业务组名称
sampleTypestring派样标记,SAMPLE:打标“派样”
liveTypestring直播标记,LIVE:打标“直播”
orderRelationTypestring拆合单标记;拆单:SPLIT_ORDER_TARGET,合单:MERGE_ORDER_TARGET
orderStatus和shippingStatusstring订单状态;待审核: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
sendConditionTypestring授信方式;PAID(先款后货),GUARANTEE_PAID(担保已付款),COD_SHIP(货到付款,快递代收),COD(货到付款),PART_PAID(赊销有定金),UNPAID(赊销无定金)
payStatusValuestring付款状态.UNPAID(未付款),PAID(已付款),PART_PAID(部分付款),GUARANTEE_PAID(担保已付款),EARNEST_PAID(已付定金)
isCustomizationboolean特殊需求.是否定制
orderLogisticsReservationstruct特殊需求.是否需要oc物流
usedInventoryTypestring特殊需求.usedInventoryType='FROZEN'表示使用冻结库存
orderProcessstructorderProcess
—priorityint特殊需求.priority<=3表示已加急
—reservePriorityint特殊需求.reservePriority=5显示库存优先
—presendStatusstring特殊需求.预发货状态
—wmsRejectStatusstring特殊需求.wmsRejectStatus='Pending'显示订单pending中.wmsRejectStatus='Intercepted'显示仓内拦截可退款
—stopSendStatusstring特殊需求.stopSendStatus='AUTO_STOP'或'MANUAL_STOP'显示停发拦截
—lockStatusstring特殊需求.lockStatus='LOCK'显示已锁定
—subOrderTypestring特殊需求.subOrderType='BOOK'时显示预订单释放时间:bookActivateTime
statusIdstring特殊需求.statusId='INV_STTS_USED'二手销售,statusId='SALE_PACK'耗材销售
sendConditionTypestring特殊需求.sendConditionType='SELL_ON_CREDIT'时,expectedRepaymentTime为预计收款时间
sampleTypestring特殊需求.sampleType='SAMPLE'显示派样单
platformShippingTypestring特殊需求.京东配送方式
checkDelayInfostring特殊需求.延迟审核
especialTagInfosstructespecialTagInfos
—tagNamestring特殊需求.聚划算,下沉成功,改过地址,改过仓库,改过商品明细,物流升级,送货上门
presellTypestring特殊需求,延迟预定,presellType=PRESELL
orderProcessstructorderProcess
—reserverStatusstring特殊需求,延迟预定,reserverStatus=UNRESERVED
—reserveTimedatetime特殊需求,延迟预定,reserveTime>当前时间+35秒
—shortageStatusstring拦截标签.缺货
customOrderTagsstructcustomOrderTags
—tagNamestring订单标签
shopstructshop 资生堂官方旗舰店-天猫
—shopNamestring店铺名称,例如:shiseido
—shopPlatformValuestring平台.例如:天猫
paystructpay
—payNamestring支付方式.例如在线支付,网银转账,调拨销售专用,微信支付,支付宝,银联支付,COD收款,跨主体调拨
currencystring币种.RMB(人民币),USD(美元)等
paytimedatetime付款时间.例如2023-01-16 14:09:21 14:09:17
platformOrderTimedatetime拍下时间.例如2023-01-16
latestCollectionTimedatetime最晚揽收时效.例如2023-02-06 14:09:21
deliveryTimedatetime最晚发货时效.例如2023-02-06 14:09:21
stockOutTimedatetime仓库出库时效.例如2023-02-06 08:09:21
orderProcessstructorderProcess
—reserveTimedatetime预定时间
—lastestPushTimedatetime最晚推送时间
buyerMemostring顾客留言
sellerMemostring小二留言
shippingMemostring仓库留言
noteMemostring便签留言
originOrdersstructoriginOrders
—platformOrderIdstring原始单号
—elseInfo中flagIdint插旗备注颜色,解析elseInfo(json格式)中key为flagId的字段
—sellerMemostring插旗备注内容
—blackDeliveryCpsstring[]快递黑白名单.黑名单列表
—whiteDeliveryCpsstring[]快递黑白名单.白名单列表
—platformOrderStatusstring平台订单状态
warehousestructwarehouse
—warehouseNamestring仓库名称
—warehouseTypestring仓库类型
shippingstructshipping
—shippingNamestring快递名称
packagesstructpackages
—logisticsNumberstring快递单号,示例:SF1620083894610
usedInventoryTypestring是否使用冻结库存.FROZEN表示使用冻结库存
needPostCodeboolean需要贴码.true表示需要,false表示不需要
needLoadingAndUnloadingboolean需要装卸货.true表示需要,false表示不需要
needTallyboolean需要理货.true表示需要,false表示不需要
orderOcFinanceInfostructoc审批流程结构,不为空则需要oc审批流程
—orderPurposestring订单用途
—sendBackstring是否需要寄回
—feeAssumestring费用承担方
—diffClaimSettlementWorkOrderstring差异理赔结算工单,订单用途选择差异理赔时必填
orderGoodsstructorderGoods
—groupNum或—numberint套餐数量或sku数量的平台发货时效
—numberint拍下数
—numberintorderGoods.number结合订单发货状态.如果订单已发货或确认收货,则取orderGoods.number,否则为0
—inventoryQuantityint系统库存
—availableQuantityint可审库存
—availableInventoryint可用库存
—senPricestring单价
—senDiscountFeestring商品优惠
—senDivideDiscountFeestring订单优惠分摊
—senTariffstring商品关税
—senGoodsFeestring货款小计
—senTotalFeestring应收小计
—divideExpandPriceUsed和—divideBasicPriceUsedstring购物金分摊
—produceDateNumint效期个数
—produceDateStart和—produceDateEnddatetime指定效期范围
—batchNoNumint批次个数
—batchNosstring指定批次号
—skustructsku
——barcodestring商家条码
——skuNamestring单品名称
——goodsstructgoods
———saleTaxRatedecimal销售税率
—groupstructgroup
——goodsGroupCodestring套餐编码
——groupNumint套餐数量
orderVolumedecimal订单预估体积
orderWeightdecimal订单预估重量
senPostFeestring邮费
totalGoodsValuestring商品总价值
senGoodsFeestring货款总额
senDiscountFeestring订单优惠
senTotalDiscountFeestring总优惠金额
senActualTotalFeestring应收金额

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

请求参数:

字段名称是否必填类型字段描述
pageYint页数为空默认1
pageSizeYint每页数量,为空默认100
SkuIdYArray intoms商品ID 不为空 则忽略返回数量(page, pageSize)

json示例

{
    "SkuId": [
        6367,
        6368
    ],
    "page": 1,
    "pageSize": 100
}

响应参数:

字段名称是否必填类型字段描述
partyIdNstring业务组ID
skuCodeNstringoms中sku的商家编码
barcodeNstring商品条码
goodsNameNstring商品名称
determineCodeNstring物料确定号
sapLongCodeNstringSAP长代码
sapShortCodeNstringSAP短代码
sapNameNstringSAP名称
goodsTypeNstringSales 正品,Sample小样 Supplies 耗材
sapGoodsTypeNstringSAP商品类型
updateTimeNstring最后更新时间

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

请求参数:

字段名称是否必填类型字段描述
pageYint页数为空默认1
pageSizeYint每页数量,为空默认100
shopIdYstring店铺ID,多个值以英文逗号连接
shippingTimeYstring出入库时间区间,最大跨度40天,syncTime为空时必填
syncTimeYstring回传时间区间,最大跨度40天,shippingTime为空时必填
order_snNstringOMS订单号, 多个值以英文逗号连接
apply_noNstring回传单号,多个值以英文逗号连接
apply_typeNstring业务类型,多个值以英文逗号连接
free_goodsNstringfree_goods,多个值以英文逗号连接
determine_codeNstring商家编码,多个值以英文逗号连接
sap_customercdNstringSAP店铺代码,多个值以英文逗号连接

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_customercdNstring店铺编码
order_snNstringOMS订单号
platform_order_idNstring平台单号
RMIAIDYstringRMIAID
pay_typeNstring支付方式
order_statusNstring订单状态
goods_typeNstring商品类型
apply_typeNstring业务类型
shipped_timeNstring发货时间/退货时间
nature_dayNstring自然日
determine_codeNstring商品编码
sku_codeNstringLQ商家编码
prod_nameNstring商品名称
apply_qtyNstring产品数量
actual_mnyNstring实付金额
retail_priceNstring建议零售单价
total_feeNstring建议零售总价
sync_statusNstring回传状态
sync_timeNstring回传时间
apply_noNstring回传订单编码
reason_codeYstringReasoncd
chargYstring批次
lgortYstring库存地点
tst_noYstring支付宝平台交易流水号
sync_filenameNstring回传文件
standby_field1Ystring备用字段1
standby_field2Ystring备用字段2
standby_field3Ystring备用字段3
standby_field4Ystring备用字段4
standby_field5Ystring备用字段5
shop_nameYstring店铺名称
free_goodsYstringFREEGOODS

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

请求参数说明:

参数名称是否为空类型参数说明
partyIdbigint业务组id
warehouseIdbigint仓库id
statusIdstring库存状态:NORMAL全新,DEFECTIVE二手
skuCodeListarray商品对应商家编码列表,最多支持100个商品
pageSizeint分页字段,每页数据量,默认为20,最大数量200
pageNumint分页字段,第几页,默认为1

请求参数json示例:

{
    "partyId": 166622,
    "warehouseId": 13213213,
    "statusId": "NORMAL",
    "skuCodeList": [
        "S1111",
        "S2222"
    ],
    "pageSize": 20,
    "pageNum": 1
}

响应参数说明:

参数名称类型参数说明
inventoryDetailListarrayinventoryDetail对象数组,具体字段见下表
totalCountint总的记录数,根据该字段来判断总页数
skuCodestring商品商家编码
barcodestring商品的条码
skuNamestring商品名称
warehouseIdbigint仓库id
statusIdstring库存状态
quantityint库存总数
availableQuantityint可用库存数

响应参数示例:

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

请求参数说明:

参数名称是否为空类型参数说明
pageint页数为空默认1
pageSizeint每页数量,为空默认100
shippingTimeArray查询参数发货时间
shopIdsArray店铺ID

请求参数json示例:

{
    "shippingTime": [
        "2023-12-01",
        "2024-03-06"
    ],
    "shopIds": [
        1000001781,
        188
    ],
    "page": 1,
    "pageSize": 10
}

响应参数说明:

字段名称是否可为空类型参数说明
date_timestring日期
sap_customer_cdstring店铺代码
shop_namestring店铺名称
total_numberstring汇总数量
total_amountstring汇总金额
sale_amountstring销售金额
sale_numberstring销售数量
return_amountstring退货金额
return_numberstring退货数量

响应参数示例:

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

请求参数说明:

参数名称是否为空类型参数说明
pageint页数为空默认1
pageSizeint每页数量,为空默认100
finishTimeArray查询参数入库时间
listTypeString查询类型,枚举型: detail 按明细查询, group 按汇总查询
channelString渠道:wx_video:微信视频号 tmall:天猫 tiktok:抖音 dewu:得物
brandString品牌 BS:资生堂 TG:TG 御银座 SDK:侍刻

请求参数json示例:

{
    "finishTime": [
        "2023-07-01",
        "2024-04-06"
    ],
    "listType": "group",
    "channel": "tmall",
    "brand": "BS",
    "page": 1,
    "pageSize": 10
}

响应参数说明:

字段名称是否可为空类型参数说明
brand_detail_idintDetail primary key
sku_idintsku主键
in_stc_nostringscm单号
sku_namestring产品名称
scm_order_snstringSCM 单号
scm_finish_timestring入库完成时间
in_qntystring申请入库数量
actually_numberstring实际入库数量
material_numberstring物料确定号
warehouse_channelstring渠道
brand_namestring品牌
cost_center_codestring成本中心
file_namestring回传文件

响应参数示例:(按明细查询):

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

Reviews