schm-leqee-oms-eapi

(0 reviews)

schm-leqee-oms-eapi

Interface description: Proxy for leqee oms api
UAT_URL: https://schm-api-test.shiseido.cn/schm-leqee-oms-eapi
PROD_URL: https://schm-api.shiseido.cn/schm-leqee-oms-eapi

Request Method：

To use HTTP request, you need to pass in headers, Request Body, Request Param, etc.

Generic Header parameters

Authentication Information

All request headers must contain the following key-value parameters as authentication information. You need to apply for this information from the administrator.

client_id: fa98****3452
client_secret: 108b****41f2

Original system parameters such as appKey, partyId, time, and sign do not need to be passed manually by the client. They are added automatically by mulesoft.

System parameters for automatic filling of test environment:

partyId: 65653

appKey: oms-server-client

API Description:

Interface Request	Description
/order/oms/list	oms list page
/order/detail	order detail
/getProductMaintenance	Skus mapping interface
/getSalePos	The SAP sales data query was sent back
/protal/groupProvince/list	Order weight query - by packaging + province summary
/protal/groupType/list	Order weight query interface (aggregated by package)
/protal/info/list	Order weight inquiry
/sync/service	Inventory inquiry
/oms/sku/inventory/list	Get available stock
/getSaleCollectOrder	Get out of storage details
/getProcurementOrder	Warehouse return replenishment interface

OMS List Page

Interface Request: /order/oms/list
Interface Description: oms list page
Request method: HTTP POST

Request Body Description:

Field Name	Type	Field Description
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	页大小

Response Body Description:

Field Name	Type	Field Description
totalCount	Integer	订单总数量
content	List	订单列表

inner content list:

Field Name	Type	Field Description
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	名称

Example

Success

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

Error

{
    "code": "sys.biz-error",
    "msg": "biz error",
    "subCode": "sys.biz-error-order-transferred",
    "subMsg": "error",
    "success": false
}

OMS Order Detail

Interface Request: /order/detail
Interface Description: oms order detail
Request method: HTTP POST

Request Body Description:

Field Name	Type	Required	Example	Field Description
orderId	long	是	57302	订单id,唯一

Response Body Description:

Field Name	Type	Field Description
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	应收金额

Example

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

Interface Request: /getProductMaintenance
Interface Description: Skus mapping interface
Request method: HTTP POST

Request Body Description:

Field Name	Required	Type	Field Description
page	Y	int	页数为空默认1
pageSize	Y	int	每页数量，为空默认100
SkuId	Y	Array int	oms商品ID 不为空则忽略返回数量（page， pageSize）

Example

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

Response Body Description:

Field Name	Required	Type	Field Description
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	最后更新时间

Example

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

The SAP sales data query was sent back

Interface Request: /getSalePos
Interface Description: The SAP sales data query was sent back
Request method: HTTP POST

Request Body Description:

Field Name	Required	Type	Field Description
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店铺代码，多个值以英文逗号连接

Example

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

Response Body Description:

Field Name	Required	Type	Field Description
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

Example

{
  "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": "免费品"
      }
    ]
  }
}

Order weight query - by packaging + province summary

Interface Request: /protal/groupProvince/list
Interface Description: Order weight query - by packaging + province summary
Request method: HTTP POST

Request Body Example:

{
    "shopIds": [
        1
    ],
    "warehouseIds": [
        1
    ],
    "startShippingTime": "2023-12-19 09:33:05",
    "endShippingTime": "2023-12-19 09:33:05",
    "provinceId": 1,
    "offset": 1,
    "length": 1
}

Response Body Example:

{
    "total": 1,
    "protalInfoList": [
        {
            "shopName": "demoData",
            "province": "demoData",
            "city": "demoData",
            "zzNum": 1,
            "xyNum": 1,
            "otherNum": 1,
            "packageNum": 1
        }
    ]
}

Order weight query - Summary by package

Interface Request: /protal/groupType/list
Interface Description: Order weight query - Summary by package
Request method: HTTP POST

Request Body Example:

{
    "shopIds": [
        1
    ],
    "warehouseIds": [
        1
    ],
    "startShippingTime": "2023-12-19 09:33:05",
    "endShippingTime": "2023-12-19 09:33:05",
    "offset": 1,
    "length": 1
}

Response Body Example:

{
    "total": 1,
    "protalInfoList": [
        {
            "shopName": "demoData",
            "zzNum": 1,
            "xyNum": 1,
            "otherNum": 1,
            "packageNum": 1
        }
    ]
}

Inventory inquiry

Interface Request: /sync/service
Interface Description: Inventory inquiry
Request method: HTTP POST

Request Body Example:

{
    "type": "测试2",
    "statusList": [
        "NORMAL",
        "DEFECTIVE"
    ],
    "customerCode": "65553",
    "warehouseCodeList": [
        "20006"
    ]
}

Mulesoft uses the body-type parameter to determine which repository address it actually needs to access.

Specific corresponding:

Test environment:

测试1: "https://test-wms-sync-1.leqee.com/api/sync/service"

测试2: "https://test-wms-sync-2.leqee.com/api/sync/service"

Production environment:

乐其上海阳乐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"

Response Body Example:

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

Response Body Example:

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

Get available stock

Interface Request: /oms/sku/inventory/list
Interface Description: Get available stock
Request method: HTTP POST

Request Body Example:

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

Response Body Example:

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

Get out of storage details

Interface Request: /getSaleCollectOrder
Interface Description: Get out of storage details
Request method: HTTP POST

Request Body Example:

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

Response Body Example:

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

Warehouse return replenishment interface

Interface Request: /getProcurementOrder
Interface Description: Warehouse return replenishment interface
Request method: HTTP POST

Request Body Description:

Parameter name	Whether it is empty	Type	Parameter Description
page	Y	int	The number of pages is empty. The default is 1
pageSize	Y	int	Number of pages, empty default 100
finishTime	Y	Array	Example Query the time when parameters are stored in the database
listType	Y	String	Query type, enumeration type: detail query based on details, group query based on summary
channel	Y	String	Channel: wx_video: wechat video tmall: Tmall tiktok: Douyin dewu: Dewu
brand	Y	String	Brand BS: Shiseido TG: TG Midginza SDK: Shi Ke

Request Body Example:

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

Response Body Description:

Parameter name	Whether it is empty	Type	Parameter Description
brand_detail_id	N	int	Detail primary key
sku_id	N	int	sku Primary key
in_stc_no	N	string	scm tracking number
sku_name	N	string	Product name
scm_order_sn	N	string	SCM tracking number
scm_finish_time	N	string	Storage completion time
in_qnty	N	string	Quantity of storage requested
actually_number	N	string	Actual quantity in storage
material_number	N	string	Material identification number
warehouse_channel	N	string	channel
brand_name	N	string	brand
cost_center_code	N	string	Cost center
file_name	N	string	Return file

Response Body Example(Query by detail):

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

Response Body Example(Query by summary):

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

home