| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHTTBED | IS-M/AM: OPM - Rate Requirements | 7 | GUELTIGBIS | IS-M: "Valid To" Date | nvarchar | 8 | 0 | | |
| 2 | JHTVGPZ | IS-M/AM: Business Partner Assignment to the Contract | 10 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 3 | JJTBEBVTP | IS-M: Distribution BU Planned Quantities Assignment | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 4 | JJTBEVARI | IS-M/AM: Ad Insert BU Variants | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 5 | JJTBEWSIN | IS-M/AM: Booking Unit Content for Commercial | 13 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 6 | JJTFPLZOLZUO | IS-M/AM: Online Fixed Spaces Grouping | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 7 | JJTFPLZONL | IS-M/AM: Online Fixed Spaces | 8 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 8 | JJTKNTKTZHL | IS-M: Online Planned Gross Impressions | 7 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 9 | JJTKS | IS-M/AM: Business Partner Hierarchy | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 10 | JJTOBJIN | IS-M/AM: Planned Production Unit - Content | 9 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 11 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 7 | GUELTIGBIS | IS-M: "Valid To" Date | nvarchar | 8 | 0 | | |
| 12 | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | 5 | GUELTIGBIS | IS-M: "Valid To" Date | nvarchar | 8 | 0 | | |
| 13 | JJTWSIN | IS-M/AM: Assignment of Content Components to a BU | 8 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 14 | JJTZKI | IS-M/AM: Content of Date Combination BU | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 15 | TJJKAMP | IS-M/AM: Campaign (Customer) | 7 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 16 | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | 4 | GUELTIGBIS | IS-M: Date to Which Change Number is Valid | nvarchar | 8 | 0 | | |
| 17 | JSTALIAS | IS-M: Alias Table for Streets | 33 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 18 | JSTANDLOG | IS-M/SD: Log for Changes to JSTAENDER | 10 | GUELTIGBIS | IS-M: Date to Which Change Number is Valid | nvarchar | 8 | 0 | | |
| 19 | JSTBEZBEZ | IS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 20 | JSTCOUNTY | IS-M: Counties or Administrative Districts from USPS (USA) | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 21 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 22 | JSTGEOHIE | IS-M/SD: Geographical Hierarchy | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 23 | JSTGEOORG | IS-M/SD: Assignment of Geographical to Organizational Units | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 24 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 25 | JSTKGSPRO | IS-M/SD: District Municipality File | 19 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 26 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 23 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 27 | JSTLAUF | IS-M/SD: Round Sequence | 9 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 28 | JSTORGHIE | IS-M/SD: Organizational Plan Hierarchy | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 29 | JSTORTPRO | IS-M/SD: City File (Post) | 25 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 30 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 28 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 31 | JSTOTLPRO | IS-M: City District File | 20 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 32 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 24 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 33 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 22 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 34 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 17 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 35 | JSTPLZPRO | IS-M: Postal Codes | 23 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 36 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 27 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 37 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 24 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 38 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 30 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 39 | JSTROUPVA | IS-M/SD: Truck Route-Publication/Edition Assignment | 7 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 40 | JSTSTRPRO | IS-M/SD: Street File (Post) | 34 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 41 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 36 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 42 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 24 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 43 | JST_ORT_CONS | IS-M: Table for City Consolidation | 30 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 44 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 28 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 45 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 28 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 46 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 33 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 47 | JST_STR_CONS | IS-M: Table for Street Consolidation | 38 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 48 | JDTPVAWGRP | IS-M/SD: Edition Plant Assignment to Bundle Group | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 49 | JKAP | Sales Order - Item Data | 5 | GUELTIGBIS | Date to which Sales Order Item is Valid | nvarchar | 8 | 0 | | |
| 50 | JKAP_INACTIVE | Publishing Sales Order: Inactive Item Data | 6 | GUELTIGBIS | Date to which Sales Order Item is Valid | nvarchar | 8 | 0 | | |
| 51 | JKEP | Sales Order: Schedule Line Data | 6 | GUELTIGBIS | Date to Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 52 | JKPA | Sales Order: Partner | 7 | GUELTIGBIS | Date to Which Partner Data in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 53 | JKPAZ | Sales Order Item: Additional Planning Data | 9 | GUELTIGBIS | Valid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Item | nvarchar | 8 | 0 | | |
| 54 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 55 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 65 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 56 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 57 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 49 | GUELTIGBIS | Date to which Sales Order Item is Valid | nvarchar | 8 | 0 | | |
| 58 | JKWWWTEMP_SUSP | IS-M: Temporary Internet Table: Suspension Data | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 59 | JKWWWTEMP_TRNSF | IS-M: Internet Temporary Table: Transfer Data | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 60 | JKWWW_PROTOCOL | IS-M: Table for Logging Creation/Changes made with IACs | 13 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 61 | JRTABLDBAR | IS-M/SD: Unloading Viability Set | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 62 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 14 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 63 | JRTABLRGLA | IS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes) | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 64 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 65 | JRTBEABST | IS-M/SD: Unloading Point | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 66 | JRTROUBEA | IS-M/SD: Truck Route Unloading Point Sequence | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 67 | JRTROUHIE | IS-M/SD: Truck Route Hierarchy | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 68 | JRTRVERT | IS-M/SD: Truck Route Contract | 3 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 69 | JRTRVPOS | IS-M/SD: Item in Truck Route Contract | 5 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 70 | JVTBEZGP | IS-M/SD: Delivery Round - Business Partner | 9 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 71 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 72 | JVTMC_HH_SUSPEND | IS-M: TMC - Explicit Exclusion of Households | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 73 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 9 | GUELTIGBIS | Valid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Item | nvarchar | 8 | 0 | | |
| 74 | JVTNCT5 | IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.) | 9 | GUELTIGBIS | Date to Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | | |
| 75 | JVTPSHFIND | IS-M/SD: Production Procedure Determination | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 76 | JVTPSTFEHL | IS-M/SD: Postal Units not Delivered | 7 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 77 | JVTVARTIME | IS-M/SD: Time Slice Variant | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 78 | JVTVERPLAN | IS-M/SD: Shipping Schedule | 14 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 79 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 9 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 80 | JWBASI | IS-M/SD: Campaign Framework | 8 | GUELTIGBIS | End of Validity of Campaign Framework | nvarchar | 8 | 0 | | |
| 81 | JYTREORG | IS-M/SD: Reorganization Periods and Areas | 13 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 82 | JYTSTREORG | IS-M/SD: Reorganization Status | 11 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 83 | TJIABCZONES | Definition of ABZ Zones per Edition | 8 | GUELTIGBIS | To | nvarchar | 8 | 0 | | |
| 84 | TJL29 | IS-M/SD: Postal Settlement Types | 4 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 85 | TJLPB | IS-M/SD: Assign Insert Data to Postal Settlement NUubers | 8 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 86 | TJLPT | IS-M/SD: Assgt of Carrying Issue Data to Postal Settlemt Nos | 6 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 87 | TJWAK | IS-M/SD: Sales Promotion | 4 | GUELTIGBIS | End of Validity of Sales Promotion | nvarchar | 8 | 0 | | |
| TOPSAP Media |
| 88 | J_1SBOTPRO | IS-M/SD CH/S: CH Carrier Data | 9 | GUELTIGBIS | IS-M: CH/S: Validity Date | nvarchar | 8 | 0 | | |
| 89 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 41 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 90 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 46 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
| 91 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 14 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | |
