| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRFB_CLASS_POS | CFM: Backup Table for TRF Class Position | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
2 | TRFB_FLOW | CFM: Backup Table with TRF Flows | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
3 | TRFB_SUBTOTAL | CFM: Backup Table with TRF Transaction Figures | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
4 | TRFB_SUBTRANS | CFM: Backup Table for TRF Business Subtransaction | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
5 | TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
6 | TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
7 | TRSB_NOM_CORR | CFM: Backup Table for Nominal Adjustment | 4 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
8 | TRSB_POSCHG_FLOW | CFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos. | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
9 | TRSB_RECON_POS | CFM: Backup Table for Position Reconciliation | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
10 | TRSB_SECACCTRANS | CFM: Backup Table for Securities Account Transfer | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
11 | TRSB_SUBTOTAL | CFM: Backup Table with Transaction Figures | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
TOPGermany |
12 | TZBCKVWBEPI | Backup: Flow data - Position/Actual | 5 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
TOPLoans Management |
13 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 227 | KMNR | Nummer der Kapitalmaßnahme | nvarchar | 13 | 0 | | |
TOPTransaction Manager |
14 | BCKVTBFHAPO | Backup: Transaction Flows | 8 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
15 | BCKVWBEPI | Backup: Flow data - Position/Actual | 5 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
16 | BCKVWBEPP | BACKUP: Flow data - Position/Planned | 8 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
17 | BCKVWBWKM | BACKUP: Flow table for corporate actions | 4 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
18 | BCKVWORDE | BACKUP: Order data | 7 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
19 | BCKVWPAKTI | BACKUP: Stock, subscription rights, investment certificates | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
20 | BCKVWPANLA | BACKUP: Asset master | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
21 | BCKVWPANLE | BACKUP: Interest-bearing securities | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
22 | BCKVWPSHARECAP | Backup: BCKVWPSHARECAP | 4 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
23 | BCKVWVORTR | BACKUP: Carryover totals - securities | 7 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
24 | BCKVWZUORD | BACKUP: SEC assignment table for restraints on disposal | 5 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
25 | BCKVZSKOKO | BACKUP: Condition header for stock, sub.rgt, invest., share. | 4 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
26 | BCKVZZKOPO | BACKUP: Condition Item Table | 12 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
27 | BCK_VTIFHAPO | Backup for Currency Changeover of Bond Underlying | 7 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
28 | RDPT_RED_BCKUP | Treasury: Backup for Converting Currency of Redemption Sch. | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
29 | TRQB_FLOW | CFM: Backup Table for Flow Data in Quantity Ledger | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
30 | TRQB_LOTFLOW | CFM: Backup Table with Lot Flows | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
31 | TRQB_POSITION | CFM: Backup Table for Quantity Ledger Position | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
32 | TRQB_SUBTOTAL | CFM: Backup Table with Quantity Ledger Pos. Transact. Figs | 3 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
33 | VWBEPI | Treasury Securities: Actual Flows - Item | 101 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
34 | VWBEPP | Treasury Securities: Planned Flows | 152 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
35 | VWBWKM | TRTM-PM: Flow table for corporate actions | 4 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
36 | VWKMKO | Corporate actions (header) | 2 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |
37 | VWKMPO | Corporate actions (items) | 2 | KMNR | Corporate Action Number | nvarchar | 13 | 0 | | |