| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMedia Product Sales and Distribution |
1 | JKSDFCHEAD | IS-M: Reference Issue Header Data | 6 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
2 | JKSDFCHEADPO | IS-M: Header Data for Ref. Issues with Planning Organization | 7 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
3 | JKSDFCITEM | IS-M: Media Issue Item Data | 6 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
4 | JKSDFCITEMPO | IS-M: Media Issue Item Data with Planning Organization | 7 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
5 | JKSDFCVARIANT | IS-M: Reference Issue Header Data | 6 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
6 | JKSDFCVARIANTPO | IS-M: Header Data for Ref. Issues with Planning Organization | 7 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
7 | JKSDISSFOREC | IS-M: Media Issue Header Data | 5 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
8 | JKSDISSFORECITEM | IS-M: Media Issue Item Data | 6 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
9 | JKSDISSUEDATE | Recall Dates for Media Issues | 18 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
10 | JKSDORDERBOOK | IS-M: Planned Purchase Quantities | 5 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
11 | JKSDORDERBOOKPL | Goods Movements for Return to Publisher | 4 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
12 | JKSDORDERBOOKPLF | Goods Movements for Return to Publisher | 4 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
13 | JKSDORDERBOOKRET | IS-M: Planned Quantities for Return to Publisher | 4 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
14 | JKSDPORDERFLOW | IS-M: Assignment of Purchase Order Book to Purchase Order | 4 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
15 | JKSDPORDERFLOWRE | IS-M: Assignment of PO Book for Rtn to Publisher to PO | 4 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
16 | JKSDQFAREA | IS-M: Planning Area for Media Issues | 3 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
17 | JKSDQFAREAPROD | IS-M: Assignment of Planning Area and Media Product | 3 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
18 | JKSDUNSOLDPOFLOW | Document Flow Return Delivery PO Unsold Copies | 6 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
19 | JPTMG0 | IS-M: Media Product Issue Sequence | 2 | MED_PROD | Higher-Level Media Product | nvarchar | 18 | 0 | | |
20 | JPTMG3 | IS-M: Control Settings for Copying Issue Seq.from Template | 2 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
21 | JPTMG4 | IS-M: Issue Sequence: Header Data | 2 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
22 | JPTMG5 | IS-M: Issue Sequence: Calendar Maint. for Each User/Product | 2 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
23 | JPTMG6 | IS-M: Planning Horizon for Quantity Planning | 2 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
24 | JVSDDELIVCYCLESA | IS-M: Assignment of Media Prods to Delivery Cycle/Sales Area | 7 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |
25 | JVSDDELIVCYCPROD | IS-M: Assign Media Products to Delivery Cycle | 5 | MED_PROD | Media Product | nvarchar | 18 | 0 | | |