| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____001V | SID-Tabelle fuer Starting Year | 3 | FROMYEAR | Starting Year | nvarchar | 4 | 0 | | |
2 | CNV_20201_RNMB | Conversion rules for number ranges | 6 | FROMYEAR | From fiscal year for conversion rule | nvarchar | 4 | 0 | | |
3 | UCS01AC | Tasks: Data Transfer | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
4 | UCS01AD1 | Tasks: Sign-Off | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
5 | UCS01AE | Tasks: Reconciliations | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
TOPBusiness Consolidation |
6 | UCF2110 | C/T: E/R Indicators: E/R Type Assignments | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
7 | UCF9010 | Balance Carryforward: Items to be Carried | 5 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
8 | UCF9020 | Balance Carryforward: Document Type Assignment | 5 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
9 | UCFC010 | Consolidation Group Change: Document Type Assignment | 5 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
10 | UCFI200 | IPI Customizing: Inventory Items | 5 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
11 | UCM6100 | Organizational Change: Top Nodes | 5 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
12 | UCMA100 | Type of Assets/Liabilities: Posting Items | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
13 | UCMA101 | Type of Asset/Liability: Consolidation Frequency | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
14 | UCMI200 | Selected Items: Cross-Functional | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
15 | UCMI201 | Selected Items: Document Type-dependent | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
16 | UCMI210 | Selected Items: Consolidation of Investments | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
17 | UCMI220 | Selected Items: Elimination of IU Profit/Loss in Inventory | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
18 | UCS0100 | Tasks: Method | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
19 | UCS0101 | Tasks: Document Type | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
20 | UCS0103 | Tasks: Elimination of IU P/L in Inventory | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
21 | UCS0104 | Tasks: Validation | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
22 | UCS0105 | Tasks: Cons Frequency | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
23 | UCS0106 | Tasks: Posting Levels | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
24 | UCS0110 | Tasks: Preceding Tasks | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
25 | UCS0120 | Tasks: Status-bearing Cons Groups | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
26 | UCS01A2 | Tasks: Log Layout: Sequence, Active/Inactive | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
27 | UCS01A3 | Tasks: IPA or CVA | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
28 | UCS01A4 | Tasks: Cons Group Selection | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
29 | UCS01A5 | Tasks: Balance Carryforward Task | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
30 | UCS01A6 | Tasks: Workflow Variant | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
31 | UCS01A7 | Measures: Workflow_variant for Sign-Off Task | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
32 | UCS01A8 | Measures: Selection ID for repunit and repgroup | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
33 | UCS01A9 | Measures: Query | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
34 | UCS01AA | Tasks: Reclassification | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
35 | UCS01AB | Tasks: Consolidation Group Change | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |
36 | UCS0400 | Statusbearing Rep.Groups for Interunit Level 10 | 6 | FROMYEAR | Effective from Fiscal Year | nvarchar | 4 | 0 | | |