API
查询单据费用
更新时间: 2023-11-16 19:40:55 访问次数:8783

接口说明

本接口可查询全部单据的费用

使用场景

所有已经计费的业务单据。

接口名称

sms.incomeSettlement.getTransactionCharge

请求说明

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

请求入参

名称 类型 必填 说明 示例
businessDocumentType String() Y 业务分类
ISP:ISP订单费
EC_ISP:其它费用(ISP/小包)
OC:海外仓出库费用
EC:海外仓其它费用
GTC:国际送仓费
FLC::入库费用
SC:仓储费
RHC:退货费用
VAS:增值服务费
OC
businessDocumentNo String() N 业务订单号
国际送仓单的WINIT订单号
海外仓出库单的WINIT订单号
海外仓入库单的WINIT订单号
ISP小包中国出库WINIT订单号
tradeDateFrom String() Y 扣费开始日期
YYYY-MM-DD ,精确至日
时间跨度不超过31天
2018-04-15
tradeDateTo String() Y 扣费截止日期
YYYY-MM-DD ,精确至日
时间跨度不超过31天
2018-05-15
pageParams Object Y 分页参数
pageSize Integer Y 每页显示数量
最大200,超出200,默认为200
200
pageNo Integer Y 页码
第几页,默认1
1

请求示例

  1. {
  2. "action":"sms.incomeSettlement.getTransactionCharge",
  3. "app_key":"rebecca",
  4. "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5. "client_sign":"9BB061E77B4A6C5C387872B260540CF6",
  6. "data":{
  7. "businessDocumentType":"OC",
  8. "businessDocumentNo":"",
  9. "tradeDateFrom":"2019-06-09",
  10. "tradeDateTo":"2019-07-09",
  11. "pageParams":{
  12. "pageSize":"200",
  13. "pageNo":"1"
  14. }
  15. },
  16. "format":"json",
  17. "language":"zh_CN",
  18. "platform":"OWNERERP",
  19. "sign":"A89BEACF3F88624EBF94AF8B94BB7B0F",
  20. "sign_method":"md5",
  21. "timestamp":"2019-01-01 00:19:26",
  22. "version":"1.0"
  23. }

返回出参

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

名称 类型 必传 说明 示例
list Array Y 查询结果
businessDocumentNo String() Y 业务订单号
1.入参中businessDocumentNo不为空,则为原入参
2.入参中businessDocumentNo为空,则为所有单据号
referenceOrderNo String() Y 业务关联订单号 WO21041823012
sellerOrderNo String() Y 卖家订单号
trackingNo String() Y 运单号 UE23314241GD
winitServiceCode String() Y Winit物流服务编码
warehouseCode String() Y 仓库编码
fulfillmentDate String() Y 订单完成时间
精确到时分秒
2018-06-05 20:06:15
orderDate String() Y 下单日期
精确到时分
2018-06-05 20:06:15
queryTransactionChargeLineVos Array Y 费用项
transactionNo String() Y 交易号
chargeCode String() Y 费用项编码
chargeName String() Y 费用项名称
chargeType String() Y 记账方式
sourceAmt Number(,2) Y 原币金额
acctAmt Number(,2) Y 结算金额,结算币
sourceCurrency String() Y 原币币种
acctCurrency String() Y 本位币币种
exchangeRate Number Y 本位币汇率
dateAcct String() Y 记账时间
精确到时分秒,北京时间
tradeDate String() Y 扣费时间
精确到时分秒,北京时间
weight Number(6,3) Y 重量,单位:KG
chargeWeight Number(6.3) Y 计费重量,单位:KG
volume Number(9.6) Y 核实体积,单位:CBM
volumeWeight Number(6.3) Y 体积重,单位:KG
description String() Y 描述
pageParams Object Y 分页参数
totalCount Integer Y 记录总数
业务单据号的总数量

currentPagesize Integer Y 当前每页记录数
currentPageNo Integer Y 当前页码,当前第几页

返回示例

  1. {
  2. "code": "0",
  3. "msg": "操作成功",
  4. "data": {
  5. "pageParams": {
  6. "currentPageSize": 200,
  7. "totalCount": 4,
  8. "currentPageNo": 1
  9. },
  10. "list": [
  11. {
  12. "businessDocumentNo": "WO0000001800",
  13. "referenceOrderNo": null,
  14. "sellerOrderNo": "252727722489-1495123873511",
  15. "trackingNo": "1Z68223Y0334901360",
  16. "winitServiceCode": "OSF810757",
  17. "warehouseName": "USWC Warehouse",
  18. "fulfillmentDate": "2019-06-10 18:41:20",
  19. "orderDate": "2019-06-10 18:38:28",
  20. "queryTransactionChargeLineVos": [
  21. {
  22. "transactionNo": "596e2933-0244-4676-9866-27ccf66e0fe9",
  23. "chargeCode": "1000914",
  24. "chargeName": "出库处理费",
  25. "sourceAmt": -0.05,
  26. "acctAmt": -0.05,
  27. "sourceCurrency": "USD",
  28. "acctCurrency": "USD",
  29. "exchangeRate": 1,
  30. "dateAcct": "2019-06-10 18:41:20",
  31. "tradeDate": "2019-06-10 18:45:16",
  32. "weight": 0.025,
  33. "chargeWeight": 0.025,
  34. "volume": 4.5E-4,
  35. "volumeWeight": null,
  36. "description": null
  37. },
  38. {
  39. "transactionNo": "23ee069b-0800-447c-9c57-93c89f72acad",
  40. "chargeCode": "1000010",
  41. "chargeName": "海外仓最后一公里派送费",
  42. "sourceAmt": 0.25,
  43. "acctAmt": 0.25,
  44. "sourceCurrency": "USD",
  45. "acctCurrency": "USD",
  46. "exchangeRate": 1,
  47. "dateAcct": "2019-06-10 18:41:20",
  48. "tradeDate": "2019-06-10 18:45:16",
  49. "weight": 0.025,
  50. "chargeWeight": 8.36,
  51. "volume": 4.5E-4,
  52. "volumeWeight": null,
  53. "description": null
  54. },
  55. {
  56. "transactionNo": "40203890-a395-405e-8cbf-8804b8ef603c",
  57. "chargeCode": "1000010",
  58. "chargeName": "海外仓最后一公里派送费",
  59. "sourceAmt": -8.36,
  60. "acctAmt": -8.36,
  61. "sourceCurrency": "USD",
  62. "acctCurrency": "USD",
  63. "exchangeRate": 1,
  64. "dateAcct": "2019-06-10 18:41:20",
  65. "tradeDate": "2019-06-10 18:45:16",
  66. "weight": 0.025,
  67. "chargeWeight": 0.025,
  68. "volume": 4.5E-4,
  69. "volumeWeight": null,
  70. "description": null
  71. }
  72. ]
  73. },
  74. {
  75. "businessDocumentNo": "WO0000001828",
  76. "referenceOrderNo": null,
  77. "sellerOrderNo": "252727722489-1495123873511",
  78. "trackingNo": "1Z68223Y0302762561",
  79. "winitServiceCode": "OSF810757",
  80. "warehouseName": "USWC Warehouse",
  81. "fulfillmentDate": "2019-06-11 11:59:05",
  82. "orderDate": "2019-06-11 11:56:44",
  83. "queryTransactionChargeLineVos": [
  84. {
  85. "transactionNo": "7267ff46-754f-45f3-b78f-c4e2799d590f",
  86. "chargeCode": "1000010",
  87. "chargeName": "海外仓最后一公里派送费",
  88. "sourceAmt": 0.25,
  89. "acctAmt": 0.25,
  90. "sourceCurrency": "USD",
  91. "acctCurrency": "USD",
  92. "exchangeRate": 1,
  93. "dateAcct": "2019-06-11 11:59:05",
  94. "tradeDate": "2019-06-11 12:03:49",
  95. "weight": 0.025,
  96. "chargeWeight": 8.36,
  97. "volume": 4.5E-4,
  98. "volumeWeight": null,
  99. "description": null
  100. },
  101. {
  102. "transactionNo": "0340110d-e797-41b2-95f1-4031380568ce",
  103. "chargeCode": "1000914",
  104. "chargeName": "出库处理费",
  105. "sourceAmt": -0.05,
  106. "acctAmt": -0.05,
  107. "sourceCurrency": "USD",
  108. "acctCurrency": "USD",
  109. "exchangeRate": 1,
  110. "dateAcct": "2019-06-11 11:59:05",
  111. "tradeDate": "2019-06-11 12:03:49",
  112. "weight": 0.025,
  113. "chargeWeight": 0.025,
  114. "volume": 4.5E-4,
  115. "volumeWeight": null,
  116. "description": null
  117. },
  118. {
  119. "transactionNo": "2e43927a-abae-468a-a774-89c1865db36e",
  120. "chargeCode": "1000010",
  121. "chargeName": "海外仓最后一公里派送费",
  122. "sourceAmt": -8.36,
  123. "acctAmt": -8.36,
  124. "sourceCurrency": "USD",
  125. "acctCurrency": "USD",
  126. "exchangeRate": 1,
  127. "dateAcct": "2019-06-11 11:59:05",
  128. "tradeDate": "2019-06-11 12:03:49",
  129. "weight": 0.025,
  130. "chargeWeight": 0.025,
  131. "volume": 4.5E-4,
  132. "volumeWeight": null,
  133. "description": null
  134. }
  135. ]
  136. },
  137. {
  138. "businessDocumentNo": "WO0000001937",
  139. "referenceOrderNo": null,
  140. "sellerOrderNo": "252727722489-1495123873511",
  141. "trackingNo": "9205590134519202581136",
  142. "winitServiceCode": "OSF810757",
  143. "warehouseName": "USWC Warehouse",
  144. "fulfillmentDate": "2019-06-17 16:49:36",
  145. "orderDate": "2019-06-17 16:47:58",
  146. "queryTransactionChargeLineVos": [
  147. {
  148. "transactionNo": "9de11b3b-b2e8-4ca8-837e-b999446b26f8",
  149. "chargeCode": "1000010",
  150. "chargeName": "海外仓最后一公里派送费",
  151. "sourceAmt": -8.36,
  152. "acctAmt": -8.36,
  153. "sourceCurrency": "USD",
  154. "acctCurrency": "USD",
  155. "exchangeRate": 1,
  156. "dateAcct": "2019-06-17 16:49:36",
  157. "tradeDate": "2019-06-17 16:51:30",
  158. "weight": 0.025,
  159. "chargeWeight": 0.025,
  160. "volume": 4.5E-4,
  161. "volumeWeight": null,
  162. "description": null
  163. },
  164. {
  165. "transactionNo": "5b37a583-a18c-4564-b2b3-a2daa1392eef",
  166. "chargeCode": "1000010",
  167. "chargeName": "海外仓最后一公里派送费",
  168. "sourceAmt": 0.25,
  169. "acctAmt": 0.25,
  170. "sourceCurrency": "USD",
  171. "acctCurrency": "USD",
  172. "exchangeRate": 1,
  173. "dateAcct": "2019-06-17 16:49:36",
  174. "tradeDate": "2019-06-17 16:51:30",
  175. "weight": 0.025,
  176. "chargeWeight": 8.36,
  177. "volume": 4.5E-4,
  178. "volumeWeight": null,
  179. "description": null
  180. },
  181. {
  182. "transactionNo": "1c8825b3-11d9-4086-a35d-f2af415e3268",
  183. "chargeCode": "1000914",
  184. "chargeName": "出库处理费",
  185. "sourceAmt": -0.05,
  186. "acctAmt": -0.05,
  187. "sourceCurrency": "USD",
  188. "acctCurrency": "USD",
  189. "exchangeRate": 1,
  190. "dateAcct": "2019-06-17 16:49:36",
  191. "tradeDate": "2019-06-17 16:51:30",
  192. "weight": 0.025,
  193. "chargeWeight": 0.025,
  194. "volume": 4.5E-4,
  195. "volumeWeight": null,
  196. "description": null
  197. }
  198. ]
  199. },
  200. {
  201. "businessDocumentNo": "WO0000002263",
  202. "referenceOrderNo": null,
  203. "sellerOrderNo": "252727722489-1495123873511",
  204. "trackingNo": "1Z68223Y0332929576",
  205. "winitServiceCode": "OSF810757",
  206. "warehouseName": "USWC Warehouse",
  207. "fulfillmentDate": "2019-07-01 15:59:34",
  208. "orderDate": "2019-07-01 15:57:19",
  209. "queryTransactionChargeLineVos": [
  210. {
  211. "transactionNo": "d81b955d-a095-4d96-b5ed-f56573ffff24",
  212. "chargeCode": "1000010",
  213. "chargeName": "海外仓最后一公里派送费",
  214. "sourceAmt": -8.36,
  215. "acctAmt": -8.36,
  216. "sourceCurrency": "USD",
  217. "acctCurrency": "USD",
  218. "exchangeRate": 1,
  219. "dateAcct": "2019-07-01 15:59:34",
  220. "tradeDate": "2019-07-01 16:03:11",
  221. "weight": 0.025,
  222. "chargeWeight": 0.025,
  223. "volume": 4.5E-4,
  224. "volumeWeight": null,
  225. "description": null
  226. },
  227. {
  228. "transactionNo": "dfab5424-7ac4-45ab-977f-3aa1c5e3fd5c",
  229. "chargeCode": "1000914",
  230. "chargeName": "出库处理费",
  231. "sourceAmt": -0.05,
  232. "acctAmt": -0.05,
  233. "sourceCurrency": "USD",
  234. "acctCurrency": "USD",
  235. "exchangeRate": 1,
  236. "dateAcct": "2019-07-01 15:59:34",
  237. "tradeDate": "2019-07-01 16:03:11",
  238. "weight": 0.025,
  239. "chargeWeight": 0.025,
  240. "volume": 4.5E-4,
  241. "volumeWeight": null,
  242. "description": null
  243. },
  244. {
  245. "transactionNo": "5af353e1-b758-4da8-9538-5f730fab20c7",
  246. "chargeCode": "1000010",
  247. "chargeName": "海外仓最后一公里派送费",
  248. "sourceAmt": 0.25,
  249. "acctAmt": 0.25,
  250. "sourceCurrency": "USD",
  251. "acctCurrency": "USD",
  252. "exchangeRate": 1,
  253. "dateAcct": "2019-07-01 15:59:34",
  254. "tradeDate": "2019-07-01 16:03:11",
  255. "weight": 0.025,
  256. "chargeWeight": 8.36,
  257. "volume": 4.5E-4,
  258. "volumeWeight": null,
  259. "description": null
  260. }
  261. ]
  262. }
  263. ]
  264. }
  265. }
关键词