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	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

Cost Center

CostCenter	Cost Centre (as defined in OneFlo)	varchar		50
7	Third Party Reference	Cost Centre (as defined in OneFlo)	varchar		50
8	Sender	Sender Name	varchar		50
9	SAddress1	Sender Address Line 1	varchar		30
10	SAddress2	Sender Address Line 2	varchar		30
11	SLocality	Sender Locality / Suburb	varchar	BRISBANE CITY	50
12	SState	Sender State	varchar	QLD	5
13	SPCode	Sender Postcode	varchar	4000	10
14	Receiver	Receiver Name	varchar		50
15	RAddress1	Receiver Address Line 1	varchar		30
16	RAddress2	Receiver Address Line 2	varchar		30
17	RLocality	Receiver Locality / Suburb	varchar	MELBOURNE	50
18	RState	Receiver State	varchar	VIC	5
19	RPCode	Receiver Postcode	varchar	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	varchar		10
26	ZoneTo	Carrier Zone To	varchar		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	varchar		20
33	UserField2	User defined field #2	varchar		20
34	UserField3	User defined field #3	varchar		20
35	UserField4	User defined field #4	varchar		20
36	UserField5	User defined field #5	varchar		20
37	References	Additional References	structured	<Reference>ref1</Reference> <Reference>…</Reference> <Reference>refX</Reference>	∞
38	ConCatRefs	Additional References (Legacy view)	comma-delimited varchar	"ref1,ref2,ref3"

∞

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>
        <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>
        <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>

Available Formats

Type	Advantages	Sample
XML	Robust data structure Easily imported into ERP or WMS or vital systems relevant for freight reporting	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 13

New Version 14

Key

Overview

Field List

XML Structure

Available Formats

Page Comparison

Versions Compared

Old Version 13

New Version 14

Key

Overview

Field List

XML Structure

Available Formats