| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JJTBEPART | IS-M/AM: Booking Unit Elements (AI) | 6 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
TOPMaster Data |
2 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 3 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
3 | JSTGEOEINH | IS-M/SD: Geographical Unit | 2 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
4 | JSTGEOORG | IS-M/SD: Assignment of Geographical to Organizational Units | 3 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
5 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 2 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
TOPMedia Sales and Distribution |
6 | /NAM/JKDISPATCH | Dispatching object | 11 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
7 | JKAPPR | Ad Pre-Print Order: Item Data | 12 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
8 | JKPAZ | Sales Order Item: Additional Planning Data | 11 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
9 | JVTGEOPOT | IS-M: Geographical Unit, Time-Dependent Planned Circulation | 2 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
10 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 15 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
11 | JVTMCP_ITEM | IS-M: TMCP Structures (CRoute/GUnit) | 6 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
12 | JVTMCP_MERGE_RES | IS-M: TMCP Merge Result for Ship-To Party Address | 6 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
13 | JVTMCP_PROT | IS-M: TMCP Logs | 8 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
14 | JVTMCP_SCHEDULE | IS-M: TMCP Household Addresses for Structures | 6 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
15 | TJI31 | Geographical Hierarchy Variant for Statistics | 4 | GEOEIN | Geo. Unit as Root of the Geographical Hierarchy Version Tree | nvarchar | 10 | 0 | | |
16 | TJI32 | Exploded Geographical Hierarchy for Statistics | 14 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
17 | TJIABCZONES | Definition of ABZ Zones per Edition | 9 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
18 | TJVTMCP_EXCL_STR | IS-M: Market Coverage Exclusion for Carrier Routes/GUnits | 3 | GEOEIN | Number of Geographical Unit | nvarchar | 10 | 0 | | |
19 | TJWAK | IS-M/SD: Sales Promotion | 7 | GEOEIN | IS-M: Geographical Unit in Sales Promotion | nvarchar | 10 | 0 | | |