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