ERP Internals/Glossary/Data Table

From Wikibooks, open books for an open world
Jump to navigation Jump to search

A place where ERP information is stored. Data tables consists of one or more records each of which has one or more fields. Each record has a unique primary key consisting of one or more fields. There can be several other keys as well. Some tables are used throughout the ERP; others are specific to one module. Some tables such as those that store the Accounts Receivable invoices are large, complex and constantly changing. Others such as the one that stores the enterprise's Accounts Receivable terms have only a few records with only a few fields and change only rarely. There are hundreds of small tables like these. Most of these small tables are managed by the Maintain Module Information function. Contrast with Parameter.

"Records" are sometimes referred to as "rows" and "fields" are sometimes referred to as "columns".