| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHTMXK | IS-M: Media-Mix Contract Header Data | 22 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
2 | JHTVABRUF | IS-M/AM: Contract Access | 31 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
3 | JHTVB | IS-M/AM: Contract Requirements | 21 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
4 | JHTVKO | IS-M/AM: Contract | 34 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
5 | JJTBB | IS-M/AM: Requirement Element of Media Sales Agent Contract | 29 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
6 | JJTBE | IS-M/AM: Booking Units | 45 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
7 | JJTBED | IS-M/AM: Date-Specific Booking Units (Exceptions) | 15 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
8 | JJTBEDWSIN | IS-M/AM: Booking Unit Content for Commercial (Date-Specific) | 12 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
9 | JJTBEWSIN | IS-M/AM: Booking Unit Content for Commercial | 20 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
10 | JJTBEZK | IS-M: Time Combination for Booking Unit Hierarchy | 19 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
11 | JJTFPLZ | IS-M/AM: Fixed Spaces Capacity | 8 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
12 | JJTFPLZD | IS-M/AM: Date-Specific Capacity for Fixed Spaces | 8 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
13 | JJTIKO | IS-M/AM: Content Component | 13 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
14 | JJTOBJIN | IS-M/AM: Planned Production Unit - Content | 23 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
15 | JJTPPE | IS-M/AM: Planned Production Unit | 12 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
16 | JJTPVAPE | IS-M/AM: Edition Element | 9 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
17 | JJTTS | IS-M/AM: Barred Telephone Numbers List | 7 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
18 | JJTVAPE | IS-M/AM: Issue Element | 8 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
19 | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | 17 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
20 | JJTWSIN | IS-M/AM: Assignment of Content Components to a BU | 14 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
21 | JJTZKI | IS-M/AM: Content of Date Combination BU | 7 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
TOPMaster Data |
22 | JSTGEOEINH | IS-M/SD: Geographical Unit | 17 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
23 | JVTABEZART | IS-M: Additional Fields for Sales Agent/Distribution Zones | 12 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
24 | JVTBEZART | IS-M: Carrier Route - Specialization of Types | 13 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
25 | JVTVERPLAN | IS-M/SD: Shipping Schedule | 21 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
26 | JVTVERVARI | IS-M/SD: Variant for Shipping Schedule | 12 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |