Overview

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	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	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		50
12	SState	Sender State	varchar		5
13	SPCode	Sender Postcode	varchar		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		50
18	RState	Receiver State	varchar		5
19	RPCode	Receiver Postcode	varchar		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	comma-delimited varchar	"ref1,ref2,ref3"	∞

XML Structure

You may download a sample below to develop your import mechanism.

<?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
CSV	Useful for basic consignment level reporting Readable in Spreadsheet applications such as Microsoft Excel Human friendly	Customer_Daily_20180815190020.csv
XML	Robust data structure Easily imported into ERP or WMS or vital systems relevant for freight reporting	Sample_Postback_Full.xml

Postback - Consignment Data

[data-colorid=jdo3p4bf1w]{color:#222222} html[data-color-mode=dark] [data-colorid=jdo3p4bf1w]{color:#dddddd}Overview

XML Structure

Available Formats

Overview