Versions Compared

Old Version 8

changes.mady.by.user Dennis Navarro

Saved on

compared with

New Version 9

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 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 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.
  4. The report can be sent by the following methods:
    1. SFTP
    2. FTP
    3. 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
    • 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 
  • References
Expand
titleExpand to see default columns...
Column NameDefinitionData TypeFormatLength (max)1ConnoteConsignment Tracking Numbervarchar202ReleasedConsignment Release datedate YYYY-MM-DD-3ReferencePrimary consignment referencevarchar204ServiceCarrier Service (as defined in OneFlo)varchar105CarrierCarrier Name (as defined in OneFlo)varchar506SenderSender Namevarchar507SAddress1Sender Address Line 1varchar308SAddress2Sender Address Line 2varchar309SLocalitySender Locality / Suburbvarchar5010SStateSender Statevarchar511SPCodeSender Postcodevarchar1012ReceiverReceiver Namevarchar5013RAddress1Receiver Address Line 1varchar3014RAddress2Receiver Address Line 2varchar3015RLocalityReceiver Locality / Suburbvarchar5016RStateReceiver Statevarchar517RPCodeReceiver Postcodevarchar1018ItemsTotal number of Itemsint-19WeightTotal Weightfloat-20VolumeTotal volumefloat-21TimeTotal Time (if captured)float-22DistanceTotal Distance (if captured)float-23ZoneFromCarrier Zone Fromvarchar1024ZoneToCarrier Zone Tovarchar1025FreightBasic Freight Chargemoney-26FeesFees Chargemoney-27NetNet Chargemoney-28GSTTaxmoney-29TotalTotal Freight Charge (Freight+Fees+GST)money-30UserField1User defined field #1varchar2031UserField2User defined field #2varchar2032UserField3User defined field #3varchar2033UserField4User defined field #4varchar2034UserField5User defined field #5varchar2035ReferencesAdditional 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

Sample_Postback_Full.xml