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 that is required by the trading partner. Examples include vendor-assigned account numbers and units of measure.

See the substitution tables information for a list of substitution entries that are required for each supported trading partner and transaction type.

  1. Select Supply Management Setup > EDI > Data Substitutions.
  2. Click Create.
  3. Specify this information:
    List Name
    Identifies the type of look-up that is performed by the map.
    Your Value
    For Outbound, this is the value that is used by the map to search the list in this table for a corresponding trading partner value.

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

    Partner Value
    For Outbound, this is the value that is sent to the trading partner when the corresponding Infor value is found in the flat file.

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

  4. Click Save.

    To modify substitution records, right-click an existing record and select Edit.