Postback - Scan Data

Owned by Dennis Navarro
Last updated: May 24, 2023 by rossc
2 min read



Overview

Scan Data is perfect for tracking where your freight is and if it has been delivered to your customers. Use the Scan Data file to integrate your ERP with EFM's centralized Scan Events.

Field List

Column Name

Definition

Data Type

Format

Length (max)

Column Name

Definition

Data Type

Format

Length (max)

1

TrackingNumber

Consignment Tracking Numbers

  • Some carriers provide item level scanning, in those cases the Item Barcode will appear here.

  • Majority of bulk carriers will only provide consignment-level tracking which in those cases, the Connote number will appear here.

varchar



50

2

ConsignmentNumber

Connote Number

varchar



20

3

Reference

Consignment primary reference

varchar



20

4

StatusDateTime

DateTimestamp of the provider's scan (Assumes provider’s timezone)

date 

YYYYMMDDhhmmss

-

5

ScanEvent

OneFlo Scan Event

varchar

Available on request

10

6

ExtraInfo

Additional Information from Carrier

varchar



50

7

Carrier

Carrier or Scan Event Provider

varchar



50



Scan Events

The granularity / detail of scan events depend on the carrier's capability. Some carriers can provide scan events in greater detail compared to others. Some carriers can also provide scan events on an item level. 

This table contains a list of fundamental scan events. Carriers configured for your account may provide more or less events than the table below, but this gives a comprehensive life-cycle of a consignment.

Scan Event

Definition

Scan Event

Definition

EDI

EDI Record Downloaded

DEPOT

Scanned in Depot

BOOKED IN

Booking Sent To Carrier

ASN

Advance Shipping Notification

PICKUP

Pickup Freight

IN

Into Depot

TRANS

In Transit

OBFD

On Board for Delivery

DEL

Delivered

COD

Confirmation Of Delivery

ATL

Authority to Leave (Delivered without Signature)

POD

Proof of Delivery Available

CONS

Connote Scanned (Generic scan - see Extra Info)



CSV Example

"TrackingNumber","ConsignmentNumber","Reference","StatusDateTime","ScanEvent","ExtraInfo","Carrier" "ALB000002860","ALB000002860","SO-SE2021478","20181024081809","OBFD","Qty:1 of 1@ ABC TAS Pty Ltd","TNT Express" "AKT000001056","AKT000001056","SO-SE2021659","20181024083139","OBFD","Qty:1 of 1@ Spring vale electrical","TNT Express" "AKT000001056","AKT000001056","SO-SE2021659","20181024075943","IN"," @ Spring vale electrical","TNT Express" "AKT000001056","AKT000001056","SO-SE2021659","20181024075941","IN"," @ Spring vale electrical","TNT Express" "AKT000001258","AKT000001258","SO-SE2020868","20181024081709","DEL","Signed by:RECEIVER Qty:1 of 1 @ RECEIVER","TNT Express" "AKT000001258","AKT000001258","SO-SE2020868","20181024081605","IN"," @ RECEIVER","TNT Express" "AKT000001258","AKT000001258","SO-SE2020868","20181024081701","OBFD","Qty:1 of 1@ RECEIVER","TNT Express" "AKT000001260","AKT000001260","SO-SE2021638","20181024083750","IN"," @ Gotham Electrical and Data C/O","TNT Express" "AKT000001260","AKT000001260","SO-SE2021638","20181024084642","OBFD","Qty:1 of 1@ Gotham Electrical and Data C/O","TNT Express" "ALB000002869","ALB000002869","SO-SE2021239","20181024081356","IN"," @ MelbournePty Ltd","TNT Express" "ALB000002869","ALB000002869","SO-SE2021239","20181024084448","OBFD","Qty:1 of 1@ Melbourne Pty Ltd","TNT Express" "BGSO0034","BGSO0034","IF-1042944","20181024080200","IN","","Followmont Transport" "AKT000001265","AKT000001265","IF-1042957","20181024081450","OBFD","Qty:1 of 1 @(ENERGY AWARE PTY LTD)","TNT Express" "ALB000002865","ALB000002865","PO-SE2007513","20181024075955","OBFD","Qty:1 of 1@ Natural Energy Products","TNT Express" "CTSOL075","CTSOL075","IF-1042997","20181024101209","BOOKED IN","Pending","Capital Transport (NSW) Pty Ltd" "CTSOL075","CTSOL075","IF-1042997","20181024101407","ASN","Failed: info@electronics.com.au","Capital Transport (NSW) Pty Ltd" "CTSOL073","CTSOL073","IF-1042990","20181024093728","BOOKED IN","Pending","Capital Transport (NSW) Pty Ltd" "CTSOL073","CTSOL073","IF-1042990","20181024094243","ASN","Failed: Johny.Cheng@kookaburra-distribution.com.au","Capital Transport (NSW) Pty Ltd" "CTSOL074","CTSOL074","SO-SE2021350","20181024093856","BOOKED IN","Pending","Capital Transport (NSW) Pty Ltd" "CTSOL074","CTSOL074","SO-SE2021350","20181024094305","ASN","Failed: accounts@store.com.au","Capital Transport (NSW) Pty Ltd" "CTSOL076","CTSOL076","IF-1042992","20181024101630","BOOKED IN","Pending","Capital Transport (NSW) Pty Ltd" "CTSOL076","CTSOL076","IF-1042992","20181024101928","ASN","Failed: test@kookaburra-distribution.com.au","Capital Transport (NSW) Pty Ltd"



XML Example

Sample_Scan_Report.xml
<?xml version="1.0" encoding="US-ASCII"?> <Scans> <ScanEvent> <TrackingNumber>ALB000002860</TrackingNumber> <!-- typically item level when carrier provides (as printed on barcode) --> <ConsignmentNumber>ALB000002860</ConsignmentNumber> <Reference>SO-SE2021478</Reference> <!-- sales order reference from ERP --> <StatusDateTime>20181024081809</StatusDateTime> <!-- YYYYMMDDhhmmss as per time provided by carrier (time barcode was scanned) --> <ScanEvent>OBFD</ScanEvent> <ExtraInfo>Qty:1 of 1@ ABC TAS Pty Ltd</ExtraInfo> <!-- Extra Information as provided by carrier --> <Carrier>TNT Express</Carrier> </ScanEvent> </Scans>



Sample

Customer_Scans_20181024102004.csv