| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | APJ1 | Project Plan Steps | 14 | Owner | Owner | nVarChar | 254 | 0 | | |
2 | APJ2 | Project Plan Steps Time Record | 9 | Owner | Owner | nVarChar | 254 | 0 | | |
3 | AWLS | Workflow - Task Details | 16 | Owner | Owner | nVarChar | 25 | 0 | | |
4 | AWTS | Workflow Engine Task Table | 2 | Owner | Owner | nVarChar | 254 | 0 | | |
5 | OWLS | Workflow - Task Details | 16 | Owner | Owner | nVarChar | 25 | 0 | | |
6 | OWTS | Workflow Engine Task Table | 2 | Owner | Owner | nVarChar | 254 | 0 | | |
7 | PJT1 | Project Plan Steps | 14 | Owner | Owner | nVarChar | 254 | 0 | | |
8 | PJT2 | Project Plan Steps Time Record | 9 | Owner | Owner | nVarChar | 254 | 0 | | |
TOPBusiness Partners |
9 | ACPN | Campaign | 5 | Owner | Campaign Owner | Int | 11 | 0 | | |
10 | AOAT | Blanket Agreement | 11 | Owner | Owner | Int | 11 | 0 | | |
11 | OCPN | Campaign | 5 | Owner | Campaign Owner | Int | 11 | 0 | | |
12 | OOAT | Blanket Agreement | 11 | Owner | Owner | Int | 11 | 0 | | |
TOPGeneral |
13 | APH1 | Project Management - Stages - History | 17 | OWNER | Owner | Int | 11 | 0 | | |
14 | APHA | Project Management Subproject - History | 2 | OWNER | Owner | Int | 11 | 0 | | |
15 | APM1 | Project Management - Stages - History | 17 | OWNER | Owner | Int | 11 | 0 | | |
16 | APMG | Project Management Document - History | 2 | OWNER | Owner | Int | 11 | 0 | | |
17 | IMGDT | User Delete Group Log Time | 2 | Owner | Message Owner | nVarChar | 25 | 0 | | |
18 | IMPLG | Private Message Log | 2 | Owner | Message Owner | nVarChar | 25 | 0 | | |
19 | IMQSG | Question Suggestions | 5 | Owner | Owner of Suggestion | nVarChar | 25 | 0 | | |
20 | ONCP | New Cockpit Table | 3 | Owner | Owner | Int | 11 | 0 | | |
21 | OPHA | Project Management Subproject | 2 | OWNER | Owner | Int | 11 | 0 | | |
22 | OPMG | Project Management Document | 2 | OWNER | Owner | Int | 11 | 0 | | |
23 | PHA1 | Project Management - Stages | 17 | OWNER | Owner | Int | 11 | 0 | | |
24 | PMG1 | Project Management - Stages | 17 | OWNER | Owner | Int | 11 | 0 | | |
25 | SPAR | SPAR | 1 | Owner | Owner | nVarChar | 40 | 0 | | |
TOPSales Opportunities |
26 | AOPR | Opportunity | 44 | Owner | Data Ownership field | Int | 11 | 0 | | |
27 | OOPR | Opportunity | 44 | Owner | Data Ownership field | Int | 11 | 0 | | |
28 | OPR1 | Opportunity - Rows | 23 | Owner | Data Ownership Field | Int | 11 | 0 | | |
TOPService |
29 | ACTR | Service Contracts | 5 | Owner | Owner | Int | 6 | 0 | | |
30 | OCTR | Service Contracts | 5 | Owner | Owner | Int | 6 | 0 | | |
31 | OSLT | Service Call Solutions | 4 | Owner | Owner | Int | 11 | 0 | | |