API
查询入库单费用
更新时间： 2019-10-16 20:27:08 访问次数：8956

接口说明

使用入库订单号、目的仓和下单日期查询入库订单订单费用信息。

接口名称

sms.incomeSettlement.pageInboundLine

请求说明

请求内容 说明
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() Y 海外仓入库单号 WI9900046392
destinationWarehouse String() N 目的海外仓名称 BEMO Warehouse
orderDateFrom Date N 查询开始日期 2018-01-16
orderDateTo Date N 查询截止日期 2018-05-23
pageParams Arrary Y 分页参数
–|pageNo Number Y 第几页,页码,默认1 1
–|pageSize Number Y 分页大小,每页记录数,最大200 100

请求示例

  1. {
  2.     "action":"sms.incomeSettlement.pageInboundLine",
  3.     "app_key":"rebecca",
  4.     "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.     "client_sign":"EB2876C76EB5FE19E770024184B32704",
  6.     "data":{
  7.         "businessDocumentNo":"WI9900001290",
  8.         "destinationWarehouse":"",
  9.         "orderDateFrom":"",
  10.         "orderDateTo":"",
  11.         "pageParams":{
  12.             "pageNo":"1",
  13.             "pageSize":"20"
  14.         }
  15.     },
  16.     "format":"json",
  17.     "language":"zh_CN",
  18.     "platform":"OWNERERP",
  19.     "sign":"528B4608E7BF658A37BE94A54716B17F",
  20.     "sign_method":"md5",
  21.     "timestamp":"2017-09-16 19:50:24",
  22.     "version":"1.0"
  23. }

返回出参

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

名称 类型 必传 说明 示例
list Array Y 查询结果
businessDocumentNo String() Y 入库订单号
sellerNo String() Y 卖家订单号
destinationWarehouse String() Y 目的海外仓名称
transType String() Y 头程运输类型 AIR
incomeSettlementLineVos Array Y 订单收费项
–|chargeCode String() Y 收费项编码
–|chargeName String() Y 收费项名称
–|documentNo String() Y 收费单据编号
–|dateAcct String() Y 记账时间，精确至秒，北京时间
–|sourceAmt String() Y 金额，原币
–|sourceCurrency String() Y 币种，原币币种
–|acctAmt String() Y 金额 ，目标货币
一般为美元
–|acctCurrency String() Y 币种，目标货币币种
一般为美元USD
–|exchangeRate String() Y 汇率
–|conversionTypeCode String() Y 兑换类别码
–|exchangeDate Date Y 兑换时间
–|businessDocumentNo String() Y 业务单号 ，入库订单号
–|sellerNo String() Y 卖家订单号
–|orderDate String() Y 入库单下单时间
–|originatingWarehouse String() Y 发货仓库名称
–|destinationWarehouse String() Y 目的仓库名称
–|transType String() Y 运输类型
–|weight String() Y 重量(KG)
–|volume String() Y 体积(CBM)
–|volumeWeight String() Y 体积重（KG）
–|chargeWeight String() Y 计算重(KG)
–|itemCodeNum String() Y 包裹商品数
–|totalItemQty String() Y 包裹单品数量
–|created Date() Y 创建时间
–|createdby String() Y 创建者

返回示例

  1. {
  2.    "code": "0",
  3.    "msg": "操作成功",
  4.    "data":    {
  5.       "pageParams":       {
  6.          "currentPageSize": 20,
  7.          "totalCount": 1,
  8.          "currentPageNo": 1
  9.       },
  10.       "list": [      
  11.         {
  12.          "id": null,
  13.          "orgId": null,
  14.          "isDelete": null,
  15.          "isActive": null,
  16.          "created": null,
  17.          "createdby": null,
  18.          "updated": null,
  19.          "updatedby": null,
  20.          "orgName": null,
  21.          "incomeSettlementNo": null,
  22.          "settlementDate": null,
  23.          "businessDocumentNo": "WI9900001290",
  24.          "docType": null,
  25.          "partnerCode": null,
  26.          "partnerName": null,
  27.          "orderDate": null,
  28.          "dateAcct": null,
  29.          "originatingWarehouse": null,
  30.          "destinationWarehouse": "USWC Warehouse",
  31.          "transType": "AIR",
  32.          "weight": null,
  33.          "volume": null,
  34.          "volumeWeight": null,
  35.          "chargeWeight": null,
  36.          "sourceCurrency": null,
  37.          "sourceTotalAmt": null,
  38.          "acctCurrency": null,
  39.          "acctTotalAmt": null,
  40.          "isInvoice": null,
  41.          "invoiceNo": null,
  42.          "invoiceDate": null,
  43.          "isReconciled": null,
  44.          "isAdjust": null,
  45.          "adjustNo": null,
  46.          "isRebate": null,
  47.          "deliveryDate": null,
  48.          "stockDate": null,
  49.          "totalDeclarePrice": null,
  50.          "itemCodeNum": null,
  51.          "totalItemQty": null,
  52.          "fistLegPrice": null,
  53.          "sellerNo": "AutoStandard air 222222",
  54.          "sellerId": null,
  55.          "buyerId": null,
  56.          "buyerCountry": null,
  57.          "declareWeight": null,
  58.          "mainDocumentNo": null,
  59.          "onwardVoyageType": null,
  60.          "unit": null,
  61.          "exchangeRate": null,
  62.          "conversionTypeCode": null,
  63.          "postalCode": null,
  64.          "firstDateAdded": null,
  65.          "wide": null,
  66.          "high": null,
  67.          "lenth": null,
  68.          "masterBillNumber": null,
  69.          "conversionRate": null,
  70.          "ascanDate": null,
  71.          "warehouseEntryType": null,
  72.          "productCode": null,
  73.          "productName": null,
  74.          "incomeSettlementLineVos":          
  75.           [
  76.             {
  77.                "id": 414442588,
  78.                "orgId": 1000000,
  79.                "isDelete": "N",
  80.                "isActive": "Y",
  81.                "created": "2019-06-03 17:44:16",
  82.                "createdby": "system",
  83.                "updated": "2019-06-03 17:44:16",
  84.                "updatedby": "system",
  85.                "chargeCode": "1000007",
  86.                "chargeName": "头程运费-空运",
  87.                "documentNo": "201906031744120016001",
  88.                "businessDocumentNo": "WI9900001290",
  89.                "sourceAmt": 42,
  90.                "sourceCurrency": "USD",
  91.                "acctAmt": 42,
  92.                "acctCurrency": "USD",
  93.                "exchangeRate": 1,
  94.                "conversionTypeCode": "114",
  95.                "incomeSettlementId": 440826006,
  96.                "revenueAdjustLineId": null,
  97.                "invoicelineId": 611060787,
  98.                "isFeeDeducation": "Y",
  99.                "docType": "1000792",
  100.                "partnerCode": "1000019",
  101.                "dateAcct": "2019-06-03 17:44:12",
  102.                "isAdjust": "N",
  103.                "isRebate": "N",
  104.                "chargeValue": "100",
  105.                "exchangeDate": "2019-06-03 17:44:12",
  106.                "warehouse": null,
  107.                "warehouseCode": null,
  108.                "productLine": "OWHS",
  109.                "arrearsAmt": null,
  110.                "isInvoice": "Y",
  111.                "logisticsDist": null,
  112.                "accountCurrency": null,
  113.                "settlementAmount": null,
  114.                "isUsedCoupon": "N",
  115.                "ispIsEbayRebate": null,
  116.                "isConformGift": "N",
  117.                "productCode": "OW01010343",
  118.                "qty": 1,
  119.                "transactionType": null,
  120.                "priceVersion": null,
  121.                "partnerName": "万邑通质量保证部测试账号1-TEST",
  122.                "orderDate": "2019-06-03 17:38:11",
  123.                "originatingWarehouse": "ShenZhen Warehouse",
  124.                "destinationWarehouse": "USWC Warehouse",
  125.                "transType": "AIR",
  126.                "weight": 10,
  127.                "volume": 0.06,
  128.                "volumeWeight": null,
  129.                "chargeWeight": 10,
  130.                "deliveryDate": "2019-06-03 17:39:23",
  131.                "stockDate": null,
  132.                "totalDeclarePrice": 120,
  133.                "itemCodeNum": "2",
  134.                "totalItemQty": 4,
  135.                "fistLegPrice": null,
  136.                "sellerNo": "AutoStandard air 222222",
  137.                "sellerId": null,
  138.                "buyerId": null,
  139.                "buyerCountry": null,
  140.                "declareWeight": null,
  141.                "mainDocumentNo": null,
  142.                "onwardVoyageType": "Winit",
  143.                "unit": "JFZ",
  144.                "postalCode": null,
  145.                "firstDateAdded": null,
  146.                "ascanDate": null,
  147.                "warehouseEntryType": null,
  148.                "wide": null,
  149.                "high": null,
  150.                "lenth": null,
  151.                "masterBillNumber": null,
  152.                "conversionRate": null,
  153.                "trackingNo": null,
  154.                "entryWhType": "SD"
  155.             },
  156.             {
  157.                "id": 414442591,
  158.                "orgId": 1000000,
  159.                "isDelete": "N",
  160.                "isActive": "Y",
  161.                "created": "2019-06-03 17:46:06",
  162.                "createdby": "system",
  163.                "updated": "2019-06-03 17:46:06",
  164.                "updatedby": "system",
  165.                "chargeCode": "1000913",
  166.                "chargeName": "入库处理费",
  167.                "documentNo": "201906031746030019001",
  168.                "businessDocumentNo": "WI9900001290",
  169.                "sourceAmt": 0.72,
  170.                "sourceCurrency": "USD",
  171.                "acctAmt": 0.72,
  172.                "acctCurrency": "USD",
  173.                "exchangeRate": 1,
  174.                "conversionTypeCode": "114",
  175.                "incomeSettlementId": 440826009,
  176.                "revenueAdjustLineId": null,
  177.                "invoicelineId": 611060790,
  178.                "isFeeDeducation": "Y",
  179.                "docType": "1000792",
  180.                "partnerCode": "1000019",
  181.                "dateAcct": "2019-06-03 17:46:03",
  182.                "isAdjust": "N",
  183.                "isRebate": "N",
  184.                "chargeValue": "101",
  185.                "exchangeDate": "2019-06-03 17:46:03",
  186.                "warehouse": null,
  187.                "warehouseCode": null,
  188.                "productLine": "OWHS",
  189.                "arrearsAmt": null,
  190.                "isInvoice": "Y",
  191.                "logisticsDist": null,
  192.                "accountCurrency": null,
  193.                "settlementAmount": null,
  194.                "isUsedCoupon": "N",
  195.                "ispIsEbayRebate": null,
  196.                "isConformGift": "N",
  197.                "productCode": "OW01010343",
  198.                "qty": 1,
  199.                "transactionType": null,
  200.                "priceVersion": null,
  201.                "partnerName": "万邑通质量保证部测试账号1-TEST",
  202.                "orderDate": "2019-06-03 17:38:11",
  203.                "originatingWarehouse": "ShenZhen Warehouse",
  204.                "destinationWarehouse": "USWC Warehouse",
  205.                "transType": "AIR",
  206.                "weight": 10,
  207.                "volume": 0.06,
  208.                "volumeWeight": null,
  209.                "chargeWeight": 10,
  210.                "deliveryDate": "2019-06-03 17:39:23",
  211.                "stockDate": "2019-06-03 17:44:49",
  212.                "totalDeclarePrice": 120,
  213.                "itemCodeNum": "2",
  214.                "totalItemQty": 4,
  215.                "fistLegPrice": null,
  216.                "sellerNo": "AutoStandard air 222222",
  217.                "sellerId": null,
  218.                "buyerId": null,
  219.                "buyerCountry": null,
  220.                "declareWeight": null,
  221.                "mainDocumentNo": null,
  222.                "onwardVoyageType": "Winit",
  223.                "unit": "SZL",
  224.                "postalCode": null,
  225.                "firstDateAdded": null,
  226.                "ascanDate": null,
  227.                "warehouseEntryType": null,
  228.                "wide": null,
  229.                "high": null,
  230.                "lenth": null,
  231.                "masterBillNumber": null,
  232.                "conversionRate": null,
  233.                "trackingNo": null,
  234.                "entryWhType": "SD"
  235.             }
  236.          ]
  237.       }]
  238.    }
  239. }