...
字段名 | 类型 | 描述 |
event.eventdetail | 事件详情 | |
event.eventdetail.activity | varchar | 事件名称 |
event.eventdetail.city | varchar | 事件发生城市 |
event.eventdetail.code | varchar | 事件代码 |
event.eventdetail.country | varchar | 事件发生国家 |
event.eventdetail.eventTime | datetime | 事件时间，精确到分 |
event.eventdetail.orderNo | varchar | 订单号 |
event.eventdetail.referenceNo | varchar | 订单参考号 |
event.eventdetail.remark | varchar | 事件备注 |
事件代码
| CODE | 中文描述 | 英文描述 |
|---|---|---|
| 1000 | 采购订单创建成功 | PO Created |
| 1010 | 运输计划创建成功 | Shipping Plan Created |
| 1020 | 订单创建 | Order Created |
| 2020 | 订单审核成功 | Order Validation Successful |
| 2025 | 订单审核失败 | Order Validation Failed |
| 2030 | 到达国内仓 | Arrive at Warehouse |
| 2033 | 入库扫描 | Dispatch Scan |
| 2035 | 已核重 | Measurement Complete |
| 2040 | 订单查验完成 | Inspection Finished |
| 2043 | 订单拆单 | Split Order |
| 2045 | 已装柜 | Loading finished |
| 2046 | 运单生成 | manifest create |
| 2047 | 出库扫描 | Delivery Scan |
| 2049 | 出口报关放行 | Export Customs Cleared |
| 2050 | 出口报关完成 | Export Customs Clearance |
| 2060 | 出库 | Outbound |
| 2065 | 出库 | Shipped |
| 2070 | 离开始发国 | Leave Port of Departure |
| 2071 | 离开中转港 | Leave the transit port |
| 2075 | 货物装运出港 | Shipment departure |
| 2077 | 货物抵达目的港 | Arrive at the port of destination |
| 2078 | 到达中转港 | Arrive at the port of transit |
| 2080 | 到达目的国 | Arrive at Port of Destination |
| 2090 | 进口清关完成 | Import Customs Clearance |
| 2093 | 到达中转仓 | Arrive at Transit Warehouse |
| 2095 | 拼单拆分完成 | Container Devanning |
| 2110 | 离开中转仓 | Leave Transit Warehouse |
| 2113 | 尾程派送中 | Delivery in Progress |
| 2115 | 运单完成 | Shipment Complete |
| 2120 | 妥投签收 | Delivered |
| 2130 | 已到仓 | Delivered |
| 2135 | 部分上架 | Partially Put Away |
| 2140 | 已上架 | Put Away |
| 2210 | 开始装柜 | Start Loading |
| 2220 | 港口交运 | Transfer to Lastmile |
| 2230 | 扫描完成 | Scan Completed |
| 2240 | 提柜 | Pick up empty |
| 2300 | 已提柜 | Pick-up FCL Carton |
| 9010 | 妥投异常 | Abnormal Warehouse Inbound |
| 9020 | 出口报关异常 | Abnormal Export Declaration |
| 9030 | 进口清关异常 | Abnormal Import Declaration |
| 9040 | 国际运输异常 | Abnormal Linehual |
| 9050 | 其他异常 | Other Abnormal |
| 9060 | 运输中 | In Transit |
| 9999 | 对接event | In Transit |
| 2055 | 起运港码头运抵 | Arrival Port of Loading |
| 2045_AIR | 已打托 | Assigned |
| 2045_EXPRESS | 已交付 | Picked up |