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
Field Name | Type | Len | Mandatory | Comment |
---|---|---|---|---|
Generated | Text | 30 | Y | |
Application | Text | 30 | Y | Name of your Application |
Version | Text | 20 | ||
DistributorId | Numeric | 10 | Y | EFM Distributor |
Shipper > | AddressType | 1 | ||
Id | Numeric | Y | Must be an account number provided by efm | |
Name | Text | 30 | ||
Address1 | Text | 30 | ||
Address2 | Text | 30 | ||
Locality | Text | 30 | ||
State | Text | 3 | ||
Postcode | Text | 4 | ||
Carrier > Account | Numeric | Y | Must be an account number provided by efm | |
Consignment > | Consignment | * | Y | Multiple |
Account | Numeric | Y | Must be an account number provided by efm | |
Connote | Text | 20 | Y | Tracking Number (used by carrier to provide tracking events to efm) |
Consigned | DateTime | Y | Date/Time consignment was created. | |
Released | DateTime | Y | Date/Time consignment was released/manifested/finalised. | |
SRT | Text | 1 | Y | Freight movement: S = Outbound, R = Returns, T = Transfer Movement (3rd party) |
CarrierAccount | Text | 20 | If the consignment involves a third-party or receiver paying, this must contain the carrier account of charged entity. This must adhere to the payor's charge entity registered on the prescribed carrier. | |
Service | Text | 20 | Y | Carrier Service Provided by efm |
ATL | Bool | Authority to Leave Flag { True | False } | ||
Reference | Text | 20 | Y | Reference number. Allows multiple instances. Consolidated consignments, for example, may contain multiple references in the form: |
Sender > | AddressType | 30 | Y | |
Name | Text | 30 | Y | |
Address1 | Text | 30 | Y | |
Address2 | Text | 30 | ||
Locality | Text | 30 | Y | |
State | Text | 3 | Y | |
Postcode | Text | 4 | Y | |
Contact | Text | 20 | ||
Phone | Text | 15 | ||
Text | 50 | |||
Receiver > | AddressType | 30 | Y | |
Name | Text | 30 | Y | |
Address1 | Text | 30 | Y | |
Address2 | Text | 30 | ||
Locality | Text | 30 | Y | |
State | Text | 3 | Y | |
Postcode | Text | 4 | Y | |
Contact | Text | 20 | ||
Phone | Text | 15 | ||
Text | 50 | |||
Items | Numeric | Y | Total Number of SUs for the consignment | |
Weight | Numeric | Y | Weight in Kgs. Up to 2 decimal places. | |
Cubage | Numeric | Y | Cubic metres (m3). Up to 3 decimal places. | |
Description | Text | 40 | ||
Special Instructions | Text | 60 | ||
Delivery Instructions | Text | 60 | ||
UserField1 | Text | 50 | ||
UserField2 | Text | 50 | ||
UserField3 | Text | 50 | ||
UserField4 | Text | 50 | ||
UserField5 | Text | 50 | ||
Package > | PackageType | * | Y | Defines the Shipping Unit |
Type | Text | 20 | Y | 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). |
Number | Numeric | Y | 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 | |
Reference | Text | 20 | Recommended for consolidated consignments. If you're consignment contains multiple references, it's best to highlighed individual items associated to which order reference. | |
Description | Text | 40 | ||
Weight | Numeric | Y | Weight of SU in Kgs. Up to 2 decimal places. | |
Cubic | Numeric | Y | Cubic metres (m3). Up to 3 decimal places. | |
Length | Numeric | Y | Length in centimetres (cm). Up to 2 decimal places. | |
Width | Numeric | Y | Length in centimetres (cm). Up to 2 decimal places. | |
Height | Numeric | Y | Length in centimetres (cm). Up to 2 decimal places. | |
PackType | Text | Y | Code for the OneFlo defined packaging type: See Shipping Items - Packaging Type | |
Barcode | Text | 50 | Y | Scannable barcode (Unique per shipping unit!) as printed on label |
DG > | DGType | * | ||
UN | Numeric | 4 | Y | UN Number for the Dangerous Goods |
Class | Text | 10 | Y | Classification of DG |
SubRisk | Text | 20 | Subsidiary hazard code | |
Group | Text | 10 | Packing group (e.g. I , II, III ) or leave blank | |
ProperShippingName | Text | 100 | Y | Identifiable DG name as specified in the code |
CommonName | Text | 100 | Y | Nickname for the DG |
Qty | Numeric | Y | Amount of DGs within the receptacle in the shipment (e.g. If there are 4 aerosol cans in this shipping unit, put 4 in this field) | |
AggQty | Numeric | Y | Amount of DG in Unit (e.g if there are 4 aerosol cans that are 300 ml each, the value placed in this field must be 300 ml x 4 cans = 1.2 L) | |
Units | Text | 10 | Y | Unit used in the AggQty (kg or L) |
Receptacle | Text | 50 | Y | Container for the DG (e.g. can, tank, box, bottle) |
XML Structure
<?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
We can customise other forms of EDI file but this is subject to cost and business approval. OneFlo has a selection of recognised EDI formats. please contact your IT Solutions consultant if your format is already recognised.
Efficacy of the CCI File
For ideas in improving the CCI data, please see CCI - Data Efficacy.