| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FTBB_YCCSPRD_DEF | Extension of Credit-Spread Definition | 8 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
2 | RDPT_CONDITION | Condition within Redemption Schedule | 30 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
3 | VIYCADVPAY | Advance Payments | 42 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPAccounting |
4 | TDIOA_SCHEME_DEF | Profile Definition for Interest on Arrears Calculation | 6 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
5 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 28 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPAgency Business Global Trade |
6 | TMZR | Agency Business: Payment Types | 26 | SZBMETH | Method of calculating interest for additional cash discount | nvarchar | 1 | 0 | | |
TOPAssetLiability Management |
7 | JBAPLANPAR | ALM Assignment of Planning Parameters to Planning Variant | 9 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
8 | JBASIMAP | ALM Simulation Type: Parameters | 9 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
9 | JBASIMPARASAVEDB | ALM: Additional Information when Saving Sim. Transactions | 22 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
10 | JBRALMPARASAVE | ALM: Evaluation Parameters | 20 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
11 | JBRBG2 | Gap Analysis - Global Control | 7 | SZBMETH | Interest Calculation Method in Gap | nvarchar | 1 | 0 | | |
12 | JBRSIMZ | Simulated Interest - Definition | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
13 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 21 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
14 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 21 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPBack Office |
15 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 82 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
16 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 82 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPBank Components |
17 | JBAFOKOKO | Condition Header | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
18 | JBASAKOKO | Collective Conditions, Condition Header | 5 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
19 | JBASTCH | Standard Conditions: Condition Header | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPInformation System |
20 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 55 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPLease Accounting |
21 | FILA_RE_PRG | Refinancing Program | 23 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
22 | TFILAFM_IRCM | Assignment of Acct Prin. to Interest Rate Calc. Methods | 5 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPLoans Management |
23 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 23 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
24 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 42 | SZBMETH | Zinsberechnungsmethode | nvarchar | 1 | 0 | | |
25 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 73 | SZBMETH | Zinsberechnungsmethode | nvarchar | 1 | 0 | | |
26 | TTONFTVZZKOKO | Test neue FIMA: VZZKOKO | 20 | SZBMETH | Zinsberechnungsmethode | nvarchar | 1 | 0 | | |
27 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 24 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
28 | VDBEPI | Posted line items for document header | 61 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
29 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 61 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
30 | VDBEPP | Flow Data - Planned Item | 54 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
31 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 54 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
32 | VDCFWAREHOUSE | Cash Flow Management | 28 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
33 | VDMEPOV | Condition Table: Variant Item | 32 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
34 | VDORDER | Borrower's note loan order data | 40 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
35 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 57 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPMaster Data |
36 | VDESCROWKOKO0 | TEMPORARY USE: Escrow Condition Headers | 21 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
37 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 41 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPReal Estate Contract |
38 | VICDCFOBJ | Object-Related Cash Flow | 38 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
39 | VICDCFPAY | Payment-Related Cash Flow | 38 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
40 | TZK02 | Condition group, condition group - condition type allocation | 22 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
41 | VIBEPP | Flow data - Planned items for real estate management | 58 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
42 | VIKOKO | Real Estate condition header | 26 | SZBMETH | Calculation method for time-dependent periods | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
43 | /BEV3/CHABEWEALT | Test Transfer Structure: Flow Records in Cash Flow Calcul. | 37 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
44 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
45 | /BEV3/CHAKONDALT | Test transfer structure cash flow for conditions | 31 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
46 | /BEV3/CHASTEU | Control Table | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
47 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
48 | /BEV3/CHCVBFIMA1 | FIMA converter 1 AC/RI control record setting | 5 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
49 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
50 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
51 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
52 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
53 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
54 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
55 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
56 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
57 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
58 | /BEV3/CHTRMSTZ_P | CH Date Item | 85 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
59 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
60 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 86 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPRisk Analysis |
61 | JBRBG0 | Gap Analysis - Global Control | 6 | SZBMETH | Interest Calculation Method in Gap | nvarchar | 1 | 0 | | |
62 | JBRDBBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 14 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
63 | JBRHBEWEG | RM: Version Table BEWEG for Extended Cat. of Primary Trans. | 15 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
64 | JBRKNZ | RM: External Key Figures for Financial Object | 10 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
65 | JBROZ | RM Gap Opportunity Interest Rates from Single Trans. Costing | 5 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
66 | JBRSVBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 15 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
67 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 21 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPTransaction Data Pool |
68 | JBCFBEWEG | Cash Flow Transaction: Flows | 23 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
69 | JBCFBZR | Cash Flow Transaction: Analysis Period | 11 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
70 | JBCFZSTRBEWEG | Cash Flow Transaction: Flow Data for Cash Flow | 24 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
71 | JBDKOKO | Condition Header | 6 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
72 | JBDVTCH | Variable Transaction - Condition Headers | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
73 | JBDZSKO | Cash Flow Header | 15 | SZBMETH | Interest Calculation Method for Cash Flow Header | nvarchar | 1 | 0 | | |
TOPTransaction Management |
74 | TCHT_HD_BEWEG_CF | SFGDT FGET Cashflows Table | 14 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
75 | TCHT_HD_COND | Instrument Conditions | 17 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
76 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 73 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
77 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 28 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
78 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 58 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
79 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 27 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
80 | TRDT_SEC_FLOW | Persistent distributor flows: Part for BEPP adaptor | 14 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
81 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 36 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
82 | VTBFHAPO | Transaction Flow | 73 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
83 | VTBFHAPO_MIGR | Migrated Financial Flows | 73 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
84 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 73 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
85 | VTBFINKO | Transaction Condition | 28 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
86 | VTBPFHAPO | Treasury: Flow Shells | 65 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
87 | VTIFHAPO | Underlying transaction flows | 58 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
88 | VTIFINKO | Underlying transaction conditions | 27 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
89 | VWBEPI | Treasury Securities: Actual Flows - Item | 50 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
90 | VWBEPP | Treasury Securities: Planned Flows | 88 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
91 | VWORDE | Order Data | 78 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPTreasury |
92 | AT56R | Supplements to Analysis System for Table T056R | 6 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
93 | JBD14 | Yield Curve Types (Header Information) | 4 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
94 | TZPA | Financial Assets Management Product Types | 14 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
95 | TZPAB | Financial Assets Management product types | 14 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
96 | VTIDERI | Master Data Listed Options and Futures | 27 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
97 | VZZKOPO | Table condition items | 44 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |
TOPTreasury and Risk Management |
98 | VZZKOKO | Table condition header | 19 | SZBMETH | Interest Calculation Method | nvarchar | 1 | 0 | | |