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

卖家或第三方通过该接口:业务分类、订单号、交易日期查询退货单费用

接口英文名称

sms.incomeSettlement.getTransactionCharge

业务分类如下:

  • ISP:ISP订单费
  • EC_ISP:其它费用(ISP/小包)
  • OC:海外仓出库费用
  • EC:其它费用(海外仓出库)
  • GTC:国际送仓费
  • FLC:入库费用
  • SC:仓储费
  • RHC:退货费用
  • VAS:增值服务费

使用场景

卖家或第三方使用该接口查询获得单据费用(单据:国际送仓WINIT订单号,海外仓出库WINIT订单号,海外仓入库WINIT订单号,ISP小包出口WINIT订单号)
该接口对应的页面是:卖家登录的万邑联,进入万邑联-我的钱包-我的账户-账户交易明细,查询的结果与该页面一致。

备注

请求说明
URL http://openapi.winit.com.cn/openapi/service
接口测试 http://openapi.sandbox.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
Array 分页参数
--| 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"
}

                            
返回出参
名称 类型 必填 说明 示例
listArray
查询结果
-|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
-|incomeSettlementLineVos Array
费用项
-|-|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
Array
分页参数

-|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
               }
            ]
         }
      ]
   }
}                          

                            
关键词