| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCEXPPOOL | Expense Pool in CAM | 24 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
2 | VIYCMETERCOSTS | Meter Based Costs | 33 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
3 | VIYCREFFACTOR | Reference Factors | 26 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
TOPSales-Based Rent and Settlement |
4 | VISRTMRP | Reporting Rule | 14 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
TOPService Charge Settlement |
5 | TIVSCAJSCKATTR | Attributes of Adjustment of SCS Advance Pmnt per SC Key | 5 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
6 | TIVSCSUDEFAULT | Defaults for Creating SU per SC Key | 6 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
7 | VISCAJROSU | Adjustment Record SCSE per RO and SU | 22 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
8 | VISCSHAREOUT | Split settlement factors for settlement variant | 8 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |
9 | VISCS_SU_SUM | Sum of All Costs and Measurement Amounts for Settlment Unit | 23 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | |