| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | A251 | IS-M: SOrg/DChannel/Division/Advertiser | 7 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
2 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 7 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
3 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 4 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
4 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 35 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
5 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 32 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
6 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 73 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
7 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 70 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
8 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 35 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
9 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 9 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
10 | JHTVAARG | IS-M/AM: Alternative Payer for Contract Settlements | 9 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
11 | JHTVAARI | IS-M/AM: Contract Settlement Payer/Advertiser Record | 5 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
12 | JHTVABRUF | IS-M/AM: Contract Access | 8 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
13 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 51 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
14 | JJVSWGPNR | IS-M/AM: Alternative Advertiser Number | 3 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
15 | S481 | IS-M/AM: View of BP Sales Areas | 10 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
16 | S481E | S481 - Structural Information | 5 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
17 | S483 | IS-M/AM: Agent Assignment | 11 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
18 | S483E | S483 - Structural Information | 6 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
TOPMaster Data |
19 | JGTBKUS | IS-M: Note to Payee for Bank Details | 4 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
20 | JGTBKVW | IS-M: Note to Payee for Banks | 6 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
21 | JYTTRGWAER | IS-M: Trigger Entries for Currency Changes | 3 | INSERENT | IS-M/AM: Advertiser for currency conversion | nvarchar | 10 | 0 | | |