...
sa订单查询
接口描述
通过订单号针对订单信息进行查询。
| HTTP Verb | URL |
|---|---|
| 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"] |
}返回内容
成功样例
...
| language | js |
|---|
...
, |
字段描述
字段名 | 类型 | 最大长度 | 描述 |
trackingNos | List<String> | 订单号:支持批量 | |
startTime | Date | 订单创建时间- 开始（包含该日期） | |
| endTime | Date | 订单创建时间- 结束（不包含该日期） | |
statusList | List<Integer> | 订单状态：支持批量 0 已创建 130 待入库 | |
salesIdList | List<Integer> | 销售列表 | |
shippedDateStart | Date | 出库时间-开始（包含该日期） | |
shippedDateEnd | Date | 出库时间-结束（不包含该日期） | |
shipperIdList | List<Integer> | 发货人列表 | |
| pageNum | Integer | 页码从1开始，默认1 | |
| pageSize | Integer | 每页的数量，默认100 |
返回内容sh
成功样例
| 代码块 | ||
|---|---|---|
| ||
{ "status": "Success", "errors": null, "data": [ { "collectionTypestatus": "pick upSuccess", "shippererrors": "shipper name",null, "orderNo": "JDQ002445001000931503", "status" : 0, "collectionWarehousesalesId" : "SH warehouse", 12283, "salesUserName" : "测试销售", "clearanceTypedetail": "customs{ declaraton", "platformSourcereferenceNo": "eBayorder1", "platformRefNoservice": "order1CN-US", "expectedDepartureDatecollectionType": "2024-03-15pick up", "insuranceTypeshipper": "Noshipper needname", "csIds": [20658,20653], "salesId": 20658, "spettlementId": "insuranceAmount": 020658, "shipper": "shipper name", "remarkcollectionWarehouse": "testSH orderwarehouse", "loadingPortclearanceType": "CNSHAcustoms declaraton", "commercialInspectionplatformSource": 0"eBay", "taxRefundplatformRefNo": 0"order1", "batteryexpectedDepartureDate": 0"2024-03-15", "magnetinsuranceType": 0"No need", "declareValueinsuranceAmount": 1000, "collectionInforemark": { "test order", "collectionDateloadingPort": "2024-03-15CNSHA", "contactcommercialInspection": "Alex", 0, "phoneNumbertaxRefund": "15000695273", 0, "zipCodebattery": "100006", 0, "countrymagnet": "CN"0, "province": "Shanghai", "declareValue": 100, "sysPeerToStatus":0, "sysPeerToStatusTime":"", "sysPeerToStatusErrMessage":"", "citycollectionInfo": "Shanghai",{ "districtcollectionDate": "2024-03-15", "addressLine1contact": "Dalian RoadAlex", "addressLine2phoneNumber": "15000695273", }, "zipCode": "100006", "consigneeInfocountry": {"CN", "addressCodeprovince": "ONT8Shanghai", "consigneecity": "FBAShanghai", "companydistrict": "", "phoneNumberaddressLine1": "Dalian Road", "zipCodeaddressLine2": "92551"," }, "emailconsigneeInfo": "",{ "countryaddressCode": "USONT8", "provinceconsignee": "CAFBA", "citycompany": "Valley", "districtphoneNumber": "", "addressLine1zipCode": "Golden State FC LLC 24300 Nandina Ave Moreno Valley, CA 92551 US (ONT8)92551", "email": "", "addressLine2country": "US", }, "province": "CA", "cartonInfocity": ["Valley", { "district": "", "ctnNoaddressLine1": "1",Golden State FC LLC 24300 Nandina Ave Moreno Valley, CA 92551 US (ONT8)", "weight": 1, "addressLine2": "" "totalWeight": 100}, "cartonInfo": [ "width": 100, { "height "ctnNo": 100"1", "lengthweight": 1001, "amounttotalWeight": 100, "declareAmountwidth": 50100, "declareDemensionheight": "20*20*20"100, "declareWeightlength": 1100, "FBAIDamount": "FBA01"100, "subOrderNodeclareAmount": "Order1-1"50, "PONumberdeclareDemension": "20*20*20", "remarkdeclareWeight": ""1, }, "FBAID": "FBA01", { "subOrderNo": "Order1-1", "ctnNo "PONumber": "2", "weightremark": 2,"" "totalWeight": 50}, { "width": 100, "heightctnNo": 100"2", "lengthweight": 1002, "amounttotalWeight": 2550, "declareAmountwidth": 50100, "declareDemensionheight": "20*20*20"100, "declareWeightlength": 1100, "FBAIDamount": "FBA01"25, "subOrderNodeclareAmount": "Order1-2"50, "PONumberdeclareDemension": "20*20*20", "remarkdeclareWeight": ""1, } "FBAID": "FBA01", ], "subOrderNo": "Order1-2", "commodityInfo": [ {"PONumber": "", "ctnNoremark": "1", } "skuNumber": "sku01", ], "unitPrice": 10, "commodityInfo": [ "amount": 100,{ "hsCodectnNo": "25010011001", "nameCNskuNumber": "车辆sku01", "nameENunitPrice": "Car"10, "materialCNamount": "金属"100, "materialENhsCode": "metal2501001100", "usagenameCN": "transport车辆", "brandnameEN": "nullCar", "salesLinkmaterialCN": "https://www.walltechsystem.cn/金属", "typematerialEN": "metal", "pictureLinkusage": "https://www.walltechsystem.cn/transport", "FBAIDbrand": "null", "PONumbersalesLink": "https://www.walltechsystem.cn/", }, "type": "", { "pictureLink": "https://www.walltechsystem.cn/", "ctnNo "FBAID": "2", "skuNumberPONumber": "sku02", "unitPrice": 10}, { "amount": 100, "hsCodectnNo": "25010011012", "nameCNskuNumber": "车辆sku02", "nameENunitPrice": "Car"10, "materialCNamount": "金属"100, "materialENhsCode": "metal2501001101", "usagenameCN": "transport车辆", "brandnameEN": "nullCar", "salesLinkmaterialCN": "https://www.walltechsystem.cn/金属", "typematerialEN": "metal", "pictureLinkusage": "https://www.walltechsystem.cn/transport", "FBAIDbrand": "null", "PONumbersalesLink": "https://www.walltechsystem.cn/", } "type": "", ], "pictureLink": "https://www.walltechsystem.cn/", "shipmentInfo": [ {"FBAID": "", "shipmentNoPONumber": "METO2403150089S", } "type": "Sea", ], "blNoshipmentInfo": "jwsea20240315170003",[ { "vessel": "MAERSK SEBAROK", "voyageshipmentNo": "409SMETO2403150089S", "loadingPorttype": "CNYTNSea", "dischargePortblNo": "AUSYDjwsea20240315170003", "transshipmentPortvessel": "MAERSK SEBAROK", "clearancePortvoyage": "409S", "ETDloadingPort": "2020-08-16T13:47:12+0800CNYTN", "ATDdischargePort": "2020-08-16T13:47:12+0800AUSYD", "ETAtransshipmentPort": "2020-08-16T13:47:12+0800",", "ATAclearancePort": "2020-08-16T13:47:12+0800", "supplierETD": "Shanghai Transport2020-08-16T13:47:12+0800", "carrierATD": "Maersk2020-08-16T13:47:12+0800", "containerTypeETA": "40HQ2020-08-16T13:47:12+0800", "containerNoATA": "012020-08-16T13:47:12+0800", "sealNosupplier": "01Shanghai Transport", "remarkcarrier": "Maersk", } "containerType": "40HQ", { "containerNo": "01", "shipmentNosealNo": "METO2403150082A01", "typeremark": "Air"," }, "mawb": "112-BZAIR20240315160000", { "flightNoshipmentNo": "CA017METO2403150082A", "loadingPorttype": "SHAAir", "dischargePortmawb": "ORD112-BZAIR20240315160000", "originCountryflightNo": "CNCA017", "destinationCountryloadingPort": "USSHA", "ETDdischargePort": "2020-08-16T13:47:12+0800ORD", "ATDoriginCountry": "2020-08-16T13:47:12+0800CN", "ETAdestinationCountry": "2020-08-16T13:47:12+0800US", "ATAETD": "2020-08-16T13:47:12+0800", "supplierATD": "Shanghai Transport2020-08-16T13:47:12+0800", "routeETA": "2020-08-16T13:47:12+0800", "remarkATA": "2020-08-16T13:47:12+0800", }, "supplier": "Shanghai Transport", { "route": "", "shipmentNoremark": "METO2403150086T"," }, "type": "Land", { "blNoshipmentNo": "BZLAND20240315170000METO2403150086T", "licensePlatetype": "沪B 95899Land", "driverblNo": "李师傅BZLAND20240315170000", "ETDlicensePlate": "2020-08-16T13:47:12+0800沪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
}
]
} |
字段描述
...
字段名
...
类型
...
描述
...
data
...
data.detail.referenceNo
...
varchar
...
订单参考号
...
data.detail.service
...
varchar
...
所使用服务
...
data.detail.collectionType
...
varchar
...
揽收方式，共有“pickup/上门揽收”、“Dropoff/自送到仓”
...
data.detail.shipper
...
varchar
...
订单所属客户
...
data.detail.collectionWarehouse
...
varchar
...
集货仓代码
...
data.detail.clearanceType
...
varchar
...
清关方式
...
data.detail.platformSource
...
varchar
...
平台来源
...
data.detail.platformRefNo
...
varchar
...
该订单在三方平台的参考号
...
data.detail.expectedDepartureDate
...
datetime
...
期望离港时间
...
data.detail.insuranceType
...
varchar
...
保险类型
...
data.detail.insuranceAmount
...
double
...
保险金额
...
data.detail.remark
...
text
...
备注
...
data.detail.loadingPort
...
varchar
...
起运港
...
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
...
揽收联系人
...
data.detail.collectionInfo.phoneNumber
...
varchar
...
电话号码
...
data.detail.collectionInfo.zipCode
...
varchar
...
邮编
...
data.detail.collectionInfo.country
...
varchar
...
国家
...
data.detail.collectionInfo.province
...
varchar
...
省
...
data.detail.collectionInfo.city
...
varchar
...
城市
...
data.detail.collectionInfo.district
...
varchar
...
区
...
data.detail.collectionInfo.addressLine1
...
varchar
...
地址第一行
...
data.detail.collectionInfo.addressLine2
...
varchar
...
地址第二行
...
data.detail.consigneeInfo
...
收件人信息
...
data.detail.consigneeInfo.addressCode
...
varchar
...
地址代码
...
data.detail.consigneeInfo.consignee
...
varchar
...
收件人
...
data.detail.consigneeInfo.company
...
varchar
...
公司
...
data.detail.consigneeInfo.phoneNumber
...
varchar
...
电话号码
...
data.detail.consigneeInfo.zipCode
...
varchar
...
邮编
...
data.detail.consigneeInfo.email
...
varchar
...
邮箱
...
data.detail.consigneeInfo.country
...
varchar
...
国家
...
data.detail.consigneeInfo.province
...
varchar
...
省
...
data.detail.consigneeInfo.city
...
varchar
...
城市
...
data.detail.consigneeInfo.district
...
varchar
...
区
...
data.detail.consigneeInfo.addressLine1
...
varchar
...
地址第一行
...
data.detail.consigneeInfo.addressLine2
...
varchar
...
地址第二行
...
data.detail.cartonInfo
...
箱子信息
...
data.detail.cartonInfo.ctnNo
...
varchar
...
箱号
...
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
...
申报尺寸，格式为“xx*xx*xx”
...
data.detail.cartonInfo.declareWeight
...
float
...
申报重量
...
data.detail.cartonInfo.FBAID
...
varchar
...
FBA ID
...
data.detail.cartonInfo.subOrderNo
...
varchar
...
子单号
...
data.detail.cartonInfo.PONumber
...
varchar
...
PO number
...
data.detail.cartonInfo.remark
...
varchar
...
备注
...
data.detail.commodityInfo
...
商品信息
...
data.detail.commodityInfo.ctnNo
...
varchar
...
商品所属箱号
...
data.detail.commodityInfo.skuNumber
...
varchar
...
商品编码
...
data.detail.commodityInfo.unitPrice
...
float
...
商品单价
...
data.detail.commodityInfo.amount
...
int
...
单箱商品数
...
data.detail.commodityInfo.hsCode
...
varchar
...
海关编码
...
data.detail.commodityInfo.nameCN
...
varchar
...
商品中文名
...
data.detail.commodityInfo.nameEN
...
varchar
...
商品英文名
...
data.detail.commodityInfo.materialCN
...
varchar
...
商品材质（中文）
...
data.detail.commodityInfo.materialEN
...
varchar
...
商品材质（英文）
...
data.detail.commodityInfo.usage
...
varchar
...
商品用途
...
data.detail.commodityInfo.brand
...
varchar
...
商品品牌
...
data.detail.commodityInfo.salesLink
...
varchar
...
商品销售链接
...
data.detail.commodityInfo.type
...
varchar
...
商品型号
...
data.detail.commodityInfo.pictureLink
...
varchar
...
商品图片
...
data.detail.commodityInfo.FBAID
...
varchar
...
FBA ID
...
data.detail.commodityInfo.PONumber
...
varchar
...
PO number
...
data.detail.shipmentInfo
...
运输信息
...
data.detail.shipmentInfo.shipmentNo
...
varchar
...
运单号
...
data.detail.shipmentInfo.type
...
varchar
...
运单类型
...
data.detail.shipmentInfo.supplier
...
varchar
...
运单所属供应商
...
data.detail.shipmentInfo.remark
...
varchar
...
备注
...
data.detail.shipmentInfo.blNo
...
varchar
...
海运提单号，仅运单类型为海运时展示
...
data.detail.shipmentInfo.vessel
...
varchar
...
船名，仅运单类型为海运时展示
...
data.detail.shipmentInfo.voyage
...
varchar
...
航次，仅运单类型为海运时展示
...
data.detail.shipmentInfo.loadingPort
...
varchar
...
起运港，仅运单类型为海运、空运时展示
...
data.detail.shipmentInfo.dischargePort
...
varchar
...
目的港，仅运单类型为海运、空运时展示
...
data.detail.shipmentInfo.transshipmentPort
...
varchar
...
中转港，仅运单类型为海运时展示
...
data.detail.shipmentInfo.clearancePort
...
varchar
...
清关口岸，仅运单类型为海运时展示
...
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
...
船公司，仅运单类型为海运时展示
传输格式为“船公司名称（船公司代码）”
...
data.detail.shipmentInfo.containerType
...
varchar
...
柜型，仅运单类型为海运时展示
...
data.detail.shipmentInfo.containerNo
...
varchar
...
柜号，仅运单类型为海运时展示
...
data.detail.shipmentInfo.sealNo
...
varchar
...
封号，仅运单类型为海运时展示
...
data.detail.shipmentInfo.mawb
...
varchar
...
空运主单号，仅运单类型为空运时展示
...
data.detail.shipmentInfo.flightNo
...
varchar
...
航班号，仅运单类型为空运时展示
...
data.detail.shipmentInfo.originCountry
...
varchar
...
始发国，仅运单类型为空运时展示
...
data.detail.shipmentInfo.destinationCountry
...
varchar
...
目的国，仅运单类型为空运时展示
...
data.detail.shipmentInfo.route
...
varchar
...
航线，仅运单类型为空运时展示
...
data.detail.shipmentInfo.licensePlate
...
varchar
...
牌照，仅运单类型为陆运时展示
...
data.detail.shipmentInfo.driver
...
varchar
...
驾驶员，仅运单类型为陆运时展示
...
data.detail.shipmentInfo.POD
...
varchar
...
POD，仅运单类型为陆运时展示
...
data.detail.shipmentInfo.ISA
...
varchar
...
ISA，仅运单类型为陆运时展示
...
data.detail.shipmentInfo.trackingNo
...
varchar
...
]
} |
字段描述
字段名 | 类型 | 最大长度 | 描述 |
| code | int | 0成功，其他失败 | |
| errors | varchar | 256 | 查询报错 |
data | 返回信息 | ||
| data.status | varchar | 20 | 该订单查询状态 |
| data.errors | varchar | 256 | 该订单查询报错 |
| data.orderNo | varchar | 128 | 查询的订单号 |
| data.detail | 订单详情数据 | ||
data.detail.referenceNo | varchar | 128 | 订单参考号 |
| data.detail.salesId | Integer | 销售UserId | |
| data.detail.csIds | List<Integer> | 客户userId | |
| data.detail.settlementId | Integer | 结算用户userId | |
| data.detail.departmentName | varchar | 部门用户名称 | |
| data.detail.shippedDate | Date | 出库时间 | |
| data.detail.referenceNo | |||
| data.detail.status | Integer | 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 | 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.salesProfit | varchar | 255 | 销售利润（CNY） |
| data.detail.profit | varchar | 255 | 实际利润（CNY） |
| data.detail.customerReceivableTax | varchar | 255 | 客户价格（CNY） |
| data.detail.salesReceivableTax | varchar | 255 | 销售价格（CNY） |
| data.detail.sysPeerToStatus | int | 推送同行状态 1 已推送 2推送失败 0 未推送 | |
| data.detail.sysPeerToStatusTime | datetime | 推送同行时间 | |
| data.detail.sysPeerToStatusErrMessage | varchar | 255 | 推送同行异常信息 |