API
查询派送费用
更新时间： 2019-08-26 19:25:36 访问次数：2905
接口说明
卖家或第三方通过该接口：使用出库订单号、跟踪号、卖家订单号、出库仓和下单日期查询出库订单的订单费用信息。
接口英文名称
sms.incomeSettlement.queryOutboundOrderFee
常用工具
使用场景
卖家或第三方使用该接口查询获得出库订单费用。
一般商务折扣体现在“最后一个公里尾程派送费”，当这个费用为负数是为商务折扣
备注
无
请求说明
| URL | http://openapi.winit.com.cn/openapi/service |
| 接口测试 | http://openapi.sandbox.winit.com.cn/openapi/service |
| 验证方法 | Token,md5 |
| 格式 | json |
| 字符编码 | UTF-8 |
| http请求方式 | http |
| 请求数限制 | 默认每分钟1000，有需要可申请加大。 |
请求入参
| 名称 | 类型 | 必填 | 说明 | 示例 |
|---|---|---|---|---|
| businessDocumentNo |
String() | N | 海外仓出库单号,在用户创建海外仓出库单后获得，唯一 | WO04875043 |
| sellerNo | String() | N | 卖家订单号 | |
| trackingNo | String() | N | 跟踪号/快递单号 | |
| destinationWarehouse | String() | N | 出库海外仓编码 | US0001 |
| orderDateFrom | String() | N | 下单起始日期(精确至日) | 2018-04-15 |
| orderDateTo | String() | N | 下单截止日期(精确至日) | |
| pageParams | Array | Y | 分页参数 | |
| -|pageSize | integer | Y | 每页显示数量，默认和最大200 | |
| -|pageNo | integer | Y | 页码，第几页，默认1 |
请求示例
{
"action":"sms.incomeSettlement.queryOutboundOrderFee",
"app_key":"rebecca",
"client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
"client_sign":"CF592BA57342089980EE97C87BE9BFAD",
"data":{
"businessDocumentNo":"WO0000004031",
"sellerNo":"",
"trackingNo":"",
"destinationWarehouse":"USWC Warehouse",
"orderDateFrom":"2019-08-01",
"orderDateTo":"2019-08-26",
"pageParams":{
"pageSize":"200",
"pageNo":"1"
}
},
"format":"json",
"language":"zh_CN",
"platform":"OWNERERP",
"sign":"6A481FBD09EE0FFCC02FA885B5F10EDC",
"sign_method":"md5",
"timestamp":"2015-06-16 00:19:26",
"version":"1.0"
}
返回出参
| 名称 | 类型 | 必填 | 说明 | 示例 |
|---|---|---|---|---|
| List | Array | Y | 查询结果，以下为子节点 | |
| -|businessDocumentNo |
String() | Y | 出库订单号 | WO04875043 |
| -|sellerNo |
String() | Y | 卖家订单号 | |
| -|trackingNo | String() | Y | 跟踪号/快递单号 | |
| -|destinationWarehouse | String() | Y | 出库海外仓 |
|
| -|productName | String() | Y | 尾程派送方式名称 |
Self Pick Service |
| -|productCode | String() | Y | 尾程派送方式代码 |
OSF1001214 |
| -|orderDate | String() | Y | 下单时间 |
2018-06-05 20:06:15 |
| -|incomeSettlementLineVos | Array | Y | 费用项,以下为子节点 | |
| -|-|isActive | String() | Y | 是否生效 | |
| -|-|chargeCode | String() | Y | 费用项编码 |
|
| -|-|chargeName | String() | Y | 费用项名称 | |
| -|-|sourceAmt | Number(,2) |
Y | 金额（原币） |
113.50,二位小数至百分位 |
| -|-|acctAmt | Number(,2) |
Y | 结算金额（结算币） |
|
| -|-|sourceCurrency | String() | Y | 币种（原币币种） |
|
| -|-|acctCurrency | String() | Y | 币种(结算币种) |
|
| -|-|exchangeRate | Number(,4) |
Y | 汇率（本币兑美元汇率） |
|
| -|-|dateAcct | String() | Y | 记账时间（精确至秒） |
|
| -|-|created | String() | Y | 交易时间（精确至秒） |
|
| -|-|createby | String() | Y | 交易创建者 |
|
| -|-|weight | Number |
Y | 重量（Kg） |
|
| -|-|volume | Number |
Y | 体积（m3） |
|
| -|-|volumeWeight | Number |
Y | 体积重（CBM） |
|
| -|-|chargeWeight | Number |
Y | 计费重（Kg） |
|
| -|-|description |
String() | Y | 备注 |
|
| pageParams |
Array |
Y | 分页，以下为子节点 |
|
| -|totalCount | Number |
Y | 记录总数 |
|
| -|currentPagesize | Number | Y | 当前每页记录数 |
|
| -|currentPageNo | Number | Y | 包裹计费重量，kg |
返回参数说明 正确的返回结果：查询成功。出库单费用详情。 错误的返回结果：错误码，错误信息
返回示例
1.正常出库单费用
{
"code": "0",
"msg": "操作成功",
"data": {
"pageParams": {
"currentPageSize": 200,
"totalCount": 1,
"currentPageNo": 1
},
"list": [ {
"id": null,
"orgId": null,
"isDelete": null,
"isActive": null,
"created": null,
"createdby": null,
"updated": null,
"updatedby": null,
"businessDocumentNo": "WO0000004031",
"orderDate": "2019-08-26 13:49:44",
"destinationWarehouse": "USWC Warehouse",
"sellerNo": "252727722489-1495123873511",
"trackingNo": "1Z68223Y0335397681",
"productCode": "OSF810757",
"productName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
"incomeSettlementLineVos": [
{
"id": 414444881,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-08-26 13:57:21",
"createdby": "system",
"updated": "2019-08-26 13:57:21",
"updatedby": "system",
"chargeCode": "1000010",
"chargeName": "海外仓最后一公里派送费",
"sourceAmt": -0.25,
"acctAmt": -0.25,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-08-26 13:52:23",
"weight": 0.025,
"volume": 4.5E-4,
"volumeWeight": null,
"chargeWeight": 8.36,
"description": null
},
{
"id": 414444882,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-08-26 13:57:21",
"createdby": "system",
"updated": "2019-08-26 13:57:21",
"updatedby": "system",
"chargeCode": "1000010",
"chargeName": "海外仓最后一公里派送费",
"sourceAmt": 8.36,
"acctAmt": 8.36,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-08-26 13:52:23",
"weight": 0.025,
"volume": 4.5E-4,
"volumeWeight": null,
"chargeWeight": 0.025,
"description": null
},
{
"id": 414444883,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-08-26 13:57:21",
"createdby": "system",
"updated": "2019-08-26 13:57:21",
"updatedby": "system",
"chargeCode": "1000914",
"chargeName": "出库处理费",
"sourceAmt": 0.05,
"acctAmt": 0.05,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-08-26 13:52:23",
"weight": 0.025,
"volume": 4.5E-4,
"volumeWeight": null,
"chargeWeight": 0.025,
"description": null
}
]
}]
}
}
2.含有商务折扣的示例
{
"code": "0",
"msg": "操作成功",
"data": {
"pageParams": {
"currentPageSize": 200,
"totalCount": 1,
"currentPageNo": 1
},
"list": [ {
"id": null,
"orgId": null,
"isDelete": null,
"isActive": null,
"created": null,
"createdby": null,
"updated": null,
"updatedby": null,
"businessDocumentNo": "WO0000000023",
"orderDate": "2019-07-03 09:42:39",
"destinationWarehouse": "USWC Warehouse",
"sellerNo": "echamp114-7300830-1651409",
"trackingNo": "788256512091",
"productCode": "OSF811002675",
"productName": "FedEx - Ground (Standard 1-5 Business Days)-USWC",
"incomeSettlementLineVos": [
{
"id": 446341708,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:35",
"createdby": "system",
"updated": "2019-07-04 08:00:39",
"updatedby": "system",
"chargeCode": "1000010",
"chargeName": "海外仓最后一公里派送费",
"sourceAmt": 47.26,
"acctAmt": 47.26,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": 50,
"description": null
},
{
"id": 446341717,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:36",
"createdby": "system",
"updated": "2019-07-04 08:00:39",
"updatedby": "system",
"chargeCode": "1000914",
"chargeName": "出库处理费",
"sourceAmt": 4.11,
"acctAmt": 4.11,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": 50,
"description": null
},
{
"id": 446341734,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:36",
"createdby": "system",
"updated": "2019-07-04 08:00:40",
"updatedby": "system",
"chargeCode": "1031252",
"chargeName": "超大尺寸附加费",
"sourceAmt": 22.5,
"acctAmt": 22.5,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": 50,
"description": null
},
{
"id": 446342547,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:35",
"createdby": "system",
"updated": "2019-07-04 08:00:39",
"updatedby": "system",
"chargeCode": "1000010",
"chargeName": "海外仓最后一公里派送费",
"sourceAmt": -1.42,
"acctAmt": -1.42,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": 47.26,
"description": null
},
{
"id": 446342550,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:35",
"createdby": "system",
"updated": "2019-07-04 08:00:39",
"updatedby": "system",
"chargeCode": "1000010",
"chargeName": "海外仓最后一公里派送费",
"sourceAmt": -13.23,
"acctAmt": -13.23,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": null,
"description": null
},
{
"id": 446342558,
"orgId": 1000000,
"isDelete": "N",
"isActive": "Y",
"created": "2019-07-04 08:00:36",
"createdby": "system",
"updated": "2019-07-04 08:00:39",
"updatedby": "system",
"chargeCode": "1003247",
"chargeName": "燃油附加费",
"sourceAmt": 4.89,
"acctAmt": 4.89,
"sourceCurrency": "USD",
"acctCurrency": "USD",
"exchangeRate": 1,
"dateAcct": "2019-07-04 07:49:46",
"weight": 50,
"volume": 0.1767435,
"volumeWeight": null,
"chargeWeight": null,
"description": null
}
]
}]
}
}
关键词
