Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 7
Next »
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.
.
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 is generated nightly (as a recommendation) in order to capture all consignments created during the despatching day. Reports are produced as a delta of consignments from the previous reporting period.
- The report can be sent by the following methods:
- SFTP
- FTP
- Email to a select set of e-mail recipients
Data Provided
OneFlo postback report includes the following information:
- Connote Information
- Sender and Receiver Details
- Estimated Charges
- User Fields and References
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" | ∞ |
|---|
Postback Formats
OneFlo can generate files in 2 different type of Postback 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
| |