Qualified Tables and Qualifiers 

A qualified table is a special kind of lookup table that is extremely versatile. It can be used to efficiently store complex relationships between a main table record and one or more lookup table records that contain various types of additional information.

A qualified table stores a set of lookup records, and also supports qualifiers, database “subfields” that apply not to the qualified table record by itself, but rather to each association of a qualified table record with a main table record. Qualified tables offer self-configuring, out-of-the-box support for multiple prices (including quantity price breaks), cross-reference part numbers, other distributor/supplier/customer-specific information; and product applications.

For more information about qualified tables and qualifiers, see Working with Qualified Tables.