Overview
OneFlo is capable of accepting an XML EDI file that must contain the following information:
- Shipper
- Carrier
- Consignment
- Details (Consignment level item count, weight, volume)
- Sender
- Receiver
- Package details (individual item dims, weight, volume, DG information)
Data Specifications
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Freight movement:
S = Outbound,
R = Returns,
T = Transfer Movement (3rd party)
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Reference number. Allows multiple instances.
Consolidated consignments, for example, may contain multiple references in the form:
<Reference>PO0001</Reference>
<Reference>PO0002</Reference>
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Warehouse specific code to determine a package type (different from PackagingType defined later)
This could be any code to identify within the warehouse (i.e. SMLCTN for small cartons, or SAT1KG for a 1 kg Satchel).
...
Status | ||||
---|---|---|---|---|
|
...
The index (starting 1) or otherwise known as ordinal integer.
e.g. if there are 3 packages, this will enumerate package 1, package 2, and package 3
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
Status | ||||
---|---|---|---|---|
|
...
XML Structure
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<EDI ManifestId="1" xmlns="http://www.opensys.com.au/schema/SCaRRS/1.1">
<Generated>
<Application>3PL_APPLICATION</Application> <!-- Place name of Application i.e. <3PL_SYSTEM> -->
<Version>VERSION</Version> <!-- Please input version of Application -->
<Created>MANIFESTDATE</Created> <!-- Include date of Manifest. Not mandatory -->
<DistributorId>101605</DistributorId> <!-- efm Logistics Services -->
</Generated>
<Shipper>
<Id>XXXXXX</Id> <!-- <Customer> ACCOUNT 6 digit number, will be provided-->
<Company>CUSTOMER NAME</Company> <!-- <Customer> trading name-->
<AddressLine1>ADDRESS LINE 1</AddressLine1>
<AddressLine2>ADDRESS LINE 2</AddressLine2>
<Locality>LOCALITY</Locality>
<State>STATE</State>
<Postcode>POSTCODE</Postcode>
<CountryCode>AU</CountryCode> <!-- 2 Character Country Code-->
<Country>AUSTRALIA</Country>
<Contact />
<Phone />
<Fax />
<Email />
</Shipper>
<Carrier>
<Id>Couriers Please Pty Ltd</Id>
<Account>102959</Account> <!-- <Carrier> 6 digit ID, will be provided by efm-->
</Carrier>
<Consignment>
<Account>XXXXXX</Account> <!-- <Customer> ACCOUNT 6 digit number, will be provided by efm-->
<Connote>CON00000000001</Connote>
<Consigned>2018-06-18T00:00:00</Consigned> <!-- Date of Consignment -->
<Released>2018-06-18T00:00:00</Released> <!-- Date of Release -->
<DeliverOn />
<Service>CPPCL</Service> <!-- Carrier Service – Must be the Service code provided by efm -->
<CarrierAccount /> <!-- Carrier Charge account (when third party pays) -->
<Reference>PO001234</Reference>
<SRT>S</SRT> <!-- Freight movement, see options above -->
<Sender>
<Company>Sender Name</Company>
<AddressLine>SENDER ADDRESS LINE 1</AddressLine>
<AddressLine />
<Locality>LOCALITY</Locality>
<State>STATE</State>
<Postcode>POSTCODE</Postcode>
<CountryCode>AU</CountryCode> <!-- 2 Character Country Code-->
<Country>AUSTRALIA</Country>
<Contact />
<Phone />
<Fax />
<Email />
</Sender>
<Receiver>
<Company>Receiver Name</Company>
<AddressLine>RECEIVER ADDRESS LINE 1</AddressLine>
<AddressLine />
<Locality>LOCALITY</Locality>
<State>STATE</State>
<Postcode>POSTCODE</Postcode>
<CountryCode>AU</CountryCode> <!-- 2 Character Country Code-->
<Country>AUSTRALIA</Country>
<Contact />
<Phone />
<Fax />
<Email />
</Receiver>
<Items>2</Items>
<Weight>7</Weight>
<Cubic>.12</Cubic>
<Instructions />
<SpecialInstructions />
<Description />
<GoodsValue>0.0000</GoodsValue>
<InsuranceClass />
<DutyTaxesPaid>False</DutyTaxesPaid>
<CustomsClearanceRequired>False</CustomsClearanceRequired>
<UserField1 />
<UserField2 />
<UserField3 />
<UserField4 />
<UserField5 />
<Package Type="ITEM"> <!-- Your Shipping Unit type e.g. CARTON, PALLET, SKID, etc -->
<Id>XXXXXXXXXXXXXXX1</Id>
<Number>1</Number> <!-- Ordinal number in reference to each consignment -->
<Reference /> <!-- Order reference for this shipping item -->
<Description>CARTON</Description>
<Weight>4.13</Weight>
<Cubic>.047</Cubic>
<Length>10</Length>
<Width>10</Width>
<Height>10</Height>
<PackagingType>CTN</PackagingType> <!-- Must adhere to https://flipgroup.atlassian.net/wiki/spaces/OIUG/pages/961445944/Shipping+Items+-+Packaging+Type -->
<Barcode>XXXXXXXXXXXXXXX1</Barcode> <!-- must be the actual barcode / sscc that is scannable on the label -->
</Package>
<Package Type="ITEM"> <!-- Your Shipping Unit type e.g. CARTON, PALLET, SKID, etc -->
<Id>XXXXXXXXXXXXXXX2</Id>
<Number>2</Number>
<Reference />
<Description>CARTON</Description>
<Weight>4.13</Weight>
<Cubic>.047</Cubic>
<Length>10</Length>
<Width>10</Width>
<Height>10</Height>
<PackType>CTN</PackType>
<Barcode>XXXXXXXXXXXXXXX2</Barcode> <!-- must be the actual barcode / sscc that is scannable on the label -->
<DG> <!-- Must follow ADG Code https://www.ntc.gov.au/heavy-vehicles/safety/australian-dangerous-goods-code/ -->
<UN>3090</UN>
<Class>9</Class>
<SubRisk>N/A</SubRisk>
<Group></Group>
<ProperShippingName>LITHIUM METAL BATTERIES CONTAINED IN EQUIPMENT</ProperShippingName>
<CommonName>LITHIUM BATTERIES</CommonName>
<Qty>1</Qty>
<AggQty>1</AggQty>
<Units>kg</Units>
<Receptacle>BOX</Receptacle>
</DG>
</Package>
</Consignment>
<Consignment>
...
</Consignment>
</EDI> |
Customisation
...
OneFlo EDI Capabilities
OneFlo can seamlessly process your electronic data interchange (EDI) documents to streamline your supply chain. We accept XML EDI files containing the following information:
The Shipper and Carrier details
The Shipment Information: Consignment details Sender, and Receiver details including level item count, weight, and volume
The Package details: Individual item specifications such as dimensions (DIMs), weight, volume, and dangerous goods (DG) information
Data Specifications
Mandatory indicator '*'
EDI
Field Name | Comment |
---|---|
Carrier* | Carrier node required |
Consignment* | At less 1 Consignment node is required can be repeated per consignment record |
Generated* | Generated node required |
Shipper* | Shipper node required |
Carrier node
Field Name | Comment |
---|---|
AddressLine1 | 30 characters limits |
AddressLine2 | 30 characters limits |
Company | The company trading name |
Contact | The contact name |
Country | 30 characters limits |
CountryCode | 2 characters limits e.g. |
Fax | Numeric value only |
Id* | 10 numeric limits, There are two ways to provide the Carrier Id value:
|
Locality | 30 characters limits |
Phone | Numeric value only |
Postcode | 4 numeric limits |
State | 3 characters limits |
Consignment node
Field Name | Comment |
---|---|
AccountId* | 10 numeric limits need to be set to the 6-digit ID provided by efm |
ATL |
|
ATLCode | If ATL= |
CarrierAccount | The carrier charge account (when third party pays) |
Connote* | 20 characters limits |
Consigned* | The date of Consignment Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
ContainerId | |
CostCenter | |
Cubic* | |
CustomsClearanceRequired |
|
DeliverOn | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
DeliveryDateFrom | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
DeliveryDateTo | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
DeliveryTimeFrom | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
DeliveryTimeTo | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
Description | |
DutyTaxesPaid |
|
GoodsValue | |
Instructions | |
InsuranceClass | |
Items* | Numeric value only |
Package* | At less 1 Package node is required can be repeated per package record
|
Receiver* | Receiver node required |
Reference* | |
Released* | The date of Release Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
Sender* | Sender node required |
Service* | There are two ways to provide the Service value:
|
SpecialInstructions | |
SRT* | either |
UserField1 | |
UserField2 | |
UserField3 | |
UserField4 | |
UserField5 | |
Weight* |
Generated node
Field Name | Comment |
---|---|
Application* | 30 characters limits should be the name of Application i.e. <OneFlo> |
CreatedAt | Datetime ISO 8601 format YYYY-MM-DDTHH:MM:SS |
DistributorId* | 10 numeric limits need to be set to efm distributor ID and it is provided by efm |
Version | 30 characters limits the version of Application |
Shipper node
Field Name | Comment |
---|---|
AddressLine1 | 30 characters limits |
AddressLine2 | 30 characters limits |
Company | The company trading name |
Contact | The contact name |
Country | 30 characters limits |
CountryCode | 2 characters limits e.g. “AU” or “NZ” |
Fax | Numeric value only |
Id* | Maximum 10 numeric value need to be set to the 6-digit ID provided by efm |
Locality | 30 characters limits |
Phone | Numeric value only |
Postcode | 4 numeric limits |
State | 3 characters limits |
Sender node
Field Name | Comment |
---|---|
AddressLine1* | 30 characters limits |
AddressLine2 | 30 characters limits |
Company* | The company trading name |
Contact | The contact name |
Country | 30 characters limits |
CountryCode | 2 characters limits e.g. “AU” or “NZ” |
Fax | Numeric value only |
Locality* | 30 characters limits |
Phone | Numeric value only |
Postcode* | 4 numeric limits |
State* | 3 characters limits |
Receiver node
Field Name | Comment |
---|---|
AddressLine1* | 30 characters limits |
AddressLine2 | 30 characters limits |
Company* | The company trading name |
Contact | The contact name |
Country | 30 characters limits |
CountryCode | 2 characters limits e.g. “AU” or “NZ” |
Fax | Numeric value only |
Locality* | 30 characters limits |
Phone | Numeric value only |
Postcode* | 4 numeric limits |
State* | 3 characters limits |
Package node
Field Name | Comment |
---|---|
Barcode* | Must be the actual barcode / sscc that is scannable on the label |
Cubic* | |
Description | |
DG | DG node if declare then must follow ADG Code https://www.ntc.gov.au/heavy-vehicles/safety/australian-dangerous-goods-code |
Height* | |
Id | |
Length* | |
Number* | |
PackType* | OneFlo Packaging code accepted value are; [BAG, CGE, CTN, CRT, DRM, LEN, PLT, SAT, SKD,OTH] For further details refer to Shipping Items - Packaging Type |
Reference | |
Weight* | |
Width* |
DG node
Field Name | Comment |
---|---|
AggQty* | |
Class* | |
CommonName* | |
Group | |
ProperShippingName* | |
Qty* | |
Receptacle* | |
SubRisk | |
UN* | |
Units* |
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Customization Options
While we currently support a selection of recognized EDI formats, OneFlo can potentially customize the system to handle other formats upon request. However, customization may incur additional costs and require business approval. Please contact your IT Solutions consultant to inquire about compatibility with your specific EDI format.
Efficacy of the CCI File
For ideas in improving the CCI data, please see CCI - Data Efficacy.