| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | OALT | Alerts Template | 5 | Active | Active Alert | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | ODOW | Data Ownership - Objects | 4 | Active | Indication: Does it Work | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 3 | OWTM | Approval Templates | 5 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPBanking |
| 4 | OPYM | Payment Methods for Payment Wizard | 47 | Active | Status of the Payment Method | VarChar | 1 | 0 | Y | N=Inactive, Y=Active |
| TOPBusiness Partners |
| 5 | ACPR | Contact Persons - History | 27 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 6 | OCLS | Activity Subjects | 6 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 7 | OCLT | Activity Types | 5 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 8 | OCPR | Contact Persons | 27 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 9 | OSLP | Sales Employee | 10 | Active | Active | VarChar | 1 | 0 | Y | N=Inactive, Y=Active |
| TOPFinance |
| 10 | AAC1 | Asset Classes - Depreciation Areas - History | 4 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 11 | ACS1 | Asset Classes - Depreciation Areas | 4 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 12 | ADMC | G/L Account Determination Criteria - Inventory - History | 3 | Active | Determination Status | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 13 | AGAR | G/L Account Advanced Rules - History | 78 | Active | Is Rule Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 14 | AMDR | Manual Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 15 | APRJ | Project Codes | 8 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 16 | ODMC | G/L Account Determination Criteria - Inventory | 3 | Active | Determination Status | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 17 | OFRC | Financial Report Categories | 7 | Active | Active Account | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 18 | OGAR | G/L Account Advanced Rules | 78 | Active | Is Rule Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 19 | OMDR | Manual Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 20 | OPRJ | Project Codes | 8 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPGeneral |
| 21 | ADRC | G/L Account Determination Criteria - Resources - History | 3 | Active | Determination Status | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 22 | AGRS | G/L Account Advanced Rules for Resources - History | 51 | Active | Is Rule Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 23 | ODRC | G/L Account Determination Criteria - Resources | 3 | Active | Determination Status | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 24 | OGRS | G/L Account Advanced Rules for Resources | 51 | Active | Is Rule Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPHuman Resources |
| 25 | AHEM | Employees - History | 115 | Active | Employee Status | VarChar | 1 | 0 | Y | N=Inactive, Y=Active |
| 26 | OHEM | Employees | 115 | Active | Employee Status | VarChar | 1 | 0 | Y | N=Inactive, Y=Active |
| TOPReports |
| 27 | EJD1 | ERV-JAb Signing Persons List | 8 | Active | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 28 | OSRA | Scheduled Report Actions | 10 | Active | Schedule Active Status | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPSales Opportunities |
| 29 | ACEM | Cost Element | 3 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 30 | AOCR | Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 31 | APRC | Cost Center | 12 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 32 | OCEM | Cost Element | 3 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 33 | OOCR | Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 34 | OPRC | Cost Center | 12 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPService |
| 35 | ORCI | Recipient List | 3 | Active | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
