| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTOTLPRO | IS-M: City District File | 3 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
2 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 7 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
3 | JSTSTRDAVERW | Reference Table for Street Records from DBP | 26 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
4 | JSTSTRPRO | IS-M/SD: Street File (Post) | 11 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
5 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 13 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
6 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 8 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
7 | JST_OTL_STATE | Status of CDT Checks | 8 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
8 | JST_STR_CONS | IS-M: Table for Street Consolidation | 15 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
TOPSAP Media |
9 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 18 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |
10 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 23 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | |