| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ODCR | Checking Rule | 11 | validFrom | Active From | nVarChar | 8 | 0 | | |
| TOPBusiness Partners |
| 2 | ACRD | Business Partners - History | 152 | validFrom | Active From | Date | 8 | 0 | | |
| 3 | OCRD | Business Partner | 152 | validFrom | Active From | Date | 8 | 0 | | |
| TOPFinance |
| 4 | AACT | G/L Account - History | 54 | ValidFrom | Active From | Date | 8 | 0 | | |
| 5 | ADTP | Fixed Assets Depreciation Types - History | 15 | ValidFrom | Valid From | Date | 8 | 0 | 19000101 | |
| 6 | AJD1 | Journal Entry - History - Rows | 77 | ValidFrom | Valid From | Date | 8 | 0 | 19000101 | |
| 7 | AMDR1 | Manual Distribution Rule - Rows | 7 | ValidFrom | Effective from | Date | 8 | 0 | 19000101 | |
| 8 | APRJ | Project Codes | 6 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 9 | BTF1 | Journal Voucher - Rows | 77 | ValidFrom | Valid From | Date | 8 | 0 | 19000101 | |
| 10 | JDT1 | Journal Entry - Rows | 77 | ValidFrom | Valid From | Date | 8 | 0 | 19000101 | |
| 11 | MDR1 | Manual Distribution Rule - Rows | 7 | ValidFrom | Effective From | Date | 8 | 0 | 19000101 | |
| 12 | OACT | G/L Accounts | 54 | ValidFrom | Active From | Date | 8 | 0 | | |
| 13 | ODTP | Fixed Assets Depreciation Types | 15 | ValidFrom | Valid From | Date | 8 | 0 | 19000101 | |
| 14 | OPRJ | Project Codes | 6 | ValidFrom | Valid From | Date | 8 | 0 | | |
| TOPGeneral |
| 15 | ARSC | Resource Master Data - Log | 28 | validFrom | Active From | Date | 8 | 0 | | |
| 16 | ORSC | Resources | 28 | validFrom | Active From | Date | 8 | 0 | | |
| TOPInventory and Production |
| 17 | AIT5 | Asset Item Projects - History | 3 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 18 | AIT6 | Asset Item Distribution Rules | 3 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 19 | AITM | Items - History | 190 | validFrom | Active From | Date | 8 | 0 | | |
| 20 | APLN | Price Lists | 15 | ValidFrom | Active From | Date | 8 | 0 | | |
| 21 | ITM5 | Asset Item Projects | 3 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 22 | ITM6 | Asset Item Distribution Rules | 3 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 23 | OITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | | |
| 24 | OPLN | Price Lists | 15 | ValidFrom | Active From | Date | 8 | 0 | | |
| 25 | SITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | | |
| 26 | UITM | Items | 190 | validFrom | Active From | Date | 8 | 0 | | |
| TOPSales Opportunities |
| 27 | AOC1 | Distribution Rule - Rows | 7 | ValidFrom | Effective from | Date | 8 | 0 | | |
| 28 | APRC | Cost Center | 10 | ValidFrom | Valid From | Date | 8 | 0 | | |
| 29 | OCR1 | Distribution Rule - Rows | 7 | ValidFrom | Effective From | Date | 8 | 0 | 19000101 | |
| 30 | OPRC | Cost Center | 10 | ValidFrom | Valid From | Date | 8 | 0 | | |
