| 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 | | |