Create supplemental tables
A supplemental table contains information about a supplemental subject that is used in one or more application areas. For example, the Currency table is a supplemental table that contains information about currencies. This table is not the primary focus of any application area; however, it is important.
Many supplemental tables contain certain sets of defaults that are applied automatically to other types of records, such as master records, when a record from the supplemental table is used. For example, the Item Category table contains five default fields:
Def. Gen. Prod. Posting Group
Def. Inventory Posting Group
Def. Tax Group Code
Def. Costing Method
Def. VAT Prod. Posting Group
Values from these fields are copied to the relevant fields in the Item table when a user selects a value in the Item Category Code field for an item. Generally, supplemental tables are not related to other tables, though many other tables are related to supplemental tables.
Supplemental table names
The name of a supplemental table is the name of one of the records in the table. For example, the Currency table is named as such because each record within it contains information about a single currency.
Primary key and other standard fields
The primary key of a supplemental table is named Code and is of type Code and of length 10. The description field of this table is typically named Description and is of type Text and of length 50, even though it might occasionally have a different length.
Some supplemental tables do not contain the Description field but will contain a Name description field instead.
Associated pages
The page that is used for a supplemental table is a list page. The associated page has only a few or no actions. The name of the page is the plural of the name of the supplemental table. Therefore, the page that you use to edit the Currency table is named Currencies. This page is set as the LookupPageID property of the table.