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 (ItemId) | |
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. | |
Service | Text | 20 | Y | Carrier Service Provided by efm |
ATL | Bool | Authority to Leave Flag { True | False } | ||
References | Text | 20 | Y | Reference numbers. Allows multiple instances. Consolidated consignments, for example, may contain multiple references in the form: |
CostCentre | Text | 20 | Optional field for some senders | |
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. | |
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 |
PalletInfo > | PalletInfoType | * | If PackageType is Pallet, please provide pallet info | |
Type | Text | 10 | LOSCAM, CHEP, PLAIN | |
Count | int | Number of pallets of this type | ||
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 | |
AggQty | Numeric | Y | Amount of DG in Unit | |
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) |
DeliveryDateFrom | Date | Delivery Date From | ||
DeliveryDateTo | Date | Delivery Date To | ||
DeliveryTimeFrom | Time | Delivery Time From | ||
DeliveryTimeTo | Time | Delivery Time To |
XML Structure
XML
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <EDI> <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> <CostCenter/> <!-- optional --> <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> <PackType>CTN</PackType> <!-- 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> <DeliveryDateFrom/> <DeliveryDateTo/> <DeliveryTimeFrom/> <DeliveryTimeTo/> </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.