| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPeriodical Sales and Distribution |
1 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 23 | GEMEINDENR | IS-M: CH: Municipality Number from Federal Statistics Office | nvarchar | 5 | 0 | | |
TOPSAP Media |
2 | J_1SPLZPRO | IS-M/SD CH/S: CH Postal Codes | 28 | GEMEINDENR | IS-M: CH: Municipality Number from Federal Statistics Office | nvarchar | 5 | 0 | | |
3 | J_1SPLZZUO | Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data) | 19 | GEMEINDENR | IS-M: CH: Municipality Number from Federal Statistics Office | nvarchar | 5 | 0 | | |
4 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 38 | GEMEINDENR | IS-M: CH: Municipality Number from Federal Statistics Office | nvarchar | 5 | 0 | | |