| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | /NAM/TJHSORTW | Sort Word Generation Function Module | 7 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
2 | JHABPZ | IS-M/AM: Assign Booking Units to an Item | 4 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
3 | JHAEA | IS-M/AM: Order-Publishing-Media Ad Schedule Line | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
4 | JHAEGEN | IS-M/AM: Schedule Lines Generation Period | 2 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
5 | JHAEO | IS-M/AM: Online Schedule Line | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
6 | JHAES | IS-M/AM: OPM Ad Insert Schedule Line | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
7 | JHAEV | IS-M/AM: OPM Distribution Schedule Line | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
8 | JHAEW | IS-M/AM: OPM Commercial Schedule Line | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
9 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 5 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
10 | JHAIKZ | IS-M/AM: Item/Booking Unit/Technical Content Comp.Assignment | 4 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
11 | JHAMEZ | IS-M/AM: Order Item Schedule Line Data (Manual) Assignment | 4 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
12 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 29 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
13 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 26 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
14 | JHATPSI | OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation | 13 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
15 | JHATPSITD | Ad Production Schedule Line - Actual Message Todo | 12 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
16 | JHAUA | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 6 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
17 | JHAUO | IS-M/AM: OPM Online Sub-Item | 6 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
18 | JHAUW | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 6 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
19 | JHTFX | IS-M/AM: Billing Index - Order Billing | 6 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
20 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 17 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
21 | JJTBEATERM | IS-M/AM: Alternative Dates for Booking Units | 2 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
22 | JJTBEDZULA | IS-M/AM: Booking Unit Admissibility for Specific Date | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
23 | JJTBEST | IS-M/AM: Booking Unit Element | 2 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
24 | JJTBEZULAS | IS-M/AM: Booking Unit Admissibility | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
25 | JJTINSSERT_DET | IS-M/AM: Series Creation Rule Determination | 5 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
26 | JJTKONZU | IS-M/AM: Sales Activity Assignments | 5 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
27 | JJTUPSELL_BE | IS-M/AM: Upselling Proposals Booking Unit Assignment | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
28 | S481 | IS-M/AM: View of BP Sales Areas | 16 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
29 | S481E | S481 - Structural Information | 11 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
30 | S482 | IS-M/AM: Ad Quantities | 9 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
31 | S482E | S482 - Structural Information | 4 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
32 | S483 | IS-M/AM: Agent Assignment | 16 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
33 | S483E | S483 - Structural Information | 11 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
34 | TJHAZARTGR | IS-M/AM: BU Grouping For Ad.Type Admissibility | 2 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
35 | TJHEDIT | IS-M/AM: Technical Editor In the Order | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
36 | TJHVSW02 | IS-M/AM: VSW Output Code Depending on Booking Unit | 2 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
37 | TJHWWW_JHAW_BE | IS-M/AM: IAC Enter Classified Ad: Admissible Booking Unit | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
38 | TJHWWW_JHB4_BBE | IS-M: Booking Unit Admissibility - Fixed Spaces Planning I | 3 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
39 | TJJ45 | IS-M/AM: Minimum and Maximum Sizes for Ads | 5 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
TOPMaster Data |
40 | JGTBKUS | IS-M: Note to Payee for Bank Details | 5 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
41 | JGTBKVW | IS-M: Note to Payee for Banks | 7 | BELEGEINH | IS-M/AM: Booking Unit | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
42 | JVTSIANZUO | IS-M: Assignment of Insert Mix to AI Orders | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |
43 | JVTSIBLZUO | IS-M: Assignment of Insert Mix to AI Orders | 7 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | | |