API
查询费用-新
更新时间： 2020-10-22 19:55:06 访问次数：3212
接口说明
本接口可查询不同全部单据的费用
使用场景
所有已经计费的业务单据的费用
备注
请求说明
| URL | https://openapi.winit.com.cn/openapi/service |
| 接口测试 | https://sandboxopenapi.winit.com.cn/openapi/service |
| 接口名 | sms.incomeSettlement.pageChargeDetails |
| 版本 | 1.0 |
| 验证方法 | Token,md5 |
| 格式 | json |
| 字符编码 | UTF-8 |
| http请求方式 | http |
| 请求数限制 | 默认每分钟1000，有需要可申请加大。 |
请求入参
| 名称 | 类型 | 必填 | 说明 | 示例 |
| businessDocumentType | String() | N | 业务分类
ISP:ISP:订单费； EC_ISP:其它费用(ISP/小包）； OC:海外仓出库费用； EC:海外仓其它费用（包含LMA）； GTC:国际送仓费； FLC:入库费用； SC:仓储费； RHC:退货费用； VAS:增值服务费。 |
|
| businessDocumentNo | String() | O | 业务订单号
国际送仓单的WINIT订单号 海外仓出库单的WINIT订单号 海外仓入单的WINIT订单号 ISP小包中国出库WINIT订单号 businessDocumentNo 和（deducationTimeStart+deducationTimeEnd）二选一必填 | |
| deducationTimeStart | String() | O | 扣费开始日期
YYYY-MM-DD， 精确至日， 时间跨度不超过31天。 businessDocumentNo 和（deducationTimeStart+deducationTimeEnd）二选一必填 |
2020-09-01 |
| deducationTimeEnd | String() | O | 扣费截止日期 YYYY-MM-DD， 精确至日， 时间跨度不超过31天。 businessDocumentNo 和（deducationTimeStart+deducationTimeEnd）二选一必填 |
2020-10-01 |
| 分页参数pageParams | ||||
| pageSize | Integer | Y | 每页显示数量：
最大200，超出200，默认为200。 | 200 |
| pageNo | Integer | Y | 页码；
第几页，默认1。 | 1 |
请求示例
{
"action": "sms.incomeSettlement.pageChargeDetails",
"app_key": "rebecca",
"client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
"data": {
"businessDocumentNo": "WO0000004031",
"deducationTimeStart": "",
"deducationTimeEnd": "",
"businessDocumentType": "OC",
"pageParams": {
"pageNo": 1,
"pageSize": "100"
}
},
"format": "json",
"language": "zh_CN",
"platform": "OWNERERP",
"sign": "CDC79A524BB3A2ACAB065CF2C820BB9C",
"sign_method": "md5",
"timestamp": "2019-10-24 17:32:58",
"version": "1.0",
"client_sign": "E3DC2D322810D343657FE393D7C2A1E1"
}
返回出参
| 名称 | 类型 | 必填 | 说明 | 示例 |
| 分页参数pageParams | ||||
| totalCount | Integer | Y | 记录总数 | |
| 业务单据号的总数量 | ||||
| currentPagesize | Integer | Y | 当前每页记录数 | |
| currentPageNo | Integer | Y | 当前页码，当前第几页 | |
| 查询结果list | ||||
| id | NUMBER | Y | 结算单明细ID | |
| created | DATE | Y | 创建时间 | |
| updated | DATE | Y | 更新时间 | |
| documentNo | VARCHAR2 | Y | 业务交易号 | |
| businessDocumentNo | VARCHAR2 | Y | 订单号 | |
| chargeCode | VARCHAR2 | Y | 费用编码 | |
| chargeName | VARCHAR2 | Y | 费用名称 | |
| transactionType | VARCHAR2 | Y | 优惠类型
1000383：消费； 1000381：winit返利； 1000389：商务折扣； 1000390：礼品卡抵扣； 1000391：优惠券抵扣。 | |
| sourceAmt | NUMBER | Y | 原币金额 | |
| sourceCurrency | VARCHAR2 | Y | 原币币种 | |
| partnerCode | VARCHAR2 | Y | 客户编码 | |
| partnerName | VARCHAR2 | Y | 客户名称 | |
| orderDate | DATE | Y | 下单日期 | |
| chargeDate | DATE | Y | 计费日期 | |
| dateAcct | DATE | Y | 记账日期 | |
| productLine | VARCHAR2 | Y | 扣费钱包 OWHS：海外仓账户 ISP：ISP账户 | |
| deducationTime | TIMESTAMP | Y | 扣费时间 | |
| logisticsDist | VARCHAR2 | N | 物流分区 | |
| warehouseCode | VARCHAR2 | N | 仓库编码 | |
| warehouse | VARCHAR2 | N | 仓库 | |
| warehouseValue | VARCHAR2 | N | 验货/始发仓库编码 | |
| originatingWarehouse | VARCHAR2 | N | 验货/始发仓库 | |
| warehousetoValue | VARCHAR2 | N | 目的仓库编码 | |
| destinationWarehouse | VARCHAR2 | N | 目的仓库 | |
| transType | VARCHAR2 | N | WINIT产品 | |
| weight | NUMBER | N | 重量（KG） | |
| volume | NUMBER | N | 体积（CBM） | |
| volumeWeight | NUMBER | N | 体积重(KG) | |
| chargeWeight | NUMBER | N | 计费重（KG/CBM） | |
| deliveryDate | DATE | N | 提货/验货完成日期 | |
| stockDate | DATE | N | 海外仓入库完成日期/出库日期/退货完成日期 | |
| totalDeclarePrice | NUMBER | N | 申报价值(USD) | |
| itemCodeNum | VARCHAR2 | N | 单品编码及数量 | |
| totalItemQty | NUMBER | N | 单品总数量 | |
| fistLegPrice | NUMBER | N | 头程运费单价(USD) | |
| sellerNo | VARCHAR2 | N | 卖家订单号 | |
| sellerId | VARCHAR2 | N | 卖家ID | |
| buyerId | VARCHAR2 | N | 买家ID | |
| buyerCountry | VARCHAR2 | N | 买家国家 | |
| declareWeight | NUMBER | N | 申报重量 | |
| mainDocumentNo | VARCHAR2 | N | 主单号/出库单号(退货单用) | |
| onwardVoyageType | VARCHAR2 | N | 头程类型 Winit:标准 Direct:直发 | |
| unit | VARCHAR2 | N | 计费单位/计费类型 | |
| postalCode | VARCHAR2 | N | 邮编 | |
| firstDateAdded | DATE | N | 首次上架日期 | |
| ascanDate | DATE | N | Ascan揽收时间 | |
| warehouseEntryType | VARCHAR2 | N | 入库方式 | |
| wide | NUMBER | N | 宽 | |
| high | NUMBER | N | 高 | |
| lenth | NUMBER | N | 长 | |
| trackingNo | VARCHAR2 | N | 出库单快递单号/包裹跟踪号 | |
| packageNo | VARCHAR2 | N | 包裹号 | |
| buyerCountryName | VARCHAR2 | N | 买家国家名称 | |
| description | VARCHAR2 | N | 备注 | |
| inspection_type | VARCHAR2 | N | 验货方式 | |
| inventory_type | VARCHAR2 | N | 库存类型 2B:2B； 2C:2C。 |
返回参数说明 正确的返回结果：出库单号，出库单状态。 错误的返回结果：错误码，错误信息
返回示例
{
"code": "0",
"msg": "操作成功",
"data": {
"pageParams": {
"currentPageSize": 100,
"totalCount": 3,
"currentPageNo": 1
},
"list": [
{
"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": "出库处理费",
"documentNo": "062c8a28-de4a-4eb6-a762-d1e94e7c4179",
"businessDocumentNo": "WO0000004031",
"sourceAmt": 0.05,
"sourceCurrency": "USD",
"acctAmt": 0.05,
"acctCurrency": "USD",
"exchangeRate": 1,
"conversionTypeCode": "114",
"incomeSettlementId": 440828301,
"revenueAdjustLineId": null,
"invoicelineId": 611061537,
"isFeeDeducation": "Y",
"docType": "1000810",
"partnerCode": "1000019",
"dateAcct": "2019-08-26 13:52:23",
"isAdjust": "N",
"isRebate": "N",
"chargeValue": "102",
"exchangeDate": "2019-08-26 13:52:23",
"warehouse": null,
"warehouseCode": null,
"productLine": "OWHS",
"arrearsAmt": null,
"isInvoice": "Y",
"logisticsDist": "USWC Warehouse",
"accountCurrency": null,
"settlementAmount": null,
"isUsedCoupon": "N",
"ispIsEbayRebate": "Y",
"isConformGift": "N",
"productCode": "OSF810757",
"qty": null,
"transactionType": null,
"priceVersion": "3850",
"partnerName": "万邑通质量保证部测试账号1-TEST",
"orderDate": "2019-08-26 13:49:44",
"originatingWarehouse": null,
"destinationWarehouse": "USWC Warehouse",
"transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
"weight": 0.025,
"volume": 0.00045,
"volumeWeight": null,
"chargeWeight": 0.025,
"deliveryDate": "2019-08-26 13:52:23",
"stockDate": "2019-08-26 13:52:23",
"totalDeclarePrice": null,
"itemCodeNum": "auto_sku22*1",
"totalItemQty": 1,
"fistLegPrice": null,
"sellerNo": "252727722489-1495123873511",
"sellerId": null,
"buyerId": null,
"buyerCountry": null,
"declareWeight": null,
"mainDocumentNo": null,
"onwardVoyageType": null,
"unit": "SZL",
"postalCode": "91436-3631",
"firstDateAdded": null,
"ascanDate": null,
"warehouseEntryType": null,
"wide": null,
"high": null,
"lenth": null,
"masterBillNumber": null,
"conversionRate": null,
"trackingNo": "1Z68223Y0335397681",
"entryWhType": "OSF81",
"chargeDate": null,
"businessType": null,
"packageNo": "WO0000004031A",
"buyerCountryName": null,
"deducationTime": "2019-08-26 13:57:21",
"description": null,
"isRecalculation": null,
"recalculationCode": null,
"recalculationName": null,
"warehouseValue": null,
"warehousetoValue": 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": "海外仓最后一公里派送费",
"documentNo": "1661a8f2-3094-4a88-b3fd-78f055fc5907",
"businessDocumentNo": "WO0000004031",
"sourceAmt": 8.36,
"sourceCurrency": "USD",
"acctAmt": 8.36,
"acctCurrency": "USD",
"exchangeRate": 1,
"conversionTypeCode": "114",
"incomeSettlementId": 440828300,
"revenueAdjustLineId": null,
"invoicelineId": 611061536,
"isFeeDeducation": "Y",
"docType": "1000810",
"partnerCode": "1000019",
"dateAcct": "2019-08-26 13:52:23",
"isAdjust": "N",
"isRebate": "N",
"chargeValue": "103",
"exchangeDate": "2019-08-26 13:52:23",
"warehouse": null,
"warehouseCode": null,
"productLine": "OWHS",
"arrearsAmt": null,
"isInvoice": "Y",
"logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
"accountCurrency": null,
"settlementAmount": null,
"isUsedCoupon": "N",
"ispIsEbayRebate": "Y",
"isConformGift": "N",
"productCode": "OSF810757",
"qty": null,
"transactionType": null,
"priceVersion": "33158",
"partnerName": "万邑通质量保证部测试账号1-TEST",
"orderDate": "2019-08-26 13:49:44",
"originatingWarehouse": null,
"destinationWarehouse": "USWC Warehouse",
"transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
"weight": 0.025,
"volume": 0.00045,
"volumeWeight": null,
"chargeWeight": 0.025,
"deliveryDate": "2019-08-26 13:52:23",
"stockDate": "2019-08-26 13:52:23",
"totalDeclarePrice": null,
"itemCodeNum": "auto_sku22*1",
"totalItemQty": 1,
"fistLegPrice": null,
"sellerNo": "252727722489-1495123873511",
"sellerId": null,
"buyerId": null,
"buyerCountry": null,
"declareWeight": null,
"mainDocumentNo": null,
"onwardVoyageType": null,
"unit": "ZL",
"postalCode": "91436-3631",
"firstDateAdded": null,
"ascanDate": null,
"warehouseEntryType": null,
"wide": null,
"high": null,
"lenth": null,
"masterBillNumber": null,
"conversionRate": null,
"trackingNo": "1Z68223Y0335397681",
"entryWhType": "OSF81",
"chargeDate": null,
"businessType": null,
"packageNo": "WO0000004031A",
"buyerCountryName": null,
"deducationTime": "2019-08-26 13:57:21",
"description": null,
"isRecalculation": null,
"recalculationCode": null,
"recalculationName": null,
"warehouseValue": null,
"warehousetoValue": null
},
{
"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": "海外仓最后一公里派送费",
"documentNo": "a4c04fe7-dc14-4a4d-a172-6d741501944b",
"businessDocumentNo": "WO0000004031",
"sourceAmt": -0.25,
"sourceCurrency": "USD",
"acctAmt": -0.25,
"acctCurrency": "USD",
"exchangeRate": 1,
"conversionTypeCode": "114",
"incomeSettlementId": 440828299,
"revenueAdjustLineId": null,
"invoicelineId": 611061535,
"isFeeDeducation": "Y",
"docType": "1000810",
"partnerCode": "1000019",
"dateAcct": "2019-08-26 13:52:23",
"isAdjust": "N",
"isRebate": "N",
"chargeValue": "103",
"exchangeDate": "2019-08-26 13:52:23",
"warehouse": null,
"warehouseCode": null,
"productLine": "OWHS",
"arrearsAmt": null,
"isInvoice": "Y",
"logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
"accountCurrency": null,
"settlementAmount": null,
"isUsedCoupon": "N",
"ispIsEbayRebate": "Y",
"isConformGift": "N",
"productCode": "OSF810757",
"qty": null,
"transactionType": "1000381",
"priceVersion": "33158",
"partnerName": "万邑通质量保证部测试账号1-TEST",
"orderDate": "2019-08-26 13:49:44",
"originatingWarehouse": null,
"destinationWarehouse": "USWC Warehouse",
"transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
"weight": 0.025,
"volume": 0.00045,
"volumeWeight": null,
"chargeWeight": 8.36,
"deliveryDate": "2019-08-26 13:52:23",
"stockDate": "2019-08-26 13:52:23",
"totalDeclarePrice": null,
"itemCodeNum": "auto_sku22*1",
"totalItemQty": 1,
"fistLegPrice": null,
"sellerNo": "252727722489-1495123873511",
"sellerId": null,
"buyerId": null,
"buyerCountry": null,
"declareWeight": null,
"mainDocumentNo": null,
"onwardVoyageType": null,
"unit": "ZL",
"postalCode": "91436-3631",
"firstDateAdded": null,
"ascanDate": null,
"warehouseEntryType": null,
"wide": null,
"high": null,
"lenth": null,
"masterBillNumber": null,
"conversionRate": null,
"trackingNo": "1Z68223Y0335397681",
"entryWhType": "OSF81",
"chargeDate": null,
"businessType": null,
"packageNo": "WO0000004031A",
"buyerCountryName": null,
"deducationTime": "2019-08-26 13:57:21",
"description": null,
"isRecalculation": null,
"recalculationCode": null,
"recalculationName": null,
"warehouseValue": null,
"warehousetoValue": null
}
]
}
}
关键词
