Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Real Estate Contract | ||||||||||
1 | TIVCDPROP | Attribute of Condition Type | 4 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
Rent Adjustment | ||||||||||
2 | TIVAJADJMVAR | Variable for Adjustment Control | 3 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
3 | TIVAJBLOCKREAS | Reason for adjustment block | 2 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
4 | TIVAJBLOCKREAST | Reason for Adjustment Lock (text) | 3 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
5 | TIVAJMETH | Adjustment Method | 1 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
6 | TIVAJMETHCOMB | Combined Adjustment Method | 1 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
7 | TIVAJMETHT | Adjustment Method (Text) | 2 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
8 | TIVAJREASON | Adjustment Reason | 2 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
9 | TIVAJREASONT | Adjustment Reason (Text) | 3 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
10 | TIVAJRULE | Adjustment Rules | 3 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 | ||
11 | VIAJRULE | Contract/Rental Object: Adjustment Rule | 8 | ADJMMETH | Adjustment Method | nvarchar | 4 | 0 |