Overview
| Tip |
|---|
| 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 |
|
...