The subsidiary (also called supplementary) table type contains lists of codes, descriptions, or other validation data. Subsidiary table examples are postal zone codes, country codes, currency codes, currency exchange rates, and so on. Subsidiary tables are often accessed by means of one of the setup menu options because they must be set up prior to being used for reference purposes by other tables. In our WDTU example, tables 50001 Radio Show Type and 50007 Publisher are subsidiary tables.
The following screenshots show some sample subsidiary tables for location, country/region, and payment terms. Each table contains data elements that are appropriate for use as a subsidiary table, plus, in some cases, fields that control the effect of referencing a particular entry. These data elements are usually entered as part of a setup process and then updated over time as appropriate:
The Location List in the preceding screenshot is a simple validation list of...
