万邑通开发者网站 - 查询单据费用

API

查询单据费用

更新时间： 2019-07-09 18:16:19 访问次数：1279

接口说明

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

接口英文名称

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

请求示例

Json
XML

{
    "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	Array		查询结果
-\|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	当前页码，当前第几页

错误的返回结果：错误码，错误信息

返回示例

Json
XML

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

关键词

查询单据费用