| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTSTRPRO | IS-M/SD: Street File (Post) | 61 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
2 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 98 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
3 | JST_STR_CONS | IS-M: Table for Street Consolidation | 74 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
4 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 10 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
TOPSAP Media |
5 | J_1SPLZZUO | Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data) | 6 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
6 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 32 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
7 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 10 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
8 | J_1SSTRPRO | IS-M/SD CH/S: CH Street Data | 9 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |
9 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 73 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | |