eTowerOne Developers
页面树结构

版本比较

旧版本 14

changes.mady.by.user 谢霁军

保存于

比较

新版本 当前版本

changes.mady.by.user 曾宇凡

保存于

标识

  • 该行被添加。
  • 该行被删除。
  • 格式已经改变。

...

sa订单查询

接口描述

通过订单号针对订单信息进行查询。

HTTP VerbURL
POST/api/supplier-service/v1/b2b/OrderSearch

...

代码块
POST /api/supplier-service/v1/b2b/OrderSearch  HTTP/1.1
Content-Type: application/json
Accept: application/json
Host: http://cfs-qa.etowertech.com/
X-WallTech-Date: Thu, 06 Aug 2020 06:44:25 GMT
Authorization: WallTech testLvs2jdug2qIoRsJyuxs:F714XG5EBjslUUdx5xJrTCVb9Xs=


请求样例

使用JSON列表格式拼接订单号数据进行查询，最多支持单次查询30个订单。

样例:

{
    "trackingNos"   : ["JDQ002445001000931503","JDQ002445001000931502"]
}

返回内容

成功样例

...

languagejs

...

,
"startTime" : "2024-10-01 12:00:00",
"endTime" : "2024-12-01 12:00:00",
"statusList" : [0,130],
"salesIdList" : [20658,20645],
"shippedDateStart" : "2024-10-01",
"shippedDateEnd" : "2024-10-20",
"shipperIdList" : [18886,18858],
"pageNum": 1,
"pageSize": 100
}

字段描述

字段名

类型

最大长度

描述

trackingNos

List<String>
订单号:支持批量

startTime

Date
订单创建时间- 开始（包含该日期）
endTimeDate
订单创建时间- 结束（不包含该日期）

statusList

List<Integer>

订单状态：支持批量

0 已创建

130 待入库
133 已入库"
155 已核重"
160 待装箱"
200 待出库"
220 运输中"
300 已签收"

salesIdList

List<Integer>
销售列表

shippedDateStart

Date
出库时间-开始（包含该日期）

shippedDateEnd

Date
出库时间-结束（不包含该日期）

shipperIdList

List<Integer>
发货人列表
pageNumInteger
页码从1开始，默认1
pageSizeInteger
每页的数量，默认100

返回内容sh

成功样例

代码块
languagejs
{
    "status": "Success",
    "errors": null,
    "data": [
        {
            "status": "Success",
            "errors": null,
            "orderNo": "JDQ002445001000931503",
			"status" : 0,
			"salesId" : 12283,
 			"orderNosalesUserName" : "JDQ002445001000931503测试销售",
            "detail": {
                "referenceNo": "order1",
                "service": "CN-US",
                "collectionType": "pick up",
                "shipper": "shipper name",
				"csIds": [20658,20653],	
				"salesId": 20658,
				"spettlementId": 20658,
				"shipper": "shipper name",
                "collectionWarehouse": "SH warehouse",
                "clearanceType": "customs declaraton",
                "platformSource": "eBay",
                "platformRefNo": "order1",
                "expectedDepartureDate": "2024-03-15",
                "insuranceType": "No need",
                "insuranceAmount": 0,
                "remark": "test order",
                "loadingPort": "CNSHA",
                "commercialInspection": 0,
                "taxRefund": 0,
                "battery": 0,
                "magnet": 0,
                "declareValue": 100,
				"sysPeerToStatus":0,
  "declareValue": 100				"sysPeerToStatusTime":"",
				"sysPeerToStatusErrMessage":"",
                "collectionInfo": {
                    "collectionDate": "2024-03-15",
                    "contact": "Alex",
                    "phoneNumber": "15000695273",
                    "zipCode": "100006",
                    "country": "CN",
                    "province": "Shanghai",
                    "city": "Shanghai",
                    "district": "",
                    "addressLine1": "Dalian Road",
                    "addressLine2": ""
                },
                "consigneeInfo": {
                    "addressCode": "ONT8",
                    "consignee": "FBA",
                    "company": "",
                    "phoneNumber": "",
                    "zipCode": "92551",
                    "email": "",
                    "country": "US",
                    "province": "CA",
                    "city": "Valley",
                    "district": "",
                    "addressLine1": "Golden State FC LLC 24300 Nandina Ave Moreno Valley, CA 92551 US (ONT8)",
                    "addressLine2": ""
                },
                "cartonInfo": [
                    {
                        "ctnNo": "1",
                        "weight": 1,
                        "totalWeight": 100,
                        "width": 100,
                        "height": 100,
                        "length": 100,
                        "amount": 100,
                        "declareAmount": 50,
                        "declareDemension": "20*20*20",
                        "declareWeight": 1,
                        "FBAID": "FBA01",
                        "subOrderNo": "Order1-1",
                        "PONumber": "",
                        "remark": ""
                    },
                    {
                        "ctnNo": "2",
                        "weight": 2,
                        "totalWeight": 50,
                        "width": 100,
                        "height": 100,
                        "length": 100,
                        "amount": 25,
                        "declareAmount": 50,
                        "declareDemension": "20*20*20",
                        "declareWeight": 1,
                        "FBAID": "FBA01",
                        "subOrderNo": "Order1-2",
                        "PONumber": "",
                        "remark": ""
                    }
                ],
                "commodityInfo": [
                    {
                        "ctnNo": "1",
                        "skuNumber": "sku01",
                        "unitPrice": 10,
                        "amount": 100,
                        "hsCode": "2501001100",
                        "nameCN": "车辆",
                        "nameEN": "Car",
                        "materialCN": "金属",
                        "materialEN": "metal",
                        "usage": "transport",
                        "brand": "null",
                        "salesLink": "https://www.walltechsystem.cn/",
                        "type": "",
                        "pictureLink": "https://www.walltechsystem.cn/",
                        "FBAID": "",
                        "PONumber": ""
                    },
                    {
                        "ctnNo": "2",
                        "skuNumber": "sku02",
                        "unitPrice": 10,
                        "amount": 100,
                        "hsCode": "2501001101",
                        "nameCN": "车辆",
                        "nameEN": "Car",
                        "materialCN": "金属",
                        "materialEN": "metal",
                        "usage": "transport",
                        "brand": "null",
                        "salesLink": "https://www.walltechsystem.cn/",
                        "type": "",
                        "pictureLink": "https://www.walltechsystem.cn/",
                        "FBAID": "",
                        "PONumber": ""
                    }
                ],
                "shipmentInfo": [
                    {
                        "shipmentNo": "METO2403150089S",
                        "type": "Sea",
                        "blNo": "jwsea20240315170003",
                        "vessel": "MAERSK SEBAROK",
                        "voyage": "409S",
                        "loadingPort": "CNYTN",
                        "dischargePort": "AUSYD",
                        "transshipmentPort": "",
                        "clearancePort": "",
                        "ETD": "2020-08-16T13:47:12+0800",
                        "ATD": "2020-08-16T13:47:12+0800",
                        "ETA": "2020-08-16T13:47:12+0800",
                        "ATA": "2020-08-16T13:47:12+0800",
                        "supplier": "Shanghai Transport",
                        "carrier": "Maersk",
                        "containerType": "40HQ",
                        "containerNo": "01",
                        "sealNo": "01",
                        "remark": ""
                    },
                    {
                        "shipmentNo": "METO2403150082A",
                        "type": "Air",
                        "mawb": "112-BZAIR20240315160000",
                        "flightNo": "CA017",
                        "loadingPort": "SHA",
                        "dischargePort": "ORD",
                        "originCountry": "CN",
                        "destinationCountry": "US",
                        "ETD": "2020-08-16T13:47:12+0800",
                        "ATD": "2020-08-16T13:47:12+0800",
                        "ETA": "2020-08-16T13:47:12+0800",
                        "ATA": "2020-08-16T13:47:12+0800",
                        "supplier": "Shanghai Transport",
                        "route": "",
                        "remark": ""
                    },
                    {
                        "shipmentNo": "METO2403150086T",
                        "type": "Land",
                        "blNo": "BZLAND20240315170000",
                        "licensePlate": "沪B 95899",
                        "driver": "李师傅",
                        "ETD": "2020-08-16T13:47:12+0800",
                        "ATD": "2020-08-16T13:47:12+0800",
                        "ETA": "2020-08-16T13:47:12+0800",
                        "ATA": "2020-08-16T13:47:12+0800",
                        "supplier": "Shanghai Transport",
                        "POD": "",
                        "ISA": "",
                        "remark": ""
                    },
                    {
                        "shipmentNo": "METO2403150088E",
                        "type": "Express",
                        "trackingNo": "BZEXPRESS20240315170000",
                        "supplier": "Shanghai Transport",
                        "remark": ""
                    }
                ]
            }
        }
    ]
}

失败样例


代码块
{
    "status": "Failed",
    "errors": [
        {
            "code": 100009,
            "message": "Order 13344389 not found"
        }
    ],
    "data": [
        {
            "status": "Failure",
            "errors": [
                {
                    "code": 100009,
                    "message": "Order 13344389 not found"
                }
            ],
            "orderId": "13344389",
            "trackingNo": null
        }
    ]
}



字段描述


订单参考号

字段名

类型

最大长度

描述

codeint
0成功，其他失败
errorsvarchar256查询报错

data



返回信息
data.statusvarchar20该订单查询状态
data.errorsvarchar256该订单查询报错
data.orderNovarchar128查询的订单号
data.detail订单详情数据

data.detail.referenceNo

varchar

128varchar20该订单查询状态
data.errorsvarchar256该订单查询报错
data.orderNovarchar128查询的订单号
data.detail

订单详情数据

data.detail.referenceNo

varchar

128

订单参考号

data.detail.salesIdInteger
销售UserId
data.detail.csIdsList<Integer>
客户userId
data.detail.settlementIdInteger
结算用户userId
data.detail.departmentNamevarchar
部门用户名称
data.detail.shippedDateDate
出库时间
data.detail.referenceNo


data.detail.statusInteger

0: "已创建" 130："待入库"  133: "已入库"

155: "已核重 160: "待装箱" 200: "待出库"

220: "运输中" 300: "已签收"

data.detail.service

varchar

128

所使用服务

data.detail.collectionType

varchar

20

揽收方式，共有“pickup/上门揽收”、“Dropoff/自送到仓”

data.detail.shipper

varchar

512

订单所属客户

data.detail.collectionWarehouse

varchar

255

集货仓代码

data.detail.clearanceType

varchar

10

清关方式

data.detail.platformSource

varchar

50

平台来源

data.detail.platformRefNo

varchar

128

该订单在三方平台的参考号

data.detail.expectedDepartureDate

datetime


期望离港时间格式：yyyy-MM-dd HH:mm:ss

data.detail.insuranceType

varchar

10

保险类型

data.detail.insuranceAmount

double


保险金额

data.detail.remark

text


备注

data.detail.loadingPort

varchar

16

起运港

data.detail.commercialInspection

boolean


是否商检

data.detail.taxRefund

boolean


是否需要退税

data.detail.battery

boolean


货物是否带电

data.detail.magnet

boolean


货物是否带磁

data.detail.declareValue

double


订单申报总金额

data.detail.collectionInfo



揽收信息容器

data.detail.collectionInfo.collectionDate(接口缺失)

datetime


揽收日期

data.detail.collectionInfo.contact(接口缺失)

varchar

512

揽收联系人

data.detail.collectionInfo.phoneNumber(接口缺失)

varchar

20

电话号码

data.detail.collectionInfo.postCode

varchar

32

邮编

data.detail.collectionInfo.country

varchar

10

国家

data.detail.collectionInfo.state

varchar

128

省

data.detail.collectionInfo.city

varchar

128

城市

data.detail.collectionInfo.district

varchar

128

区

data.detail.collectionInfo.addressLine1

varchar

512

地址第一行

data.detail.collectionInfo.addressLine2

varchar

512

地址第二行

data.detail.collectionInfo.addressLine3


data.detail.consigneeInfo



收件人信息

data.detail.consigneeInfo.addressCode(接口缺失)

varchar

27

地址代码

data.detail.consigneeInfo.consignee(接口缺失)

varchar

512

收件人

data.detail.consigneeInfo.company(接口缺失)

varchar

512

公司

data.detail.consigneeInfo.phoneNumber(接口缺失)phoneNumber

varchar

20

电话号码

data.detail.consigneeInfo.postCode

varchar

32

邮编

data.detail.consigneeInfo.email(接口缺失)

varchar

512

邮箱

data.detail.consigneeInfo.country

varchar

10

国家

data.detail.consigneeInfo.state

varchar

128

省

data.detail.consigneeInfo.city

varchar

128

城市

data.detail.consigneeInfo.district

varchar

128

区

data.detail.consigneeInfo.addressLine1

varchar

512

地址第一行

data.detail.consigneeInfo.addressLine2

varchar

512

地址第二行

data.detail.consigneeInfo.addressLine3


data.detail.cartonInfo

list


箱子信息

data.detail.cartonInfo[].ctnNo

varchar

128

箱号

data.detail.cartonInfo[].weight

double


单箱重量

data.detail.cartonInfo[].totalWeight

double


总重量

data.detail.cartonInfo.[]width

double


箱宽度

data.detail.cartonInfo[].height

double


箱高度

data.detail.cartonInfo[].length

double


箱长度

data.detail.cartonInfo[].amount

int


箱数

data.detail.cartonInfo[].declareAmount

int


申报箱数

data.detail.cartonInfo[].declareDemension

varchar

256

申报尺寸，格式为“xx*xx*xx”

data.detail.cartonInfo[].declareWeight

float


申报重量

data.detail.cartonInfo[].FBAID

varchar

200

FBA ID

data.detail.cartonInfo[].subOrderNo

varchar

32

子单号

data.detail.cartonInfo[].pONumber

varchar

200

PO number

data.detail.cartonInfo[].remark

varchar

255

备注

data.detail.commodityInfo

list


商品信息

data.detail.commodityInfo[].ctnNo

varchar

128

商品所属箱号

data.detail.commodityInfo[].skuNumber

varchar

128

商品编码

data.detail.commodityInfo[].unitPrice

float


商品单价

data.detail.commodityInfo[].amount

int


单箱商品数

data.detail.commodityInfo[].hsCode

varchar

64

海关编码

data.detail.commodityInfo[].nameCN

varchar

255

商品中文名

data.detail.commodityInfo[].nameEN

varchar

255

商品英文名

data.detail.commodityInfo[].materialCN

varchar

128

商品材质（中文）

data.detail.commodityInfo[].materialEN

varchar

128

商品材质（英文）

data.detail.commodityInfo[].usage

varchar

128

商品用途

data.detail.commodityInfo[].brand

varchar

128

商品品牌

data.detail.commodityInfo[].salesLink

varchar

4000

商品销售链接

data.detail.commodityInfo[].type

varchar

128

商品型号

data.detail.commodityInfo[].pictureLink

varchar

255

商品图片

data.detail.commodityInfo[].fBAID

varchar

200

FBA ID

data.detail.commodityInfo[].pONumber

varchar

200

PO number

data.detail.shipmentInfo

list


运输信息

data.detail.shipmentInfo[].shipmentNo

varchar

128

运单号

data.detail.shipmentInfo[].type

varchar

128

运单类型

data.detail.shipmentInfo[].supplier

varchar

128

运单所属供应商

data.detail.shipmentInfo[].remark

varchar

255

备注

data.detail.shipmentInfo[].blNo

varchar

128

海运提单号，仅运单类型为海运时展示

data.detail.shipmentInfo[].vessel

varchar

255

船名，仅运单类型为海运时展示

data.detail.shipmentInfo[].voyage

varchar

250

航次，仅运单类型为海运时展示

data.detail.shipmentInfo[].loadingPort

varchar

32

起运港，仅运单类型为海运、空运时展示

data.detail.shipmentInfo[].dischargePort

varchar

32

目的港，仅运单类型为海运、空运时展示

data.detail.shipmentInfo[].transshipmentPort

varchar

250

中转港，仅运单类型为海运时展示

data.detail.shipmentInfo[].clearancePort

varchar

32

清关口岸，仅运单类型为海运时展示

data.detail.shipmentInfo[].ETD

datetime


预计出发时间，仅运单类型为海运、空运、陆运时展示

data.detail.shipmentInfo[].ATD

datetime


实际出发时间，仅运单类型为海运、空运、陆运时展示

data.detail.shipmentInfo[].ETA

datetime


预计到达时间，仅运单类型为海运、空运、陆运时展示

data.detail.shipmentInfo[].ATA

datetime


实际到达时间，仅运单类型为海运、空运、陆运时展示

data.detail.shipmentInfo[].carrier

varchar

128

船公司，仅运单类型为海运时展示

传输格式为“船公司名称（船公司代码）”

data.detail.shipmentInfo[].containerType

varchar

128

柜型，仅运单类型为海运时展示

data.detail.shipmentInfo[].containerNo

varchar

128

柜号，仅运单类型为海运时展示

data.detail.shipmentInfo.[]sealNo

varchar

128

封号，仅运单类型为海运时展示

data.detail.shipmentInfo[].mawb

varchar

200

空运主单号，仅运单类型为空运时展示

data.detail.shipmentInfo[].flightNo

varchar

128

航班号，仅运单类型为空运时展示

data.detail.shipmentInfo[].originCountry

varchar

32

始发国，仅运单类型为空运时展示

data.detail.shipmentInfo[].destinationCountry

varchar

32

目的国，仅运单类型为空运时展示

data.detail.shipmentInfo[].route

varchar

128

航线，仅运单类型为空运时展示

data.detail.shipmentInfo[].licensePlate

varchar

128

牌照，仅运单类型为陆运时展示

data.detail.shipmentInfo[].driver

varchar

128

驾驶员，仅运单类型为陆运时展示

data.detail.shipmentInfo[].POD

varchar

128

POD，仅运单类型为陆运时展示

data.detail.shipmentInfo[].ISA

varchar

128

ISA，仅运单类型为陆运时展示

data.detail.shipmentInfo[].trackingNo

varchar

255

跟踪号，仅运单类型为快递时展示

data.detail.salesProfitvarchar255销售利润（CNY）
data.detail.profitvarchar255实际利润（CNY）
data.detail.customerReceivableTaxvarchar255客户价格（CNY）
data.detail.salesReceivableTaxvarchar255销售价格（CNY）
data.detail.sysPeerToStatusint
推送同行状态 1 已推送 2推送失败 0 未推送
data.detail.sysPeerToStatusTimedatetime
推送同行时间
data.detail.sysPeerToStatusErrMessagevarchar255推送同行异常信息