Analysing EDI Orders Files

How to read and analyse a raw orders EDI file

John Paul Gilmartin avatar
Written by John Paul Gilmartin
Updated over a week ago

How analyse an EDI orders file

  1. Navigate to Web EDI analyser.

  2. Select Analyze EDI Files

  3. Select File Upload

    1. The order structure will then be presented in a tree view.

Expand the Top Level

EDI files are structured in segments. Each segment defines specific information that relates to the transaction, the segment may also contain child segments that provide extended information that relate to the parent segment. For example in an order there is a line segment which will have a quantity child segment.

For a complete view of all the possible orders segments click here for the GS1 branching diagram.

How to Analyse an EDI Order File Line Segment

  1. LIN - Line Item

    1. Line item identifier

      1. Order line number

    2. Action description

      1. Added

    3. Item identifier

    4. Item type identification code

      1. SRV = GS1 Global Trade Item Number

  2. PIA - Additional product id

  3. IMD - Item Description

  4. QTY - Quantity

    1. Quantity type code qualifier

      1. 21 = Ordered quantity

    2. Quantity

    3. Measurement unit code

      1. O01 is custom to M&S and refers to packs

  5. MOA -Monetary amount

    1. Monetary type code qualifier

      1. 203 = Line item amount

    2. Monetary amount

  6. PRI - Price details -CUX - Currencies

    1. Price code qualifier

      1. AAA = Calculation net

    2. Price Amount

    3. Price type code

      1. CT - Contract

    4. Price specification code

      1. NTP = Net unit price

    5. Unit price basis value

      1. Ordered Quantity

    6. Measurement unit code

      1. KGM = kilogram

    7. Currency usage code qualifier

      1. 2 = reference currency

    8. Currency identification code

    9. Currency type code qualifier

      1. 9 = Order currency

  7. PAC- Package -> QTY - Quantity

    1. Package type description code

      1. PU = Tray

    2. Quantity type code qualifier

      1. 52 = Quantity per pack

    3. Quantity

Did this answer your question?