| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHAES | IS-M/AM: OPM Ad Insert Schedule Line | 8 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
2 | JHAEV | IS-M/AM: OPM Distribution Schedule Line | 8 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
3 | JJTBEDZULA | IS-M/AM: Booking Unit Admissibility for Specific Date | 4 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
4 | JJTPE | IS-M/AM: Production Units | 8 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
5 | JJTVAPE | IS-M/AM: Issue Element | 4 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
TOPMedia Product Sales and Distribution |
6 | JSDVA_MIG | IS-M: Issue Worklist for Media Product Migration | 5 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
7 | A466 | IS-M/SD: Special Retail Prices | 9 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
8 | JDTVASYNC | IS-M: Worklist for Issue Synchronization M/SD -> M/AM | 6 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
9 | JDTVAUSGB | IS-M/SD: Issues | 5 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
10 | JITSTAT | IS-M/SD: Daily IVW Statistics | 19 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
11 | JLTP1PVA | IS-M/SD: Postal Settlement Data on an Issue (New) | 8 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
12 | JRTABLG | IS-M: Drop-Off | 20 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
13 | JVTASTAT01 | IS-M/SD: Supplements to Shipping Status | 8 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
14 | JVTLFNG | IS-M/SD: Delivery/Home Delivery | 22 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
15 | JVTLFSTAT | IS-M/SD: Daily Delivery Statistics | 10 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
16 | JVTNOTADM | IS-M/SD: Administrative Data on Carrier Change Notification | 2 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
17 | JVTNOTICE | IS-M/SD: Carrier Change Notifications | 2 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
18 | TJV62 | IS-M/SD: Sales Data for Goods Arrival Record | 4 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |
TOPSAP Media |
19 | J_1SWEMF00 | IS-M/SD CH/W: Daily WEMF Statistics | 19 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | | |