| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMedia Product Sales and Distribution |
| 1 | JKSDCONTRACTQUAN | IS-M: Contract-Related Quantities | 6 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 2 | JKSDDEMAND | IS-M: Planned Quantities | 6 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 3 | JKSDDEMANDARC | IS-M: Archive for Changed Planning Records | 6 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 4 | JKSDDEMANDFLOW | IS-M: Assignment of Contract Item to Order | 5 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 5 | JKSDEVENTVERIFY | IS-M: Verified Planned Quantity (Event Planning) | 5 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 6 | JKSDORDERBOOK | IS-M: Planned Purchase Quantities | 8 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 7 | JKSDPLANQEVENTEX | IS-M: Use of Event | 6 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 8 | JKSDPORDERFLOW | IS-M: Assignment of Purchase Order Book to Purchase Order | 7 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 9 | JKSDPROTOCOL | IS-M: Order Generation Log | 7 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 10 | JKSDPROTOCOL2 | IS-M: Log | 8 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 11 | JKSDQEVENTVERIFY | IS-M: Verified Planned Quantity (Event Planning) | 5 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 12 | JKSDQUANTITYROLE | IS-M: Contract-Related Quantities for Specific Roles | 6 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 13 | JKSDQUANVERIFY | IS-M: Verified Quantities | 4 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 14 | JKSDRETURNCHECK | IS-M: Quantity Check on Return | 12 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 15 | JKSDSQPEVENTEXEC | Planned Quantity Changes Based on Event | 7 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 16 | JKSDUNSOLDITEM | IS-M: Item Data on Unsold Copies/Credit Memos | 84 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 17 | JKSDWERKSQUAN | IS-M: Plant-Related Quantities | 4 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 18 | JVSDSHPPLISSOPT | Shipping Dates for a Media Issue for Optimized Contracts | 9 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 19 | JVSDTRSPPLANCONT | IS-M: Transportation Plan - Contracts in Truck Route | 7 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 20 | JVSDTRSPPLCONTNA | IS-M: Transportation Plan - Contracts Not Assigned | 5 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 21 | JVSDWLORD | Shipping Dates for Gen. of Sales Orders from Qty Planning | 5 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 22 | JVSDWLTRSPLCONTR | Alternative Shipping Dates for Sales Orders from Qty Planng | 7 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 23 | JVSDWLTRSPLISSUE | Shipping Dates for Media Issue | 9 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 24 | JVTPHCONTQUAN | IS-M/SD: Temporary Table for RJVPH_CREATE_SUBDELIVERY | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 25 | JVTPHCONTRACT | IS-M/SD: Phase Shipping - Contracts Assigned Explicitly | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 26 | JVTPHISSUE | IS-M/SD: Phase Shipping - Media Issues | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 27 | JVTPHPROMOTION | IS-M: Assignment of Phase Model to Retail Promotion | 3 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 28 | JVTPHDATE | IS-M/SD: Phase-Based Shipping - Dates per Media Issue | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 29 | JVTPHGEO | IS-M/SD: Phase Shipping - Geo.Units | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
| 30 | JVTPHMODELL | IS-M/SD: Phase Shipping - Model | 2 | PHASEMDL | Phase Model | nvarchar | 10 | 0 | | |
