...
...
Data Provided
OneFlo postback report includes the following information:
...
| Expand |
|---|
| title | Expand to see default columns... |
|---|
|
| 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 | Sender | Sender Name | varchar |
| 50 |
|---|
| 7 | SAddress1 | Sender Address Line 1 | varchar |
| 30 |
|---|
| 8 | SAddress2 | Sender Address Line 2 | varchar |
| 30 |
|---|
| 9 | SLocality | Sender Locality / Suburb | varchar |
| 50 |
|---|
| 10 | SState | Sender State | varchar |
| 5 |
|---|
| 11 | SPCode | Sender Postcode | varchar |
| 10 |
|---|
| 12 | Receiver | Receiver Name | varchar |
| 50 |
|---|
| 13 | RAddress1 | Receiver Address Line 1 | varchar |
| 30 |
|---|
| 14 | RAddress2 | Receiver Address Line 2 | varchar |
| 30 |
|---|
| 15 | RLocality | Receiver Locality / Suburb | varchar |
| 50 |
|---|
| 16 | RState | Receiver State | varchar |
| 5 |
|---|
| 17 | RPCode | Receiver Postcode | varchar |
| 10 |
|---|
| 18 | Items | Total number of Items | int |
| - |
|---|
| 19 | Weight | Total Weight | float |
| - |
|---|
| 20 | Volume | Total volume | float |
| - |
|---|
| 21 | Time | Total Time (if captured) | float |
| - |
|---|
| 22 | Distance | Total Distance (if captured) | float |
| - |
|---|
| 23 | ZoneFrom | Carrier Zone From | varchar |
| 10 |
|---|
| 24 | ZoneTo | Carrier Zone To | varchar |
| 10 |
|---|
| 25 | Freight | Basic Freight Charge | money |
| - |
|---|
| 26 | Fees | Fees Charge | money |
| - |
|---|
| 27 | Net | Net Charge | money |
| - |
|---|
| 28 | GST | Tax | money |
| - |
|---|
| 29 | Total | Total Freight Charge (Freight+Fees+GST) | money |
| - |
|---|
| 30 | UserField1 | User defined field #1 | varchar |
| 20 |
|---|
| 31 | UserField2 | User defined field #2 | varchar |
| 20 |
|---|
| 32 | UserField3 | User defined field #3 | varchar |
| 20 |
|---|
| 33 | UserField4 | User defined field #4 | varchar |
| 20 |
|---|
| 34 | UserField5 | User defined field #5 | varchar |
| 20 |
|---|
| 35 | References | Additional References | comma-delimited varchar | "ref1,ref2,ref3" | ∞ |
|---|
|
Sample Formats
| Type | Advantages | Sample |
|---|
| CSV | - Useful for basic consignment level reporting
- Readable in Spreadsheet applications such as Microsoft Excel
- Human friendly
| Customer_Daily_20180815190020.csv |
| XML | - Robust data structure
- Easily imported into ERP or WMS or vital systems relevant for freight reporting
| |
...