| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClassification System New |
| 1 | CHARACTER_DMLDB | Characteristic | 8 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| 2 | CHARACTER_DMLH | Characteristic | 10 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| 3 | DEFSCOPE_DMLDB | Definition Scope | 8 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| 4 | DEFSCOPE_DMLH | Definition Scope | 10 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| 5 | DTYPE_DMLDB | CME Data Type | 8 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| 6 | DTYPE_DMLH | CME Data Type | 10 | STATE_ID | Key Status | varbinary | 16 | 0 | | |
| TOPDevelopment Plans |
| 7 | HRPAD77 | Additional data for PAD77 | 3 | STATE_ID | State of Development Plan | nvarchar | 2 | 0 | | |
| 8 | T77BX | Further Processing of Development Plans | 3 | STATE_ID | State of Development Plan | nvarchar | 2 | 0 | | |
| 9 | T77BY | Texts for Development Plan States | 3 | STATE_ID | State of Development Plan | nvarchar | 2 | 0 | | |
| 10 | T77BZ | Development Plan States | 2 | STATE_ID | State of Development Plan | nvarchar | 2 | 0 | | |
| TOPSAP NetWeaver Mobile - Use subcomponents |
| 11 | MEREP_10100 | Replica DB for Synchronization (Base) Segmt | 11 | STATE_ID | State ID | nvarchar | 32 | 0 | | |
| 12 | MEREP_10700 | Mobile Sync Key Control Table | 12 | STATE_ID | State ID | nvarchar | 32 | 0 | | |
| 13 | MEREP_10700D | Mobile Log Table for TOP Data | 12 | STATE_ID | State ID | nvarchar | 32 | 0 | | |
| 14 | MEREP_201 | Replica DB for Download (Base) | 14 | STATE_ID | State ID | nvarchar | 32 | 0 | | |
| 15 | MEREP_207 | Replica DB for Timed 2-Way Sync | 15 | STATE_ID | State ID | nvarchar | 32 | 0 | | |
| TOPTransport Management System |
| 16 | CMSDPUBLISH | CMS: Publish | 3 | STATE_ID | Character Field Length = 10 | nvarchar | 10 | 0 | | |
| 17 | CMSDSTATE | CMS Lifecycle States | 1 | STATE_ID | Character Field Length = 10 | nvarchar | 10 | 0 | | |
| 18 | CMSDSUBSCRIBE | CMS: Subscribe | 4 | STATE_ID | Character Field Length = 10 | nvarchar | 10 | 0 | | |
