ERP Internals/Data Tables

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

Even a small ERP has a hundred data tables. A large, full-function one has thousands. The following list covers the major groups of tables. Supporting Tables covers the minor tables and Parameters cover the miscellaneous options and values for each module.

Note that the definition of these tables is not complete in that we do not include field length or format (i.e. we define "Customer Number" but we do not say how long it is, whether it is divided into segments, or whether it is numeric or alphanumeric). For the purposes of this document, that amount of detail is not necessary.

Since many tables are used by more than one module, the tables are listed in alphabetical order.