API
查询派送费用
更新时间： 2024-07-03 10:17:49 访问次数：13452

接口说明

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

接口名称

sms.incomeSettlement.queryOutboundOrderFee

请求说明

请求内容 说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000，1000有需要可申请加大。

请求入参

名称 类型 必填 说明 示例
businessDocumentNo String() N 海外仓出库单号
在用户创建海外仓出库单后获得，唯一		 WO04875043
sellerNo String() N 卖家订单号
trackingNo String() N 跟踪号/快递单号
destinationWarehouse String() N 出库海外仓编码 US0001
orderDateFrom String() N 下单起始日期(精确至日) 2019-08-01
orderDateTo String() N 下单截止日期(精确至日) 2019-08-26
pageParams Array Y 分页参数
-|pageSize integer Y 每页显示数量，默认和最大200
-|pageNo integer Y 页码，第几页，默认1

请求示例

  1. {
  2.     "action":"sms.incomeSettlement.queryOutboundOrderFee",
  3.     "app_key":"rebecca",
  4.     "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.     "client_sign":"CF592BA57342089980EE97C87BE9BFAD",
  6.     "data":{
  7.           "businessDocumentNo":"WO0000004031",
  8.         "sellerNo":"",
  9.         "trackingNo":"",
  10.         "destinationWarehouse":"USWC Warehouse",
  11.         "orderDateFrom":"2019-08-01",
  12.         "orderDateTo":"2019-08-26",
  13.         "pageParams":{
  14.             "pageSize":"200",
  15.             "pageNo":"1"
  16.         }
  17.     },
  18.     "format":"json",
  19.     "language":"zh_CN",
  20.     "platform":"OWNERERP",
  21.     "sign":"6A481FBD09EE0FFCC02FA885B5F10EDC",
  22.     "sign_method":"md5",
  23.     "timestamp":"2015-06-16 00:19:26",
  24.     "version":"1.0"
  25. }

返回出参

返回参数说明：正确的返回编码code：0及结果data，错误的返回错误码及错误信息msg。

名称 类型 必传 说明 示例
List Object Y 查询结果list
-|businessDocumentNo String() Y 出库订单号
-|sellerNo String() Y 卖家订单号
-|trackingNo String() Y 跟踪号/快递单号
-|destinationWarehouse String() Y 出库海外仓
-|productName String() Y 尾程派送方式名称
-|productCode String() Y 尾程派送方式代码
-|orderDate String() Y 下单时间
-|incomeSettlementLineVos Array Y 费用明细
-|-|isActive String() Y 是否生效
-|-|chargeCode String() Y 费用项编码
-|-|chargeName String() Y 费用项名称
-|-|sourceAmt Number(,2) Y 金额（原币）
-|-|sourceCurrency String() Y 币种（原币币种）
-|-|acctAmt Number(,2) 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 Object Y 分页
-|totalCount Number Y 记录总数
-|currentPagesize Number Y 当前每页记录数
-|currentPageNo Number Y 当前页码

返回示例

1.正常出库单费用

  1. {
  2.    "code": "0",
  3.    "msg": "操作成功",
  4.    "data":    {
  5.       "pageParams":       {
  6.          "currentPageSize": 200,
  7.          "totalCount": 1,
  8.          "currentPageNo": 1
  9.       },
  10.       "list": [      {
  11.          "id": null,
  12.          "orgId": null,
  13.          "isDelete": null,
  14.          "isActive": null,
  15.          "created": null,
  16.          "createdby": null,
  17.          "updated": null,
  18.          "updatedby": null,
  19.          "businessDocumentNo": "WO0000004031",
  20.          "orderDate": "2019-08-26 13:49:44",
  21.          "destinationWarehouse": "USWC Warehouse",
  22.          "sellerNo": "252727722489-1495123873511",
  23.          "trackingNo": "1Z68223Y0335397681",
  24.          "productCode": "OSF810757",
  25.          "productName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  26.          "incomeSettlementLineVos":          [
  27.                         {
  28.                "id": 414444881,
  29.                "orgId": 1000000,
  30.                "isDelete": "N",
  31.                "isActive": "Y",
  32.                "created": "2019-08-26 13:57:21",
  33.                "createdby": "system",
  34.                "updated": "2019-08-26 13:57:21",
  35.                "updatedby": "system",
  36.                "chargeCode": "1000010",
  37.                "chargeName": "海外仓最后一公里派送费",
  38.                "sourceAmt": -0.25,
  39.                "acctAmt": -0.25,
  40.                "sourceCurrency": "USD",
  41.                "acctCurrency": "USD",
  42.                "exchangeRate": 1,
  43.                "dateAcct": "2019-08-26 13:52:23",
  44.                "weight": 0.025,
  45.                "volume": 4.5E-4,
  46.                "volumeWeight": null,
  47.                "chargeWeight": 8.36,
  48.                "description": null
  49.             },
  50.                         {
  51.                "id": 414444882,
  52.                "orgId": 1000000,
  53.                "isDelete": "N",
  54.                "isActive": "Y",
  55.                "created": "2019-08-26 13:57:21",
  56.                "createdby": "system",
  57.                "updated": "2019-08-26 13:57:21",
  58.                "updatedby": "system",
  59.                "chargeCode": "1000010",
  60.                "chargeName": "海外仓最后一公里派送费",
  61.                "sourceAmt": 8.36,
  62.                "acctAmt": 8.36,
  63.                "sourceCurrency": "USD",
  64.                "acctCurrency": "USD",
  65.                "exchangeRate": 1,
  66.                "dateAcct": "2019-08-26 13:52:23",
  67.                "weight": 0.025,
  68.                "volume": 4.5E-4,
  69.                "volumeWeight": null,
  70.                "chargeWeight": 0.025,
  71.                "description": null
  72.             },
  73.                         {
  74.                "id": 414444883,
  75.                "orgId": 1000000,
  76.                "isDelete": "N",
  77.                "isActive": "Y",
  78.                "created": "2019-08-26 13:57:21",
  79.                "createdby": "system",
  80.                "updated": "2019-08-26 13:57:21",
  81.                "updatedby": "system",
  82.                "chargeCode": "1000914",
  83.                "chargeName": "出库处理费",
  84.                "sourceAmt": 0.05,
  85.                "acctAmt": 0.05,
  86.                "sourceCurrency": "USD",
  87.                "acctCurrency": "USD",
  88.                "exchangeRate": 1,
  89.                "dateAcct": "2019-08-26 13:52:23",
  90.                "weight": 0.025,
  91.                "volume": 4.5E-4,
  92.                "volumeWeight": null,
  93.                "chargeWeight": 0.025,
  94.                "description": null
  95.             }
  96.          ]
  97.       }]
  98.    }
  99. }

2.含有商务折扣的示例

image.png

  1. {
  2.    "code": "0",
  3.    "msg": "操作成功",
  4.    "data":    {
  5.       "pageParams":       {
  6.          "currentPageSize": 200,
  7.          "totalCount": 1,
  8.          "currentPageNo": 1
  9.       },
  10.       "list": [      {
  11.          "id": null,
  12.          "orgId": null,
  13.          "isDelete": null,
  14.          "isActive": null,
  15.          "created": null,
  16.          "createdby": null,
  17.          "updated": null,
  18.          "updatedby": null,
  19.          "businessDocumentNo": "WO0000000023",
  20.          "orderDate": "2019-07-03 09:42:39",
  21.          "destinationWarehouse": "USWC Warehouse",
  22.          "sellerNo": "echamp114-7300830-1651409",
  23.          "trackingNo": "788256512091",
  24.          "productCode": "OSF811002675",
  25.          "productName": "FedEx - Ground (Standard 1-5 Business Days)-USWC",
  26.          "incomeSettlementLineVos":          [
  27.                         {
  28.                "id": 446341708,
  29.                "orgId": 1000000,
  30.                "isDelete": "N",
  31.                "isActive": "Y",
  32.                "created": "2019-07-04 08:00:35",
  33.                "createdby": "system",
  34.                "updated": "2019-07-04 08:00:39",
  35.                "updatedby": "system",
  36.                "chargeCode": "1000010",
  37.                "chargeName": "海外仓最后一公里派送费",
  38.                "sourceAmt": 47.26,
  39.                "acctAmt": 47.26,
  40.                "sourceCurrency": "USD",
  41.                "acctCurrency": "USD",
  42.                "exchangeRate": 1,
  43.                "dateAcct": "2019-07-04 07:49:46",
  44.                "weight": 50,
  45.                "volume": 0.1767435,
  46.                "volumeWeight": null,
  47.                "chargeWeight": 50,
  48.                "description": null
  49.             },
  50.                         {
  51.                "id": 446341717,
  52.                "orgId": 1000000,
  53.                "isDelete": "N",
  54.                "isActive": "Y",
  55.                "created": "2019-07-04 08:00:36",
  56.                "createdby": "system",
  57.                "updated": "2019-07-04 08:00:39",
  58.                "updatedby": "system",
  59.                "chargeCode": "1000914",
  60.                "chargeName": "出库处理费",
  61.                "sourceAmt": 4.11,
  62.                "acctAmt": 4.11,
  63.                "sourceCurrency": "USD",
  64.                "acctCurrency": "USD",
  65.                "exchangeRate": 1,
  66.                "dateAcct": "2019-07-04 07:49:46",
  67.                "weight": 50,
  68.                "volume": 0.1767435,
  69.                "volumeWeight": null,
  70.                "chargeWeight": 50,
  71.                "description": null
  72.             },
  73.                         {
  74.                "id": 446341734,
  75.                "orgId": 1000000,
  76.                "isDelete": "N",
  77.                "isActive": "Y",
  78.                "created": "2019-07-04 08:00:36",
  79.                "createdby": "system",
  80.                "updated": "2019-07-04 08:00:40",
  81.                "updatedby": "system",
  82.                "chargeCode": "1031252",
  83.                "chargeName": "超大尺寸附加费",
  84.                "sourceAmt": 22.5,
  85.                "acctAmt": 22.5,
  86.                "sourceCurrency": "USD",
  87.                "acctCurrency": "USD",
  88.                "exchangeRate": 1,
  89.                "dateAcct": "2019-07-04 07:49:46",
  90.                "weight": 50,
  91.                "volume": 0.1767435,
  92.                "volumeWeight": null,
  93.                "chargeWeight": 50,
  94.                "description": null
  95.             },
  96.                         {
  97.                "id": 446342547,
  98.                "orgId": 1000000,
  99.                "isDelete": "N",
  100.                "isActive": "Y",
  101.                "created": "2019-07-04 08:00:35",
  102.                "createdby": "system",
  103.                "updated": "2019-07-04 08:00:39",
  104.                "updatedby": "system",
  105.                "chargeCode": "1000010",
  106.                "chargeName": "海外仓最后一公里派送费",
  107.                "sourceAmt": -1.42,
  108.                "acctAmt": -1.42,
  109.                "sourceCurrency": "USD",
  110.                "acctCurrency": "USD",
  111.                "exchangeRate": 1,
  112.                "dateAcct": "2019-07-04 07:49:46",
  113.                "weight": 50,
  114.                "volume": 0.1767435,
  115.                "volumeWeight": null,
  116.                "chargeWeight": 47.26,
  117.                "description": null
  118.             },
  119.                         {
  120.                "id": 446342550,
  121.                "orgId": 1000000,
  122.                "isDelete": "N",
  123.                "isActive": "Y",
  124.                "created": "2019-07-04 08:00:35",
  125.                "createdby": "system",
  126.                "updated": "2019-07-04 08:00:39",
  127.                "updatedby": "system",
  128.                "chargeCode": "1000010",
  129.                "chargeName": "海外仓最后一公里派送费",
  130.                "sourceAmt": -13.23,
  131.                "acctAmt": -13.23,
  132.                "sourceCurrency": "USD",
  133.                "acctCurrency": "USD",
  134.                "exchangeRate": 1,
  135.                "dateAcct": "2019-07-04 07:49:46",
  136.                "weight": 50,
  137.                "volume": 0.1767435,
  138.                "volumeWeight": null,
  139.                "chargeWeight": null,
  140.                "description": null
  141.             },
  142.                         {
  143.                "id": 446342558,
  144.                "orgId": 1000000,
  145.                "isDelete": "N",
  146.                "isActive": "Y",
  147.                "created": "2019-07-04 08:00:36",
  148.                "createdby": "system",
  149.                "updated": "2019-07-04 08:00:39",
  150.                "updatedby": "system",
  151.                "chargeCode": "1003247",
  152.                "chargeName": "燃油附加费",
  153.                "sourceAmt": 4.89,
  154.                "acctAmt": 4.89,
  155.                "sourceCurrency": "USD",
  156.                "acctCurrency": "USD",
  157.                "exchangeRate": 1,
  158.                "dateAcct": "2019-07-04 07:49:46",
  159.                "weight": 50,
  160.                "volume": 0.1767435,
  161.                "volumeWeight": null,
  162.                "chargeWeight": null,
  163.                "description": null
  164.             }
  165.          ]
  166.       }]
  167.    }
  168. }