Flat File subscriptions allow users to receive all truck gate events for a specific SCAC. You can request a subscription by sending an email to mhiggins@vit.org. Please specify either an Email address or an FTP address to which the files should be sent, as well as the frequency at which they should be sent (e.g. once per hour, once per day, etc).
The files are CSV formatted.
Layout - V1
Record Id
Unique identifier for event.
File Type/User
"DCXXX" DC Deliver Chassis
"DDXXX" DD Deliver Domestic
"DEXXX" DE Deliver Export
"DIXXX" DI Deliver Import
"DMXXX" DM Delivery Empty
"RCXXX" RC Receive Chassis
"RDXXX" RD Receive Domestic
"REXXX" RE Receive Export
"RMXXX" RM Receive Empty
(XXX is user id)
Activity
"GATE OUT" (DC) bare chassis
"FULL OUT" (DI) (DE) (DD)
"EMPTY OUT" (DM)
"GATE IN" (RC) bare chassis
"FULL IN" (RE) (RD)
"EMPTY IN" (RM)
Activity Date Completion
YYYYMMDD
Activity Time Completion
HHMM
Unit Number
Chassis Number
ISO code
Steamship Line Scac
Status
"E" Empty
"F" Full
Category
"E" Export
"I" Import
"M" Empty
Unit Status
"CC" container on chassis
"CN" container only
"CH" chassis only
Bill of Lading
Booking
Vessel Lloyds Code
Vessel Name
Voyage Number
Seal 1
Seal 2
Trucker
SCAC of trucker (normally)
Gross weight
Gross units
"LB" pounds
"KG" Kilos
Temperature
Temperature Units
"C" Celsius
"F" Farenheit
Port (Domestic)
Schedule D/K Code
Port Name
Port (Foreign)
Schedule D/K Code
Port Name
License Nbr
Truck License Number
Tag ID
Identification tag of carrier/trucker
Trucker
Trucker Name
Chassis Accessory Nbr
Container Accessory Nbr
Hazardous IMDG Code
Hazardous UNDG Nbr
PIN
Tare weight
Tare units
"LB" pounds
"KG" Kilos
Layout - V1
| Column | Field |
|---|---|
| 01 | Record Id |
| 02 | File Type/User |
| 03 | Activity |
| 04 | Activity Date Completion |
| 05 | Activity Time Completion |
| 06 | Unit Number |
| 07 | Chassis Number |
| 08 | ISO code |
| 09 | Steamship Line Scac |
| 10 | Status |
| 11 | Category |
| 12 | Unit Status |
| 13 | Bill of Lading |
| 14 | Booking |
| 15 | Vessel Lloyds Code |
| 16 | Vessel Name |
| 17 | Voyage Number |
| 18 | Seal 1 |
| 19 | Seal 2 |
| 20 | Trucker |
| 21 | Gross weight |
| 22 | Gross units |
| 23 | Temperature |
| 24 | Temperature Units |
| 25 | Port (Domestic) |
| 26 | Port Name |
| 27 | Port (Foreign) |
| 28 | Port Name |
| 29 | License Nbr |
| 30 | Tag ID |
| 31 | Trucker |
| 32 | Chassis Accessory Nbr |
| 33 | Container Accessory Nbr |
| 34 | Hazardous IMDG Code |
| 35 | Hazardous UNDG Nbr |
| 36 | PIN |
| 37 | Tare weight |
| 38 | Tare units |