...
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个订单。
样例:
{ |
返回内容
成功样例
...
| 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" : 12283, "SH warehouse "salesUserName" : "测试销售", "clearanceTypedetail": "customs{ declaraton", "platformSourcereferenceNo": "eBayorder1", "platformRefNoservice": "order1CN-US", "expectedDepartureDatecollectionType": "2024-03-15pick up", "insuranceTypeshipper": "Noshipper needname", "csIds": [20658,20653], "salesId": 20658, "spettlementId": "insuranceAmount20658, "shipper": 0"shipper name", "remarkcollectionWarehouse": "testSH orderwarehouse", "loadingPortclearanceType": "CNSHAcustoms declaraton", "commercialInspectionplatformSource": 0"eBay", "taxRefundplatformRefNo": 0"order1", "batteryexpectedDepartureDate": 0"2024-03-15", "magnetinsuranceType": "No 0need", "declareValueinsuranceAmount": 1000, "collectionInforemark": { "test order", "collectionDateloadingPort": "2024-03-15CNSHA", "contactcommercialInspection": "Alex"0, "phoneNumbertaxRefund": "15000695273"0, "zipCodebattery": "100006"0, "countrymagnet": "CN"0, "provincedeclareValue": "Shanghai", 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)", "addressLine2email": "", } "country": "US", "cartonInfoprovince": ["CA", { "city": "Valley", "ctnNodistrict": "1", "weightaddressLine1": 1,"Golden State FC LLC 24300 Nandina Ave Moreno Valley, CA 92551 US (ONT8)", "totalWeight": 100, "addressLine2": "" "width": 100}, "cartonInfo": [ "height": 100, { "length": 100, "ctnNo": "1", "amount "weight": 1001, "declareAmounttotalWeight": 50100, "declareDemensionwidth": "20*20*20"100, "declareWeightheight": 1100, "FBAIDlength": "FBA01"100, "subOrderNoamount": "Order1-1"100, "PONumberdeclareAmount": ""50, "remarkdeclareDemension": "20*20*20", } "declareWeight": 1, { "FBAID": "FBA01", "ctnNosubOrderNo": "2Order1-1", "weightPONumber": 2"", "totalWeightremark": 50,"" "width": 100}, "height": 100,{ "lengthctnNo": 100"2", "amountweight": 252, "declareAmounttotalWeight": 50, "declareDemensionwidth": "20*20*20"100, "declareWeightheight": 1100, "FBAIDlength": "FBA01"100, "subOrderNoamount": "Order1-2"25, "PONumberdeclareAmount": ""50, "remarkdeclareDemension": "20*20*20", } "declareWeight": 1, ], "FBAID": "FBA01", "commodityInfo": [ {"subOrderNo": "Order1-2", "ctnNoPONumber": "1", "skuNumberremark": "sku01", } "unitPrice": 10, ], "amount": 100, "commodityInfo": [ "hsCode": "2501001100",{ "nameCNctnNo": "车辆1", "nameENskuNumber": "Carsku01", "materialCNunitPrice": "金属"10, "materialENamount": "metal"100, "usagehsCode": "transport2501001100", "brandnameCN": "null车辆", "salesLinknameEN": "https://www.walltechsystem.cn/Car", "typematerialCN": "金属", "pictureLinkmaterialEN": "https://www.walltechsystem.cn/metal", "FBAIDusage": "transport", "PONumberbrand": "null", }, "salesLink": "https://www.walltechsystem.cn/", { "type": "", "ctnNo": "2", "pictureLink": "https://www.walltechsystem.cn/", "skuNumber "FBAID": "sku02", "unitPricePONumber": 10,"" "amount": 100}, { "hsCode": "2501001101", "nameCNctnNo": "车辆2", "nameENskuNumber": "Carsku02", "materialCNunitPrice": "金属"10, "materialENamount": "metal"100, "usagehsCode": "transport2501001101", "brandnameCN": "null车辆", "salesLinknameEN": "https://www.walltechsystem.cn/Car", "typematerialCN": "金属", "pictureLinkmaterialEN": "https://www.walltechsystem.cn/metal", "FBAIDusage": "transport", "PONumberbrand": "null", } "salesLink": "https://www.walltechsystem.cn/", ], "type": "", "shipmentInfo": [ {"pictureLink": "https://www.walltechsystem.cn/", "shipmentNoFBAID": "METO2403150089S", "typePONumber": "Sea", } "blNo": "jwsea20240315170003", ], "vessel": "MAERSK SEBAROK", "shipmentInfo": [ "voyage": "409S",{ "loadingPortshipmentNo": "CNYTNMETO2403150089S", "dischargePorttype": "AUSYDSea", "transshipmentPortblNo": "jwsea20240315170003", "clearancePortvessel": "MAERSK SEBAROK", "ETDvoyage": "2020-08-16T13:47:12+0800409S", "ATDloadingPort": "2020-08-16T13:47:12+0800CNYTN", "ETAdischargePort": "2020-08-16T13:47:12+0800",AUSYD", "ATAtransshipmentPort": "2020-08-16T13:47:12+0800", "supplierclearancePort": "Shanghai Transport", "carrierETD": "Maersk2020-08-16T13:47:12+0800", "containerTypeATD": "40HQ2020-08-16T13:47:12+0800", "containerNoETA": "012020-08-16T13:47:12+0800", "sealNoATA": "012020-08-16T13:47:12+0800", "remarksupplier": "" Shanghai Transport", } "carrier": "Maersk", { "containerType": "40HQ", "shipmentNocontainerNo": "METO2403150082A01", "typesealNo": "Air01", "mawbremark": "112-BZAIR20240315160000"," }, "flightNo": "CA017", { "loadingPortshipmentNo": "SHAMETO2403150082A", "dischargePorttype": "ORDAir", "originCountrymawb": "CN112-BZAIR20240315160000", "destinationCountryflightNo": "USCA017", "ETDloadingPort": "2020-08-16T13:47:12+0800SHA", "ATDdischargePort": "2020-08-16T13:47:12+0800ORD", "ETAoriginCountry": "2020-08-16T13:47:12+0800CN", "ATAdestinationCountry": "2020-08-16T13:47:12+0800US", "supplierETD": "Shanghai Transport2020-08-16T13:47:12+0800", "routeATD": "2020-08-16T13:47:12+0800", "remarkETA": "" 2020-08-16T13:47:12+0800", }, {"ATA": "2020-08-16T13:47:12+0800", "shipmentNosupplier": "METO2403150086TShanghai Transport", "typeroute": "Land", "blNoremark": "BZLAND20240315170000", }, "licensePlate": "沪B 95899", { "driver": "李师傅", "shipmentNo": "METO2403150086T", "ETD "type": "2020-08-16T13:47:12+0800Land", "ATDblNo": "2020-08-16T13:47:12+0800BZLAND20240315170000", "ETAlicensePlate": "2020-08-16T13:47:12+0800沪B 95899", "ATAdriver": "2020-08-16T13:47:12+0800李师傅", "supplierETD": "Shanghai Transport2020-08-16T13:47:12+0800", "PODATD": "2020-08-16T13:47:12+0800", "ISAETA": "2020-08-16T13:47:12+0800", "remarkATA": "2020-08-16T13:47:12+0800", }, "supplier": "Shanghai Transport", { "shipmentNo"POD": "METO2403150088E", "typeISA": "Express", "trackingNoremark": "BZEXPRESS20240315170000", }, "supplier": "Shanghai Transport", { "remark": "" "shipmentNo": "METO2403150088E", } ] "type": "Express", } } ] } |
失败样例
| 代码块 |
|---|
{ "statustrackingNo": "FailedBZEXPRESS20240315170000", "errors": [ { "codesupplier": 100009"Shanghai Transport", "message": "Order 13344389 not found" }"remark": "" ], "data": [ { } "status": "Failure", ] "errors": [ } } ] } |
失败样例
| 代码块 |
|---|
{
"status": "Failed",
"errors": [
{
"code": 100009, "code": 100009,
"message": "Order 13344389 not found"
}
],
} "data": [
{
], "orderIdstatus": "13344389Failure",
"trackingNoerrors": 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.postCode
...
varchar
...
邮编
...
data.detail.collectionInfo.country
...
varchar
...
国家
...
data.detail.collectionInfo.state
...
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.postCode
...
varchar
...
邮编
...
data.detail.consigneeInfo.email
...
varchar
...
邮箱
...
data.detail.consigneeInfo.country
...
varchar
...
国家
...
data.detail.consigneeInfo.state
...
varchar
...
省
...
data.detail.consigneeInfo.city
...
varchar
...
城市
...
data.detail.consigneeInfo.district
...
varchar
...
区
...
data.detail.consigneeInfo.addressLine1
...
varchar
...
地址第一行
...
data.detail.consigneeInfo.addressLine2
...
varchar
...
地址第二行
...
data.detail.cartonInfo
...
list
...
"code": 100009,
"message": "Order 13344389 not found"
}
],
"orderId": "13344389",
"trackingNo": null
}
]
} |
字段描述
字段名 | 类型 | 最大长度 | 描述 | ||||
| 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[].ctnNodeclareDemension | varchar | 128 | 箱号256 | 申报尺寸,格式为“xx*xx*xx” | |||
data.detail.cartonInfo[].weightdeclareWeight | doublefloat | 单箱重量申报重量 | |||||
data.detail.cartonInfo[].totalWeightFBAID | varchardouble | 200 | 总重量FBA ID | ||||
data.detail.cartonInfo.[]width | double | 箱宽度.subOrderNo | varchar | 32 | 子单号 | ||
data.detail.cartonInfo[].heightpONumber | varchardouble | 200 | 箱高度PO number | ||||
data.detail.cartonInfo[].lengthremark | varchardouble | 255 | 箱长度备注 | ||||
data.detail.cartonInfo[].amount | int | 箱数commodityInfo | list | 商品信息 | |||
data.detail.cartonInfocommodityInfo[].declareAmountctnNo | varcharint | 128 | 申报箱数商品所属箱号 | ||||
data.detail.cartonInfocommodityInfo[].declareDemensionskuNumber | varchar | 256 | 申报尺寸,格式为“xx*xx*xx”128 | 商品编码 | |||
data.detail.cartonInfocommodityInfo[].declareWeightunitPrice | float | 申报重量商品单价 | |||||
data.detail.cartonInfocommodityInfo[].FBAIDamount | varchar | 200 | FBA IDint | 单箱商品数 | |||
data.detail.cartonInfocommodityInfo[].subOrderNohsCode | varchar | 3264 | 子单号海关编码 | ||||
data.detail.cartonInfocommodityInfo[].pONumbernameCN | varchar | 200255 | PO number商品中文名 | ||||
data.detail.cartonInfocommodityInfo[].remarknameEN | varchar | 255 | 备注商品英文名 | ||||
data.detail.commodityInfo | 商品信息 | data.detail.commodityInfo.ctnNo[].materialCN | varchar | 128 | 商品所属箱号商品材质(中文) | ||
data.detail.commodityInfo[].skuNumbermaterialEN | varchar | 128 | 商品编码商品材质(英文) | ||||
data.detail.commodityInfo[].unitPriceusage | varcharfloat | 128 | 商品单价商品用途 | ||||
data.detail.commodityInfo[].amountbrand | varcharint | 128 | 单箱商品数商品品牌 | ||||
data.detail.commodityInfo[].hsCodesalesLink | varchar | 644000 | 海关编码商品销售链接 | ||||
data.detail.commodityInfo[].nameCNtype | varchar | 255128 | 商品中文名商品型号 | ||||
data.detail.commodityInfo[].nameENpictureLink | varchar | 255 | 商品英文名商品图片 | ||||
data.detail.commodityInfo[].materialCNfBAID | varchar | 128200 | 商品材质(中文)FBA ID | ||||
data.detail.commodityInfo[].materialENpONumber | varchar | 128200 | 商品材质(英文)PO number | ||||
data.detail.commodityInfo.usageshipmentInfo | varcharlist | 128 | 商品用途运输信息 | ||||
data.detail.commodityInfoshipmentInfo[].brandshipmentNo | varchar | 128 | 商品品牌运单号 | ||||
data.detail.commodityInfoshipmentInfo[].salesLinktype | varchar | 4000128 | 商品销售链接运单类型 | ||||
data.detail.commodityInfoshipmentInfo[].typesupplier | varchar | 128 | 商品型号运单所属供应商 | ||||
data.detail.commodityInfoshipmentInfo[].pictureLinkremark | varchar | 255 | 商品图片备注 | ||||
data.detail.commodityInfoshipmentInfo[].FBAIDblNo | varchar | 200128 | FBA ID海运提单号,仅运单类型为海运时展示 | ||||
data.detail.commodityInfoshipmentInfo[].PONumbervessel | varchar | 200255 | PO number船名,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo | list | 运输信息[].voyage | varchar | 250 | 航次,仅运单类型为海运时展示 | ||
data.detail.shipmentInfo[].shipmentNoloadingPort | varchar | 12832 | 运单号起运港,仅运单类型为海运、空运时展示 | ||||
data.detail.shipmentInfo[].typedischargePort | varchar | 12832 | 运单类型目的港,仅运单类型为海运、空运时展示 | ||||
data.detail.shipmentInfo[].suppliertransshipmentPort | varchar | 128250 | 运单所属供应商中转港,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].remarkclearancePort | varchar | 25532 | 备注清关口岸,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].blNoETD | varchardatetime | 128预计出发时间,仅运单类型为海运、空运、陆运时展示 | 海运提单号,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].vesselATD | varchardatetime | 255实际出发时间,仅运单类型为海运、空运、陆运时展示 | 船名,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].voyageETA | varchardatetime | 250预计到达时间,仅运单类型为海运、空运、陆运时展示 | 航次,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].loadingPortATA | varchardatetime | 32实际到达时间,仅运单类型为海运、空运、陆运时展示 | 起运港,仅运单类型为海运、空运时展示 | ||||
data.detail.shipmentInfoshipmentInfo[].dischargePortcarrier | varchar | 12832 | 船公司,仅运单类型为海运时展示 目的港,仅运单类型为海运、空运时展示传输格式为“船公司名称(船公司代码)” | ||||
data.detail.shipmentInfo[].transshipmentPortcontainerType | varchar | 250128 | 中转港,仅运单类型为海运时展示柜型,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo[].clearancePortcontainerNo | varchar | 32128 | 清关口岸,仅运单类型为海运时展示柜号,仅运单类型为海运时展示 | ||||
data.detail.shipmentInfo.ETD | datetime | 预计出发时间,仅运单类型为海运、空运、陆运时展示[]sealNo | varchar | 128 | 封号,仅运单类型为海运时展示 | ||
data.detail.shipmentInfo[].ATDmawb | varchardatetime | 200 | 实际出发时间,仅运单类型为海运、空运、陆运时展示空运主单号,仅运单类型为空运时展示 | ||||
data.detail.shipmentInfo[].ETAflightNo | varchardatetime | 128 | 预计到达时间,仅运单类型为海运、空运、陆运时展示航班号,仅运单类型为空运时展示 | ||||
data.detail.shipmentInfo[].ATAoriginCountry | varchardatetime | 32 | 实际到达时间,仅运单类型为海运、空运、陆运时展示始发国,仅运单类型为空运时展示 | ||||
data.detail.shipmentInfo[].carrierdestinationCountry | varchar | 12832 | 船公司,仅运单类型为海运时展示目的国,仅运单类型为空运时展示 传输格式为“船公司名称(船公司代码)” | ||||
data.detail.shipmentInfo[].containerTyperoute | varchar | 128 | 柜型,仅运单类型为海运时展示航线,仅运单类型为空运时展示 | ||||
data.detail.shipmentInfo[].containerNolicensePlate | varchar | 128 | 柜号,仅运单类型为海运时展示牌照,仅运单类型为陆运时展示 | ||||
data.detail.shipmentInfoshipmentInfo[].sealNodriver | varchar | 128 | 封号,仅运单类型为海运时展示驾驶员,仅运单类型为陆运时展示 | ||||
data.detail.shipmentInfo[].mawbPOD | varchar | 200128 | 空运主单号,仅运单类型为空运时展示POD,仅运单类型为陆运时展示 | ||||
data.detail.shipmentInfo[].flightNoISA | varchar | 128 | 航班号,仅运单类型为空运时展示ISA,仅运单类型为陆运时展示 | ||||
data.detail.shipmentInfo[].originCountrytrackingNo | varchar | 32255 | 始发国,仅运单类型为空运时展示跟踪号,仅运单类型为快递时展示 | ||||
| data.detail. | shipmentInfo.destinationCountrysalesProfit | varchar | 32255 | 目的国,仅运单类型为空运时展示销售利润(CNY) | |||
| data.detail. | shipmentInfo.routeprofit | varchar | 128255 | 航线,仅运单类型为空运时展示实际利润(CNY) | |||
| data.detail. | shipmentInfo.licensePlatecustomerReceivableTax | varchar | 128255 | 牌照,仅运单类型为陆运时展示客户价格(CNY) | |||
| data.detail. | shipmentInfo.driversalesReceivableTax | varchar | 128255 | 驾驶员,仅运单类型为陆运时展示销售价格(CNY) | |||
| data.detail. | shipmentInfo.PODsysPeerToStatus | varchar | 128 | POD,仅运单类型为陆运时展示 | int | 推送同行状态 1 已推送 2推送失败 0 未推送 | |
| data.detail. | shipmentInfo.ISAsysPeerToStatusTime | varchardatetime | 128 | ISA,仅运单类型为陆运时展示推送同行时间 | |||
| data.detail. | shipmentInfo.trackingNosysPeerToStatusErrMessage | varchar | 255 | 跟踪号,仅运单类型为快递时展示推送同行异常信息 |