API
查询入库单费用
更新时间: 2019-10-16 20:27:08 访问次数:6942

接口说明

使用入库订单号、目的仓和下单日期查询入库订单订单费用信息。

接口名称

sms.incomeSettlement.pageInboundLine

请求说明

请求内容 说明
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() Y 海外仓入库单号 WI9900046392
destinationWarehouse String() N 目的海外仓名称 BEMO Warehouse
orderDateFrom Date N 查询开始日期 2018-01-16
orderDateTo Date N 查询截止日期 2018-05-23
pageParams Arrary Y 分页参数
–|pageNo Number Y 第几页,页码,默认1 1
–|pageSize Number Y 分页大小,每页记录数,最大200 100

请求示例

  1. {
  2. "action":"sms.incomeSettlement.pageInboundLine",
  3. "app_key":"rebecca",
  4. "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5. "client_sign":"EB2876C76EB5FE19E770024184B32704",
  6. "data":{
  7. "businessDocumentNo":"WI9900001290",
  8. "destinationWarehouse":"",
  9. "orderDateFrom":"",
  10. "orderDateTo":"",
  11. "pageParams":{
  12. "pageNo":"1",
  13. "pageSize":"20"
  14. }
  15. },
  16. "format":"json",
  17. "language":"zh_CN",
  18. "platform":"OWNERERP",
  19. "sign":"528B4608E7BF658A37BE94A54716B17F",
  20. "sign_method":"md5",
  21. "timestamp":"2017-09-16 19:50:24",
  22. "version":"1.0"
  23. }

返回出参

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

名称 类型 必传 说明 示例
list Array Y 查询结果
businessDocumentNo String() Y 入库订单号
sellerNo String() Y 卖家订单号
destinationWarehouse String() Y 目的海外仓名称
transType String() Y 头程运输类型 AIR
incomeSettlementLineVos Array Y 订单收费项
–|chargeCode String() Y 收费项编码
–|chargeName String() Y 收费项名称
–|documentNo String() Y 收费单据编号
–|dateAcct String() Y 记账时间,精确至秒,北京时间
–|sourceAmt String() Y 金额,原币
–|sourceCurrency String() Y 币种,原币币种
–|acctAmt String() Y 金额 ,目标货币
一般为美元
–|acctCurrency String() Y 币种,目标货币币种
一般为美元USD
–|exchangeRate String() Y 汇率
–|conversionTypeCode String() Y 兑换类别码
–|exchangeDate Date Y 兑换时间
–|businessDocumentNo String() Y 业务单号 ,入库订单号
–|sellerNo String() Y 卖家订单号
–|orderDate String() Y 入库单下单时间
–|originatingWarehouse String() Y 发货仓库名称
–|destinationWarehouse String() Y 目的仓库名称
–|transType String() Y 运输类型
–|weight String() Y 重量(KG)
–|volume String() Y 体积(CBM)
–|volumeWeight String() Y 体积重(KG)
–|chargeWeight String() Y 计算重(KG)
–|itemCodeNum String() Y 包裹商品数
–|totalItemQty String() Y 包裹单品数量
–|created Date() Y 创建时间
–|createdby String() Y 创建者

返回示例

  1. {
  2. "code": "0",
  3. "msg": "操作成功",
  4. "data": {
  5. "pageParams": {
  6. "currentPageSize": 20,
  7. "totalCount": 1,
  8. "currentPageNo": 1
  9. },
  10. "list": [
  11. {
  12. "id": null,
  13. "orgId": null,
  14. "isDelete": null,
  15. "isActive": null,
  16. "created": null,
  17. "createdby": null,
  18. "updated": null,
  19. "updatedby": null,
  20. "orgName": null,
  21. "incomeSettlementNo": null,
  22. "settlementDate": null,
  23. "businessDocumentNo": "WI9900001290",
  24. "docType": null,
  25. "partnerCode": null,
  26. "partnerName": null,
  27. "orderDate": null,
  28. "dateAcct": null,
  29. "originatingWarehouse": null,
  30. "destinationWarehouse": "USWC Warehouse",
  31. "transType": "AIR",
  32. "weight": null,
  33. "volume": null,
  34. "volumeWeight": null,
  35. "chargeWeight": null,
  36. "sourceCurrency": null,
  37. "sourceTotalAmt": null,
  38. "acctCurrency": null,
  39. "acctTotalAmt": null,
  40. "isInvoice": null,
  41. "invoiceNo": null,
  42. "invoiceDate": null,
  43. "isReconciled": null,
  44. "isAdjust": null,
  45. "adjustNo": null,
  46. "isRebate": null,
  47. "deliveryDate": null,
  48. "stockDate": null,
  49. "totalDeclarePrice": null,
  50. "itemCodeNum": null,
  51. "totalItemQty": null,
  52. "fistLegPrice": null,
  53. "sellerNo": "AutoStandard air 222222",
  54. "sellerId": null,
  55. "buyerId": null,
  56. "buyerCountry": null,
  57. "declareWeight": null,
  58. "mainDocumentNo": null,
  59. "onwardVoyageType": null,
  60. "unit": null,
  61. "exchangeRate": null,
  62. "conversionTypeCode": null,
  63. "postalCode": null,
  64. "firstDateAdded": null,
  65. "wide": null,
  66. "high": null,
  67. "lenth": null,
  68. "masterBillNumber": null,
  69. "conversionRate": null,
  70. "ascanDate": null,
  71. "warehouseEntryType": null,
  72. "productCode": null,
  73. "productName": null,
  74. "incomeSettlementLineVos":
  75. [
  76. {
  77. "id": 414442588,
  78. "orgId": 1000000,
  79. "isDelete": "N",
  80. "isActive": "Y",
  81. "created": "2019-06-03 17:44:16",
  82. "createdby": "system",
  83. "updated": "2019-06-03 17:44:16",
  84. "updatedby": "system",
  85. "chargeCode": "1000007",
  86. "chargeName": "头程运费-空运",
  87. "documentNo": "201906031744120016001",
  88. "businessDocumentNo": "WI9900001290",
  89. "sourceAmt": 42,
  90. "sourceCurrency": "USD",
  91. "acctAmt": 42,
  92. "acctCurrency": "USD",
  93. "exchangeRate": 1,
  94. "conversionTypeCode": "114",
  95. "incomeSettlementId": 440826006,
  96. "revenueAdjustLineId": null,
  97. "invoicelineId": 611060787,
  98. "isFeeDeducation": "Y",
  99. "docType": "1000792",
  100. "partnerCode": "1000019",
  101. "dateAcct": "2019-06-03 17:44:12",
  102. "isAdjust": "N",
  103. "isRebate": "N",
  104. "chargeValue": "100",
  105. "exchangeDate": "2019-06-03 17:44:12",
  106. "warehouse": null,
  107. "warehouseCode": null,
  108. "productLine": "OWHS",
  109. "arrearsAmt": null,
  110. "isInvoice": "Y",
  111. "logisticsDist": null,
  112. "accountCurrency": null,
  113. "settlementAmount": null,
  114. "isUsedCoupon": "N",
  115. "ispIsEbayRebate": null,
  116. "isConformGift": "N",
  117. "productCode": "OW01010343",
  118. "qty": 1,
  119. "transactionType": null,
  120. "priceVersion": null,
  121. "partnerName": "万邑通质量保证部测试账号1-TEST",
  122. "orderDate": "2019-06-03 17:38:11",
  123. "originatingWarehouse": "ShenZhen Warehouse",
  124. "destinationWarehouse": "USWC Warehouse",
  125. "transType": "AIR",
  126. "weight": 10,
  127. "volume": 0.06,
  128. "volumeWeight": null,
  129. "chargeWeight": 10,
  130. "deliveryDate": "2019-06-03 17:39:23",
  131. "stockDate": null,
  132. "totalDeclarePrice": 120,
  133. "itemCodeNum": "2",
  134. "totalItemQty": 4,
  135. "fistLegPrice": null,
  136. "sellerNo": "AutoStandard air 222222",
  137. "sellerId": null,
  138. "buyerId": null,
  139. "buyerCountry": null,
  140. "declareWeight": null,
  141. "mainDocumentNo": null,
  142. "onwardVoyageType": "Winit",
  143. "unit": "JFZ",
  144. "postalCode": null,
  145. "firstDateAdded": null,
  146. "ascanDate": null,
  147. "warehouseEntryType": null,
  148. "wide": null,
  149. "high": null,
  150. "lenth": null,
  151. "masterBillNumber": null,
  152. "conversionRate": null,
  153. "trackingNo": null,
  154. "entryWhType": "SD"
  155. },
  156. {
  157. "id": 414442591,
  158. "orgId": 1000000,
  159. "isDelete": "N",
  160. "isActive": "Y",
  161. "created": "2019-06-03 17:46:06",
  162. "createdby": "system",
  163. "updated": "2019-06-03 17:46:06",
  164. "updatedby": "system",
  165. "chargeCode": "1000913",
  166. "chargeName": "入库处理费",
  167. "documentNo": "201906031746030019001",
  168. "businessDocumentNo": "WI9900001290",
  169. "sourceAmt": 0.72,
  170. "sourceCurrency": "USD",
  171. "acctAmt": 0.72,
  172. "acctCurrency": "USD",
  173. "exchangeRate": 1,
  174. "conversionTypeCode": "114",
  175. "incomeSettlementId": 440826009,
  176. "revenueAdjustLineId": null,
  177. "invoicelineId": 611060790,
  178. "isFeeDeducation": "Y",
  179. "docType": "1000792",
  180. "partnerCode": "1000019",
  181. "dateAcct": "2019-06-03 17:46:03",
  182. "isAdjust": "N",
  183. "isRebate": "N",
  184. "chargeValue": "101",
  185. "exchangeDate": "2019-06-03 17:46:03",
  186. "warehouse": null,
  187. "warehouseCode": null,
  188. "productLine": "OWHS",
  189. "arrearsAmt": null,
  190. "isInvoice": "Y",
  191. "logisticsDist": null,
  192. "accountCurrency": null,
  193. "settlementAmount": null,
  194. "isUsedCoupon": "N",
  195. "ispIsEbayRebate": null,
  196. "isConformGift": "N",
  197. "productCode": "OW01010343",
  198. "qty": 1,
  199. "transactionType": null,
  200. "priceVersion": null,
  201. "partnerName": "万邑通质量保证部测试账号1-TEST",
  202. "orderDate": "2019-06-03 17:38:11",
  203. "originatingWarehouse": "ShenZhen Warehouse",
  204. "destinationWarehouse": "USWC Warehouse",
  205. "transType": "AIR",
  206. "weight": 10,
  207. "volume": 0.06,
  208. "volumeWeight": null,
  209. "chargeWeight": 10,
  210. "deliveryDate": "2019-06-03 17:39:23",
  211. "stockDate": "2019-06-03 17:44:49",
  212. "totalDeclarePrice": 120,
  213. "itemCodeNum": "2",
  214. "totalItemQty": 4,
  215. "fistLegPrice": null,
  216. "sellerNo": "AutoStandard air 222222",
  217. "sellerId": null,
  218. "buyerId": null,
  219. "buyerCountry": null,
  220. "declareWeight": null,
  221. "mainDocumentNo": null,
  222. "onwardVoyageType": "Winit",
  223. "unit": "SZL",
  224. "postalCode": null,
  225. "firstDateAdded": null,
  226. "ascanDate": null,
  227. "warehouseEntryType": null,
  228. "wide": null,
  229. "high": null,
  230. "lenth": null,
  231. "masterBillNumber": null,
  232. "conversionRate": null,
  233. "trackingNo": null,
  234. "entryWhType": "SD"
  235. }
  236. ]
  237. }]
  238. }
  239. }