Using Information from Lookup Tables

A lookup table is used to select information related to a value in inbound or outbound data. Each partner profile and the internal system partner profile can have many lookup tables associated with it.

To use information from a lookup table, you must have created that table already in the Partner Editor. See How to Create a Table in the IBM® Sterling Gentran:Server® for Microsoft Windows User Guide for more information on creating Partner lookup tables.

Note: For a screen entry translation object, the system displays a list which allows you to select the entry from the table. For a print translation object, the system prints the information on the report.

Use this procedure to map information from a Lookup Table.

  1. Double-click an existing element or field, or create a new element or field.

    The system displays the Field (or Element or CII TFD) Properties dialog box.

  2. Select the Standard Rule tabs.
  3. From the standard rule list, choose Select.
  4. From the table list, select the key from which the system looks up the trading partner.
  5. In the sub table box, type the name of the lookup table.
  6. If you want the system to generate an error if the lookup fails, select the compliance error check box.
  7. From the map from list, select the field from which the contents are mapped.
  8. From the map to list, select the element, field, or TFD to which the information from the Partner Editor is mapped.
  9. Click OK to add the standard rule.