Setting up the substitution table

The substitution table is used during translation when an element of your data must be exchanged for a corresponding value required by the trading partner. Examples include vendor-assigned account numbers, units of measure, and so on. Refer to the Substitution Tables Information in Lawson EDI for Supply Chain Management Trading Partner List for a list of substitution entries needed for each trading partner and transaction type supported.

Set up substitution tables

  1. Access Data Substitution Table Setup (ED40.1).
  2. Specify or select this information:
    List name

    Identifies the type of lookup being performed by the map.

    Lawson value

    Outbound, this is the value that the map will use to search the list in this table for a corresponding trading partner value.

    Inbound, this is the value that the map will use to populate the flat file when the corresponding external value is received from the trading partner.

    External Value

    Outbound, this is the value that is sent to the trading partner when the corresponding Lawson value is found in the flat file.

    Inbound, this is the value that is used to search the list for a corresponding Lawson value.

  3. Add the record to save your work.