Versions Compared

Old Version 30

changes.mady.by.user Steven Reynolds (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user rossc

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

Performing Order Lookup

Image Removed

System Component Map

Image Removed

Components

  • Customer System

Customer's system used as the source system for order data. Provider order data is exportable into an EDI file that will act as a data feed to the Message Transmitter process

  • Customer Workstation

Customer uses their consigning workstations to access the OneFlo portal to be able to access OneFlo functionality. 

  • OneFlo Portal

OneFlo is a cloud based, multi-carrier, Logistics Management System designed for consigning, manifesting & tracking consignments, tracking carrier performance & enabling logistics-based reports for analyzing supply chain activity. Order Lookup is accessed via the OneFlo Portal.

  • OneFlo Order Integration Service

The Order Integration service (Installing Order Lookup) is designed to increase the efficiency of the despatch process by identifying and loading order data based on EDI files. The service identifies order EDI files and loads the contents as an order into OneFlo. Once loaded the order is accessible in the OneFlo portal and upon selecting the order all order data is mapped to the consignment creation form. The population of this data reduces data entry required by the despatch teams and increases accuracy of the consignment data.

  • OneFlo Postback Report

In order to populate consignment number against the original Order in efm a OneFlo Postback data file can be generated on a nightly schedule. This data file will be transferred over to Customer where a efm service will load the file data to update Orders. This function requires Customer to nominate an FTP server that OneFlo can use to place the nightly batch file.

Information Requirements

Customer order data required may vary depending on the process the Order Lookup integration is intended to achieve.

The following specification defines an XML structure for the Order Detail. When the source system can only produce a CSV, please consult the efm Technical Solutions Contact assigned.

Order Detail Information

...

How does Order Lookup work?

Complete Message Transmitter Service

  1. The Customer system generates a File with consignment Information on the Customer's Server. The File must be.
    1. CSV/XML Format
    2. Contain the order file Information listed below
    3. Limited to one file per Order
  2. EFM Installs a Windows Service on the Customer's Server to pick up this File and send it to our Message Transmitter Service which transforms this File into a standard Message that OneFlo can interpret.
  3. Customer uses OneFlo Portal to "Look up" the consignment that can now be found within the system.

Custom Message Transmitter Service

  1. The customer system sends an XML Payload of all required data, to a custom API End Point.
    1. This Payload must meet OneFlo information requirements perfectly.
  2. Customer uses OneFlo UI to "Look up" the consignment that can now be found within the system.
Warning
titleWARNING

Custom Services are only available upon evaluation and require internal approval before moving forward.

Table of Contents

Warning

Customisations

Any variations from this standard template will only be available upon evaluation, and requires Flip approval before moving forward.

Information Requirements

Order Detail Information

Field Name

Type

Length

Mandatory

...

minOccurence

Description

...

OrderReferenceNumber

Text/Numeric

30

Mandatory

1

Must be Unique

...

Additional Reference

References

30

Optional

0*


ThirdPartyAccount

Text

20

Optional

0*

Provide the Carrier Account if the receiver or a Third Party will be paying for this freight.

CostCentre

Text

30

Optional

0*

...

Cost Centre implementations vary. Please speak with Account Manager regarding use.

Service

Text

20

Optional

0-1

Preferred service following the Service Code provided by EFM. Must comply with the code otherwise will be ignored.

...

Sender

Address


Optional

0-1

Only used when creating return or third party orders when a sender needs to be specified.

...

Receiver

Address


Mandatory

1

...


Items

Item


Recommended

0-1*

...

Delivery Instructions

...

Text

...

60

...

Recommended

...

Special Instructions

...

Text

...

60

...

Recommended

...


Atl - Authority to Leave

Boolean

5

Optional

...

0-1

Only accepts the value: true/false

UserField1

Text

30

Optional


Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index

...

UserField2

Text

30

Optional


Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index

...

UserField3

Text

30

Optional


Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index

...

UserField4

Text

30

Optional


Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index

...

UserField5

Text

30

Optional


Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index

Anchor
AddressType
AddressType
Address Type Information

...

Field Name

Type

Length

Mandatory

...

minOccurence

Description

...

Name

Text

30

Mandatory

1

...


Address1

Text

30

Mandatory

1

...


Address2

Text

30

Optional

1

...


Locality

Text

30

Mandatory

1

...


State

Text

5

Mandatory

1

...


Postcode

Text

5

Mandatory

1

...


ContactName

Text

20

Optional

0-1

...


ContactPhone

Text

15

Optional

0-1

...


ContactEmail

Text

50

Recommended

0-1


Instructions

Text

80

Optional

0-1

Anchor
ItemType
ItemType
Item Type Information

...

Field Name

Type

Length

Mandatory

...

minOccurence

Description

1

Reference

Text

...

20

Recommended

1


2

Code

Text

...

20

Recommended

1

Defined: https://portal.oneflo.com.au/MyProducts/Index

3

PackagingType

Test

20

Recommended

1

Shipping Items - Packaging Type

4

Description

Text

...

40

Recommended

1

Description of the package

...

5

Items

Numeric


Recommended

1

number of items of this type / dims / weight

...

6

Length

Numeric


Recommended

1

in centimetres, must be whole number

...

7

Width

Numeric


Recommended

1

in centimetres, must be whole number

...

8

Height

Numeric


Recommended

1

in centimetres, must be whole number

...

9

Weight

Numeric


Recommended

1

in kilograms, can include decimal

...

10

Volume

Numeric


Optional

1

in cubic metres, can include decimal

...


Sample Files

XML with comments

Order Lookup With Comments

...

Code Block
languagexml

...

<?xml version="1.0" encoding="utf-8"?>
<CreateOrderLookup>
	<Orders>
		<Order>
			<AccountId>000000</AccountId>
			<OrderReference>BANANA4</OrderReference>						<!-- Mandatory: The primary reference number for your consignment. Also used to look up this order -->
			<References>													<!-- Optional -->
				<string></string>											<!-- Repeat for as many references you wish to add-->
			</References>						
            <DispatchDate>2018-10-23</DispatchDate>							<!-- Optional -->	
            <CostCentre>APPLE1</CostCentre>									<!-- Optional -->
            <ThirdPartyAccount>APPLE36</ThirdPartyAccount>					<!-- Optional -->
			<Service>TEST</Service>											<!-- Optional: If an incorrect service code is used it will successfully import without selecting a service -->
			<Receiver>
				<Name>Sample Receiver</Name>								<!-- Mandatory -->
				<Line1>123 Sample Road</Line1>								<!-- Mandatory -->
				<Line2>Receiving Dock 2</Line2>
				<Suburb>MELBOURNE</Suburb>									<!-- Mandatory -->
				<State>VIC</State>											<!-- Mandatory -->
				<Postcode>3000</Postcode>									<!-- Mandatory -->
				<Country>AU</Country>										<!-- Mandatory -->
				<ContactName>Sample Contact</ContactName>
				<Email>contact@sampledomain.com.au</Email> 					<!-- Mandatory when ASN is activated-->
				<Phone>0411 999 999</Phone>
				<Atl>true</Atl>												<!-- Optional: Flags Authority to Leave. Possible values: true / false / blank -->
				<Instructions>Signature Required</Instructions>				<!-- Optional, limit 60char -->    
			</Receiver>
			<UserFields>													<!-- Custom fields configured in OneFlo. Defined in https://portal.oneflo.com.au/MyUserFields/Index -->
																			<!-- If Not Used, Remove whole element-->
				<UserField1>506180</UserField1>
				<UserField2>Inspected and Confirmed</UserField2>
				<UserField3>MISC</UserField3>
				<UserField4>Rest</UserField4>
				<UserField5>OR-9874152162196</UserField5>
			</UserFields>
			<ShippingUnits>													<!--Optional: If you are can provide your shipping unit details.-->
																			<!-- If Not Used, Remove whole element-->
				<ShippingUnit>												<!-- Define One or many items as per the below structure -->
					<Reference>Order001</Reference>							
					<Code>SAT</Code>										<!-- Defined: https://portal.oneflo.com.au/MyProducts/Index -->
					<Description>Carton of goodies</Description>							
					<PackagingType>CTN</PackagingType>						<!-- Defined: https://flip-eng.atlassian.net/wiki/spaces/OIUG/pages/2451651171 -->
					<Items>1</Items>										<!-- number of items of this type / dims / weight -->
					<Length>10</Length>										<!-- in centimetres,  must be whole number-->
					<Height>10</Height>										<!-- in centimetres, must be whole number -->
					<Width>10</Width>										<!-- in centimetres, must be whole number -->
					<Weight>2</Weight>										<!-- in kilograms, can include decimal -->
					<Volume>0.001</Volume>									<!-- in cubic metres, can include decimal -->
				</ShippingUnit>
				<ShippingUnit>
					<Reference>Order002</Reference>							
					<Code>1KGSAT</Code>										<!-- Defined: https://portal.oneflo.com.au/MyProducts/Index -->
					<Description>Satchel 1KG</Description>			
					<PackagingType>SAT</PackagingType>						<!-- Defined: https://flip-eng.atlassian.net/wiki/spaces/OIUG/pages/2451651171 -->
					<Items>1</Items>										<!-- number of items of this type / dims / weight -->
					<Length>10</Length>										<!-- in centimetres, must be whole number-->
					<Height>10</Height>										<!-- in centimetres, must be whole number -->
					<Width>2</Width>										<!-- in centimetres, must be whole number -->
					<Weight>1</Weight>										<!-- in kilograms, can include decimal -->
					<Volume>0.001</Volume>									<!-- in cubic metres, can include decimal -->
				</ShippingUnit>
			</ShippingUnits>
		</Order>
	</Orders>
</CreateOrderLookup>

XML

Order Lookup Template
Code Block
languagexml
<?xml version="1.0" encoding="utf-8"?>
<CreateOrderLookup>
	<Orders>
		<Order>
			<AccountId>000000</AccountId>
			<OrderReference>BANANA4</OrderReference>						
			<References>													
				<string></string>											
			</References>						
            <DispatchDate>2018-10-23</DispatchDate>								
            <CostCentre>APPLE1</CostCentre>									
            <ThirdPartyAccount>APPLE36</ThirdPartyAccount>					
			<Service>TEST</Service>											
			<Receiver>
				<Name>Sample Receiver</Name>
				<Line1>123 Sample Road</Line1>
				<Line2>Receiving Dock 2</Line2>
				<Suburb>MELBOURNE</Suburb>
				<State>VIC</State>

...

	<Postcode>3000</Postcode>

...

	<Country>AU</Country>
				<ContactName>Sample Contact</ContactName>
				<Email>contact@sampledomain.com.au</Email>
				<Phone>0411 999 999</Phone>

...

	<Atl>true</Atl>
				<Instructions>Signature Required</Instructions>
			</Receiver>

...


			<UserFields>
				<UserField1>506180</UserField1>
				<UserField2>Inspected and Confirmed</UserField2>
				<UserField3>MISC</UserField3>
				<UserField4>Rest</UserField4>
				<UserField5>OR-9874152162196</UserField5>
			</UserFields>
			<ShippingUnits>
				<ShippingUnit>
					<Reference>CARTON</Reference>							
					<Code>CT-SMALL</Code>										
					<Description>CARTON of toy cars</Description>							
					<PackagingType>CTN</PackagingType>
					<Items>1</Items>
					<Length>10</Length>

...

		<Height>10</Height>
					<Width>10</Width>
					<Weight>2</Weight>

...

<Volume>0.001</Volume>
				</ShippingUnit>
				<ShippingUnit>
					<Reference>SATCHEL</Reference>
					<Code>1KGSAT</Code>										
					<Description>SATCHEL of Replacement screws</Description>
					<PackagingType>SAT</PackagingType>
					<Items>1</Items>
					<Length>10</Length>
					<Height>10</Height>
					<Width>2</Width>
					<Weight>2</Weight>
					<Volume>0.001</Volume>
				</ShippingUnit>
			</ShippingUnits>
		</

...

Order>
	</

...

Orders>
</CreateOrderLookup>

CSV

CSV No Items

Order_Lookup_Consignment.csv

Consignment CSV Import
Code Block
languagexml
OrderReferenceNumber,References,Service,Name,Address1,Address2,Locality,State,Postcode,ContactName,ContactPhone,ContactEmail,Authority to Leave,Delivery Instructions,Special Instructions,UserField1,UserField2,UserField3,UserField4,UserField5

CSV with Items  

Order_Lookup_Consignment.csv

Consignment CSV Import
Code Block
languagexml
OrderReferenceNumber,References,Service,Name,Address1,Address2,Locality,State,Postcode,ContactName,ContactPhone,ContactEmail,Authority to Leave,Delivery Instructions,Special Instructions,UserField1,UserField2,UserField3,UserField4,UserField5,ItemReference,Code,Description,Items,Length,Width,Height,Weight