Overview
Below is the standard format for all of the CSV files that are exported from the Hi-Trans System.
Field | Max Length | Example |
---|---|---|
Freightnote Number | 10 | SN1234 |
Freightnote Despatch Date | 10 | 12/12/2012 |
Freightnote Sender's Reference | 12 | SRF12345 |
Status Code | 2 | C = Created |
Status Reference | 10 | MN1242 |
Status Date | 10 | 23/12/2013 |
Status Time | 5 | 08:23 |
The files that are exported from the Hi-Trans system will be received in the below CSV format.
Status Codes
Status Code can be one of the following values:
“C” (Connote Created In Our System)
Status Reference = Blank
Status Date = Blank
Status Time = Blank
“PR" - Pickup Rebooked
Status Reference = Blank
Status Date = Blank
Status Time = Blank
“K” (Pickup Acknowledgement - That It's Been Received By Our System)
Status Reference = Blank
Status Date = Blank
Status Time = Blank
“L” (Pickup Allocated To A Vehicle)
Status Reference = Vehicle Allocated To ID
Status Date = Blank
Status Time = Blank
“P” (Pickup Completed)
Status Reference = Blank
Status Date = Completed Date
Status Time = Completed Time
“PF” (Pickup Futile)
Status Reference = Futile Code
Status Date = Completed Date
Status Time = Completed Time
“PN” (Pickup Completed Signed By Name)
Status Reference = Signed By Name
Status Date = Completed Date
Status Time = Completed Time
“M” (Manifested)
Status Reference = Manifest Number
Status Date = Manifest Date
Status Time = Blank
“A” (Manifest Arrived)
Status Reference = Manifest Number
Status Date = Arrived Date
Status Time = Arrived Time
“R” (Runsheet)
Status Reference = Runsheet Number
Status Date = Runsheet Date
Status Time = Blank
“D” (Delivered)
Status Reference = Delivery ID
Status Date = Delivered Date
Status Time = Delivered Time
“D” (Delivery Futile)
Status Reference = Deilivery Code
Status Date = Delivered Date
Status Time = Delivered Time
“N” (Delivered Name)
Status Reference = Delivered To Name
Status Date = Delivered Date
Status Time = Delivered Time
“T” (Timeslot Date / Time Change)
Status Reference = Blank
Status Date = New Timeslot Date
Status Time = New Timeslot Time
Freightnote Status files exported will be named “FNStatus<date/time stamp>X.csv” where X = a unique identifier for the current export profile.
A file is generated every hour containing ALL status updates that have occurred since the last file and transferred to FTP server.
Sign On Glass - JPG File format
The file will be provided in EMF format with the name of the freightnote as the file name.
POD - TIF File format
The file will be provided in TIFF format with the following fields in the file name.