| 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 | 18 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
2 | ADRSTRCONV | Conversion of Street Sections | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
3 | ADRSTREET | Streets | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
4 | ADRSTREETT | Streets (long texts) | 4 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
5 | ADRSTRPCD | Street (section)/postal code: Assignment | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPIntercompany Data Exchange |
6 | EADRSTRTGRID | Allocation of Grid to Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
7 | EADRSTRTGRID_NEW | Allocation of Grid in Utilities Industry to Street (New) | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPRegional structure |
8 | ADRSTRTCCS | Division-Dependent Data for Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
9 | ADRSTRTISU | IS-U Applic. Data for Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
10 | ADRSTRTKON | Franchise Contracts for Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
11 | ADRSTRTMRU | MRUs for Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
12 | EADRSTRTAMS | AMS for Street | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
13 | EADRSTRTROUTE | Route Number for Street Section | 3 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPWaste Management |
14 | EEWA_ROB | Cleaning Object | 30 | STRT_CODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |