| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHAE | IS-M/AM: OPM Sub-Item Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
2 | JHAEA | IS-M/AM: Order-Publishing-Media Ad Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
3 | JHAEO | IS-M/AM: Online Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
4 | JHAES | IS-M/AM: OPM Ad Insert Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
5 | JHAEV | IS-M/AM: OPM Distribution Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
6 | JHAEW | IS-M/AM: OPM Commercial Schedule Line | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
7 | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item | 8 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
8 | JHAMOZ | IS-M/AM: Assign Ad Specs to Order Objects | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
9 | JHAMOZO | IS-M/AM: Assignment of Online Ad Specs to Order Objects | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
10 | JHAMOZW | IS-M/AM: Assign Commercial Ad Specs to Order Objects | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
11 | JHAPLZ | IS-M/AM: OPM Positioning Assignment | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
12 | JHAREKL | IS-M/AM: Complaint Object | 12 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
13 | JHASIZ | IS-M/AM: OPM Ad Insert Assignment | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
14 | JHATEOTD | IS-M/AM: Online Production Schedule Line Todo | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
15 | JHATPSI | OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
16 | JHATSTATOTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
17 | JHAU | IS-M/AM: Order-Publishing-Media Sub-Item | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
18 | JHAUA | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
19 | JHAUO | IS-M/AM: OPM Online Sub-Item | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
20 | JHAUSI | IS-M/AM: Sub-Items (Positioning) for Ad Insert | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
21 | JHAUV | IS-M/AM: Distribution Sub-Item | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
22 | JHAUW | IS-M/AM: Order-Publishing-Media Ad Sub-Item | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
23 | JVTMCI_ITEM | IS-M: TMCI Household Addresses for AI Schedule Lines | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |
24 | JVTMCI_MERGE_RES | TMCI Merge Result: Merge Result for Ship-To Address | 4 | UPOS_NR | IS-M: Order Sub-Item Number | nvarchar | 4 | 0 | | |