| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AWLS | Workflow - Task Details | 17 | Priority | Priority | Int | 6 | 0 | 2 | 1=High, 2=Medium, 3=Low |
2 | OALR | Alerts | 3 | Priority | Priority | VarChar | 1 | 0 | 1 | 0=-, 2=mHighPriority |
3 | OALT | Alerts Template | 4 | Priority | Priority | VarChar | 1 | 0 | 1 | 0=Low, 1=Normal, 2=High |
4 | OWLS | Workflow - Task Details | 17 | Priority | Priority | Int | 6 | 0 | 2 | 1=High, 2=Medium, 3=Low |
5 | TCD1 | Key Fields for Determination | 6 | Priority | Priority | Int | 11 | 0 | 0 | |
TOPBusiness Partners |
6 | ACLG | Activities - History | 31 | Priority | Priority | VarChar | 1 | 0 | 1 | 0=Low, 1=Normal, 2=High |
7 | ACRD | Business Partners - History | 145 | Priority | Priority | Int | 11 | 0 | -1 | |
8 | OCLG | Activities | 31 | Priority | Priority | VarChar | 1 | 0 | 1 | 0=Low, 1=Normal, 2=High |
9 | OCRD | Business Partner | 145 | Priority | Priority | Int | 11 | 0 | -1 | |
TOPFinance |
10 | ADMC | G/L Account Determination Criteria - Inventory - History | 4 | Priority | Determination Priority | Int | 6 | 0 | | |
11 | ODMC | G/L Account Determination Criteria - Inventory | 4 | Priority | Determination Priority | Int | 6 | 0 | | |
12 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 5 | Priority | Rule Priority | Int | 6 | 0 | 100 | |
13 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 5 | Priority | Rule Priority | Int | 6 | 0 | 100 | |
TOPGeneral |
14 | ADRC | G/L Account Determination Criteria - Resources - History | 4 | Priority | Determination Priority | Int | 6 | 0 | | |
15 | APH2 | Project Management - Stages - Open Issues - History | 5 | PRIORITY | Priority | Int | 11 | 0 | | |
16 | APM2 | Project Management - Stages - Open Issues - History | 5 | PRIORITY | Priority | Int | 11 | 0 | | |
17 | ODRC | G/L Account Determination Criteria - Resources | 4 | Priority | Determination Priority | Int | 6 | 0 | | |
18 | PHA2 | Project Management - Stages - Open Issues | 5 | PRIORITY | Priority | Int | 11 | 0 | | |
19 | PMG2 | Project Management - Stages - Open Issues | 5 | PRIORITY | Priority | Int | 11 | 0 | | |
TOPInventory and Production |
20 | AWOR | Production Order - History | 50 | Priority | Priority | Int | 6 | 0 | 100 | |
21 | OWOR | Production Order | 50 | Priority | Priority | Int | 6 | 0 | 100 | |
22 | UWOR | Production Order | 50 | Priority | Priority | Int | 6 | 0 | 100 | |
TOPService |
23 | ASCL | History | 19 | priority | Priority | VarChar | 1 | 0 | L | H=High, L=Low, M=Medium |
24 | OSCL | Service Calls | 19 | priority | Priority | VarChar | 1 | 0 | L | H=High, L=Low, M=Medium |
25 | QUE2 | Queue Elements | 5 | priority | Priority | Int | 11 | 0 | | |