| 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 | | |