API接口目录

零售云业务

采购API
订单API
库存API
价格API
商品API
报表API
消息服务API
基础数据API
物流API
零售商认证API
发票API
快修回收API
云仓API
异常码自查工具
suning.retailer.sapsaleorderstoc.query 零售云sap销售订单列表查询接口
¥免费

零售云sap销售订单列表查询接口

公共参数
请求参数
名称 类型 是否必须 示例值 描述
appIdStringY111111调用方唯一编码
merchantCustNoStringY7017963441老板账号编码
storeCodeStringY59021店铺编码
startDateStringY2018-08-30开始日期
endDateStringY2018-08-30结束日期
响应参数
名称 类型 示例值 描述
respListString
orderNoStringP1807100000359021订单号
orderItemNoStringD1807100000359021订单行号
purchaseOrderNoStringA1001009136采购单号
purchaseOrderItemNoStringA100100913601采购订单行号
orderTypeString1订单类型
orderAmountString1订单金额
paidAmountString1实付金额
orderDiscountAmountString0订单优惠金额
orderStateString1订单状态
buyerAddressStringXXX路31号XXX大厦A座2楼收货地址
cmmdtyCodeString000000000100004919商品编码
cmmdtyNameStringopp商品名称
quantityString1数量
unitPriceString1单价
sellPriceString1实际单价
orderItemDiscountAmountString0订单行优惠金额
orderItemStateString1订单行状态
createTimeString2018-06-19 00:00:00创建时间
saleDireString0销售方向,-1为退货,0为正常订单
brandCodeString01品牌编码
brandNameString格力品牌名称
categoryCodeString01商品组编码
categoryNameString手机链商品组名称
请求示例
  • XML示例
  • JSON示例
复制全部代码
                                <sn_request>
  <sn_body>
    <querySapsaleorderstoc>
      <startDate>2018-08-30</startDate>
      <appId>111111</appId>
      <endDate>2018-08-30</endDate>
      <merchantCustNo>7017963441</merchantCustNo>
      <storeCode>59021</storeCode>
    </querySapsaleorderstoc>
  </sn_body>
</sn_request>

                                
                                {
  "sn_request": {
    "sn_body": {
      "querySapsaleorderstoc": {
        "startDate": "2018-08-30",
        "appId": "111111",
        "endDate": "2018-08-30",
        "merchantCustNo": "7017963441",
        "storeCode": "59021"
      }
    }
  }
}
                                
响应示例
  • XML示例
  • JSON示例
复制全部代码
                              <sn_responseContent>
  <sn_body>
    <querySapsaleorderstoc>
      <respList>
        <sellPrice>1</sellPrice>
        <cmmdtyCode>000000000100004919</cmmdtyCode>
        <createTime>2018-06-19 00:00:00</createTime>
        <orderState>1</orderState>
        <orderType>1</orderType>
        <saleDire>0</saleDire>
        <categoryCode>01</categoryCode>
        <unitPrice>1</unitPrice>
        <purchaseOrderNo>A1001009136</purchaseOrderNo>
        <buyerAddress>XXX路31号XXX大厦A座2楼</buyerAddress>
        <orderItemNo>D1807100000359021</orderItemNo>
        <brandName>格力</brandName>
        <orderItemState>1</orderItemState>
        <categoryName>手机链</categoryName>
        <cmmdtyName>opp</cmmdtyName>
        <orderNo>P1807100000359021</orderNo>
        <brandCode>01</brandCode>
        <orderAmount>1</orderAmount>
        <orderItemDiscountAmount>0</orderItemDiscountAmount>
        <paidAmount>1</paidAmount>
        <quantity>1</quantity>
        <orderDiscountAmount>0</orderDiscountAmount>
        <purchaseOrderItemNo>A100100913601</purchaseOrderItemNo>
      </respList>
    </querySapsaleorderstoc>
  </sn_body>
</sn_responseContent>

                              
                              {
  "sn_responseContent": {
    "sn_body": {
      "querySapsaleorderstoc": {
        "respList": [
          {
            "sellPrice": "1",
            "cmmdtyCode": "000000000100004919",
            "createTime": "2018-06-19 00:00:00",
            "orderState": "1",
            "orderType": "1",
            "saleDire": "0",
            "categoryCode": "01",
            "unitPrice": "1",
            "purchaseOrderNo": "A1001009136",
            "buyerAddress": "XXX路31号XXX大厦A座2楼",
            "orderItemNo": "D1807100000359021",
            "brandName": "格力",
            "orderItemState": "1",
            "categoryName": "手机链",
            "cmmdtyName": "opp",
            "orderNo": "P1807100000359021",
            "orderItemDiscountAmount": "0",
            "orderAmount": "1",
            "brandCode": "01",
            "paidAmount": "1",
            "quantity": "1",
            "orderDiscountAmount": "0",
            "purchaseOrderItemNo": "A100100913601"
          }
        ]
      }
    }
  }
}
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.retailer.querysapsaleorderstoc.missing-parameter:* 参数必填 请检查此参数的值,*号表示参数字段名
biz.retailer.querysapsaleorderstoc.format-error:* 参数格式错误 请检查此参数的值,*号表示参数字段名
biz.handler.data-get:no-result 查询没结果 请检查查询参数
isp.sys.service.unavailable.srcdss 服务不可用 请联系苏宁技术人员
biz.retailer.querysapsaleorderstoc.invalid-biz:100 请求参数缺失或异常
biz.retailer.querysapsaleorderstoc.invalid-biz:101 接口执行返回失败
biz.retailer.querysapsaleorderstoc.invalid-biz:102 查询结果为空
biz.retailer.querysapsaleorderstoc.invalid-biz:103 系统异常
biz.retailer.querysapsaleorderstoc.invalid-biz:105 无效的AppId请求
biz.retailer.querysapsaleorderstoc.invalid-biz:106 老板编号与门店不匹配
公共异常码
API工具
FAQ