| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | LAW2D_USMM_PERS | LAW 2.0 USMM user results | 20 | EXTERNALID | LAW 2.0 External Grouping ID | ntext | 1073741823 | 0 | | |
| 2 | RSCRMTGEXTIDS | External IDs in Target Groups | 2 | EXTERNALID | External ID for Business Partner (for example, D&B) | nvarchar | 40 | 0 | | |
| 3 | RSCRMTGTODO | External IDs Still to be Attached to Target Group | 4 | EXTERNALID | External ID for Business Partner (for example, D&B) | nvarchar | 40 | 0 | | |
| TOPAlert Framework |
| 4 | SALRT | Alert: Instance Table | 9 | EXTERNALID | External ID for an Alert | nvarchar | 5 | 0 | | |
| TOPEnergy Data Management |
| 5 | ESERVPROV | Service provider | 5 | EXTERNALID | External Number | nvarchar | 20 | 0 | | |
| TOPExternal Services |
| 6 | ESLL | Lines of Service Package | 71 | EXTERNALID | SRM Reference Key | nvarchar | 40 | 0 | | |
| TOPIntercompany Data Exchange |
| 7 | EGRID | Grid in the Utilities Industry | 6 | EXTERNALID | External ID of Grid | nvarchar | 40 | 0 | | |
| 8 | TEPRV | Obsolete- do not use! | 6 | EXTERNALID | External Number | nvarchar | 20 | 0 | | |
| TOPTransport Management System |
| 9 | TMSBUFPRO | TMS Manager: Project Info for Requests of Import Queues | 5 | EXTERNALID | Project ID | nvarchar | 32 | 0 | | |
| TOPTransport Organizer |
| 10 | CTSPROJECT | Assignment of a CTS Project to an External Project | 2 | EXTERNALID | Project ID | nvarchar | 32 | 0 | | |
