| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIA1T | Texts for acct settlement variants | 3 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
TOPMigration |
2 | TIVMISETSRRH | Settlement Variant for Frequency | 2 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
3 | TIA01 | Settlement variants | 2 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
4 | TIA02 | Settlement periods | 2 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
5 | TIV92 | External fee types | 10 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
6 | VIAK01 | History of acct settlement runs | 9 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
7 | VIAK04 | Allocation of Settlement Variants to Settlement Unit | 8 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
8 | VIAK25 | Cost collector for SU (per settlement period) | 10 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
9 | VICNSCS | Real Estate Contract: Service Charge Key | 7 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
10 | VIMIUH | Sales-Based LO: Contractual Sales Lease-Outs Header | 12 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
11 | VIVW04 | Management contract: Settlement periods for fee types | 7 | ABRVAR | Settlement variant | nvarchar | 4 | 0 | | |
TOPSwitzerland |
12 | T5C2C | Withholding Tax Liability | 16 | ABRVAR | WHT Accounting Output Variant | nvarchar | 2 | 0 | | |