| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | /NAM/JHACCBUNDLE | Credit Card Processing - Bundling and Delta Processing | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
2 | JHABILOZ | IS-M/AM: Assign Artwork to Ad Spec | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
3 | JHABPZ | IS-M/AM: Assign Booking Units to an Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
4 | JHACHIF | IS-M/AM: Box No.Attributes/Response Master Record | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
5 | JHADRV | IS-M/AM: OPM Ad Spec Master | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
6 | JHADRVA | IS-M/AM: Number of OPM Type Ad Spec Masters | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
7 | JHAE | IS-M/AM: OPM Sub-Item Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
8 | JHAEA | IS-M/AM: Order-Publishing-Media Ad Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
9 | JHAEO | IS-M/AM: Online Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
10 | JHAERL | IS-M: OPM Ad Error Log for Schedule Line Generation | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
11 | JHAES | IS-M/AM: OPM Ad Insert Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
12 | JHAEV | IS-M/AM: OPM Distribution Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
13 | JHAEW | IS-M/AM: OPM Commercial Schedule Line | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
14 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
15 | JHAGA2 | IS-M/AM: JHAGA Enhancement | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
16 | JHAGAP | IS-M/AM: Sales Agent Determination Log | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
17 | JHAGAPM | IS-M/AM: Messages Log for Sales Agent Determination | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
18 | JHAGAX | IS-M/AM: Update Index for Billing Dataset | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
19 | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
20 | JHAGVX | IS-M/AM: Order Sales Agent Assignment Settlement Index | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
21 | JHAGVZ | IS-M/AM: Order Sales Agent Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
22 | JHAHFZ | IS-M/AM: Order Item Copy Assignment (Todo) | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
23 | JHAIKZ | IS-M/AM: Item/Booking Unit/Technical Content Comp.Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
24 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
25 | JHAK | IS-M/AM: Order-Publishing-Media (Header Data) | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
26 | JHAKPV | IS-M/AM: OPM Header Sales Agent / Item Sales Agent | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
27 | JHAMEZ | IS-M/AM: Order Item Schedule Line Data (Manual) Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
28 | JHAMOT | IS-M/AM: Ad Spec | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
29 | JHAMOTO | IS-M/AM: Online Ad Spec | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
30 | JHAMOTW | IS-M/AM: OPM Ad Spec (Commercial) | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
31 | JHAMOZ | IS-M/AM: Assign Ad Specs to Order Objects | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
32 | JHAMOZO | IS-M/AM: Assignment of Online Ad Specs to Order Objects | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
33 | JHAMOZW | IS-M/AM: Assign Commercial Ad Specs to Order Objects | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
34 | JHAOFFERT | IS-M/AM: Response Management | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
35 | JHAP | IS-M/AM: Order-Publishing-Media Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
36 | JHAPA | IS-M/AM: Order-Publishing-Media Ad Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
37 | JHAPAFP | IS-M/AM: Contract Determination Log for OPM Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
38 | JHAPD | IS-M/AM: OPM Service Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
39 | JHAPLZ | IS-M/AM: OPM Positioning Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
40 | JHAPO | IS-M/AM: Order-Publishing-Media Online Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
41 | JHAPP | Order-Publishing-Media Package Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
42 | JHAPS | IS-M/AM: OPM Ad Insert Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
43 | JHAPV | IS-M/AM: OPM Distribution Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
44 | JHAPW | IS-M/AM: OPM Commercial Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
45 | JHAPZUO | IS-M/AM: Work List of Non Assigned Items | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
46 | JHAP_PPF | IS-M: PPF Order Item in Advertising Management | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
47 | JHAREKL | IS-M/AM: Complaint Object | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
48 | JHAREV1 | IS-M/AM: Order Revenue Recognition Key Date Values | 25 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
49 | JHAREV3 | IS-M/AM: Order Revenue Recognition Key Date Quantities | 22 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
50 | JHASIZ | IS-M/AM: OPM Ad Insert Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
51 | JHATEOTD | IS-M/AM: Online Production Schedule Line Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
52 | JHATERR | IS-M/AM: Error Messages from the Technical System | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
53 | JHATEXTORD | IS-M/AM: Transfer External Orders from the Technical System | 5 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
54 | JHATGZ | IS-M/AM: Target Group Assignment for OPM Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
55 | JHATMOTD | IS-M/AM: Ad Spec (Technical Interface) Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
56 | JHATMOTOTD | IS-M/AM: Online Ad Spec (Technical Interface) Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
57 | JHATPAPTD | IS-M/AM: Ad Production Order Item (Todo) | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
58 | JHATPSI | OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
59 | JHATPSITD | Ad Production Schedule Line - Actual Message Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
60 | JHATPSTD | IS-M/AM: Ad Production Schedule Line - Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
61 | JHATRZ | IS-M/AM: Order Item Date Assignment | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
62 | JHATRZW | IS-M/AM: Order Item Date Assignment (Commercial) | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
63 | JHATSTATOTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
64 | JHATSTATTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
65 | JHATVASPTD | IS-M/AM: Order Item Pool Issue Shift Header | 3 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
66 | JHAU | IS-M/AM: Order-Publishing-Media Sub-Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
67 | JHAUA | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
68 | JHAUO | IS-M/AM: OPM Online Sub-Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
69 | JHAUSI | IS-M/AM: Sub-Items (Positioning) for Ad Insert | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
70 | JHAUV | IS-M/AM: Distribution Sub-Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
71 | JHAUW | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
72 | JHA_ORDER_INDEX | Selection Index for Orders | 10 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
73 | JHTFX | IS-M/AM: Billing Index - Order Billing | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
74 | JHTVAABG | IS-M/AM: Contract Settlement - Changed Assessment Basis | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
75 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 12 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
76 | JHTVABRUF | IS-M/AM: Contract Access | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
77 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 13 | AVM_NR | IS-M: Order | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
78 | JVTMCI_HEADER | IS-M: TMCI Ad Insert Items | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
79 | JVTMCI_ITEM | IS-M: TMCI Household Addresses for AI Schedule Lines | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
80 | JVTMCI_MERGEINFO | IS-M: Explode TMCI AI Schedule Lines in M/SD Structures | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
81 | JVTMCI_MERGE_RES | TMCI Merge Result: Merge Result for Ship-To Address | 2 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
82 | JVTSIANZUO | IS-M: Assignment of Insert Mix to AI Orders | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
83 | JVTSIBLZUO | IS-M: Assignment of Insert Mix to AI Orders | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
84 | JVTSIRHZUO | IS-M: Assignment of Delivery to AI Sched.Line - Delta Cov. | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
85 | JVTSIVTZUO | IS-M: Assignment of Delivery to AI Schedule Line for Dist. | 4 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |