| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 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 |
| Banking | ||||||||||
| 4 | OPYM | Payment Methods for Payment Wizard | 47 | Active | Status of the Payment Method | VarChar | 1 | 0 | Y | |
| Business Partners | ||||||||||
| 5 | ACPR | Contact Persons - History | 27 | Active | Active | VarChar | 1 | 0 | Y | |
| 6 | OCPR | Contact Persons | 27 | Active | Active | VarChar | 1 | 0 | Y | |
| Finance | ||||||||||
| 7 | AMDR | Manual Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | |
| 8 | OFRC | Financial Report Categories | 7 | Active | Active Account | VarChar | 1 | 0 | N | |
| 9 | OMDR | Manual Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | |
| 10 | OPRJ | Project Codes | 8 | Active | Active | VarChar | 1 | 0 | Y | |
| Human Resources | ||||||||||
| 11 | AHEM | Employees | 115 | Active | Employee Status | VarChar | 1 | 0 | Y | |
| 12 | OHEM | Employees | 115 | Active | Employee Status | VarChar | 1 | 0 | Y | |
| Reports | ||||||||||
| 13 | EJD1 | ERV-JAb Signing Persons List | 8 | Active | Active | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 14 | OSRA | Scheduled Report Actions | 10 | Active | Schedule Active Status | VarChar | 1 | 0 | Y | |
| Sales Opportunities | ||||||||||
| 15 | AOCR | Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | |
| 16 | OOCR | Distribution Rule | 10 | Active | Active | VarChar | 1 | 0 | Y | |
| 17 | OPRC | Cost Center | 12 | Active | Active | VarChar | 1 | 0 | Y | |