ERP Internals/Data Tables

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. Accounts Payable Check Accounts Payable Invoice Accounts Receivable Invoice Accounts Receivable Payment Bank Bank Check Bank Deposit Bank Transaction Bill of Materials Bondholder Bondholder Transaction Chart of Accounts Contact Currency Customer Employee Employee Check Employee Transaction Fixed Asset Fixed Asset Transaction General Ledger Account Balance General Ledger Budget General Ledger Reports General Ledger Transaction HR Benefits HR Deductions HR Hiring HR Planned Days Off HR Qualifications HR Review Item Item Analysis Item Transaction Job Job Transaction Maintenance Master Production Schedule Material Requirements Opportunity Purchase Order Quotation/Estimate Sales Analysis Sales Compensation Sales Order Sales Representative Service Contract Shareholder Shareholder Transaction Supplier Time User Unit