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