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