| 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 | 7 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
2 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 2 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
3 | JSTPLZPRO | IS-M: Postal Codes | 2 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
4 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 6 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
5 | JSTSTRDAVERW | Reference Table for Street Records from DBP | 20 | PLZNEU | IS-M: New postal code (D) | nvarchar | 5 | 0 | | |
6 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 6 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
7 | JST_PLZ_STATE | Status of Postal Code Checks | 6 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
8 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 6 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
9 | JST_PLO_CONS | IS-M: Table for Consolidating Postal Code-City | 7 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
10 | JST_PLO_STATE | Status of Postal Code Checks | 7 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
TOPSAP Media |
11 | J_1SPLZPRO | IS-M/SD CH/S: CH Postal Codes | 2 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
12 | J_1SPLZZUO | Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data) | 2 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |
13 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 15 | PLZNEU | IS-M: Postal code | nvarchar | 10 | 0 | | |