| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | APJ2 | Project Plan Steps Time Record | 4 | Date | Date | Date | 8 | 0 | | |
| 2 | ATC1 | Attachments - Rows | 7 | Date | Attachment Date | Date | 8 | 0 | | |
| 3 | OCCD | Cargo Customs Declaration Numbers | 2 | Date | Date | Date | 8 | 0 | | |
| 4 | PJT2 | Project Plan Steps Time Record | 4 | Date | Date | Date | 8 | 0 | | |
| 5 | USR5 | User Access Log | 5 | Date | Date | Date | 8 | 0 | | |
| TOPBusiness Partners |
| 6 | ACL1 | Activity Check-ins | 3 | Date | Date | Date | 8 | 0 | | |
| 7 | CLG1 | Activity CheckIns | 3 | Date | Date | Date | 8 | 0 | | |
| TOPGeneral |
| 8 | APH2 | Project Management - Stages - Open Issues - History | 12 | DATE | Date Entered | Date | 8 | 0 | | |
| 9 | APH3 | Project Management - Stages - Attachments - History | 6 | DATE | Date | Date | 8 | 0 | | |
| 10 | APM2 | Project Management - Stages - Open Issues - History | 12 | DATE | Date Entered | Date | 8 | 0 | | |
| 11 | APM3 | Project Management - Stages - Attachments - History | 6 | DATE | Date | Date | 8 | 0 | | |
| 12 | ASH1 | Project Management Time Sheet - Rows - History | 3 | Date | Date | Date | 8 | 0 | | |
| 13 | OCPT | Cockpit Main Table | 13 | Date | Publication Date | Date | 8 | 0 | | |
| 14 | ONCP | New Cockpit Table | 12 | Date | Publication Date | Date | 8 | 0 | | |
| 15 | OTCN | Tracking Note | 3 | Date | Date | Date | 8 | 0 | | |
| 16 | PHA2 | Project Management - Stages - Open Issues | 12 | DATE | Date Entered | Date | 8 | 0 | | |
| 17 | PHA3 | Project Management - Stages - Attachments | 6 | DATE | Date | Date | 8 | 0 | | |
| 18 | PMG2 | Project Management - Stages - Open Issues | 12 | DATE | Date Entered | Date | 8 | 0 | | |
| 19 | PMG3 | Project Management - Stages - Attachments | 6 | DATE | Date | Date | 8 | 0 | | |
| 20 | RLCK | resource locks table | 5 | date | Date | Date | 8 | 0 | | |
| 21 | RLOG | Resource Edit Log | 6 | Date | Date | Date | 8 | 0 | | |
| 22 | RMSG | EditMode Messages | 4 | date | date | Date | 8 | 0 | | |
| 23 | RSDB | Resource DB List | 4 | Date | Creation date | Date | 8 | 0 | | |
| 24 | SFDK | SFDK | 5 | Date | Feedback Date | Date | 8 | 0 | | |
| 25 | SXREL | XLR Event Log | 4 | Date | Date | Date | 8 | 0 | | |
| 26 | TSH1 | Project Management Time Sheet - Rows | 3 | Date | Date | Date | 8 | 0 | | |
| TOPHuman Resources |
| 27 | AHE3 | Employee Reviews | 3 | date | Employee Review Date | Date | 8 | 0 | | |
| 28 | HEM3 | Employee Reviews | 3 | date | Employee Review Date | Date | 8 | 0 | | |
| TOPMarketing Documents |
| 29 | OMIN | A/R Monthly Invoice | 3 | Date | Monthly Invoice Issue Date | Date | 8 | 0 | | |
| 30 | OMIV | A/P Monthly Invoice | 3 | Date | Issued Date | Date | 8 | 0 | | |
| TOPMRP |
| 31 | FCT1 | Sales Forecast - Rows | 4 | Date | Day Forecasted | Date | 8 | 0 | | |
| TOPReports |
| 32 | OSOI | Statement of Import Wizard | 3 | Date | Run Date | Date | 8 | 0 | | |
| 33 | SRA2 | Scheduled Report Run Output | 2 | Date | Date of Run | Date | 8 | 0 | | |
