| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 38 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
2 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 35 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
3 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 109 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
4 | JHTMGPZ | IS-M: Media-Mix Contract: Business Partner | 2 | VTNR | IS-M: Contract Number for Media-Mix Contract | nvarchar | 10 | 0 | | |
5 | JHTMXK | IS-M: Media-Mix Contract Header Data | 2 | VTNR | IS-M: Contract Number for Media-Mix Contract | nvarchar | 10 | 0 | | |
6 | JHTVAABG | IS-M/AM: Contract Settlement - Changed Assessment Basis | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
7 | JHTVAABK | IS-M/AM: Contract Settlement Header Data | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
8 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
9 | JHTVAARG | IS-M/AM: Alternative Payer for Contract Settlements | 7 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
10 | JHTVAARI | IS-M/AM: Contract Settlement Payer/Advertiser Record | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
11 | JHTVABRUF | IS-M/AM: Contract Access | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
12 | JHTVAZUO | IS-M/AM: Contract/Agency Assignment | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
13 | JHTVBZUO | IS-M/AM: Contract/Beneficiary Assignment | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
14 | JHTVGPZ | IS-M/AM: Business Partner Assignment to the Contract | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
15 | JHTVKO | IS-M/AM: Contract | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
16 | JHTVPO | IS-M/AM: Contract Item | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
17 | JHTVVBER | IS-M/AM: Contract/Assigned Sales Areas | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
18 | JHTVVZUO | IS-M/AM: Contract/ Sales Agent Assignment | 2 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
19 | JJTBB | IS-M/AM: Requirement Element of Media Sales Agent Contract | 17 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
20 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 27 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |
TOPInformation System |
21 | TJBWA1 | IS-M: Worklist of Contracts for BW Delta Renewal | 3 | VTNR | IS-M: Contract Number | nvarchar | 6 | 0 | | |