版本比较

标识

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

...

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": [
        {
            "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
        }
    ]
}



字段描述


箱号申报尺寸,格式为“xx*xx*xx”12825525032shipmentInfo.destinationCountry目的国,仅运单类型为空运时展示shipmentInfo.route航线,仅运单类型为空运时展示shipmentInfo.licensePlate牌照,仅运单类型为陆运时展示shipmentInfo.driver驾驶员,仅运单类型为陆运时展示shipmentInfo.PODshipmentInfo.ISAvarcharISA,仅运单类型为陆运时展示shipmentInfo.trackingNo跟踪号,仅运单类型为快递时展示

字段名

类型

最大长度

描述

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

data



返回信息
data.statusvarchar20该订单查询状态
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

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

128256

申报尺寸,格式为“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

256128

商品编码

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


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

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

data.detail.shipmentInfo[].vesselATD

varchardatetime


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

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

data.detail.shipmentInfo[].voyageETA

varchardatetime


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

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

data.detail.shipmentInfo[].loadingPortATA

varchardatetime


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

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

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.salesProfitvarchar32255销售利润(CNY)
data.detail.profitvarchar128255实际利润(CNY)
data.detail.customerReceivableTaxvarchar128255客户价格(CNY)
data.detail.salesReceivableTaxvarchar128255销售价格(CNY)
data.detail.sysPeerToStatus

varchar

128

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

int
推送同行状态 1 已推送 2推送失败 0 未推送
data.detail.sysPeerToStatusTimedatetime128
推送同行时间
data.detail.sysPeerToStatusErrMessagevarchar255推送同行异常信息