| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAddress ManagementBusiness Address |
1 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 25 | HOUSENUM_H | House number - upper limit (LSM Workbench interface only) | nvarchar | 10 | 0 | | |
2 | ADRSTRPCD | Street (section)/postal code: Assignment | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
TOPIntercompany Data Exchange |
3 | EADRSTRTGRID | Allocation of Grid to Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
4 | EADRSTRTGRID_NEW | Allocation of Grid in Utilities Industry to Street (New) | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
TOPRegional structure |
5 | ADRSTRTCCS | Division-Dependent Data for Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
6 | ADRSTRTISU | IS-U Applic. Data for Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
7 | ADRSTRTKON | Franchise Contracts for Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
8 | ADRSTRTMRU | MRUs for Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
9 | EADRSTRTAMS | AMS for Street | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |
10 | EADRSTRTROUTE | Route Number for Street Section | 4 | HOUSENUM_H | House number - upper limit of an interval | nvarchar | 10 | 0 | | |