API
查询费用-新
更新时间： 2024-11-08 15:37:48 访问次数：9967

接口说明

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

使用场景

所有已经计费的业务单据的费用

接口名称

sms.incomeSettlement.pageChargeDetails

请求说明

请求内容 说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000，1000有需要可申请加大。

请求入参

名称 类型 必填 说明 示例
businessDocumentType String() N 业务分类
ISP：ISP订单费
EC_ISP：其它费用（ISP/小包)
OC：海外仓出库费用
EC：海外仓其它费用（包含LMA）
GTC：国际送仓费
FLC:：入库费用
SC：仓储费
RHC：退货费用
VAS：增值服务费		 OC
businessDocumentNo String() O 业务订单号
国际送仓单的WINIT订单号
海外仓出库单的WINIT订单号
海外仓入库单的WINIT订单号
ISP小包中国出库WINIT订单号
businessDocumentNo 和（deducationTimeStart+deducationTimeEnd）二选一必填
deducationTimeStart String() O 扣费开始日期
YYYY-MM-DD ，精确至日
时间跨度不超过2天		 2020-09-01
deducationTimeEnd String() O 扣费截止日期
YYYY-MM-DD ，精确至日
时间跨度不超过2天		 2020-09-01
pageParams Object Y 分页参数
pageSize Integer Y 每页显示数量
最大200，超出200，默认为200		 200
pageNo Integer Y 页码
第几页，默认1		 1

请求示例

  1. {
  2.     "action": "sms.incomeSettlement.pageChargeDetails",
  3.     "app_key": "rebecca",
  4.     "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.     "data": {
  6.         "businessDocumentNo": "WO0000004031",
  7.         "deducationTimeStart": "",
  8.         "deducationTimeEnd": "",
  9.         "businessDocumentType": "OC",
  10.         "pageParams": {
  11.             "pageNo": 1,
  12.             "pageSize": "100"
  13.         }
  14.     },
  15.     "format": "json",
  16.     "language": "zh_CN",
  17.     "platform": "OWNERERP",
  18.     "sign": "CDC79A524BB3A2ACAB065CF2C820BB9C",
  19.     "sign_method": "md5",
  20.     "timestamp": "2019-10-24 17:32:58",
  21.     "version": "1.0",
  22.     "client_sign": "E3DC2D322810D343657FE393D7C2A1E1"
  23. }

返回出参

返回参数说明：正确的返回编码code：0及结果data，错误的返回错误码及错误信息msg。

名称 类型 必传 说明 示例
list Array Y 查询结果
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：优惠券抵扣。
fundsDirection VARCHAR2 Y 资金方向
1：收入
2：支出
exchangeRate NUMBER Y 结算汇率
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/2C		 2B
pageParams Object Y 分页参数
totalCount Integer Y 记录总数
业务单据号的总数量
currentPagesize Integer Y 当前每页记录数
currentPageNo Integer Y 当前页码，当前第几页

返回示例

  1. {
  2.     "code": "0",
  3.     "msg": "操作成功",
  4.     "data": {
  5.         "pageParams": {
  6.             "currentPageSize": 100,
  7.             "totalCount": 3,
  8.             "currentPageNo": 1
  9.         },
  10.         "list": [
  11.             {
  12.                 "id": 414444883,
  13.                 "orgId": 1000000,
  14.                 "isDelete": "N",
  15.                 "isActive": "Y",
  16.                 "created": "2019-08-26 13:57:21",
  17.                 "createdby": "system",
  18.                 "updated": "2019-08-26 13:57:21",
  19.                 "updatedby": "system",
  20.                 "chargeCode": "1000914",
  21.                 "chargeName": "出库处理费",
  22.                 "documentNo": "062c8a28-de4a-4eb6-a762-d1e94e7c4179",
  23.                 "businessDocumentNo": "WO0000004031",
  24.                 "sourceAmt": 0.05,
  25.                 "sourceCurrency": "USD",
  26.                 "acctAmt": 0.05,
  27.                 "acctCurrency": "USD",
  28.                 "exchangeRate": 1,
  29.                 "conversionTypeCode": "114",
  30.                 "incomeSettlementId": 440828301,
  31.                 "revenueAdjustLineId": null,
  32.                 "invoicelineId": 611061537,
  33.                 "isFeeDeducation": "Y",
  34.                 "docType": "1000810",
  35.                 "partnerCode": "1000019",
  36.                 "dateAcct": "2019-08-26 13:52:23",
  37.                 "isAdjust": "N",
  38.                 "isRebate": "N",
  39.                 "chargeValue": "102",
  40.                 "exchangeDate": "2019-08-26 13:52:23",
  41.                 "warehouse": null,
  42.                 "warehouseCode": null,
  43.                 "productLine": "OWHS",
  44.                 "arrearsAmt": null,
  45.                 "isInvoice": "Y",
  46.                 "logisticsDist": "USWC Warehouse",
  47.                 "accountCurrency": null,
  48.                 "settlementAmount": null,
  49.                 "isUsedCoupon": "N",
  50.                 "ispIsEbayRebate": "Y",
  51.                 "isConformGift": "N",
  52.                 "productCode": "OSF810757",
  53.                 "qty": null,
  54.                 "transactionType": "1000383",
  55.                 "priceVersion": "3850",
  56.                 "partnerName": "万邑通质量保证部测试账号1-TEST",
  57.                 "orderDate": "2019-08-26 13:49:44",
  58.                 "originatingWarehouse": null,
  59.                 "destinationWarehouse": "USWC Warehouse",
  60.                 "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  61.                 "weight": 0.025,
  62.                 "volume": 0.00045,
  63.                 "volumeWeight": null,
  64.                 "chargeWeight": 0.025,
  65.                 "deliveryDate": "2019-08-26 13:52:23",
  66.                 "stockDate": "2019-08-26 13:52:23",
  67.                 "totalDeclarePrice": null,
  68.                 "itemCodeNum": "auto_sku22*1",
  69.                 "totalItemQty": 1,
  70.                 "fistLegPrice": null,
  71.                 "sellerNo": "252727722489-1495123873511",
  72.                 "sellerId": null,
  73.                 "buyerId": null,
  74.                 "buyerCountry": null,
  75.                 "declareWeight": null,
  76.                 "mainDocumentNo": null,
  77.                 "onwardVoyageType": null,
  78.                 "unit": "SZL",
  79.                 "postalCode": "91436-3631",
  80.                 "firstDateAdded": null,
  81.                 "ascanDate": null,
  82.                 "warehouseEntryType": null,
  83.                 "wide": null,
  84.                 "high": null,
  85.                 "lenth": null,
  86.                 "masterBillNumber": null,
  87.                 "conversionRate": null,
  88.                 "trackingNo": "1Z68223Y0335397681",
  89.                 "entryWhType": "OSF81",
  90.                 "chargeDate": null,
  91.                 "businessType": null,
  92.                 "packageNo": "WO0000004031A",
  93.                 "buyerCountryName": null,
  94.                 "deducationTime": "2019-08-26 13:57:21",
  95.                 "description": null,
  96.                 "isRecalculation": null,
  97.                 "recalculationCode": null,
  98.                 "recalculationName": null,
  99.                 "warehouseValue": null,
  100.                 "warehousetoValue": null
  101.             },
  102.             {
  103.                 "id": 414444882,
  104.                 "orgId": 1000000,
  105.                 "isDelete": "N",
  106.                 "isActive": "Y",
  107.                 "created": "2019-08-26 13:57:21",
  108.                 "createdby": "system",
  109.                 "updated": "2019-08-26 13:57:21",
  110.                 "updatedby": "system",
  111.                 "chargeCode": "1000010",
  112.                 "chargeName": "海外仓最后一公里派送费",
  113.                 "documentNo": "1661a8f2-3094-4a88-b3fd-78f055fc5907",
  114.                 "businessDocumentNo": "WO0000004031",
  115.                 "sourceAmt": 8.36,
  116.                 "sourceCurrency": "USD",
  117.                 "acctAmt": 8.36,
  118.                 "acctCurrency": "USD",
  119.                 "exchangeRate": 1,
  120.                 "conversionTypeCode": "114",
  121.                 "incomeSettlementId": 440828300,
  122.                 "revenueAdjustLineId": null,
  123.                 "invoicelineId": 611061536,
  124.                 "isFeeDeducation": "Y",
  125.                 "docType": "1000810",
  126.                 "partnerCode": "1000019",
  127.                 "dateAcct": "2019-08-26 13:52:23",
  128.                 "isAdjust": "N",
  129.                 "isRebate": "N",
  130.                 "chargeValue": "103",
  131.                 "exchangeDate": "2019-08-26 13:52:23",
  132.                 "warehouse": null,
  133.                 "warehouseCode": null,
  134.                 "productLine": "OWHS",
  135.                 "arrearsAmt": null,
  136.                 "isInvoice": "Y",
  137.                 "logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
  138.                 "accountCurrency": null,
  139.                 "settlementAmount": null,
  140.                 "isUsedCoupon": "N",
  141.                 "ispIsEbayRebate": "Y",
  142.                 "isConformGift": "N",
  143.                 "productCode": "OSF810757",
  144.                 "qty": null,
  145.                 "transactionType": "1000383",
  146.                 "priceVersion": "33158",
  147.                 "partnerName": "万邑通质量保证部测试账号1-TEST",
  148.                 "orderDate": "2019-08-26 13:49:44",
  149.                 "originatingWarehouse": null,
  150.                 "destinationWarehouse": "USWC Warehouse",
  151.                 "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  152.                 "weight": 0.025,
  153.                 "volume": 0.00045,
  154.                 "volumeWeight": null,
  155.                 "chargeWeight": 0.025,
  156.                 "deliveryDate": "2019-08-26 13:52:23",
  157.                 "stockDate": "2019-08-26 13:52:23",
  158.                 "totalDeclarePrice": null,
  159.                 "itemCodeNum": "auto_sku22*1",
  160.                 "totalItemQty": 1,
  161.                 "fistLegPrice": null,
  162.                 "sellerNo": "252727722489-1495123873511",
  163.                 "sellerId": null,
  164.                 "buyerId": null,
  165.                 "buyerCountry": null,
  166.                 "declareWeight": null,
  167.                 "mainDocumentNo": null,
  168.                 "onwardVoyageType": null,
  169.                 "unit": "ZL",
  170.                 "postalCode": "91436-3631",
  171.                 "firstDateAdded": null,
  172.                 "ascanDate": null,
  173.                 "warehouseEntryType": null,
  174.                 "wide": null,
  175.                 "high": null,
  176.                 "lenth": null,
  177.                 "masterBillNumber": null,
  178.                 "conversionRate": null,
  179.                 "trackingNo": "1Z68223Y0335397681",
  180.                 "entryWhType": "OSF81",
  181.                 "chargeDate": null,
  182.                 "businessType": null,
  183.                 "packageNo": "WO0000004031A",
  184.                 "buyerCountryName": null,
  185.                 "deducationTime": "2019-08-26 13:57:21",
  186.                 "description": null,
  187.                 "isRecalculation": null,
  188.                 "recalculationCode": null,
  189.                 "recalculationName": null,
  190.                 "warehouseValue": null,
  191.                 "warehousetoValue": null
  192.             },
  193.             {
  194.                 "id": 414444881,
  195.                 "orgId": 1000000,
  196.                 "isDelete": "N",
  197.                 "isActive": "Y",
  198.                 "created": "2019-08-26 13:57:21",
  199.                 "createdby": "system",
  200.                 "updated": "2019-08-26 13:57:21",
  201.                 "updatedby": "system",
  202.                 "chargeCode": "1000010",
  203.                 "chargeName": "海外仓最后一公里派送费",
  204.                 "documentNo": "a4c04fe7-dc14-4a4d-a172-6d741501944b",
  205.                 "businessDocumentNo": "WO0000004031",
  206.                 "sourceAmt": -0.25,
  207.                 "sourceCurrency": "USD",
  208.                 "acctAmt": -0.25,
  209.                 "acctCurrency": "USD",
  210.                 "exchangeRate": 1,
  211.                 "conversionTypeCode": "114",
  212.                 "incomeSettlementId": 440828299,
  213.                 "revenueAdjustLineId": null,
  214.                 "invoicelineId": 611061535,
  215.                 "isFeeDeducation": "Y",
  216.                 "docType": "1000810",
  217.                 "partnerCode": "1000019",
  218.                 "dateAcct": "2019-08-26 13:52:23",
  219.                 "isAdjust": "N",
  220.                 "isRebate": "N",
  221.                 "chargeValue": "103",
  222.                 "exchangeDate": "2019-08-26 13:52:23",
  223.                 "warehouse": null,
  224.                 "warehouseCode": null,
  225.                 "productLine": "OWHS",
  226.                 "arrearsAmt": null,
  227.                 "isInvoice": "Y",
  228.                 "logisticsDist": "US_USPS_PM (CA)-USPS ZONE 1",
  229.                 "accountCurrency": null,
  230.                 "settlementAmount": null,
  231.                 "isUsedCoupon": "N",
  232.                 "ispIsEbayRebate": "Y",
  233.                 "isConformGift": "N",
  234.                 "productCode": "OSF810757",
  235.                 "qty": null,
  236.                 "transactionType": "1000381",
  237.                 "priceVersion": "33158",
  238.                 "partnerName": "万邑通质量保证部测试账号1-TEST",
  239.                 "orderDate": "2019-08-26 13:49:44",
  240.                 "originatingWarehouse": null,
  241.                 "destinationWarehouse": "USWC Warehouse",
  242.                 "transType": "USPS - Priority Mail (Express 2-3 Business Days)-USWC",
  243.                 "weight": 0.025,
  244.                 "volume": 0.00045,
  245.                 "volumeWeight": null,
  246.                 "chargeWeight": 8.36,
  247.                 "deliveryDate": "2019-08-26 13:52:23",
  248.                 "stockDate": "2019-08-26 13:52:23",
  249.                 "totalDeclarePrice": null,
  250.                 "itemCodeNum": "auto_sku22*1",
  251.                 "totalItemQty": 1,
  252.                 "fistLegPrice": null,
  253.                 "sellerNo": "252727722489-1495123873511",
  254.                 "sellerId": null,
  255.                 "buyerId": null,
  256.                 "buyerCountry": null,
  257.                 "declareWeight": null,
  258.                 "mainDocumentNo": null,
  259.                 "onwardVoyageType": null,
  260.                 "unit": "ZL",
  261.                 "postalCode": "91436-3631",
  262.                 "firstDateAdded": null,
  263.                 "ascanDate": null,
  264.                 "warehouseEntryType": null,
  265.                 "wide": null,
  266.                 "high": null,
  267.                 "lenth": null,
  268.                 "masterBillNumber": null,
  269.                 "conversionRate": null,
  270.                 "trackingNo": "1Z68223Y0335397681",
  271.                 "entryWhType": "OSF81",
  272.                 "chargeDate": null,
  273.                 "businessType": null,
  274.                 "packageNo": "WO0000004031A",
  275.                 "buyerCountryName": null,
  276.                 "deducationTime": "2019-08-26 13:57:21",
  277.                 "description": null,
  278.                 "isRecalculation": null,
  279.                 "recalculationCode": null,
  280.                 "recalculationName": null,
  281.                 "warehouseValue": null,
  282.                 "warehousetoValue": null
  283.             }
  284.         ]
  285.     }
  286. }
关键词