API
查询费用-新
更新时间: 2023-11-16 19:38:29 访问次数:6946

接口说明

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

使用场景

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

接口名称

sms.incomeSettlement.pageChargeDetails

请求说明

请求内容 说明
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() N 业务分类
ISP:ISP订单费
EC_ISP:其它费用(ISP/小包)
OC:海外仓出库费用
EC:海外仓其它费用(包含LMA)
GTC:国际送仓费
FLC::入库费用
SC:仓储费
RHC:退货费用
VAS:增值服务费
OC
businessDocumentNo String() O 业务订单号
国际送仓单的WINIT订单号
海外仓出库单的WINIT订单号
海外仓入库单的WINIT订单号
ISP小包中国出库WINIT订单号
businessDocumentNo 和(deducationTimeStart+deducationTimeEnd)二选一必填
tradeDateFrom String() O 扣费开始日期
YYYY-MM-DD ,精确至日
时间跨度不超过31天
2020-09-01
tradeDateTo String() O 扣费截止日期
YYYY-MM-DD ,精确至日
时间跨度不超过31天
2020-09-01
pageParams Object Y 分页参数
pageSize Integer Y 每页显示数量
最大200,超出200,默认为200
200
pageNo Integer Y 页码
第几页,默认1
1

请求示例

  1. {
  2. "action": "sms.incomeSettlement.pageChargeDetails",
  3. "app_key": "rebecca",
  4. "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5. "data": {
  6. "businessDocumentNo": "WO0000004031",
  7. "deducationTimeStart": "",
  8. "deducationTimeEnd": "",
  9. "businessDocumentType": "OC",
  10. "pageParams": {
  11. "pageNo": 1,
  12. "pageSize": "100"
  13. }
  14. },
  15. "format": "json",
  16. "language": "zh_CN",
  17. "platform": "OWNERERP",
  18. "sign": "CDC79A524BB3A2ACAB065CF2C820BB9C",
  19. "sign_method": "md5",
  20. "timestamp": "2019-10-24 17:32:58",
  21. "version": "1.0",
  22. "client_sign": "E3DC2D322810D343657FE393D7C2A1E1"
  23. }

返回出参

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

名称 类型 必传 说明 示例
list Array Y 查询结果
id NUMBER Y 结算单明细ID
created DATE Y 创建时间
updated DATE Y 更新时间
documentNo VARCHAR2 Y 业务交易号
businessDocumentNo VARCHAR2 Y 订单号
chargeCode VARCHAR2 Y 费用编码
chargeName VARCHAR2 Y 费用名称
transactionType VARCHAR2 Y 优惠类型
1000383:消费;
1000381:winit返利;
1000389:商务折扣;
1000390:礼品卡抵扣;
1000391:优惠券抵扣。
fundsDirection VARCHAR2 Y 资金方向
1:收入;2:支出
exchangeRate NUMBER Y 结算汇率
sourceAmt NUMBER Y 原币金额
sourceCurrency VARCHAR2 Y 原币币种
partnerCode VARCHAR2 Y 客户编码
partnerName VARCHAR2 Y 客户名称
orderDate DATE Y 下单日期
chargeDate DATE Y 计费日期,北京时间
dateAcct DATE Y 记账日期,北京时间
productLine VARCHAR2 Y 扣费钱包
OWHS:海外仓账户
ISP:ISP账户
deducationTime TIMESTAMP Y 扣费时间
logisticsDist VARCHAR2 N 物流分区
warehouseCode VARCHAR2 N 仓库编码
warehouse VARCHAR2 N 仓库
warehouseValue VARCHAR2 N 验货/始发仓库编码
originatingWarehouse VARCHAR2 N 验货/始发仓库
warehousetoValue VARCHAR2 N 目的仓库编码
destinationWarehouse VARCHAR2 N 目的仓库
transType VARCHAR2 N WINIT产品
weight NUMBER N 重量(KG)
volume NUMBER N 体积(CBM)
volumeWeight NUMBER N 体积重(KG)
chargeWeight NUMBER N 计费重(KG/CBM)
deliveryDate DATE N 提货/验货完成日期
stockDate DATE N 海外仓入库完成日期/出库日期/退货完成日期
totalDeclarePrice NUMBER N 申报价值(USD)
itemCodeNum VARCHAR2 N 单品编码及数量
totalItemQty NUMBER N 单品总数量
fistLegPrice NUMBER N 头程运费单价(USD)
sellerNo VARCHAR2 N 卖家订单号
sellerId VARCHAR2 N 卖家ID
buyerId VARCHAR2 N 买家ID
buyerCountry VARCHAR2 N 买家国家
declareWeight NUMBER N 申报重量
mainDocumentNo VARCHAR2 N 主单号/出库单号(退货单用)
onwardVoyageType VARCHAR2 N 头程类型 Winit:标准 Direct:直发
unit VARCHAR2 N 计费单位/计费类型
postalCode VARCHAR2 N 邮编
firstDateAdded DATE N 首次上架日期
ascanDate DATE N Ascan揽收时间
warehouseEntryType VARCHAR2 N 入库方式
wide NUMBER N
high NUMBER N
lenth NUMBER N
trackingNo VARCHAR2 N 出库单快递单号/包裹跟踪号
packageNo VARCHAR2 N 包裹号
buyerCountryName VARCHAR2 N 买家国家名称
description VARCHAR2 N 备注
inspection_type VARCHAR2 N 增值服务类型
inventory_type VARCHAR2 N 库存类型
2B:2B;
2C:2C。
pageParams Object Y 分页参数
totalCount Integer Y 记录总数
业务单据号的总数量

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

返回示例

  1. {
  2. "code": "0",
  3. "msg": "操作成功",
  4. "data": {
  5. "pageParams": {
  6. "currentPageSize": 100,
  7. "totalCount": 3,
  8. "currentPageNo": 1
  9. },
  10. "list": [
  11. {
  12. "id": 414444883,
  13. "orgId": 1000000,
  14. "isDelete": "N",
  15. "isActive": "Y",
  16. "created": "2019-08-26 13:57:21",
  17. "createdby": "system",
  18. "updated": "2019-08-26 13:57:21",
  19. "updatedby": "system",
  20. "chargeCode": "1000914",
  21. "chargeName": "出库处理费",
  22. "documentNo": "062c8a28-de4a-4eb6-a762-d1e94e7c4179",
  23. "businessDocumentNo": "WO0000004031",
  24. "sourceAmt": 0.05,
  25. "sourceCurrency": "USD",
  26. "acctAmt": 0.05,
  27. "acctCurrency": "USD",
  28. "exchangeRate": 1,
  29. "conversionTypeCode": "114",
  30. "incomeSettlementId": 440828301,
  31. "revenueAdjustLineId": null,
  32. "invoicelineId": 611061537,
  33. "isFeeDeducation": "Y",
  34. "docType": "1000810",
  35. "partnerCode": "1000019",
  36. "dateAcct": "2019-08-26 13:52:23",
  37. "isAdjust": "N",
  38. "isRebate": "N",
  39. "chargeValue": "102",
  40. "exchangeDate": "2019-08-26 13:52:23",
  41. "warehouse": null,
  42. "warehouseCode": null,
  43. "productLine": "OWHS",
  44. "arrearsAmt": null,
  45. "isInvoice": "Y",
  46. "logisticsDist": "USWC Warehouse",
  47. "accountCurrency": null,
  48. "settlementAmount": null,
  49. "isUsedCoupon": "N",
  50. "ispIsEbayRebate": "Y",
  51. "isConformGift": "N",
  52. "productCode": "OSF810757",
  53. "qty": null,
  54. "transactionType": "1000383",
  55. "priceVersion": "3850",
  56. "partnerName": "万邑通质量保证部测试账号1-TEST",
  57. "orderDate": "2019-08-26 13:49:44",
  58. "originatingWarehouse": null,
  59. "destinationWarehouse": "USWC Warehouse",
  60. "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  61. "weight": 0.025,
  62. "volume": 0.00045,
  63. "volumeWeight": null,
  64. "chargeWeight": 0.025,
  65. "deliveryDate": "2019-08-26 13:52:23",
  66. "stockDate": "2019-08-26 13:52:23",
  67. "totalDeclarePrice": null,
  68. "itemCodeNum": "auto_sku22*1",
  69. "totalItemQty": 1,
  70. "fistLegPrice": null,
  71. "sellerNo": "252727722489-1495123873511",
  72. "sellerId": null,
  73. "buyerId": null,
  74. "buyerCountry": null,
  75. "declareWeight": null,
  76. "mainDocumentNo": null,
  77. "onwardVoyageType": null,
  78. "unit": "SZL",
  79. "postalCode": "91436-3631",
  80. "firstDateAdded": null,
  81. "ascanDate": null,
  82. "warehouseEntryType": null,
  83. "wide": null,
  84. "high": null,
  85. "lenth": null,
  86. "masterBillNumber": null,
  87. "conversionRate": null,
  88. "trackingNo": "1Z68223Y0335397681",
  89. "entryWhType": "OSF81",
  90. "chargeDate": null,
  91. "businessType": null,
  92. "packageNo": "WO0000004031A",
  93. "buyerCountryName": null,
  94. "deducationTime": "2019-08-26 13:57:21",
  95. "description": null,
  96. "isRecalculation": null,
  97. "recalculationCode": null,
  98. "recalculationName": null,
  99. "warehouseValue": null,
  100. "warehousetoValue": null
  101. },
  102. {
  103. "id": 414444882,
  104. "orgId": 1000000,
  105. "isDelete": "N",
  106. "isActive": "Y",
  107. "created": "2019-08-26 13:57:21",
  108. "createdby": "system",
  109. "updated": "2019-08-26 13:57:21",
  110. "updatedby": "system",
  111. "chargeCode": "1000010",
  112. "chargeName": "海外仓最后一公里派送费",
  113. "documentNo": "1661a8f2-3094-4a88-b3fd-78f055fc5907",
  114. "businessDocumentNo": "WO0000004031",
  115. "sourceAmt": 8.36,
  116. "sourceCurrency": "USD",
  117. "acctAmt": 8.36,
  118. "acctCurrency": "USD",
  119. "exchangeRate": 1,
  120. "conversionTypeCode": "114",
  121. "incomeSettlementId": 440828300,
  122. "revenueAdjustLineId": null,
  123. "invoicelineId": 611061536,
  124. "isFeeDeducation": "Y",
  125. "docType": "1000810",
  126. "partnerCode": "1000019",
  127. "dateAcct": "2019-08-26 13:52:23",
  128. "isAdjust": "N",
  129. "isRebate": "N",
  130. "chargeValue": "103",
  131. "exchangeDate": "2019-08-26 13:52:23",
  132. "warehouse": null,
  133. "warehouseCode": null,
  134. "productLine": "OWHS",
  135. "arrearsAmt": null,
  136. "isInvoice": "Y",
  137. "logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
  138. "accountCurrency": null,
  139. "settlementAmount": null,
  140. "isUsedCoupon": "N",
  141. "ispIsEbayRebate": "Y",
  142. "isConformGift": "N",
  143. "productCode": "OSF810757",
  144. "qty": null,
  145. "transactionType": "1000383",
  146. "priceVersion": "33158",
  147. "partnerName": "万邑通质量保证部测试账号1-TEST",
  148. "orderDate": "2019-08-26 13:49:44",
  149. "originatingWarehouse": null,
  150. "destinationWarehouse": "USWC Warehouse",
  151. "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  152. "weight": 0.025,
  153. "volume": 0.00045,
  154. "volumeWeight": null,
  155. "chargeWeight": 0.025,
  156. "deliveryDate": "2019-08-26 13:52:23",
  157. "stockDate": "2019-08-26 13:52:23",
  158. "totalDeclarePrice": null,
  159. "itemCodeNum": "auto_sku22*1",
  160. "totalItemQty": 1,
  161. "fistLegPrice": null,
  162. "sellerNo": "252727722489-1495123873511",
  163. "sellerId": null,
  164. "buyerId": null,
  165. "buyerCountry": null,
  166. "declareWeight": null,
  167. "mainDocumentNo": null,
  168. "onwardVoyageType": null,
  169. "unit": "ZL",
  170. "postalCode": "91436-3631",
  171. "firstDateAdded": null,
  172. "ascanDate": null,
  173. "warehouseEntryType": null,
  174. "wide": null,
  175. "high": null,
  176. "lenth": null,
  177. "masterBillNumber": null,
  178. "conversionRate": null,
  179. "trackingNo": "1Z68223Y0335397681",
  180. "entryWhType": "OSF81",
  181. "chargeDate": null,
  182. "businessType": null,
  183. "packageNo": "WO0000004031A",
  184. "buyerCountryName": null,
  185. "deducationTime": "2019-08-26 13:57:21",
  186. "description": null,
  187. "isRecalculation": null,
  188. "recalculationCode": null,
  189. "recalculationName": null,
  190. "warehouseValue": null,
  191. "warehousetoValue": null
  192. },
  193. {
  194. "id": 414444881,
  195. "orgId": 1000000,
  196. "isDelete": "N",
  197. "isActive": "Y",
  198. "created": "2019-08-26 13:57:21",
  199. "createdby": "system",
  200. "updated": "2019-08-26 13:57:21",
  201. "updatedby": "system",
  202. "chargeCode": "1000010",
  203. "chargeName": "海外仓最后一公里派送费",
  204. "documentNo": "a4c04fe7-dc14-4a4d-a172-6d741501944b",
  205. "businessDocumentNo": "WO0000004031",
  206. "sourceAmt": -0.25,
  207. "sourceCurrency": "USD",
  208. "acctAmt": -0.25,
  209. "acctCurrency": "USD",
  210. "exchangeRate": 1,
  211. "conversionTypeCode": "114",
  212. "incomeSettlementId": 440828299,
  213. "revenueAdjustLineId": null,
  214. "invoicelineId": 611061535,
  215. "isFeeDeducation": "Y",
  216. "docType": "1000810",
  217. "partnerCode": "1000019",
  218. "dateAcct": "2019-08-26 13:52:23",
  219. "isAdjust": "N",
  220. "isRebate": "N",
  221. "chargeValue": "103",
  222. "exchangeDate": "2019-08-26 13:52:23",
  223. "warehouse": null,
  224. "warehouseCode": null,
  225. "productLine": "OWHS",
  226. "arrearsAmt": null,
  227. "isInvoice": "Y",
  228. "logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
  229. "accountCurrency": null,
  230. "settlementAmount": null,
  231. "isUsedCoupon": "N",
  232. "ispIsEbayRebate": "Y",
  233. "isConformGift": "N",
  234. "productCode": "OSF810757",
  235. "qty": null,
  236. "transactionType": "1000381",
  237. "priceVersion": "33158",
  238. "partnerName": "万邑通质量保证部测试账号1-TEST",
  239. "orderDate": "2019-08-26 13:49:44",
  240. "originatingWarehouse": null,
  241. "destinationWarehouse": "USWC Warehouse",
  242. "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  243. "weight": 0.025,
  244. "volume": 0.00045,
  245. "volumeWeight": null,
  246. "chargeWeight": 8.36,
  247. "deliveryDate": "2019-08-26 13:52:23",
  248. "stockDate": "2019-08-26 13:52:23",
  249. "totalDeclarePrice": null,
  250. "itemCodeNum": "auto_sku22*1",
  251. "totalItemQty": 1,
  252. "fistLegPrice": null,
  253. "sellerNo": "252727722489-1495123873511",
  254. "sellerId": null,
  255. "buyerId": null,
  256. "buyerCountry": null,
  257. "declareWeight": null,
  258. "mainDocumentNo": null,
  259. "onwardVoyageType": null,
  260. "unit": "ZL",
  261. "postalCode": "91436-3631",
  262. "firstDateAdded": null,
  263. "ascanDate": null,
  264. "warehouseEntryType": null,
  265. "wide": null,
  266. "high": null,
  267. "lenth": null,
  268. "masterBillNumber": null,
  269. "conversionRate": null,
  270. "trackingNo": "1Z68223Y0335397681",
  271. "entryWhType": "OSF81",
  272. "chargeDate": null,
  273. "businessType": null,
  274. "packageNo": "WO0000004031A",
  275. "buyerCountryName": null,
  276. "deducationTime": "2019-08-26 13:57:21",
  277. "description": null,
  278. "isRecalculation": null,
  279. "recalculationCode": null,
  280. "recalculationName": null,
  281. "warehouseValue": null,
  282. "warehousetoValue": null
  283. }
  284. ]
  285. }
  286. }
关键词