| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZML_MAILSETTING | Mail settings for OTM | 5 | ISSUE | Issue type JIRA | nvarchar | 2 | 0 | | |
TOPChina |
2 | T7CNLC_ISSUE | Issue | 4 | ISSUE | Issue | nvarchar | 2 | 0 | | |
3 | T7CNLC_ISSUET | Issue Description | 5 | ISSUE | Issue | nvarchar | 2 | 0 | | |
4 | T7CNLC_ISUDTL | Issue Details | 4 | ISSUE | Issue | nvarchar | 2 | 0 | | |
5 | T7CNLC_ISUDTLT | Issue Details Description | 5 | ISSUE | Issue | nvarchar | 2 | 0 | | |
TOPDSD Connector |
6 | /DSD/ME_MAP_RULE | DSD-Connector: Define Mapping Rules | 3 | ISSUE | DSD Connector: Issue | nvarchar | 6 | 0 | | |
TOPIndonesia |
7 | PA0318 | HR Master Record: Infotype Family data for Indonesia (0318) | 26 | ISSUE | Date of issue of Passport (Indonesia) | nvarchar | 8 | 0 | | |
TOPMedia Product Sales and Distribution |
8 | JKSDCONTRACTMIX | IS-M: Mix for Contract - Lower Level Issues | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
9 | JKSDCONTRACTQUAN | IS-M: Contract-Related Quantities | 4 | ISSUE | IS-M: Carrying Issue | nvarchar | 18 | 0 | | |
10 | JKSDDEMAND | IS-M: Planned Quantities | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
11 | JKSDDEMANDARC | IS-M: Archive for Changed Planning Records | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
12 | JKSDDEMANDFLOW | IS-M: Assignment of Contract Item to Order | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
13 | JKSDFCHEAD | IS-M: Reference Issue Header Data | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
14 | JKSDFCHEADPO | IS-M: Header Data for Ref. Issues with Planning Organization | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
15 | JKSDFCITEM | IS-M: Media Issue Item Data | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
16 | JKSDFCITEMPO | IS-M: Media Issue Item Data with Planning Organization | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
17 | JKSDFCVARIANT | IS-M: Reference Issue Header Data | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
18 | JKSDFCVARIANTPO | IS-M: Header Data for Ref. Issues with Planning Organization | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
19 | JKSDISSFOREC | IS-M: Media Issue Header Data | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
20 | JKSDISSFORECITEM | IS-M: Media Issue Item Data | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
21 | JKSDISSUEDATES | Return Dates | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
22 | JKSDISSUEGROUP | Insert Planning: Assigned Mixes for Insert Group | 2 | ISSUE | Material Number | nvarchar | 18 | 0 | | |
23 | JKSDISSUERETPROC | Goods Receipt for Customer Return: Edit Parameters | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
24 | JKSDISSUESTAT | Statistical Values for a Media Issue | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
25 | JKSDLOGORDERST | IS-M: Status Query | 6 | ISSUE | Material Number | nvarchar | 18 | 0 | | |
26 | JKSDORDERAD | IS-M: Ad Inserts for Contract | 4 | ISSUE | Material Number | nvarchar | 18 | 0 | | |
27 | JKSDORDERADDMIX | IS-M: Mix for Contract | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
28 | JKSDORDERADMIXPL | IS-M: Mix for Contract (Planned) | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
29 | JKSDPROTOCOL | IS-M: Order Generation Log | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
30 | JKSDPROTOCOL2 | IS-M: Log | 7 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
31 | JKSDQUANTITYROLE | IS-M: Contract-Related Quantities for Specific Roles | 4 | ISSUE | IS-M: Carrying Issue | nvarchar | 18 | 0 | | |
32 | JKSDQUANUPDATED | IS-M: Updated Deliveries | 4 | ISSUE | Material Number | nvarchar | 18 | 0 | | |
33 | JKSDQUANUPDMSD | IS-M: Updated Deliveries in Shipping Orders | 8 | ISSUE | Material Number | nvarchar | 18 | 0 | | |
34 | JKSDREPROTOCOL | IS-M: Return Release Log | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
35 | JKSDSBRSALESHIST | IS-M: SBR Sales History | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
36 | JKSDSQPEVENTEXEC | Planned Quantity Changes Based on Event | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
37 | JKSDSQPEVENTISS | Assignment of Event to Media Issues | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
38 | JKSDSQPEVENTISSU | Assignment of Media Products/Issues to Event | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
39 | JKSDWERKSISSUE | IS-M: Assignment of Plant to Contract and Issue | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
40 | JKSDWERKSQUAN | IS-M: Plant-Related Quantities | 3 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
41 | JKSEFLOW | IS-M: Document Flow for Generated Orders ISP | 5 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
42 | JKSENIP | IS-M: Shipping Schedule | 8 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
43 | JKSESCHED | IS-M: Media Schedule Lines | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
44 | JKSESUBPRICESETM | IS-M: Dynamic Price Group - Allowed Media Issue | 3 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
45 | JVSDPACKRULE | IS-M/SD: Packaging Rules for Media Issues | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
46 | JVSDPLANISSUEINS | IS-M/SD: Media Issue Planning - Insert | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
47 | JVSDSHPPLISSOPT | Shipping Dates for a Media Issue for Optimized Contracts | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
48 | JVSDSPLIT | IS-M: Media Issue Mix | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
49 | JVSDSPLITPLAN | IS-M: Issue Split (Planned) | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
50 | JVSDSPLITSUB | IS-M: Issue Split for Lower Level Issues | 3 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
51 | JVSDTRSPPLANCONT | IS-M: Transportation Plan - Contracts in Truck Route | 9 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
52 | JVSDTRSPPLCONTNA | IS-M: Transportation Plan - Contracts Not Assigned | 7 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
53 | JVSDTRSPPLISSNA | IS-M: Transportation Plan - Media Issues Not Assigned | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
54 | JVSDTRSPPLISSUES | IS-M: Transportation Plan - Assigned Media Issues | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
55 | JVSDWLORD | Shipping Dates for Gen. of Sales Orders from Qty Planning | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
56 | JVSDWLTRSPLCONTR | Alternative Shipping Dates for Sales Orders from Qty Planng | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
57 | JVSDWLTRSPLISSUE | Shipping Dates for Media Issue | 4 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
58 | JVTPHSBRISSUE | Assignment of Media Issue to Replen. Planning Phase Model | 2 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
TOPPeriodical Sales and Distribution |
59 | J2SDDROPOFF_IDX | IS-M/SD: LES Interface Index Drop-Offs - Purchase Quantities | 6 | ISSUE | Media Issue | nvarchar | 18 | 0 | | |
60 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 4 | ISSUE | Issue | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
61 | /DSD/ME_MESS2OBJ | DSD Connector: Assignment Message Types to MDE Object | 2 | ISSUE | DSD Connector: Sequence Number | nvarchar | 6 | 0 | | |