| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBusiness Partners |
| 1 | ACLG | Activities - History | 7 | Closed | Closed Activity | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | OCLG | Activities | 7 | Closed | Closed Activity | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPFinance |
| 3 | AJD1 | Journal Entry - History - Rows | 55 | Closed | Closed | VarChar | 1 | 0 | N | |
| 4 | BTF1 | Journal Voucher - Rows | 55 | Closed | Closed | VarChar | 1 | 0 | N | |
| 5 | JDT1 | Journal Entry - Rows | 55 | Closed | Closed | VarChar | 1 | 0 | N | |
| TOPGeneral |
| 6 | APH2 | Project Management - Stages - Open Issues - History | 7 | CLOSED | Closed | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 7 | APM2 | Project Management - Stages - Open Issues - History | 7 | CLOSED | Closed | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | PHA2 | Project Management - Stages - Open Issues | 7 | CLOSED | Closed | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 9 | PMG2 | Project Management - Stages - Open Issues | 7 | CLOSED | Closed | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPMarketing Documents |
| 10 | MIN1 | Monthly Invoice Report Document Information | 13 | Closed | Document Closed? | VarChar | 1 | 0 | N | |
| 11 | MIV1 | A/P Monthly Invoice - Document | 13 | Closed | Is Document closed in MI | VarChar | 1 | 0 | N | N=Not Closed, Y=Closed |
