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

接口说明

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

接口名称

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. }