查询派送费用
更新时间: 2024-07-03 10:17:49 访问次数:12193
接口说明
卖家或第三方通过该接口:使用出库订单号、跟踪号、卖家订单号、出库仓和下单日期查询出库订单的订单费用信息。
接口名称
sms.incomeSettlement.queryOutboundOrderFee
请求说明
请求内容 | 说明 |
---|---|
URL | https://openapi.winit.com.cn/openapi/service |
接口测试 | https://sandboxopenapi.winit.com.cn/openapi/service |
验证方法 | Token,md5 |
格式 | json |
字符编码 | UTF-8 |
http请求方式 | http |
请求数限制 | 默认每分钟1000,1000有需要可申请加大。 |
请求入参
名称 | 类型 | 必填 | 说明 | 示例 |
---|---|---|---|---|
businessDocumentNo | String() | N | 海外仓出库单号 在用户创建海外仓出库单后获得,唯一 |
WO04875043 |
sellerNo | String() | N | 卖家订单号 | |
trackingNo | String() | N | 跟踪号/快递单号 | |
destinationWarehouse | String() | N | 出库海外仓编码 | US0001 |
orderDateFrom | String() | N | 下单起始日期(精确至日) | 2019-08-01 |
orderDateTo | String() | N | 下单截止日期(精确至日) | 2019-08-26 |
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"
}
返回出参
返回参数说明:正确的返回编码code:0及结果data,错误的返回错误码及错误信息msg。
名称 | 类型 | 必传 | 说明 | 示例 |
---|---|---|---|---|
List | Object | Y | 查询结果list | |
-|businessDocumentNo | String() | Y | 出库订单号 | |
-|sellerNo | String() | Y | 卖家订单号 | |
-|trackingNo | String() | Y | 跟踪号/快递单号 | |
-|destinationWarehouse | String() | Y | 出库海外仓 | |
-|productName | String() | Y | 尾程派送方式名称 | |
-|productCode | String() | Y | 尾程派送方式代码 | |
-|orderDate | String() | Y | 下单时间 | |
-|incomeSettlementLineVos | Array | Y | 费用明细 | |
-|-|isActive | String() | Y | 是否生效 | |
-|-|chargeCode | String() | Y | 费用项编码 | |
-|-|chargeName | String() | Y | 费用项名称 | |
-|-|sourceAmt | Number(,2) | Y | 金额(原币) | |
-|-|sourceCurrency | String() | Y | 币种(原币币种) | |
-|-|acctAmt | Number(,2) | 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 | Object | Y | 分页 | |
-|totalCount | Number | Y | 记录总数 | |
-|currentPagesize | Number | Y | 当前每页记录数 | |
-|currentPageNo | Number | Y | 当前页码 |
返回示例
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
}
]
}]
}
}
关键词