Relational database: selected modules
| ERP functional module | Number of tables | Tables in the module as % of the total | Records within each module (in thousands) | Records of each module as % of the total | Average number of records per module |
|---|---|---|---|---|---|
| Accounting (AC) | 78 | 4.06% | 225,245 | 5.02% | 2,887,757 |
| Human Resources (HR) | 340 | 17.68% | 1,484 | 0.03% | 4,365 |
| Inventory (IN) | 71 | 3.69% | 14,916 | 0.33% | 210,091 |
| Operations Management (OM) | 58 | 3.02% | 381 | 0.01% | 6,562 |
| Internal Requests (IR) | 87 | 4.52% | 1,832 | 0.04% | 21,063 |
| Commercial Management (CM) | 808 | 42.02% | 4,093,412 | 91.25% | 5,066,104 |
| Payroll (PR) | 381 | 19.81% | 135,126 | 3.01% | 354,662 |
| Records Management (RM) | 100 | 5.2% | 13,417 | 0.30% | 134,168 |
| Total Database | 1,923 | 100% | 4,485,813 | 100.00% | 2,332,716* |
| ERP functional module | Number of tables | Tables in the module as % of the total | Records within each module (in thousands) | Records of each module as % of the total | Average number of records per module |
|---|---|---|---|---|---|
| Accounting (AC) | 78 | 4.06% | 225,245 | 5.02% | 2,887,757 |
| Human Resources (HR) | 340 | 17.68% | 1,484 | 0.03% | 4,365 |
| Inventory (IN) | 71 | 3.69% | 14,916 | 0.33% | 210,091 |
| Operations Management (OM) | 58 | 3.02% | 381 | 0.01% | 6,562 |
| Internal Requests (IR) | 87 | 4.52% | 1,832 | 0.04% | 21,063 |
| Commercial Management (CM) | 808 | 42.02% | 4,093,412 | 91.25% | 5,066,104 |
| Payroll (PR) | 381 | 19.81% | 135,126 | 3.01% | 354,662 |
| Records Management (RM) | 100 | 5.2% | 13,417 | 0.30% | 134,168 |
| Total Database | 1,923 | 100% | 4,485,813 | 100.00% | 2,332,716* |
Note(s): *The average number of records per module at the level of the total database is calculated as the total records divided by the total of tables as follows: 4,485,813,693/1,923 = 2,332,716
Source(s): Own elaboration
Sharing content requires targeting cookies to be enabled. Please update your cookie preferences to use this feature.