Each application area has its own setup table. These setup tables hold only one record that contains fields to select options for the application area or to hold data that applies to the whole company. No tables are related to setup tables; though, setup tables are frequently related to other tables and typically to tables.
Setup table names
The name of a setup table is usually the name of the application area that it configures followed by the word setup. For example, the table that contains setup information for the general ledger application area is named General Ledger Setup. One exception to this rule is the Company Information table.
Primary key and other standard fields
The primary key for a setup table is a Code type field of length 10 named Primary Key. The primary key is always left blank because only one record for each table is permitted. Setup tables don't have a description field.
Associated setup page
Only one page is used for setup tables, and it's of type Card. The page has the same name as the table and the primary key field isn't included.
The page allows for modifying information but does not allow for inserting or deleting records. If a record isn't in the underlying table on this page, the code in the OnOpenPage trigger inserts a record.
Not every table that contains the word setup in its name is a setup table. Some tables that have more than one record contain the word setup in their names. Generally, these tables follow the rules of the subsidiary tables, as previously described, and don't follow the rules that are outlined in this section.
aws training courses malaysia
