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

接口说明

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

使用场景

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

接口名称

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. }
关键词