cancel
Showing results for 
Search instead for 
Did you mean: 

Create setup tables

Create setup tables

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.

isac certification malaysia