| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDPT_CONDITION | Condition within Redemption Schedule | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
2 | TDP4 | Alloc. of activity type and flow category to condition type | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
3 | TZK0A | Condition type texts (Table TZK01) | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
4 | TZK0G | Texts for condition type-dependent detailed description | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
5 | TZKM1 | Event-controlled modification of condition items | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
6 | VDMSG_FOR_COND | Message type for different condition types | 2 | SKOART | Condition Type for Table VDMSG_FOR_COND | nvarchar | 4 | 0 | | |
7 | VDREF_INT | Customizing table for Reference Interest Rate | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
8 | VDSEPA_MND_USG | Overview of mandates used in Loans Management | 10 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPAccounting |
9 | TDIOA_BAL_COND | Assignment Condition Type to Flow Type Grouping - IOA Calc. | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
10 | VDIOA_CALC_DET | Progress (Interest) of Model Account IOA Calculation | 20 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPAssetLiability Management |
11 | TTD_COND_MAP | Time Deposit Conditions to Treasury Conditions | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPBack Office |
12 | TRSC_CONDITION | Treasury: Update Types for Condition Type | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
13 | TRSC_CONDITION_P | Update Types for Condition Type (Passive Positions) | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
14 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 99 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
15 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 99 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPBank Components |
16 | JBACDPERTY | Permitted Condition Types for List Types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
17 | JBAFOKOPO | Condition Items | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
18 | JBASAKOKO | Collective Conditions, Condition Header | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
19 | JBASTCP | Standard Conditions: Condition Item | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
20 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 22 | SKOART | Konditionsart (feinste Unterteilung der Konditionssätze) | nvarchar | 4 | 0 | | |
21 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 12 | SKOART | Konditionsart (feinste Unterteilung der Konditionssätze) | nvarchar | 4 | 0 | | |
TOPLoans Management |
22 | TDBO_CONDN | Standard Conditions | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
23 | TDCOND_PROP | Currency-Dependent Default Setting of Conditions | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
24 | TDFFB_CFHEXEPT_O | Exception Table for Controlling Outflow Behavior | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
25 | TDLOANFKO | Condition Types per Application Partial Function Loans | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
26 | TDP0 | Selection, Modification- and Reference Fields | 9 | SKOART | General parameters for logical field | nvarchar | 4 | 0 | | |
27 | TDREPAY_CFHANDLE | Cash Flow Behavior in the Payoff | 3 | SKOART | Condition Type for Partial Waiver | nvarchar | 4 | 0 | | |
28 | TDREPAY_PRCOND | Condition Type Determination for the Payoff | 5 | SKOART | Condition Type for Partial Waiver | nvarchar | 4 | 0 | | |
29 | TDRP_COND_TYPE | Repayment schedule: relevant condition types | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
30 | TRDC_REC | Summarization of Loan Document Items: Carryforward Records | 14 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
31 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 6 | SKOART | Konditionsart (feinste Unterteilung der Konditionssätze) | nvarchar | 4 | 0 | | |
32 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 175 | SKOART | Konditionsart (feinste Unterteilung der Konditionssätze) | nvarchar | 4 | 0 | | |
33 | VDARC_DOC_REC | Carryforward Records for Reorganization of Loan Doc. Items | 15 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
34 | VDBEPI | Posted line items for document header | 68 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
35 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 68 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
36 | VDBEPP | Flow Data - Planned Item | 102 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
37 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 102 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
38 | VDCFWAREHOUSE | Cash Flow Management | 19 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
39 | VDKOPO_EU | Condition Item Data Before EURO Conversion (Loans) | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
40 | VDREPAYMENT | Payoff Master Data | 53 | SKOART | Partial Payoff: Condition Type for Repayment ChangeC | nvarchar | 4 | 0 | | |
41 | VDVORTR | Loan carry-forward totals | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
42 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 105 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPMaster Data |
43 | TDMODEL_FIELDTXT | Field Texts for Consumer Loans | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
44 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 4 | SKOART | Payment Type (Condition Type) | nvarchar | 4 | 0 | | |
TOPMigration |
45 | TIG09 | Immobilien gew.: zulässige Konditionsarten je Flächenart | 3 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
46 | TIVMISETCDSR | Assignment of Sales-Based Rent Conditions | 2 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
47 | VIGWFLBW | Immobilien gew.: Flächen-Bewertungen (zeitabh.) | 4 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
48 | VIGWFLBW_F | Immobilien gew.: Flächen-Bewertungen Stammdaten | 4 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
49 | VIGWFLBW_M | Immobilien gew.: Flächen-Bewertungen (zeitabh.) | 4 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
50 | VIGWVOBW | Immobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G | 7 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
51 | VIGWVOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 7 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
52 | VIGW_VOBW | CRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR | 7 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
53 | VIGW_VOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 7 | SKOART | Ehtolaji (ehtotietueiden tarkin jako alaluokkiin) | nvarchar | 4 | 0 | | |
TOPPortfolio |
54 | VDARL_PAYM_PLAN | References from Premium Plans to Relevant Objects | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
55 | VDCOT_VER_CON | Conditions in the Condition Table | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
56 | IVBP | Line Item (Settlement: Service Charge Collector) (Obsolete) | 30 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
57 | S406 | Rental units | 59 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
58 | S407 | Rental agreements | 98 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
59 | TIANP | Minimum amounts for adjustment of advance pmnts/flat-rates | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
60 | TIK01 | Condition types additional data for DARWIN Real Estate | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
61 | TIK03 | Condition type - Condition category allocation | 2 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
62 | TIK05 | Alternative reference areas for condition types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
63 | TIPAR | Rent Adjustment: Rounding Parameters | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
64 | TIV48 | Allocation of condition types to settlement factors | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
65 | TIV86 | Allocation of periodic fee types to condition types | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
66 | TIV90 | Default-condition types for adjustment type | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
67 | TIVM3 | RA: Permitted Condition Types for Each Adjustment Method | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
68 | TIVN2 | Defaults for Settlement Participation of Condition Type | 4 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
69 | TIVWB08 | Wirtschaftlichkeitsber.: Konditionsarten für Mietanpassung | 2 | SKOART | Konditionsart für Berechnung Erlöse WiBe | nvarchar | 4 | 0 | | |
70 | TIVWB51 | WB: Gruppen für Aufwandsarten | 4 | SKOART | Konditionsart (feinste Unterteilung der Konditionssätze) | nvarchar | 4 | 0 | | |
71 | TZK01 | Condition types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
72 | TZK02 | Condition group, condition group - condition type allocation | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
73 | TZK09 | Relationship between condition types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
74 | VIAK02 | Settlement Participation for Service Charge Settlement | 10 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
75 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 21 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
76 | VIAK14 | RA credit memo/receivable:now only used as structure! | 11 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
77 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 11 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
78 | VIAKUV | Sales settlement histories | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
79 | VIBEPP | Flow data - Planned items for real estate management | 66 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
80 | VICNSCS | Real Estate Contract: Service Charge Key | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
81 | VICNSCSPP | Real Estate Contract: Liability Reserves | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
82 | VIMI09 | Graded Lease-Out | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
83 | VIMI16 | RE: Records of a Rent Adjustment Run | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
84 | VIMI17 | RE: Adjustment Run Header | 31 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
85 | VIMI18 | Rent Adjustment History for Lease-Out | 7 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
86 | VIMI25 | Sales reports | 6 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
87 | VIMI28 | Sales settlement histories | 8 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
88 | VIMI45 | OLD, replaced by VIMI55 for 3.0 | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
89 | VIMI46 | OLD, replaced by VIMI56 for 3.0 | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
90 | VIMI54 | Real Estate: Time-dependent adjustment data | 6 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
91 | VIMI55 | Index Data for Lease-Out (Time-Dependent) | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
92 | VIMI56 | LO: Adjustment Block for Condition Types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
93 | VIMIUH | Sales-Based LO: Contractual Sales Lease-Outs Header | 3 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
94 | VIMIUI | Sales-Based Grading Lease-Out Items | 3 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
95 | VIRPS406 | Rental units | 59 | SKOART | Condition: Type | nvarchar | 4 | 0 | | |
96 | VIRPS407 | Rental agreements | 98 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
97 | VZZKOPO_DM | Amount fields for VZZKOPO in original currency | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPSingle Transaction Costing |
98 | JBDZZTK | Standard Customizing for Condition Field Selection | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPTransaction Data Pool |
99 | JBDKKOF | Fixing Table for Variable Transactions | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
100 | JBDKKOF_BACKUP | Backup Table for the Conversion of JBDKKOF | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
101 | JBDKKOF_N | New Fixing Table for Variable Transactions | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
102 | JBDKOPO | Condition Items | 7 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
103 | JBDTZK01 | Condition Types for Variable Transactions | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
104 | JBDVTCP | Variable Transaction - Condition Items | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPTransaction Management |
105 | TCHT_HD_COND | Instrument Conditions | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
106 | VTBMDMAPKOND | CFM: Mirror Transaction - Map Conditions | 4 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
107 | AT11 | Allocation of Condition Types to Transaction Types | 5 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
108 | AT20 | Supplements to Condition Types | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
109 | BCKVZZKOPO | BACKUP: Condition Item Table | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
110 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 24 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
111 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 19 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
112 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 22 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
113 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 18 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
114 | TRDT_SEC_FLOW | Persistent distributor flows: Part for BEPP adaptor | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
115 | VTBFHAPO | Transaction Flow | 24 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
116 | VTBFHAPO_MIGR | Migrated Financial Flows | 24 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
117 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 24 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
118 | VTBFINKO | Transaction Condition | 19 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
119 | VTBPFHAPO | Treasury: Flow Shells | 23 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
120 | VTIFHAPO | Underlying transaction flows | 22 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
121 | VTIFINKO | Underlying transaction conditions | 18 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
122 | VWBEPI | Treasury Securities: Actual Flows - Item | 57 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
123 | VWBEPP | Treasury Securities: Planned Flows | 102 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
TOPTreasury |
124 | TZK07 | Condition type-dependent detailed description skopo | 3 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
125 | VZZKOPA | Alternative condition item - conditions | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
126 | VZZKOPO | Table condition items | 9 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |
127 | VZZUSP | Payment splitting | 14 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | |