API
查询单据费用
更新时间: 2019-07-09 18:16:19 访问次数:6081
接口说明

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

使用场景

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

请求说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
接口名sms.incomeSettlement.getTransactionCharge
版本1.0
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟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
 pageSize Integer Y 每页显示数量
最大200,超出200,默认为200
200
pageNo Integer Y 页码
第几页,默认1
1
请求示例
{
    "action":"sms.incomeSettlement.getTransactionCharge",
    "app_key":"rebecca",
 "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
"client_sign":"9BB061E77B4A6C5C387872B260540CF6",
    "data":{
        "businessDocumentType":"OC",
        "businessDocumentNo":"",
        "tradeDateFrom":"2019-06-09",
        "tradeDateTo":"2019-07-09",
        "pageParams":{
            "pageSize":"200",
            "pageNo":"1"
        }
    },
    "format":"json",
    "language":"zh_CN",
    "platform":"OWNERERP",
    "sign":"A89BEACF3F88624EBF94AF8B94BB7B0F",
    "sign_method":"md5",
    "timestamp":"2019-01-01 00:19:26",
    "version":"1.0"
}

                            
返回出参
名称 类型 必填 说明 示例
查询结果list
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
费用项Lis.incomeSettlementLineVos
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)

计费重量
单位:KG

volume
Number(9.6)

核实体积
单位:CBM

volumeWeight
Number(6.3)

体积重
单位:KG

description
String() Y 描述

分页参数pageParams
totalCount Integer
Y 记录总数
业务单据号的总数量

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

错误的返回结果:错误码,错误信息

返回示例
{
   "code": "0",
   "msg": "操作成功",
   "data":    {
      "pageParams":       {
         "currentPageSize": 200,
         "totalCount": 4,
         "currentPageNo": 1
      },
      "list":       [
                  {
            "businessDocumentNo": "WO0000001800",
            "referenceOrderNo": null,
            "sellerOrderNo": "252727722489-1495123873511",
            "trackingNo": "1Z68223Y0334901360",
            "winitServiceCode": "OSF810757",
            "warehouseName": "USWC Warehouse",
            "fulfillmentDate": "2019-06-10 18:41:20",
            "orderDate": "2019-06-10 18:38:28",
            "queryTransactionChargeLineVos":             [
                              {
                  "transactionNo": "596e2933-0244-4676-9866-27ccf66e0fe9",
                  "chargeCode": "1000914",
                  "chargeName": "出库处理费",
                  "sourceAmt": -0.05,
                  "acctAmt": -0.05,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-10 18:41:20",
                  "tradeDate": "2019-06-10 18:45:16",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "23ee069b-0800-447c-9c57-93c89f72acad",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": 0.25,
                  "acctAmt": 0.25,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-10 18:41:20",
                  "tradeDate": "2019-06-10 18:45:16",
                  "weight": 0.025,
                  "chargeWeight": 8.36,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "40203890-a395-405e-8cbf-8804b8ef603c",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": -8.36,
                  "acctAmt": -8.36,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-10 18:41:20",
                  "tradeDate": "2019-06-10 18:45:16",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               }
            ]
         },
                  {
            "businessDocumentNo": "WO0000001828",
            "referenceOrderNo": null,
            "sellerOrderNo": "252727722489-1495123873511",
            "trackingNo": "1Z68223Y0302762561",
            "winitServiceCode": "OSF810757",
            "warehouseName": "USWC Warehouse",
            "fulfillmentDate": "2019-06-11 11:59:05",
            "orderDate": "2019-06-11 11:56:44",
            "queryTransactionChargeLineVos":             [
                              {
                  "transactionNo": "7267ff46-754f-45f3-b78f-c4e2799d590f",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": 0.25,
                  "acctAmt": 0.25,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-11 11:59:05",
                  "tradeDate": "2019-06-11 12:03:49",
                  "weight": 0.025,
                  "chargeWeight": 8.36,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "0340110d-e797-41b2-95f1-4031380568ce",
                  "chargeCode": "1000914",
                  "chargeName": "出库处理费",
                  "sourceAmt": -0.05,
                  "acctAmt": -0.05,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-11 11:59:05",
                  "tradeDate": "2019-06-11 12:03:49",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "2e43927a-abae-468a-a774-89c1865db36e",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": -8.36,
                  "acctAmt": -8.36,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-11 11:59:05",
                  "tradeDate": "2019-06-11 12:03:49",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               }
            ]
         },
                  {
            "businessDocumentNo": "WO0000001937",
            "referenceOrderNo": null,
            "sellerOrderNo": "252727722489-1495123873511",
            "trackingNo": "9205590134519202581136",
            "winitServiceCode": "OSF810757",
            "warehouseName": "USWC Warehouse",
            "fulfillmentDate": "2019-06-17 16:49:36",
            "orderDate": "2019-06-17 16:47:58",
            "queryTransactionChargeLineVos":             [
                              {
                  "transactionNo": "9de11b3b-b2e8-4ca8-837e-b999446b26f8",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": -8.36,
                  "acctAmt": -8.36,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-17 16:49:36",
                  "tradeDate": "2019-06-17 16:51:30",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "5b37a583-a18c-4564-b2b3-a2daa1392eef",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": 0.25,
                  "acctAmt": 0.25,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-17 16:49:36",
                  "tradeDate": "2019-06-17 16:51:30",
                  "weight": 0.025,
                  "chargeWeight": 8.36,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "1c8825b3-11d9-4086-a35d-f2af415e3268",
                  "chargeCode": "1000914",
                  "chargeName": "出库处理费",
                  "sourceAmt": -0.05,
                  "acctAmt": -0.05,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-06-17 16:49:36",
                  "tradeDate": "2019-06-17 16:51:30",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               }
            ]
         },
                  {
            "businessDocumentNo": "WO0000002263",
            "referenceOrderNo": null,
            "sellerOrderNo": "252727722489-1495123873511",
            "trackingNo": "1Z68223Y0332929576",
            "winitServiceCode": "OSF810757",
            "warehouseName": "USWC Warehouse",
            "fulfillmentDate": "2019-07-01 15:59:34",
            "orderDate": "2019-07-01 15:57:19",
            "queryTransactionChargeLineVos":             [
                              {
                  "transactionNo": "d81b955d-a095-4d96-b5ed-f56573ffff24",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": -8.36,
                  "acctAmt": -8.36,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-07-01 15:59:34",
                  "tradeDate": "2019-07-01 16:03:11",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "dfab5424-7ac4-45ab-977f-3aa1c5e3fd5c",
                  "chargeCode": "1000914",
                  "chargeName": "出库处理费",
                  "sourceAmt": -0.05,
                  "acctAmt": -0.05,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-07-01 15:59:34",
                  "tradeDate": "2019-07-01 16:03:11",
                  "weight": 0.025,
                  "chargeWeight": 0.025,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               },
                              {
                  "transactionNo": "5af353e1-b758-4da8-9538-5f730fab20c7",
                  "chargeCode": "1000010",
                  "chargeName": "海外仓最后一公里派送费",
                  "sourceAmt": 0.25,
                  "acctAmt": 0.25,
                  "sourceCurrency": "USD",
                  "acctCurrency": "USD",
                  "exchangeRate": 1,
                  "dateAcct": "2019-07-01 15:59:34",
                  "tradeDate": "2019-07-01 16:03:11",
                  "weight": 0.025,
                  "chargeWeight": 8.36,
                  "volume": 4.5E-4,
                  "volumeWeight": null,
                  "description": null
               }
            ]
         }
      ]
   }
}                          

                            
关键词