API
查询费用-新
更新时间: 2020-10-22 19:55:06 访问次数:4051
接口说明
本接口可查询不同全部单据的费用
使用场景
所有已经计费的业务单据的费用
备注
请求说明
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 } ] } }
关键词