...
...
...
OneFlo postback report includes the following information:
- Connote Information
- Sender and Receiver Details
- Estimated Charges
- User Fields
- Data passed form ERP to OneFlo which include but not limited to:
- Warehouse Codes
- Despatch Person / User Code
- Sales Representative
- any other fields that are relevant from a Logistics/Business perspective
- Data inputted by the User while creating a consignment
- Data passed form ERP to OneFlo which include but not limited to:
- References
...
Overview
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" | ∞ |
...
Available Formats
Type | Advantages | Sample |
---|---|---|
CSV |
| Customer_Daily_20180815190020.csv |
XML |
|
...