| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPEnergy Data Management |
| 1 | EAMI_AMS_ALLOC | Allocation of AMI to Grid | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 2 | EEDMSETTLDOCALER | Settlement Document (Alerts) | 15 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 3 | EEDMSETTLDOCERR | Settlement Document (Errors) | 16 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 4 | EEDMSETTLDOCPARV | Settlement Document (Persistent Value Parameters) | 11 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 5 | EEDMSETTLDOCSNDP | Settlement Document (Sent Profiles) | 14 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 6 | EEDMSETTLDOCUPDP | Settlement Document (Updated Profiles) | 9 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 7 | EEDMSETTLIN | Load Shapes Per Settlement Run | 5 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 8 | EEDMSETTLUF | Usage Factors per Settlement Run | 5 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| TOPIntercompany Data Exchange |
| 9 | EADRCITYGRID | Allocation of Grid to City | 5 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 10 | EADRCITYGRID_NEW | Allocation of Grid in Utilities Industry to Location (New) | 6 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 11 | EADRSTRTGRID | Allocation of Grid to Street | 10 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 12 | EADRSTRTGRID_NEW | Allocation of Grid in Utilities Industry to Street (New) | 11 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 13 | EGRID | Grid in the Utilities Industry | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 14 | EGRIDH | Allocation of Distributor to Grid | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 15 | EGRIDL | Allocation of Grid Level to Grid | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 16 | EGRIDPOD | Allocation of Point of Delivery to Grid | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 17 | EGRIDRATEDET | Rate Determination for Grid | 3 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 18 | EGRIDT | Grid in the Utilities Industry (Text Table) | 3 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 19 | EGRIDVL | Allocation of Voltage Level to Grid | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| TOPPoint of delivery |
| 20 | EUIGRID | Allocation of PoD to Grid | 7 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| TOPSAP Utilities |
| 21 | EEXTSYNPROF | Conversion of External Synthetic Profile ID and Profile | 3 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 22 | EEXTSYNPROFT | Conversion of Ext. Synth. Prof. Description and Prof. (Txt) | 3 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 23 | EFRANCH_GRID_IN | Assign Franchisee to Grid for India | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 24 | EPROFIL_SETL_PAR | Parameter for Settlement Units | 2 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
| 25 | EPROF_DELV_IN | India : Proof of delivery for Bill Distribution | 5 | GRID_ID | Grid | nvarchar | 10 | 0 | | |
