| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMaster Data |
| 1 | JSTALIAS | IS-M: Alias Table for Streets | 34 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 2 | JSTKGSPRO | IS-M/SD: District Municipality File | 20 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 3 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 24 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 4 | JSTORTPRO | IS-M/SD: City File (Post) | 26 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 5 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 29 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 6 | JSTOTLPRO | IS-M: City District File | 21 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 7 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 25 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 8 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 23 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 9 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 18 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 10 | JSTPLZPRO | IS-M: Postal Codes | 24 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 11 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 28 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 12 | JSTSTRPRO | IS-M/SD: Street File (Post) | 35 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 13 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 37 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 14 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 25 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 15 | JST_ORT_CONS | IS-M: Table for City Consolidation | 31 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 16 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 29 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 17 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 29 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 18 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 34 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 19 | JST_STR_CONS | IS-M: Table for Street Consolidation | 39 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 20 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 54 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| TOPSAP Media |
| 21 | J_1SPLZZUO | Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data) | 29 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 22 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 42 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
| 23 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 47 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
