| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMedia Product Sales and Distribution |
| 1 | JVSDSHPPLISSOPT | Shipping Dates for a Media Issue for Optimized Contracts | 11 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 2 | JVSDTRSPPLAN | IS-M: Transportation Plan | 5 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 3 | JVSDTRSPPLANCONT | IS-M: Transportation Plan - Contracts in Truck Route | 10 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 4 | JVSDTRSPPLANORD | IS-M: Transportation Plan - Order Items (Pull) in Truck Rte | 7 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 5 | JVSDTRSPPLCONTNA | IS-M: Transportation Plan - Contracts Not Assigned | 8 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 6 | JVSDTRSPPLISSNA | IS-M: Transportation Plan - Media Issues Not Assigned | 3 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 7 | JVSDTRSPPLISSUES | IS-M: Transportation Plan - Assigned Media Issues | 5 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 8 | JVSDTRSPPLORDNA | IS-M: Transportation Plan - Order Items Not Assigned | 5 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 9 | JVSDWLORD | Shipping Dates for Gen. of Sales Orders from Qty Planning | 8 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 10 | JVSDWLTRSPLCONTR | Alternative Shipping Dates for Sales Orders from Qty Planng | 9 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 11 | JVSDWLTRSPLISSUE | Shipping Dates for Media Issue | 11 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 12 | JVSDWLTRSPLORDER | IS-M: TP Worklist of Orders for Pull Process per Shippg Date | 6 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| 13 | JVSDWLTRSPPLAN | IS-M: TP Worklist Status | 5 | SHIPPINGDATE | Shipping Date | nvarchar | 8 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 14 | JVTMCP_HEADER | IS-M: TMCP Issue | 7 | SHIPPINGDATE | Shipping Date for TMC Product | nvarchar | 8 | 0 | | |
