| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDPT_CONDITION | Condition within Redemption Schedule | 68 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPBack Office |
2 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 100 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
3 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 100 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPLoans Management |
4 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 104 | SKALIDWT | Zinskalender | nvarchar | 2 | 0 | | |
5 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 74 | SKALIDWT | Zinskalender | nvarchar | 2 | 0 | | |
6 | TTONFTVZZKOKO | Test neue FIMA: VZZKOKO | 57 | SKALIDWT | Zinskalender | nvarchar | 2 | 0 | | |
7 | VDBEPI | Posted line items for document header | 142 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
8 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 141 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
9 | VDBEPP | Flow Data - Planned Item | 167 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
10 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 167 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
11 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 170 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPMaster Data |
12 | VDESCROWKOKO0 | TEMPORARY USE: Escrow Condition Headers | 58 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
13 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 91 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPReal Estate Management |
14 | TZK02 | Condition group, condition group - condition type allocation | 50 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
15 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 74 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
16 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 29 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
17 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 28 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
18 | TRDT_SEC_FLOW | Persistent distributor flows: Part for BEPP adaptor | 32 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
19 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 37 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
20 | VTBFHAPO | Transaction Flow | 74 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
21 | VTBFHAPO_MIGR | Migrated Financial Flows | 74 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
22 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 74 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
23 | VTBFINKO | Transaction Condition | 29 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
24 | VTBPFHAPO | Treasury: Flow Shells | 66 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
25 | VTIFINKO | Underlying transaction conditions | 28 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
26 | VWBEPI | Treasury Securities: Actual Flows - Item | 51 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
27 | VWBEPP | Treasury Securities: Planned Flows | 89 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPTreasury |
28 | VZZKOPO | Table condition items | 94 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |
TOPTreasury and Risk Management |
29 | VZZKOKO | Table condition header | 56 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | | |