API
查询派送费用
更新时间: 2019-08-26 19:25:36 访问次数:1931
接口说明

卖家或第三方通过该接口:使用出库订单号、跟踪号、卖家订单号、出库仓和下单日期查询出库订单的订单费用信息。

接口英文名称

sms.incomeSettlement.queryOutboundOrderFee

使用场景

卖家或第三方使用该接口查询获得出库订单费用。
一般商务折扣体现在“最后一个公里尾程派送费”,当这个费用为负数是为商务折扣

备注
请求说明
URL http://openapi.winit.com.cn/openapi/service
接口测试 http://openapi.sandbox.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000,有需要可申请加大。
请求入参
名称 类型 必填 说明 示例
businessDocumentNo
String() N 海外仓出库单号,在用户创建海外仓出库单后获得,唯一 WO04875043
sellerNo
String()
N卖家订单号

trackingNo
String()
N跟踪号/快递单号

destinationWarehouse
String()
N出库海外仓编码
US0001
orderDateFrom
String()
N下单起始日期(精确至日)
2018-04-15
orderDateTo
String()
N下单截止日期(精确至日)

pageParams
Array
Y分页参数

-|pageSize
integer
Y每页显示数量,默认和最大200

-|pageNo
integer
Y页码,第几页,默认1

请求示例
{
    "action":"sms.incomeSettlement.queryOutboundOrderFee",
    "app_key":"rebecca",
    "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
    "client_sign":"CF592BA57342089980EE97C87BE9BFAD",
    "data":{
    	"businessDocumentNo":"WO0000004031",
        "sellerNo":"",
        "trackingNo":"",
        "destinationWarehouse":"USWC Warehouse",
        "orderDateFrom":"2019-08-01",
        "orderDateTo":"2019-08-26",
        "pageParams":{
            "pageSize":"200",
            "pageNo":"1"
        }
    },
    "format":"json",
    "language":"zh_CN",
    "platform":"OWNERERP",
    "sign":"6A481FBD09EE0FFCC02FA885B5F10EDC",
    "sign_method":"md5",
    "timestamp":"2015-06-16 00:19:26",
    "version":"1.0"
}

                            
返回出参
名称 类型 必填 说明 示例
ListArray
Y查询结果,以下为子节点

-|businessDocumentNo
String() Y 出库订单号 WO04875043
-|sellerNo
String() Y 卖家订单号
-|trackingNo String() Y 跟踪号/快递单号
-|destinationWarehouse String() Y 出库海外仓
-|productName String() Y 尾程派送方式名称
Self Pick Service
-|productCode String() Y 尾程派送方式代码
OSF1001214
-|orderDate String() Y 下单时间
2018-06-05 20:06:15
-|incomeSettlementLineVos Array Y 费用项,以下为子节点
-|-|isActive String() Y 是否生效
-|-|chargeCode String() Y 费用项编码
-|-|chargeNameString()
Y
费用项名称

-|-|sourceAmt Number(,2)
Y 金额(原币)
113.50,二位小数至百分位
-|-|acctAmt Number(,2)
Y 结算金额(结算币)
-|-|sourceCurrency String() Y 币种(原币币种)
-|-|acctCurrency String() Y 币种(结算币种)
-|-|exchangeRate Number(,4)
Y 汇率(本币兑美元汇率)
-|-|dateAcct String() Y 记账时间(精确至秒)
-|-|created String() Y 交易时间(精确至秒)
-|-|createby String() Y 交易创建者
-|-|weight Number
Y 重量(Kg
-|-|volume Number
Y 体积(m3
-|-|volumeWeight Number
Y 体积重(CBM
-|-|chargeWeight Number
Y 计费重(Kg
-|-|description
String() Y 备注
pageParams
Array
Y 分页,以下为子节点
-|totalCount Number
Y 记录总数
-|currentPagesize Number Y 当前每页记录数
-|currentPageNo Number Y 包裹计费重量,kg

返回参数说明 正确的返回结果:查询成功。出库单费用详情。 错误的返回结果:错误码,错误信息

返回示例
1.正常出库单费用
{
   "code": "0",
   "msg": "操作成功",
   "data":    {
      "pageParams":       {
         "currentPageSize": 200,
         "totalCount": 1,
         "currentPageNo": 1
      },
      "list": [      {
         "id": null,
         "orgId": null,
         "isDelete": null,
         "isActive": null,
         "created": null,
         "createdby": null,
         "updated": null,
         "updatedby": null,
         "businessDocumentNo": "WO0000004031",
         "orderDate": "2019-08-26 13:49:44",
         "destinationWarehouse": "USWC Warehouse",
         "sellerNo": "252727722489-1495123873511",
         "trackingNo": "1Z68223Y0335397681",
         "productCode": "OSF810757",
         "productName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
         "incomeSettlementLineVos":          [
                        {
               "id": 414444881,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-08-26 13:57:21",
               "createdby": "system",
               "updated": "2019-08-26 13:57:21",
               "updatedby": "system",
               "chargeCode": "1000010",
               "chargeName": "海外仓最后一公里派送费",
               "sourceAmt": -0.25,
               "acctAmt": -0.25,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-08-26 13:52:23",
               "weight": 0.025,
               "volume": 4.5E-4,
               "volumeWeight": null,
               "chargeWeight": 8.36,
               "description": null
            },
                        {
               "id": 414444882,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-08-26 13:57:21",
               "createdby": "system",
               "updated": "2019-08-26 13:57:21",
               "updatedby": "system",
               "chargeCode": "1000010",
               "chargeName": "海外仓最后一公里派送费",
               "sourceAmt": 8.36,
               "acctAmt": 8.36,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-08-26 13:52:23",
               "weight": 0.025,
               "volume": 4.5E-4,
               "volumeWeight": null,
               "chargeWeight": 0.025,
               "description": null
            },
                        {
               "id": 414444883,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-08-26 13:57:21",
               "createdby": "system",
               "updated": "2019-08-26 13:57:21",
               "updatedby": "system",
               "chargeCode": "1000914",
               "chargeName": "出库处理费",
               "sourceAmt": 0.05,
               "acctAmt": 0.05,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-08-26 13:52:23",
               "weight": 0.025,
               "volume": 4.5E-4,
               "volumeWeight": null,
               "chargeWeight": 0.025,
               "description": null
            }
         ]
      }]
   }
}
2.含有商务折扣的示例

{
   "code": "0",
   "msg": "操作成功",
   "data":    {
      "pageParams":       {
         "currentPageSize": 200,
         "totalCount": 1,
         "currentPageNo": 1
      },
      "list": [      {
         "id": null,
         "orgId": null,
         "isDelete": null,
         "isActive": null,
         "created": null,
         "createdby": null,
         "updated": null,
         "updatedby": null,
         "businessDocumentNo": "WO0000000023",
         "orderDate": "2019-07-03 09:42:39",
         "destinationWarehouse": "USWC Warehouse",
         "sellerNo": "echamp114-7300830-1651409",
         "trackingNo": "788256512091",
         "productCode": "OSF811002675",
         "productName": "FedEx - Ground (Standard 1-5 Business Days)-USWC",
         "incomeSettlementLineVos":          [
                        {
               "id": 446341708,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:35",
               "createdby": "system",
               "updated": "2019-07-04 08:00:39",
               "updatedby": "system",
               "chargeCode": "1000010",
               "chargeName": "海外仓最后一公里派送费",
               "sourceAmt": 47.26,
               "acctAmt": 47.26,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": 50,
               "description": null
            },
                        {
               "id": 446341717,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:36",
               "createdby": "system",
               "updated": "2019-07-04 08:00:39",
               "updatedby": "system",
               "chargeCode": "1000914",
               "chargeName": "出库处理费",
               "sourceAmt": 4.11,
               "acctAmt": 4.11,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": 50,
               "description": null
            },
                        {
               "id": 446341734,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:36",
               "createdby": "system",
               "updated": "2019-07-04 08:00:40",
               "updatedby": "system",
               "chargeCode": "1031252",
               "chargeName": "超大尺寸附加费",
               "sourceAmt": 22.5,
               "acctAmt": 22.5,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": 50,
               "description": null
            },
                        {
               "id": 446342547,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:35",
               "createdby": "system",
               "updated": "2019-07-04 08:00:39",
               "updatedby": "system",
               "chargeCode": "1000010",
               "chargeName": "海外仓最后一公里派送费",
               "sourceAmt": -1.42,
               "acctAmt": -1.42,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": 47.26,
               "description": null
            },
                        {
               "id": 446342550,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:35",
               "createdby": "system",
               "updated": "2019-07-04 08:00:39",
               "updatedby": "system",
               "chargeCode": "1000010",
               "chargeName": "海外仓最后一公里派送费",
               "sourceAmt": -13.23,
               "acctAmt": -13.23,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": null,
               "description": null
            },
                        {
               "id": 446342558,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-07-04 08:00:36",
               "createdby": "system",
               "updated": "2019-07-04 08:00:39",
               "updatedby": "system",
               "chargeCode": "1003247",
               "chargeName": "燃油附加费",
               "sourceAmt": 4.89,
               "acctAmt": 4.89,
               "sourceCurrency": "USD",
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "dateAcct": "2019-07-04 07:49:46",
               "weight": 50,
               "volume": 0.1767435,
               "volumeWeight": null,
               "chargeWeight": null,
               "description": null
            }
         ]
      }]
   }
}