| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIV64 | Periods of notice - replaced by TIVKUE2 and TIVKUE3 | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
2 | TIVXCITTASICTC | Contract Type classification | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
3 | TIVXCITTASIRATE | TASI City rates | 5 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
4 | VIXCITTASICALC | TASI calculation data | 7 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
5 | TIVCACTCNTYPE | Contract-Type-Dependent Settings for Diff. Condition Crcy | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
6 | TIVLS26 | LUM: Vertragsart für Liegenschaftsverträge | 2 | SMVART | Externe Vertragsart Immobilien | nvarchar | 4 | 0 | | |
TOPMigration |
7 | TIVMISETCNTYPE | Mapping of Contract Types | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
8 | TIVCNCCTADD | Attribute for Contract | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
9 | TIVCNCCTFMOD | Field Status per Contract Type | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
10 | TIVCNUSGCNTYPE | Allowed Usage Type per Contract Type | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
11 | S407 | Rental agreements | 146 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
12 | TIPA1 | FI-FVVI: Parameters for tenancy law and adjustment type | 3 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
13 | TIV26 | Real Estate Contract Type (Entities) | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
14 | TIV2F | Text table for Real Estate Contract Type (table TIV26) | 3 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
15 | TIV46 | Tax code for administration costs surcharge on IEA | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
16 | TIVBOLLO | Parameters Imposta di Bollo | 5 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
17 | TIVCPOI01 | Recipients | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
18 | TIVCPOI02 | Partner Assignment in the Includes of the OI Print Structure | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
19 | TIVKUE2 | Period regulation - periods of notice | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
20 | TIVKUE2V | Notice Periods for Period Regulation - Tenant View | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
21 | TIVKUE3 | Deadline regulation - periods of notice | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
22 | TIVKUE3V | Notice Periods for Deadline Regulation - Tenant View | 4 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
23 | TIVRCTYPCORRGRP | Default Correspondence Group for Rental Agreement Type | 2 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
24 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 12 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
25 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 9 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
26 | VIMIMV | Lease-Out | 13 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |
27 | VIRPS407 | Rental agreements | 146 | SMVART | External Real Estate contract type | nvarchar | 4 | 0 | | |