API
查询入库单费用
更新时间: 2018-05-25 16:43:39 访问次数:1603
接口说明

卖家或第三方通过该接口:使用入库订单号、目的仓和下单日期查询入库订单订单费用信息。

接口英文名称

sms.incomeSettlement.pageInboundLine

使用场景

卖家或第三方使用该接口查询获得入库订单费用。

备注
请求说明
URL http://openapi.winit.com.cn/openapi/service
接口测试 http://openapi.sandbox.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟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
请求示例
{
    "action":"sms.incomeSettlement.pageInboundLine",
    "app_key":"rebecca",
    "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
    "client_sign":"EB2876C76EB5FE19E770024184B32704",
    "data":{
        "businessDocumentNo":"WI9900001290",
        "destinationWarehouse":"",
        "orderDateFrom":"",
        "orderDateTo":"",
        "pageParams":{
            "pageNo":"1",
            "pageSize":"20"
        }
    },
    "format":"json",
    "language":"zh_CN",
    "platform":"OWNERERP",
    "sign":"528B4608E7BF658A37BE94A54716B17F",
    "sign_method":"md5",
    "timestamp":"2017-09-16 19:50:24",
    "version":"1.0"
}

                            
返回出参
名称 类型 必填 说明 示例
list Array Y 查询结果,以下为子节点
--|businessDocumentNoString()
Y
入库订单号
--|sellerNoString()
Y卖家订单号
--|destinationWarehouse String() Y 目的海外仓名称
--|transType String() Y 头程运输类型 AIR
--|incomeSettlementLineVos Array()
订单收费项,以下为子节点
--|--|created Date() Y 创建时间
--|--|createdby String() Y 创建者
--|--|chargeCode
String() Y 收费项编码
--|--|chargeName
String() Y 收费项名称
--|--|documentNo
String() Y 单据编号
--|--|businessDocumentNo
String() Y 业务单号
入库订单号
--|--|sourceAmt
String() Y 金额(原币)
--|--|sourceCurrency
String() Y 币种(原币币种)
--|--|acctAmt
String() Y 金额
目标货币,一般为美元
--|--|acctCurrency
String() Y 币种
目标货币币种,一般为美元USD)
--|--|exchangeRate
String() Y 汇率
--|--|conversionTypeCode
String() Y 兑换类别码
--|--|exchangeDateDateY兑换时间
--|--|dateAcct
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 包裹单品数量
--|--|sellerNo
String() Y 卖家订单号

返回参数说明 正确的返回结果:查询成功。入库单费用详情,注意部分返回的参数默认为空原。 错误的返回结果:错误码,错误信息

返回示例
{
   "code": "0",
   "msg": "操作成功",
   "data":    {
      "pageParams":       {
         "currentPageSize": 20,
         "totalCount": 1,
         "currentPageNo": 1
      },
      "list": [      {
         "id": null,
         "orgId": null,
         "isDelete": null,
         "isActive": null,
         "created": null,
         "createdby": null,
         "updated": null,
         "updatedby": null,
         "orgName": null,
         "incomeSettlementNo": null,
         "settlementDate": null,
         "businessDocumentNo": "WI9900001290",
         "docType": null,
         "partnerCode": null,
         "partnerName": null,
         "orderDate": null,
         "dateAcct": null,
         "originatingWarehouse": null,
         "destinationWarehouse": "USWC Warehouse",
         "transType": "AIR",
         "weight": null,
         "volume": null,
         "volumeWeight": null,
         "chargeWeight": null,
         "sourceCurrency": null,
         "sourceTotalAmt": null,
         "acctCurrency": null,
         "acctTotalAmt": null,
         "isInvoice": null,
         "invoiceNo": null,
         "invoiceDate": null,
         "isReconciled": null,
         "isAdjust": null,
         "adjustNo": null,
         "isRebate": null,
         "deliveryDate": null,
         "stockDate": null,
         "totalDeclarePrice": null,
         "itemCodeNum": null,
         "totalItemQty": null,
         "fistLegPrice": null,
         "sellerNo": "AutoStandard air 222222",
         "sellerId": null,
         "buyerId": null,
         "buyerCountry": null,
         "declareWeight": null,
         "mainDocumentNo": null,
         "onwardVoyageType": null,
         "unit": null,
         "exchangeRate": null,
         "conversionTypeCode": null,
         "postalCode": null,
         "firstDateAdded": null,
         "wide": null,
         "high": null,
         "lenth": null,
         "masterBillNumber": null,
         "conversionRate": null,
         "ascanDate": null,
         "warehouseEntryType": null,
         "productCode": null,
         "productName": null,
         "incomeSettlementLineVos":          [
                        {
               "id": 414442587,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-06-03 17:40:10",
               "createdby": "system",
               "updated": "2019-06-03 17:40:10",
               "updatedby": "system",
               "chargeCode": "1055247",
               "chargeName": "C类包裹附加操作费",
               "documentNo": "201906031740070015001",
               "businessDocumentNo": "WI9900001290",
               "sourceAmt": 0,
               "sourceCurrency": "USD",
               "acctAmt": 0,
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "conversionTypeCode": "114",
               "incomeSettlementId": 440826005,
               "revenueAdjustLineId": null,
               "invoicelineId": 1,
               "isFeeDeducation": "Y",
               "docType": "1000792",
               "partnerCode": "1000019",
               "dateAcct": "2019-06-03 17:40:07",
               "isAdjust": "N",
               "isRebate": "N",
               "chargeValue": "129",
               "exchangeDate": "2019-06-03 17:40:07",
               "warehouse": null,
               "warehouseCode": null,
               "productLine": "OWHS",
               "arrearsAmt": null,
               "isInvoice": "Y",
               "logisticsDist": null,
               "accountCurrency": null,
               "settlementAmount": null,
               "isUsedCoupon": "N",
               "ispIsEbayRebate": null,
               "isConformGift": "N",
               "productCode": "OW01010343",
               "qty": 1,
               "transactionType": null,
               "priceVersion": null,
               "partnerName": "万邑通质量保证部测试账号1-TEST",
               "orderDate": "2019-06-03 17:38:11",
               "originatingWarehouse": "ShenZhen Warehouse",
               "destinationWarehouse": "USWC Warehouse",
               "transType": "AIR",
               "weight": 10,
               "volume": 0.06,
               "volumeWeight": null,
               "chargeWeight": 10,
               "deliveryDate": "2019-06-03 17:39:23",
               "stockDate": null,
               "totalDeclarePrice": 120,
               "itemCodeNum": "2",
               "totalItemQty": 4,
               "fistLegPrice": null,
               "sellerNo": "AutoStandard air 222222",
               "sellerId": null,
               "buyerId": null,
               "buyerCountry": null,
               "declareWeight": null,
               "mainDocumentNo": null,
               "onwardVoyageType": "Winit",
               "unit": "SPN",
               "postalCode": null,
               "firstDateAdded": null,
               "ascanDate": null,
               "warehouseEntryType": null,
               "wide": null,
               "high": null,
               "lenth": null,
               "masterBillNumber": null,
               "conversionRate": null,
               "trackingNo": null,
               "entryWhType": "SD"
            },
                        {
               "id": 414442588,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-06-03 17:44:16",
               "createdby": "system",
               "updated": "2019-06-03 17:44:16",
               "updatedby": "system",
               "chargeCode": "1000007",
               "chargeName": "头程运费-空运",
               "documentNo": "201906031744120016001",
               "businessDocumentNo": "WI9900001290",
               "sourceAmt": 42,
               "sourceCurrency": "USD",
               "acctAmt": 42,
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "conversionTypeCode": "114",
               "incomeSettlementId": 440826006,
               "revenueAdjustLineId": null,
               "invoicelineId": 611060787,
               "isFeeDeducation": "Y",
               "docType": "1000792",
               "partnerCode": "1000019",
               "dateAcct": "2019-06-03 17:44:12",
               "isAdjust": "N",
               "isRebate": "N",
               "chargeValue": "100",
               "exchangeDate": "2019-06-03 17:44:12",
               "warehouse": null,
               "warehouseCode": null,
               "productLine": "OWHS",
               "arrearsAmt": null,
               "isInvoice": "Y",
               "logisticsDist": null,
               "accountCurrency": null,
               "settlementAmount": null,
               "isUsedCoupon": "N",
               "ispIsEbayRebate": null,
               "isConformGift": "N",
               "productCode": "OW01010343",
               "qty": 1,
               "transactionType": null,
               "priceVersion": null,
               "partnerName": "万邑通质量保证部测试账号1-TEST",
               "orderDate": "2019-06-03 17:38:11",
               "originatingWarehouse": "ShenZhen Warehouse",
               "destinationWarehouse": "USWC Warehouse",
               "transType": "AIR",
               "weight": 10,
               "volume": 0.06,
               "volumeWeight": null,
               "chargeWeight": 10,
               "deliveryDate": "2019-06-03 17:39:23",
               "stockDate": null,
               "totalDeclarePrice": 120,
               "itemCodeNum": "2",
               "totalItemQty": 4,
               "fistLegPrice": null,
               "sellerNo": "AutoStandard air 222222",
               "sellerId": null,
               "buyerId": null,
               "buyerCountry": null,
               "declareWeight": null,
               "mainDocumentNo": null,
               "onwardVoyageType": "Winit",
               "unit": "JFZ",
               "postalCode": null,
               "firstDateAdded": null,
               "ascanDate": null,
               "warehouseEntryType": null,
               "wide": null,
               "high": null,
               "lenth": null,
               "masterBillNumber": null,
               "conversionRate": null,
               "trackingNo": null,
               "entryWhType": "SD"
            },
                        {
               "id": 414442589,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-06-03 17:44:16",
               "createdby": "system",
               "updated": "2019-06-03 17:44:16",
               "updatedby": "system",
               "chargeCode": "1000012",
               "chargeName": "海外进口关税",
               "documentNo": "201906031744150017001",
               "businessDocumentNo": "WI9900001290",
               "sourceAmt": 3.6,
               "sourceCurrency": "USD",
               "acctAmt": 3.6,
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "conversionTypeCode": "114",
               "incomeSettlementId": 440826007,
               "revenueAdjustLineId": null,
               "invoicelineId": 611060788,
               "isFeeDeducation": "Y",
               "docType": "1000792",
               "partnerCode": "1000019",
               "dateAcct": "2019-06-03 17:44:15",
               "isAdjust": "N",
               "isRebate": "N",
               "chargeValue": "104",
               "exchangeDate": "2019-06-03 17:44:15",
               "warehouse": null,
               "warehouseCode": null,
               "productLine": "OWHS",
               "arrearsAmt": null,
               "isInvoice": "Y",
               "logisticsDist": null,
               "accountCurrency": null,
               "settlementAmount": null,
               "isUsedCoupon": "N",
               "ispIsEbayRebate": null,
               "isConformGift": "N",
               "productCode": "OW01010343",
               "qty": 1,
               "transactionType": null,
               "priceVersion": null,
               "partnerName": "万邑通质量保证部测试账号1-TEST",
               "orderDate": "2019-06-03 17:38:11",
               "originatingWarehouse": "ShenZhen Warehouse",
               "destinationWarehouse": "USWC Warehouse",
               "transType": "AIR",
               "weight": 10,
               "volume": 0.06,
               "volumeWeight": null,
               "chargeWeight": 10,
               "deliveryDate": "2019-06-03 17:39:23",
               "stockDate": null,
               "totalDeclarePrice": 120,
               "itemCodeNum": "2",
               "totalItemQty": 4,
               "fistLegPrice": null,
               "sellerNo": "AutoStandard air 222222",
               "sellerId": null,
               "buyerId": null,
               "buyerCountry": null,
               "declareWeight": null,
               "mainDocumentNo": null,
               "onwardVoyageType": "Winit",
               "unit": "TJ",
               "postalCode": null,
               "firstDateAdded": null,
               "ascanDate": null,
               "warehouseEntryType": null,
               "wide": null,
               "high": null,
               "lenth": null,
               "masterBillNumber": null,
               "conversionRate": null,
               "trackingNo": null,
               "entryWhType": "SD"
            },
                        {
               "id": 414442590,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-06-03 17:44:22",
               "createdby": "system",
               "updated": "2019-06-03 17:44:23",
               "updatedby": "system",
               "chargeCode": "3",
               "chargeName": "杂费MPF",
               "documentNo": "201906031744160018001",
               "businessDocumentNo": "WI9900001290",
               "sourceAmt": 0.42,
               "sourceCurrency": "USD",
               "acctAmt": 0.42,
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "conversionTypeCode": "114",
               "incomeSettlementId": 440826008,
               "revenueAdjustLineId": null,
               "invoicelineId": 611060789,
               "isFeeDeducation": "Y",
               "docType": "1000792",
               "partnerCode": "1000019",
               "dateAcct": "2019-06-03 17:44:16",
               "isAdjust": "N",
               "isRebate": "N",
               "chargeValue": "112",
               "exchangeDate": "2019-06-03 17:44:16",
               "warehouse": null,
               "warehouseCode": null,
               "productLine": "OWHS",
               "arrearsAmt": null,
               "isInvoice": "Y",
               "logisticsDist": null,
               "accountCurrency": null,
               "settlementAmount": null,
               "isUsedCoupon": "N",
               "ispIsEbayRebate": null,
               "isConformGift": "N",
               "productCode": "OW01010343",
               "qty": 1,
               "transactionType": null,
               "priceVersion": null,
               "partnerName": "万邑通质量保证部测试账号1-TEST",
               "orderDate": "2019-06-03 17:38:11",
               "originatingWarehouse": "ShenZhen Warehouse",
               "destinationWarehouse": "USWC Warehouse",
               "transType": "AIR",
               "weight": 10,
               "volume": 0.06,
               "volumeWeight": null,
               "chargeWeight": 10,
               "deliveryDate": "2019-06-03 17:39:23",
               "stockDate": null,
               "totalDeclarePrice": 120,
               "itemCodeNum": "2",
               "totalItemQty": 4,
               "fistLegPrice": null,
               "sellerNo": "AutoStandard air 222222",
               "sellerId": null,
               "buyerId": null,
               "buyerCountry": null,
               "declareWeight": null,
               "mainDocumentNo": null,
               "onwardVoyageType": "Winit",
               "unit": "TJ",
               "postalCode": null,
               "firstDateAdded": null,
               "ascanDate": null,
               "warehouseEntryType": null,
               "wide": null,
               "high": null,
               "lenth": null,
               "masterBillNumber": null,
               "conversionRate": null,
               "trackingNo": null,
               "entryWhType": "SD"
            },
                        {
               "id": 414442591,
               "orgId": 1000000,
               "isDelete": "N",
               "isActive": "Y",
               "created": "2019-06-03 17:46:06",
               "createdby": "system",
               "updated": "2019-06-03 17:46:06",
               "updatedby": "system",
               "chargeCode": "1000913",
               "chargeName": "入库处理费",
               "documentNo": "201906031746030019001",
               "businessDocumentNo": "WI9900001290",
               "sourceAmt": 0.72,
               "sourceCurrency": "USD",
               "acctAmt": 0.72,
               "acctCurrency": "USD",
               "exchangeRate": 1,
               "conversionTypeCode": "114",
               "incomeSettlementId": 440826009,
               "revenueAdjustLineId": null,
               "invoicelineId": 611060790,
               "isFeeDeducation": "Y",
               "docType": "1000792",
               "partnerCode": "1000019",
               "dateAcct": "2019-06-03 17:46:03",
               "isAdjust": "N",
               "isRebate": "N",
               "chargeValue": "101",
               "exchangeDate": "2019-06-03 17:46:03",
               "warehouse": null,
               "warehouseCode": null,
               "productLine": "OWHS",
               "arrearsAmt": null,
               "isInvoice": "Y",
               "logisticsDist": null,
               "accountCurrency": null,
               "settlementAmount": null,
               "isUsedCoupon": "N",
               "ispIsEbayRebate": null,
               "isConformGift": "N",
               "productCode": "OW01010343",
               "qty": 1,
               "transactionType": null,
               "priceVersion": null,
               "partnerName": "万邑通质量保证部测试账号1-TEST",
               "orderDate": "2019-06-03 17:38:11",
               "originatingWarehouse": "ShenZhen Warehouse",
               "destinationWarehouse": "USWC Warehouse",
               "transType": "AIR",
               "weight": 10,
               "volume": 0.06,
               "volumeWeight": null,
               "chargeWeight": 10,
               "deliveryDate": "2019-06-03 17:39:23",
               "stockDate": "2019-06-03 17:44:49",
               "totalDeclarePrice": 120,
               "itemCodeNum": "2",
               "totalItemQty": 4,
               "fistLegPrice": null,
               "sellerNo": "AutoStandard air 222222",
               "sellerId": null,
               "buyerId": null,
               "buyerCountry": null,
               "declareWeight": null,
               "mainDocumentNo": null,
               "onwardVoyageType": "Winit",
               "unit": "SZL",
               "postalCode": null,
               "firstDateAdded": null,
               "ascanDate": null,
               "warehouseEntryType": null,
               "wide": null,
               "high": null,
               "lenth": null,
               "masterBillNumber": null,
               "conversionRate": null,
               "trackingNo": null,
               "entryWhType": "SD"
            }
         ]
      }]
   }
}