| Panel | ||||
|---|---|---|---|---|
| ||||
|
...
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.
| View file | ||||
|---|---|---|---|---|
|
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” “DF” (Delivery Futile)
Status Reference = Deilivery Delivery 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 - JPEG File format
The file will be provided in jpeg format with the name of the freightnote as the file name.
POD - TIF, PNG, PDF File format
PODs can be provided in Tiff, PNG, PDF or bmp depending on the source of the POD.
The filename will always end with an underscore and the freightnote number with extension. For example, Freightnote SW12345 will be XXXX_SW12345.tif.
...