API
查询费用-新
更新时间: 2020-10-22 19:55:06 访问次数:3212
Document
接口说明

本接口可查询不同全部单据的费用

使用场景
所有已经计费的业务单据的费用
备注
请求说明
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:增值服务费。
businessDocumentNoString()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
pageSizeIntegerY每页显示数量:
最大200,超出200,默认为200。
200
pageNoIntegerY页码;
第几页,默认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
totalCountIntegerY记录总数
业务单据号的总数量
currentPagesizeIntegerY当前每页记录数
currentPageNoIntegerY当前页码,当前第几页
查询结果list
idNUMBERY结算单明细ID
createdDATEY创建时间
updatedDATEY更新时间
documentNoVARCHAR2Y业务交易号
businessDocumentNoVARCHAR2Y订单号
chargeCodeVARCHAR2Y费用编码
chargeNameVARCHAR2Y费用名称
transactionTypeVARCHAR2Y优惠类型
1000383:消费;
1000381:winit返利;
1000389:商务折扣;
1000390:礼品卡抵扣;
1000391:优惠券抵扣。
sourceAmtNUMBERY原币金额
sourceCurrencyVARCHAR2Y原币币种
partnerCodeVARCHAR2Y客户编码
partnerNameVARCHAR2Y客户名称
orderDateDATEY下单日期
chargeDateDATEY计费日期
dateAcctDATEY记账日期
productLineVARCHAR2Y扣费钱包
OWHS:海外仓账户
ISP:ISP账户
deducationTimeTIMESTAMPY扣费时间
logisticsDistVARCHAR2N物流分区
warehouseCodeVARCHAR2N仓库编码
warehouseVARCHAR2N仓库
warehouseValueVARCHAR2N验货/始发仓库编码
originatingWarehouseVARCHAR2N验货/始发仓库
warehousetoValueVARCHAR2N目的仓库编码
destinationWarehouseVARCHAR2N目的仓库
transTypeVARCHAR2NWINIT产品
weightNUMBERN重量(KG)
volumeNUMBERN体积(CBM)
volumeWeightNUMBERN体积重(KG)
chargeWeightNUMBERN计费重(KG/CBM)
deliveryDateDATEN提货/验货完成日期
stockDateDATEN海外仓入库完成日期/出库日期/退货完成日期
totalDeclarePriceNUMBERN申报价值(USD)
itemCodeNumVARCHAR2N单品编码及数量
totalItemQtyNUMBERN单品总数量
fistLegPriceNUMBERN头程运费单价(USD)
sellerNoVARCHAR2N卖家订单号
sellerIdVARCHAR2N卖家ID
buyerIdVARCHAR2N买家ID
buyerCountryVARCHAR2N买家国家
declareWeightNUMBERN申报重量
mainDocumentNoVARCHAR2N主单号/出库单号(退货单用)
onwardVoyageTypeVARCHAR2N头程类型 Winit:标准 Direct:直发
unitVARCHAR2N计费单位/计费类型
postalCodeVARCHAR2N邮编
firstDateAddedDATEN首次上架日期
ascanDateDATENAscan揽收时间
warehouseEntryTypeVARCHAR2N入库方式
wideNUMBERN
highNUMBERN
lenthNUMBERN
trackingNoVARCHAR2N出库单快递单号/包裹跟踪号
packageNoVARCHAR2N包裹号
buyerCountryNameVARCHAR2N买家国家名称
descriptionVARCHAR2N备注
inspection_typeVARCHAR2N验货方式
inventory_typeVARCHAR2N库存类型
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
            }
        ]
    }
}


 
     
关键词