Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
| Table of Contents |
|---|
Overview
| 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 | 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 | 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 |
| |
CSV |
|