The Compound Pattern

A Compound pattern helps us to define attributes that depend on a combination of two entities. This allows us to create additional flexibility when designing the application setup, creating values that connect through a many-to-many relationship.

Technical description

When applying this pattern, the table has two fields of type code and a length of 10 characters. Both the values should allow blank values.

The following diagram explains how to implement the Compound pattern:

To use the compound table in the application, both the fields are members of the table that uses the attributes. Typically, the compound key values are inherited from the fields in Master Data.

Implementation

The Compound table is used to define attributes for a combination of two values in the system.

Examples

The pattern is used in Microsoft Dynamics NAV for the General and VAT/TAX Posting Setup, which is as follows:

...