Table of Contents

Overview

Excerpt

Tip

Consignment Level Data provides an excellent overview of freight being dispatched and costs incurred. An Excellent resource to integrate into your ERP/WMS, OR to use manually to perform reports and analysis to break down costs and assign them internally.

Receive the all the data we can offer and decide what is right for you. making future development as easy as possible ensuring you always have all your consignment information as stored in your Dispatch platform.

Field List

Field

Definition

Data Type

Format

Length (max)

1

Connote

Consignment Tracking Number

varchartext

20

2

Released

Consignment Release date

date

YYYY-MM-DD

-

3

Reference

Primary consignment reference

varchartext

20

4

Service

Carrier Service (as defined in OneFlo)

varchartext

10

5

Carrier

Carrier Name (as defined in OneFlo)

varchartext

50

6

CostCenter

Cost Centre (as defined in OneFlo) varchar- use OneFlo for best results

text

50

7

Third Party Reference

Cost Centre (as defined Third Party Account provided in OneFlo)

varchartext

50

8

Sender

Sender Name

varchartext

50

9

SAddress1

Sender Address Line 1

varchartext

30

10

SAddress2

Sender Address Line 2

varchartext

30

11

SLocality

Sender Locality / Suburb

varchartext

BRISBANE CITY

50

12

SState

Sender State

varchartext

QLD

5

13

SPCode

Sender Postcode

varchartext

4000

10

14

Receiver

Receiver Name

varchartext

50

15

RAddress1

Receiver Address Line 1

varchartext

30

16

RAddress2

Receiver Address Line 2

varchartext

30

17

RLocality

Receiver Locality / Suburb

varchartext

MELBOURNE

50

18

RState

Receiver State

varchartext

VIC

5

19

RPCode

Receiver Postcode

varchartext

3000

10

20

Items

Total number of Items

int

-

21

Weight

Total Weight

float

-

22

Volume

Total volume

float

-

23

Time

Total Time (if captured)

float

-

24

Distance

Total Distance (if captured)

float

-

25

ZoneFrom

Carrier Zone From

varchartext

10

26

ZoneTo

Carrier Zone To

varchartext

10

27

Freight

Basic Freight Charge

money

-

28

Fees

Fees Charge

money

-

29

Net

Net Charge

money

-

30

GST

Tax

money

-

31

Total

Total Freight Charge (Freight+Fees+GST)

money

-

32

UserField1

User defined field #1

varchartext

20

33

UserField2

User defined field #2

varchartext

20

34

UserField3

User defined field #3

varchartext

20

35

UserField4

User defined field #4

varchartext

20

36

UserField5

User defined field #5

varchartext

20

37

SUs

List of Shipping Units (packages/containers)

stsructured

Code Block

<SU>
        <ItemNo>1</ItemNo>
        <Reference>3180553</Reference>
		<PackageType>CTN</PackageType> <!-- see https://flipgroup.atlassian.net/wiki/spaces/OIUG/pages/961445944/Shipping+Items+-+Packaging+Type for a full list -->
        <Type>CA0030</Type>
        <Weight>21</Weight>
        <Length>40</Length>
        <Width>26</Width>
        <Height>26</Height>
        <Volume>0.027</Volume>
        <Barcode>VCAL009168001</Barcode>
        <Description>Carton Standard</Description>
        <ItemID>VCAL009168001</ItemID>
</SU>

38

References

Additional References

structured

Alternatively in CSV format these can be pipe delimited

∞

3839

ConCatRefs

Additional References (Legacy view)

comma-delimited

varchar

"ref1,ref2,ref3"

40

ETA

Consignment ETA date

date

YYYY-MM-DD

-

XML Structure

This is the standard OneFlo XML Postback structure. We recommend using this as it will have all available dataset against the consignment. It will be up to your system to pick and choose which elements of the consignment element will be imported.

Note
You may download a sample from the Available Formats section to develop your import mechanism.

Code Block

<?xml version="1.0" encoding="us-ascii"?>
<Consignments>
  <Consignment>
    <Connote>VCAL009168</Connote>
    <Consigned>2019-03-04T00:00:00+11:00</Consigned>
    <Released>2019-03-04T00:00:00+11:00</Released>
	<Carrier>Border Express Transport</Carrier>
    <Service>BBEP</Service>
    <Reference>3180553</Reference>
    <Sender>KOALA AUSTRALIA PTY LTD</Sender>
    <SAddress1>22 Kangaroo Drive</SAddress1>
    <SAddress2>
    </SAddress2>
    <SLocality>DANDENONG SOUTH</SLocality>
    <SState>VIC</SState>
    <SPcode>3175</SPcode>
    <SCountryCode>AU</SCountryCode>
    <SCountry>AUSTRALIA</SCountry>
    <SContact>DESPATCH, KOALA</SContact>
    <SPhone>0312345678</SPhone>
    <SEmail>Despatch@KOALA.com</SEmail>
    <SenderLocation>DANDENONG SOUTH VIC 3175</SenderLocation>
    <Receiver>FROG GROUP PTY LTD</Receiver>
    <RAddress1>10 WHALE AVENUE</RAddress1>
    <RAddress2>
    </RAddress2>
    <RLocality>BLACKTOWN</RLocality>
    <RState>NSW</RState>
    <RPcode>2148</RPcode>
    <RCountryCode>AU</RCountryCode>
    <RCountry>AUSTRALIA</RCountry>
    <RContact>EMMA OKEEFFE</RContact>
    <RPhone>
    </RPhone>
    <ReceiverLocation>BLACKTOWN NSW 2148</ReceiverLocation>
    <Description>
    </Description>
    <DeliveryInstructions>
    </DeliveryInstructions>
    <SpecialInstructions>
    </SpecialInstructions>
    <Items>2</Items>
    <Weight>44</Weight>
    <Volume>0.054</Volume>
    <Distance>0</Distance>
    <Hours>0</Hours>
    <FreightCharge>18.0000</FreightCharge>
    <FreightFeesCharge>2.4300</FreightFeesCharge>
    <NetCharge>20.4300</NetCharge>
    <TaxCharge>2.0400</TaxCharge>
    <TotalCharge>22.4700</TotalCharge>
    <ConCatRefs> 3180553</ConCatRefs>
    <ETA>2019-03-05T00:00:00+11:00</ETA>
	<References>
		<Reference>Reference1</Reference>
		<Reference>Reference2</Reference>
	</References>     <SUs>
      <SU>
        <ItemNo>1</ItemNo>
        <Reference>3180553</Reference>
		<PackageType>CTN</PackageType> <!-- see https://flipgroup.atlassian.net/wiki/spaces/OIUG/pages/961445944/Shipping+Items+-+Packaging+Type for a full list -->
        <Type>CA0030</Type>
        <Weight>21</Weight>
        <Length>40</Length>
        <Width>26</Width>
        <Height>26</Height>
        <Volume>0.027</Volume>
        <Barcode>VCAL009168001</Barcode>
        <Description>Carton Standard</Description>
        <ItemID>VCAL009168001</ItemID>
      </SU>
      <SU>
        <ItemNo>2</ItemNo>
        <Reference>3180553</Reference>
		<PackageType>CTN</PackageType> <!-- see https://flipgroup.atlassian.net/wiki/spaces/OIUG/pages/961445944/Shipping+Items+-+Packaging+Type for a full list -->
        <Type>CA0030</Type>
        <Weight>23</Weight>
        <Length>40</Length>
        <Width>26</Width>
        <Height>26</Height>
        <Volume>0.027</Volume>
        <Barcode>VCAL009168002</Barcode>
        <Description>Carton Standard</Description>
        <ItemID>VCAL009168002</ItemID>
      </SU>
    </SUs>
  </Consignment>
</Consignments>

Available Formats

Type

Advantages

Sample

XML

Robust data structure
Easily imported into ERP or WMS or vital systems relevant for freight reporting

View file

name	Sample_Postback_Full.xml

CSV

Useful for basic consignment level reporting
Readable in Spreadsheet applications such as Microsoft Excel
Human friendly

5190020.csv

Versions Compared

Old Version 14

New Version Current

Key

Overview

Field List

XML Structure

Available Formats

Page Comparison

Versions Compared

Old Version 14

New Version Current

Key

Overview

Field List

XML Structure

Available Formats