Overview
Consignment Level Data provides an excellent overview of freight being dispatched and costs incurred. An Excellent resource to integrate into your ERP/WMS, OR to use manually to perform reports and analysis to break down costs and assign them internally.
Receive the all the data we can offer and decide what is right for you. making future development as easy as possible ensuring you always have all your consignment information as stored in your Dispatch platform.
| Column Name | Definition | Data Type | Format | Length (max) | |
|---|---|---|---|---|---|
| 1 | Connote | Consignment Tracking Number | varchar | 20 | |
| 2 | Released | Consignment Release date | date | YYYY-MM-DD | - |
| 3 | Reference | Primary consignment reference | varchar | 20 | |
| 4 | Service | Carrier Service (as defined in OneFlo) | varchar | 10 | |
| 5 | Carrier | Carrier Name (as defined in OneFlo) | varchar | 50 | |
| 6 | Cost Center | Cost Centre (as defined in OneFlo) | varchar | 50 | |
| 7 | Third Party Reference | Cost Centre (as defined in OneFlo) | varchar | 50 | |
| 8 | Sender | Sender Name | varchar | 50 | |
| 9 | SAddress1 | Sender Address Line 1 | varchar | 30 | |
| 10 | SAddress2 | Sender Address Line 2 | varchar | 30 | |
| 11 | SLocality | Sender Locality / Suburb | varchar | 50 | |
| 12 | SState | Sender State | varchar | 5 | |
| 13 | SPCode | Sender Postcode | varchar | 10 | |
| 14 | Receiver | Receiver Name | varchar | 50 | |
| 15 | RAddress1 | Receiver Address Line 1 | varchar | 30 | |
| 16 | RAddress2 | Receiver Address Line 2 | varchar | 30 | |
| 17 | RLocality | Receiver Locality / Suburb | varchar | 50 | |
| 18 | RState | Receiver State | varchar | 5 | |
| 19 | RPCode | Receiver Postcode | varchar | 10 | |
| 20 | Items | Total number of Items | int | - | |
| 21 | Weight | Total Weight | float | - | |
| 22 | Volume | Total volume | float | - | |
| 23 | Time | Total Time (if captured) | float | - | |
| 24 | Distance | Total Distance (if captured) | float | - | |
| 25 | ZoneFrom | Carrier Zone From | varchar | 10 | |
| 26 | ZoneTo | Carrier Zone To | varchar | 10 | |
| 27 | Freight | Basic Freight Charge | money | - | |
| 28 | Fees | Fees Charge | money | - | |
| 29 | Net | Net Charge | money | - | |
| 30 | GST | Tax | money | - | |
| 31 | Total | Total Freight Charge (Freight+Fees+GST) | money | - | |
| 32 | UserField1 | User defined field #1 | varchar | 20 | |
| 33 | UserField2 | User defined field #2 | varchar | 20 | |
| 34 | UserField3 | User defined field #3 | varchar | 20 | |
| 35 | UserField4 | User defined field #4 | varchar | 20 | |
| 36 | UserField5 | User defined field #5 | varchar | 20 | |
| 37 | References | Additional References | comma-delimited varchar | "ref1,ref2,ref3" | ∞ |
Available Formats
| Type | Advantages | Sample |
|---|---|---|
| CSV |
| Customer_Daily_20180815190020.csv |
| XML |
|