| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RE_ST | Payroll result: Taxes (ES) | 19 | MOTIV | Change reason | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
2 | JHABILOZ | IS-M/AM: Assign Artwork to Ad Spec | 3 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
3 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 10 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
4 | JHAGPZ | IS-M/AM: Assign Business Partner to Order and Item | 10 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
5 | JHAMOT | IS-M/AM: Ad Spec | 3 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
6 | JHAMOTO | IS-M/AM: Online Ad Spec | 3 | MOTIV | IS-M: Order ad spec number (online) | nvarchar | 6 | 0 | | |
7 | JHAMOTW | IS-M/AM: OPM Ad Spec (Commercial) | 3 | MOTIV | IS-M: Order ad spec number (commercial) | nvarchar | 6 | 0 | | |
8 | JHAMOZ | IS-M/AM: Assign Ad Specs to Order Objects | 6 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
9 | JHAMOZO | IS-M/AM: Assignment of Online Ad Specs to Order Objects | 6 | MOTIV | IS-M: Order ad spec number (online) | nvarchar | 6 | 0 | | |
10 | JHAMOZW | IS-M/AM: Assign Commercial Ad Specs to Order Objects | 6 | MOTIV | IS-M: Order ad spec number (commercial) | nvarchar | 6 | 0 | | |
11 | JHATERR | IS-M/AM: Error Messages from the Technical System | 5 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
12 | JHATMOTD | IS-M/AM: Ad Spec (Technical Interface) Todo | 3 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
13 | JHATMOTOTD | IS-M/AM: Online Ad Spec (Technical Interface) Todo | 3 | MOTIV | IS-M: Order ad spec number (online) | nvarchar | 6 | 0 | | |
14 | JHATPSI | OPM Prod.Sched.Line - Actual Message with Plnd/Act Variation | 11 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
15 | JHATPSITD | Ad Production Schedule Line - Actual Message Todo | 10 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
16 | JHATPSTD | IS-M/AM: Ad Production Schedule Line - Todo | 9 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
17 | JHATRZW | IS-M/AM: Order Item Date Assignment (Commercial) | 8 | MOTIV | IS-M: Order ad spec number (commercial) | nvarchar | 6 | 0 | | |
18 | JHATSTATOTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 6 | MOTIV | IS-M: Order ad spec number (online) | nvarchar | 6 | 0 | | |
19 | JHATSTATTD | IS-M/AM: Status/Characteristic Alignment from Technical Todo | 5 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
20 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 14 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
21 | JVTANZZUS | IS-M: Ad Mix for Carrying Issues | 4 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | | |
TOPSpain |
22 | PA0062 | HR master record Infotype 0062 (Tax Spain)) | 33 | MOTIV | Change reason | nvarchar | 2 | 0 | | |
23 | T5E38 | Reasons for IRPF percentage change | 2 | MOTIV | Change reason | nvarchar | 2 | 0 | | |
24 | T5E8M | Reasons for IRPF percentage change | 3 | MOTIV | Change reason | nvarchar | 2 | 0 | | |