| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JJTBEPART | IS-M/AM: Booking Unit Elements (AI) | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
2 | JJTPE | IS-M/AM: Production Units | 31 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
3 | JDTSTVOPA | IS-M: Bundling Rule | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
4 | JDTWGHVOPA | IS-M/SD: Bundling Rule - Weight Scale | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
5 | JKACCAMOPROT | IS-M/SD: Amortization Log | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
6 | JKAMOPLAN | IS-M/SD: Amortization Plan for Billing Cycle | 8 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
7 | JKAP | Sales Order - Item Data | 16 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
8 | JKAPRV | IS-M/SD: Sales Order - Retroactive Shipping Data | 8 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
9 | JKAP_INACTIVE | Publishing Sales Order: Inactive Item Data | 17 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
10 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
11 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 22 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
12 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
13 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 62 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
14 | JKWWWTEMP_SUSP | IS-M: Temporary Internet Table: Suspension Data | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
15 | JKWWWTEMP_TRNSF | IS-M: Internet Temporary Table: Transfer Data | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
16 | JRTABLG | IS-M: Drop-Off | 6 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
17 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 10 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
18 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 9 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
19 | JVTANN00 | IS-M: Technical Order Deadline Limit | 7 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
20 | JVTBEZHPVA | IS-M/SD: Main Edition in Carrier Route | 5 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
21 | JVTLFNG | IS-M/SD: Delivery/Home Delivery | 8 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
22 | JVTLFSTAT | IS-M/SD: Daily Delivery Statistics | 6 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
23 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 11 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
24 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 22 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
25 | JVTPRDGR01 | IS-M/SD: Elements of Production Group | 6 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
26 | JVTVSPDIR | IS-M/SD: Shipping Document Directory | 12 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
27 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 26 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |
28 | TJD07 | IS-M/SD: Mix Type | 2 | BEZUGSTYP | | nvarchar | 2 | 0 | | |
29 | TJD08 | IS-M/SD: Text Table for Mix Type | 3 | BEZUGSTYP | | nvarchar | 2 | 0 | | |
30 | TJKWWW_VAR | IS-M/SD: WWW, Combinations of Variable Order Values | 5 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | | |