| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 45 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |
2 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 19 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |
3 | JSTSTRPRO | IS-M/SD: Street File (Post) | 62 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |
4 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 99 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |
5 | JST_STR_CONS | IS-M: Table for Street Consolidation | 75 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |
TOPSAP Media |
6 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 75 | ERWPLZ | 2-Digit Postal Code Extension CH | nvarchar | 2 | 0 | | |