null

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 35 Next »

Overview

OneFlo is capable of accepting an XML EDI file that must contain the following information:

  1. Shipper

  2. Carrier

  3. Consignment

    1. Details (Consignment level item count, weight, volume)

    2. Sender

    3. Receiver

    4. 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.
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 }

   References

Text

20

Y

Reference numbers. Allows multiple instances.

Consolidated consignments, for example, may contain multiple references in the form:
<Reference>PO0001</Reference>
<Reference>PO0002</Reference>

   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



      Email

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



      Email

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

      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 
(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)

  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.


  • No labels