| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Market Data |
1 | /BA1/TF4_MATSTR | Maturity Structures for Key Rate Duration | 2 | STR_ID | Maturity Structure | nvarchar | 10 | 0 | | |
2 | /BA1/TF4_MATSTRC | Currencies of Maturity Structure | 2 | STR_ID | Maturity Structure | nvarchar | 10 | 0 | | |
3 | /BA1/TF4_MATSTRP | Properties of Maturity Structure | 2 | STR_ID | Maturity Structure | nvarchar | 10 | 0 | | |
4 | /BA1/TF4_MATSTRT | Text Table for Maturity Structures | 2 | STR_ID | Maturity Structure | nvarchar | 10 | 0 | | |
TOPFunds Management |
5 | FMCI | Commitment items master data | 41 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
6 | FMFCTR | Funds Center Master Record | 51 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
7 | FMFINCODE | FIFM: Financing code | 22 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
TOPGovernance, Risk and Compliance |
8 | GRFNDMSTRING | NOT USED! DataMart: Storage for strings (language dependent) | 3 | STR_ID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
TOPMaster Data |
9 | FMMDCISUB1 | Value of Substring 1 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
10 | FMMDCISUB1T | Text of Substring 1 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
11 | FMMDCISUB2 | Value of Substring 2 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
12 | FMMDCISUB2T | Text of Substring 2 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
13 | FMMDCISUB3 | Value of Substring 3 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
14 | FMMDCISUB3T | Text of Substring 3 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
15 | FMMDCISUB4 | Value of Substring 4 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
16 | FMMDCISUB4T | Text of Substring 4 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
17 | FMMDCISUB5 | Value of Substring 5 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
18 | FMMDCISUB5T | Text of Substring 5 of Commitment Item | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
19 | FMMDFCSUB1 | Value of Substring 1 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
20 | FMMDFCSUB1T | Text of Substring 1 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
21 | FMMDFCSUB2 | Value of Substring 2 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
22 | FMMDFCSUB2T | Text of Substring 2 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
23 | FMMDFCSUB3 | Value of Substring 3 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
24 | FMMDFCSUB3T | Text of Substring 3 of Funds Center | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
25 | FMMDFDSUB1 | Value of Substring 1 of Fund | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
26 | FMMDFDSUB1T | Text of Substring 1 of Fund | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
27 | FMMDFDSUB2 | Value of Substring 2 of Fund | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
28 | FMMDFDSUB2T | Text of Substring 2 of Fund | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
29 | FMMDFNSUB1 | Value of Substring 1 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
30 | FMMDFNSUB1T | Text of Substring 1 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
31 | FMMDFNSUB2 | Value of Substring 2 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
32 | FMMDFNSUB2T | Text of Substring 2 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
33 | FMMDFNSUB3 | Value of Substring 3 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
34 | FMMDFNSUB3T | Text of Substring 3 of Functional Area | 2 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
35 | FMMDSTRID | Define Subdivision ID of FM Master Data | 3 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
36 | FMMDSUBDIV | Define Substrings of FM Master Data | 3 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
37 | FMMDSUBDIVT | Define Substrings of FM Master Data | 4 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |
TOPOverhead Cost Controlling |
38 | TFKB | Functional areas | 4 | STR_ID | Master Data Subdivision ID | nvarchar | 10 | 0 | | |