---
schema_version: "1"
id: fe1ae6de46b5f16cd6bcd763470e2a98d218deb2e8e42edaf5d5b637f90f2b95
title: Configuring and Managing Lookup Tables
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/partner-manager/latest/lookup-tables-overview.md
canonical_url: https://docs.mulesoft.com/partner-manager/latest/lookup-tables-overview
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 7780ee69ef154df3942302a3a85456a8deac68adf4c39a96c03574b61b4adf03
description: MuleSoft Documentation Site
release: 2.x
latest: true
---
---
product: Partner Manager
version: 2.x
is-latest-version: true
---

# Configuring and Managing Lookup Tables

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

Lookup tables are centralized reference values that mappings use to translate data between systems
in Partner Manager. They help you keep inbound and outbound transformations consistent and avoid
repeating translation logic in each map.

Use lookup tables when mappings depend on reusable code or ID translations across partners and
systems. This approach simplifies updates, supports bidirectional translation scenarios, and scales
as integrations grow.

## Lookup Table Types

These lookup table types are available:

- **Composite Key Lookup**

  Use composite key lookup when the result depends on one or more key columns together. This type
  uses AND logic, so all required key values must be provided for a match.

  Result: zero or one matching row.

- **Cross-Reference Lookup**

  Use cross-reference lookup when a row can be identified by any one of one or more key columns.
  This type uses OR logic across key columns.

  Result: zero or one matching row.

- **Generic Lookup (optional)**

  Enable generic lookup when you need flexible filtering by one or more columns and might need
  multiple matching rows.

  Result: zero, one, or many matching rows.

## View and Search Lookup Tables

To access lookup tables, select **Lookup Tables** from the Partner Manager sidebar. You can search
by name or description and filter by type.

## Lookup Table Limitations

Lookup table limits by environment include:

- Maximum lookup tables: 100

- Maximum columns per table: 10

- Maximum rows per table: 10,000

- Maximum lookup table name length: 50 characters

- Maximum column name length: 30 characters

- Maximum value length per cell: 200 characters

> [!NOTE] Each lookup results in an Object Store v2 call. If you anticipate high transaction volume,
> consider an Object Store v2 premium subscription. For details, see
> [Object Store v2 Rate Limiting and Billing](https://docs.mulesoft.com/object-store/osv2-usage).

## Next Steps

- To create lookup tables, see [Creating Lookup Tables](https://docs.mulesoft.com/partner-manager/latest/lookup-tables-create).

- To use lookup tables in DataWeave mappings, see
  [Using Lookup Tables in DataWeave](https://docs.mulesoft.com/partner-manager/latest/lookup-tables-dataweave).