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