| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Data |
1 | TIVBDCHARACT | Fixtures and Fittings Characteristic | 2 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
2 | TIVBDCHARACTT | Fixtures and Fittings Characteristic (Text) | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
3 | TIVBDCTOBJ | Allowed Fixtures/Fittings Characteristics per Object Type | 4 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
4 | TIVBDUSTYREL | Allowed Usage Types per Usage Group | 4 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
5 | VIBDCHARACT | Fixtures/Fittings | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
TOPDFPS Authorized Infrastructure |
6 | /ISDFPS/T_RECAEX | RE: Extend Equipment Characteristics | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
TOPLocalization |
7 | TIVXCNLCHARARD | Fixtures and Fittings Characteristic NL | 2 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
8 | VIXCNLCHARACT | Fixtures/Fittings NL | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
TOPMigration |
9 | TIVMISET | Basic Settings for Migration | 12 | FIXFITCHARACT | Fixtures/Fittings Characteristic for Apportionment Loss Risk | nvarchar | 6 | 0 | | |
10 | TIVMISETOBJCHAR | Mapping from Object Characteristic to Fixt/Fittings Char. | 5 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
11 | TIVMISETOO | Mapping of Occupancy Obligation | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
12 | TIVMISETUSGTYPE | Mapping of Usage Type of Rental Object | 4 | FIXFITCHARACT | Fixtures/Fittings Characteristic for Apportionment Loss Risk | nvarchar | 6 | 0 | | |
TOPOffer and Rental Request |
13 | TIVORCHARACT | Fixt./Fittings Characteristic for Real Estate Search | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
TOPRent Adjustment |
14 | TIVAJRLRASRCH | Increase/Reduction Characteristic | 3 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
15 | TIVAJRLRASRCHA | Increases/Reductions per Characteristic Categ. and Space | 14 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
16 | VIAJRECRLRAFF | Adjustment Record RLRAFF | 8 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
TOPService Charge Settlement |
17 | TIVSCCHRGRO | Calculation of Surcharges Dependent on Rental Object | 4 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |
18 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 44 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | |