Objectives
OneFlo Postback report aims to eliminate manual data entry, providing an end of day report of all manifested consignments that have been performed in OneFlo within the last 24 hours.
While the defined service is for Manifested Consignments to be sent once per day, this is customize able upon internal review and advanced scoping session.
.
How does Postback work?
Standard Postback Report
- The EFM team configure the Postback service to provide a report of all manifested Consignments at the end of the day.
- The Information to the right are the columns provided within the report.
- The Report can be sent by email to required recipients, or placed in a directory by FTP
Data Provided
| 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" | ∞ |