| 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 | 7 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
2 | JKSDDEMAND | IS-M: Planned Quantities | 7 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
3 | JKSDDEMANDARC | IS-M: Archive for Changed Planning Records | 7 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
4 | JKSDDEMANDFLOW | IS-M: Assignment of Contract Item to Order | 6 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
5 | JKSDEVENTVERIFY | IS-M: Verified Planned Quantity (Event Planning) | 6 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
6 | JKSDORDERBOOK | IS-M: Planned Purchase Quantities | 9 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
7 | JKSDPLANQEVENTEX | IS-M: Use of Event | 7 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
8 | JKSDPORDERFLOW | IS-M: Assignment of Purchase Order Book to Purchase Order | 8 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
9 | JKSDPROTOCOL | IS-M: Order Generation Log | 8 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
10 | JKSDPROTOCOL2 | IS-M: Log | 9 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
11 | JKSDQEVENTVERIFY | IS-M: Verified Planned Quantity (Event Planning) | 6 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
12 | JKSDQUANTITYROLE | IS-M: Contract-Related Quantities for Specific Roles | 7 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
13 | JKSDQUANVERIFY | IS-M: Verified Quantities | 5 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
14 | JKSDRETURNCHECK | IS-M: Quantity Check on Return | 13 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
15 | JKSDSQPEVENTEXEC | Planned Quantity Changes Based on Event | 8 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
16 | JKSDUNSOLDITEM | IS-M: Item Data on Unsold Copies/Credit Memos | 85 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
17 | JKSDWERKSQUAN | IS-M: Plant-Related Quantities | 5 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
18 | JVSDSHPPLISSOPT | Shipping Dates for a Media Issue for Optimized Contracts | 10 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
19 | JVSDTRSPPLANCONT | IS-M: Transportation Plan - Contracts in Truck Route | 8 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
20 | JVSDTRSPPLCONTNA | IS-M: Transportation Plan - Contracts Not Assigned | 6 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
21 | JVSDWLORD | Shipping Dates for Gen. of Sales Orders from Qty Planning | 6 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
22 | JVSDWLTRSPLCONTR | Alternative Shipping Dates for Sales Orders from Qty Planng | 8 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
23 | JVSDWLTRSPLISSUE | Shipping Dates for Media Issue | 10 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
24 | JVTPHCONTRACT | IS-M/SD: Phase Shipping - Contracts Assigned Explicitly | 4 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
25 | JVTPHDATE | IS-M/SD: Phase-Based Shipping - Dates per Media Issue | 4 | PHASENBR | Sequence Number in Phase Delivery | nvarchar | 10 | 0 | | |