| Table of Contents |
|---|
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.
| Info |
|---|
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 ERP provider Leaves a File with consignment Information on the Client's Server.
- File Must Be.
- CSV/XML Format
- Contain the order file Information listed below
- Limited to one file per Order
- File Must Be.
- EFM Installs a Service on the Client's Server to Pick up this File and send it to our Message Transmitter Service which transforms this File into a standard Message that OneFlo can interpret.
- Customer uses OneFlo UI to "Look up" the consignment that can now be found within the system.
Custom Postback Report
- The ERP provider sends an XML Payload of all required data, to a custom API End Point.
- This Payload must meet OneFlo information requirements perfectly.
- Customer uses OneFlo UI to "Look up" the consignment that can now be found within the system.
| title | WARNING |
|---|
- 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" | ∞ |