Define Lookup Tables

This function is used to create lookup tables. For each lookup table you define such features as:

  • A code for lookup table with a maximum of 12 characters.
  • A description of the contents of the lookup table.
  • Which columns the lookup table will contain.
  • The format of the columns, that is, what kind of values can be defined in each column.

    If you select Numeric, you can use a maximum of nine digits.

  • Which type of IBM Controller objects the codes are converted into, if any.
  • If the lookup table should be allowed to use duplicates, that is, the same code several times (this is only valid for lookup tables in the Fields (2) tab when defining import specifications).

These definitions in combination define what the detail window will look like and what information it can contain.

Procedure

  1. On the Transfer menu, click External Data/Define Lookup Table. The Define Lookup Tables window opens.
  2. Click the New button to define a new lookup table. All fields are cleared for entry. (You can also click the Show Valid Choices button to select an existing lookup table.)
  3. In the Lookup tables field, enter the name of the new lookup table.
  4. In the Description list box, enter a description of the lookup table.
  5. Select the relevant check boxes and when applicable, enter the relevant information in the fields to the right of the check boxes.

    Select IBM Controller Object to define the field to contain an IBM® Controller object. A list of IBM Controller objects is displayed. Select the type of Controller object you want and associated format in the list below:

    • Actuality (use uppercase width 6)
    • Company (use uppercase width 13)
    • Currency (use uppercase width 2)
    • Account (use uppercase width 3)
    • Dim 1-4 (use uppercase width 4)
    • Automatic Journal Type (use uppercase width 2)
    • Journal Type (use uppercase width 2)

    Select the Factor option to include a factor field in the lookup table. The factor is used if you want to multiply the imported values.

  6. Click Save.
  7. If you want to fill a new lookup table with data or to edit a lookup table you continue with Edit Lookup Table.