Nav

Lookup Tables

Anypoint Partner Manager (APM) enables you to create, populate and edit a lookup table. A lookup table is a table that facilitates transaction processing by associating values. For example, this page shows how to create a lookup table that associates home partner product codes with trading partner product codes.

Creating a Lookup Table

This section shows you how to use the APM user interface to create a lookup table. Alternatively, you can create a lookup table through calls to the Anypoint Partner Manager API; see Create a Lookup Table.

Get Started

These settings are editable for the Home Partner (Your company in the Trading Partners Page) only.
  1. Start APM. The B2B Transactions Page appears.

  2. In the left-hand navigation pane, click Trading Partners. The Trading Partners Page appears.

    In the Name table, click the name of the Home Partner.

To Create a Lookup Table

  1. In the Partners section of the left-hand navigation pane on the Company information page, click Lookup Tables Adm..

img-lookup-table
Figure 1. Add or Edit a Lookup Table Page
  1. On the Add or Edit a Lookup Table Page, click New.

    The New Lookup Table Page appears.

img-new-lookup-table
Figure 2. New Lookup Table Page
  1. On the New Lookup Table Page in the Name box, type a descriptive name for the table you want to add.

    The Save Button appears; click it to save the new table.

    The Fields and Keys sections of the page appear, enabling you to add fields and keys.

img-lookup-table-fields-and-keys
Figure 3. Lookup Table Fields and Keys
  1. To add a field, click Add field.

    The Field Name box appears; enter a name for a field you want to add, then click Save (the checkmark icon) to the right of the box.

    The new field name appears.

    To add another field, repeat this step.

  2. To add a key, click Add key.

    The Key Name box appears.

  3. In the Key Name box, enter a name for the key you want to add.

  4. Click Add Field.

    The Add Field selection box appears. Use the arrows to select a field you want make this key (or to make a part of this key), then click click the Plus symbol (+) next to new key.

  5. To add more fields to this key, repeat the previous step until the key is what you want it to be.

Working with a Lookup Table

Lookup table settings are editable for the Home Partner (Your company in the Trading Partners Page) only.
  1. Start APM. The B2B Transactions Page appears.

  2. In the left-hand navigation pane, click Trading Partners. The Trading Partners Page appears.

    In the Name table, click the name of the Home Partner.

  3. In the Partners section of the left-hand navigation pane on the Company information page, click Lookup Tables.

    The Lookup Tables Page appears.

img-lookup-tables
Figure 4. Lookup Tables Page
  1. On the Lookup Tables Page, in the Lookup Tables dropdown listbox, click the down arrow.

    The Lookup Tables dropdown list appears, populated with any lookup tables that have been created in the environment in which you are working.

    To work with a table, click to select it from the dropdown list. The Lookup Tables Detail Page appears. The first row on this page is the Filter Row.

    Until you add rows to a table, the Filter Row is the only row that appears. This is the case in Lookup Tables Detail Page.

    Use the Filter Row to filter a column for a specific string. You can filter multiple columns at the same time; for example, if you type a in the first column and b in the second, the page displays all rows that include both an a in the first column and a b in the second.

    To add a row to the table, see Add a Row to a Table.

    To work with existing rows, see Working with Table Rows.

img-lookup-tables-detail-filter-row
Figure 5. Lookup Tables Detail Page

Add a Row to a Table

  1. On the Lookup Tables Detail Page, click Add Row.

    A new row appears under the Filter Row.

img-lookup-tables-detail-add-row-labeled
Figure 6. Lookup Tables Detail Page, add row
  1. Enter values for the new row in the appropriate cells.

  2. When you have entered all values, the Save icon at the right end of the new row (identified in Lookup Tables Detail Page, add row) is enabled.

    Click the Save icon to save the new row..

    To cancel the new row without saving, click the Cancel icon (identified in Lookup Tables Detail Page).

img-lookup-tables-detail-row-added
Figure 7. Lookup Tables Detail Page, row added

Working with Table Rows

When multiple rows have been added to a lookup table, it appears as in Lookup Tables Detail Page, multiple rows added.

img-lookup-tables-detail-multi-row-labeled
Figure 8. Lookup Tables Detail Page, multiple rows added

Edit a Row

  1. On Lookup Tables Detail Page, multiple rows added, click the Edit icon that corresponds to the row you want to edit. The Edit icon becomes a Save icon, and the Delete icon becomes a Cancel icon.

  2. Edit or cells in the row as appropriate.

    To cancel changes, click the Cancel icon.

    To save changes, click the Save icon.

Delete a Row

  1. On Lookup Tables Detail Page, multiple rows added, click the Delete icon that corresponds to the row you want to delete.

    The row you identified is deleted.

.

.