| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JJTBEBVT | IS-M/AM: Booking Unit Elements (Distribution) | 6 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
2 | JJTBEPART | IS-M/AM: Booking Unit Elements (AI) | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
3 | JJTGPBTBZ | IS-M/AM: Customer Potential: Zone - BP | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
TOPFunds Management |
4 | FMCI | Commitment items master data | 27 | BEZIRK | District | nvarchar | 4 | 0 | | |
5 | FMPG | Commitment Items in FM Area/Fiscal Year | 21 | BEZIRK | District | nvarchar | 4 | 0 | | |
TOPMaster Data |
6 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
7 | JSTLAUF | IS-M/SD: Round Sequence | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
TOPMedia Sales and Distribution |
8 | /NAM/JKDISPATCH | Dispatching object | 9 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
9 | /NAM/TJKAPPL_MON | Application Access for Determination of Monitoring | 16 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
10 | /NAM/TJKCMPTHRSH | Complaint Threshold | 3 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
TOPPatient Management |
11 | TN13A | IS-H: Parishes | 4 | BEZIRK | IS-H: Parish according to community index | nvarchar | 11 | 0 | | |
TOPPeriodical Sales and Distribution |
12 | JDTSTVOPA | IS-M: Bundling Rule | 11 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
13 | JDTWGHVOPA | IS-M/SD: Bundling Rule - Weight Scale | 11 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
14 | JFDFS | IS-M/SD: Billing/Settlement Index | 42 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
15 | JKAP | Sales Order - Item Data | 83 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
16 | JKAPRV | IS-M/SD: Sales Order - Retroactive Shipping Data | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
17 | JKPAZ | Sales Order Item: Additional Planning Data | 10 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
18 | JLTVM01 | IS-M/SD: Contract Arr.for SC/Carrier/Deliv.Type/Deliv.Set | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
19 | JLTVM02 | IS-M/SD: Contract Arrgmts SC/ - /Deliv.Type/Deliv.Rnd | 4 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
20 | JLTVV01 | IS-M/SD: Contract Arr.Sales Org/SC/Deliv.Type/Deliv.Set | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
21 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
22 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 3 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
23 | JVTABEZART | IS-M: Additional Fields for Sales Agent/Distribution Zones | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
24 | JVTBEZART | IS-M: Carrier Route - Specialization of Types | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
25 | JVTBEZGP | IS-M/SD: Delivery Round - Business Partner | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
26 | JVTBEZHPVA | IS-M/SD: Main Edition in Carrier Route | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
27 | JVTBEZIRK | IS-M: Carrier Route (Generalization) | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
28 | JVTBEZPOT | IS-M: Carrier Route, Time-Dependent Planned Circulation | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
29 | JVTBEZRND | IS-M/SD: Delivery Round | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
30 | JVTBZRDNR | IS-M: SDoc.Printing No.for Delivery Exception per Del.Round | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
31 | JVTFEHLER | IS-M: Distribution Error Message | 17 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
32 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 16 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
33 | JVTMCP_ITEM | IS-M: TMCP Structures (CRoute/GUnit) | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
34 | JVTMCP_MERGE_RES | IS-M: TMCP Merge Result for Ship-To Party Address | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
35 | JVTMCP_PROT | IS-M: TMCP Logs | 7 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
36 | JVTMCP_SCHEDULE | IS-M: TMCP Household Addresses for Structures | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
37 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 11 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
38 | JVTVSPDIR | IS-M/SD: Shipping Document Directory | 7 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
39 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 4 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
40 | JVTZUSTM | IS-M/SD: Carrier Notification (Shipping Documents) | 3 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
41 | TJL35 | IS-M/SD: Master Data for Contract Arrangement Determination | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
42 | TJL39 | IS-M/SD: Master Data for Contract Arrangement Determination | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
43 | TJL42 | IS-M/SD: Master Data for External Contract Arrangement Det. | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
44 | TJL44 | IS-M/SD: Master Data for External Contract Arrangement Det. | 5 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
45 | TJV41 | IS-M/SD: Type of Shipping Problem Message | 17 | BEZIRK | IS-M: Relevancy of Carrier Route | nvarchar | 1 | 0 | | |
46 | TJVTMCP_EXCL_STR | IS-M: Market Coverage Exclusion for Carrier Routes/GUnits | 2 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |
TOPSAP Media |
47 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 15 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | | |