| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_ECI_BAL | RBD ECF - Positions Import Table | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
2 | /IBS/TRB_ECI_BVC | RBD ECF - Book Value Components Import Table | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
3 | /IBS/TRB_ECI_CF | RBD ECF - Cash Flow Import Table | 6 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
4 | /IBS/TRB_ECI_CO | RBD ECF - Import Table for Collateral | 6 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
5 | /IBS/TRB_ECI_HD | RBD ECF - Import Table Header Data | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
6 | /IBS/TRB_ECM_BAL | RBD ECF: Manual Contract Management - Positions | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
7 | /IBS/TRB_ECM_BVC | RBD ECF: Manual Contract Management - Book Value Components | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
8 | /IBS/TRB_ECM_HD | RBD ECF: Manual Contract Management - Header Data | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
9 | /IBS/TRB_KTO_PRP | RBD Account. Master Data | 17 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
TOPPublic Sector |
10 | T5D5Z | Supplementary Pension Public Sector: SPI Data | 8 | STIDA | Day and Month of Key Date for Notification of Differences | nvarchar | 4 | 0 | | |
TOPValue Adjustment |
11 | /IBS/TRB_IASGHD | RBD IAS-GATE Header Data | 21 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
12 | /IBS/TRB_KTO | RBD Account. Master Data | 17 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
13 | /IBS/TRB_KTODATE | RBD Account Key Date for Valuation Method | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
14 | /IBS/TRB_RBDGATE | RBD: Universal Data Basis/Worklist | 9 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
15 | /IBS/TRB_RBDLOSS | RBD Loss Source System | 6 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |
16 | /IBS/TRB_VS_SALD | RBD Individual Document Table | 5 | STIDA | RBD: Key Date for Extraction of Flow Types | nvarchar | 8 | 0 | | |