Creating translation tables

You create a new translation table when you need to translate a value in a document to a corresponding value. For instance, a simple element that contains an internal part number that must be converted to a trading partner's corresponding part number.

The following steps describe how to create a new translation table.

  1. Open the Translation Table editor. The following steps describe how to do this.
    1. Click the Mapping button on the main application window.
    2. In the Translation Tables tab, click the New button. The Translation Table editor opens.
  2. On the General tab of the Translation Table editor, type in the name of the translation table in the Name field.
  3. You can optionally type a description of the translation table in the Description field.
  4. In the Source Value group box, indicate whether the source values will be character or numeric in the Data Type field.
  5. In the Source Value group box, identify the maximum length of the source values in the Maximum Length field. The length can be up to 35 characters long.
  6. In the Target Values group box, indicate whether the target values will be character or numeric in the Data Type field.
  7. In the Target Value group box, identify the maximum length of the target values in the Maximum Length field. The length can be up to 63 characters long. The combined length of the source and target values can not exceed 68 characters.
  8. Click the New button to open the Add New Translation Table Entry dialog to create the translation table entries. Each entry associates a source value with a target value. In the dialog, enter a source value and its corresponding target value. Click the Insert button to insert the entry. The dialog remains open so another association between a source value and a target value can be made. Click the OK button to add the last entry to the translation table, or press the Cancel button if the last association has already been made.
  9. Click the Comments tab, and add any comments you have about the translation table.
  10. Click the Save button on the toolbar. Data Interchange Services client saves the new translation table to the database.
  11. Close the editor when you are done.

Copyright IBM Corp. 2003, 2005