Versions Compared

Old Version 3

changes.mady.by.user Steven Reynolds (Unlicensed)

Saved on

compared with

New Version 4

changes.mady.by.user Dennis Navarro

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 customizable upon internal review and advanced scoping session.

.

How does Postback work?

Standard Postback Report

  1. The EFM team configure the Postback service to provide a report of all manifested Consignments at the end of the day.
  2. The Information to the right are the columns provided within the report.
  3. The Report can be sent by email to required recipients, or placed in a directory by FTP



Data Provided

OneFlo postback report includes the following information:

  • Connote Information
  • Sender and Receiver Details
  • Estimated Charges
  • User Fields and References


Expand
titleExpand to see default columns...



Column NameDefinitionData TypeFormatLength (max)
1ConnoteConsignment Tracking Numbervarchar
20
2ReleasedConsignment Release datedate YYYY-MM-DD-
3ReferencePrimary consignment referencevarchar
20
4ServiceCarrier Service (as defined in OneFlo)varchar
10
5CarrierCarrier Name (as defined in OneFlo)varchar
50
6SenderSender Namevarchar
50
7SAddress1Sender Address Line 1varchar
30
8SAddress2Sender Address Line 2varchar
30
9SLocalitySender Locality / Suburbvarchar
50
10SStateSender Statevarchar
5
11SPCodeSender Postcodevarchar
10
12ReceiverReceiver Namevarchar
50
13RAddress1Receiver Address Line 1varchar
30
14RAddress2Receiver Address Line 2varchar
30
15RLocalityReceiver Locality / Suburbvarchar
50
16RStateReceiver Statevarchar
5
17RPCodeReceiver Postcodevarchar
10
18ItemsTotal number of Itemsint
-
19WeightTotal Weightfloat
-
20VolumeTotal volumefloat
-
21TimeTotal Time (if captured)float
-
22DistanceTotal Distance (if captured)float
-
23ZoneFromCarrier Zone Fromvarchar
10
24ZoneToCarrier Zone Tovarchar
10
25FreightBasic Freight Chargemoney
-
26FeesFees Chargemoney
-
27NetNet Chargemoney
-
28GSTTaxmoney
-
29TotalTotal Freight Charge (Freight+Fees+GST)money
-
30UserField1User defined field #1varchar
20
31UserField2User defined field #2varchar
20
32UserField3User defined field #3varchar
20
33UserField4User defined field #4varchar
20
34UserField5User defined field #5varchar
20
35ReferencesAdditional References

comma-delimited

varchar

"ref1,ref2,ref3"∞




Postback Formats

OneFlo can generate files in 2 different type of Postback Formats:


TypeAdvantagesSample
CSV
  1. Useful for basic consignment level reporting
  2. Readable in Spreadsheet applications such as Microsoft Excel
  3. Human friendly
Customer_Daily_20180815190020.csv
XML
  1. Robust data structure
  2. Easily imported into ERP or WMS or vital systems relevant for freight reporting

Customer_Report_20190102130023.xml