Synonym Table by Out Value (Select Standard Rule)

The synonym table by out value function is used to support IBM® Sterling Gentran:Server® for UNIX maps. This function enables you access the Sterling Gentran:Server synonym table and search a specified table column (In or Out) to match the data in the current map component. When a match is found, the translator returns the contents of that synonym table row into the field you specify.

In Sterling Gentran:Server, this function enables you to configure cross-referencing so you can convert your values (for example, a part number) to your trading partner's values during outbound processing, and to convert your trading partner's values to your values during inbound processing.

Note: This rule is not supported in Sterling B2B Integrator Map Editor—this function enables easier migration of maps fromSterling Gentran:Server to Sterling B2B Integrator by enabling you to view the rule in your maps.

The following list describes the fields on the Standard Rule tab with the Select standard rule selected and Synonym Table by Out Value selected from the Table and key (or group) list:

Field: Description
Table and key (or group): Synonym Table by Out Value. The translator selects the data from the field on which the standard rule operates and queries the synonym table. If the data from the field matches data in the selected synonym table column, the translator returns that entire row from the synonym table.
Sub-table to use: The name of the table to query.
Raise compliance error: For compliance reasons, the field must contain one of the values from the selected synonym table column (nothing else is valid for the field for which this standard rule is located).
Map from: The table column for which you want to query (In or Out) or the table name (Name).
Note: Items are displayed in the map-from list only after you make a selection from the table and key list.
Map to: The field to which you want to map the synonym table row that contains data that matches the data in the current map component (the map component on which the standard rule operates).
Note: If you are working in the input side of the map, you can access all the fields in the current group. If you are working in the output side, you can access all the fields in the current record. A total of eight fields can be mapped using one Select standard rule. Entries are displayed in the map-to list after you select a table and key. These entries are activated after you select an entry in the map-from box.