| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | APH1 | Project Management - Stages - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
2 | APH2 | Project Management - Stages - Open Issues - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
3 | APH3 | Project Management - Stages - Attachments - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
4 | APH4 | Project Management - Stages - Documents - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
5 | APH5 | Project Management - Stages - Resources - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
6 | APH6 | Project Management - Stages - Activities - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
7 | APH7 | Project Management - Workorders - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
8 | APM1 | Project Management - Stages - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
9 | APM2 | Project Management - Stages - Open Issues - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
10 | APM3 | Project Management - Stages - Attachments - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
11 | APM4 | Project Management - Stages - Documents - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
12 | APM5 | Project Management - Stages - Resources - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
13 | APM6 | Project Management - Stages - Activities - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
14 | APM7 | Project Management - Workorders - History | 3 | StageID | Stage ID | Int | 11 | 0 | | |
15 | ASH1 | Project Management Time Sheet - Rows - History | 24 | StageID | Stage ID | Int | 11 | 0 | | |
16 | PHA1 | Project Management - Stages | 3 | StageID | Stage ID | Int | 11 | 0 | | |
17 | PHA2 | Project Management - Stages - Open Issues | 3 | StageID | Stage ID | Int | 11 | 0 | | |
18 | PHA3 | Project Management - Stages - Attachments | 3 | StageID | Stage ID | Int | 11 | 0 | | |
19 | PHA4 | Project Management - Stages - Documents | 3 | StageID | Stage ID | Int | 11 | 0 | | |
20 | PHA5 | Project Management - Stages - Resources | 3 | StageID | Stage ID | Int | 11 | 0 | | |
21 | PHA6 | Project Management - Stages - Activities | 3 | StageID | Stage ID | Int | 11 | 0 | | |
22 | PHA7 | Project Management - Workorders | 3 | StageID | Stage ID | Int | 11 | 0 | | |
23 | PMC2 | Project Management Configuration - Stages Setup | 1 | StageID | Stage No. | Int | 11 | 0 | | |
24 | PMG1 | Project Management - Stages | 3 | StageID | Stage ID | Int | 11 | 0 | | |
25 | PMG2 | Project Management - Stages - Open Issues | 3 | StageID | Stage ID | Int | 11 | 0 | | |
26 | PMG3 | Project Management - Stages - Attachments | 3 | StageID | Stage ID | Int | 11 | 0 | | |
27 | PMG4 | Project Management - Stages - Documents | 3 | StageID | Stage ID | Int | 11 | 0 | | |
28 | PMG5 | Project Management - Stages - Resources | 3 | StageID | Stage ID | Int | 11 | 0 | | |
29 | PMG6 | Project Management - Stages - Activities | 3 | StageID | Stage ID | Int | 11 | 0 | | |
30 | PMG7 | Project Management - Workorders | 3 | StageID | Stage ID | Int | 11 | 0 | | |
31 | PMG9 | Project Management - Charged Document Lines Log - Used by Billing Wizard | 9 | StageID | Stage ID | Int | 11 | 0 | | |
32 | TSH1 | Project Management Time Sheet - Rows | 24 | StageID | Stage ID | Int | 11 | 0 | | |
TOPInventory and Production |
33 | ATT1 | Bill of Materials - Components - History | 28 | StageId | Stage ID | Int | 11 | 0 | | |
34 | ATT2 | BOM - Route Stages - History | 2 | StageId | Stage ID | Int | 11 | 0 | | |
35 | AWO1 | Production Order (Rows) - History | 32 | StageId | Stage ID | Int | 11 | 0 | | |
36 | AWO4 | Production Order - Route Stages - History | 2 | StageId | Stage ID | Int | 11 | 0 | | |
37 | ITT1 | Bill of Materials - Components | 28 | StageId | Stage ID | Int | 11 | 0 | | |
38 | ITT2 | BOM - Route Stages | 2 | StageId | Stage ID | Int | 11 | 0 | | |
39 | UWOR1 | Production Order - Rows | 32 | StageId | Stage ID | Int | 11 | 0 | | |
40 | UWOR4 | Production Order - Route Stages | 2 | StageId | Stage ID | Int | 11 | 0 | | |
41 | WOR1 | Production Order - Rows | 32 | StageId | Stage ID | Int | 11 | 0 | | |
42 | WOR4 | Production Order - Route Stages | 2 | StageId | Stage ID | Int | 11 | 0 | | |