查询入库单费用
更新时间: 2019-10-16 20:27:08 访问次数:8381
接口说明
使用入库订单号、目的仓和下单日期查询入库订单订单费用信息。
接口名称
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 |
请求示例
{
"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"
}
返回出参
返回参数说明:正确的返回编码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 | 创建者 |
返回示例
{
"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": 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": 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"
}
]
}]
}
}
关键词