| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | VIYCCOST2DC | Application of Distribution / Denominator Method | 63 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 2 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 44 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 3 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 55 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 4 | VIYCMETERCOSTS | Meter Based Costs | 31 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 5 | VIYCRENT | Rental period | 9 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 6 | VIYCSETTL | Settlement Identification with Log Reference | 7 | PFROM | Start of Settlement Period | nvarchar | 8 | 0 | | |
| 7 | VIYCSETTLSTEP | CAM Settlement Step Information | 18 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 8 | VIYCSTLMTRCOST | Settled Meter Costs with lease | 14 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| TOPFlexible Real Estate Management |
| 9 | VIXCSCCHTAPE | Header Data for External Heating Expenses Settlement | 14 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| TOPLocalization |
| 10 | J_3RSEXTRACTH | Extract header (obsolete) | 4 | PFROM | Fiscal Period | nvarchar | 2 | 0 | | |
| 11 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 11 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| TOPRental Accounting |
| 12 | VIRAACRITEM | Accrual Item | 5 | PFROM | Start of Calculation Period | nvarchar | 8 | 0 | | |
| 13 | VIRADOCITEM | RE Document Item | 17 | PFROM | Start of Calculation Period | nvarchar | 8 | 0 | | |
| TOPSales and Distribution |
| 14 | J_1USEXTRACTH | EXTRACTH | 4 | PFROM | Fiscal Period | nvarchar | 2 | 0 | | |
| TOPSales-Based Rent and Settlement |
| 15 | VISRCALCSB | Interim Result | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 16 | VISRCALCSUM | Calculation Results per Sales Rule | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 17 | VISRSTATUS | Status per Contract and Sales Rule (Dependent on Version) | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| TOPService Charge Settlement |
| 18 | VISCACCRUAL | Accrual/Deferral | 6 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 19 | VISCAJROSU | Adjustment Record SCSE per RO and SU | 9 | PFROM | Start of Settlement Period | nvarchar | 8 | 0 | | |
| 20 | VISCCOSTSEXT | Costs per Object - Legacy Data Transfer | 11 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 21 | VISCMAPPROCSCS | Mapping Process to Settlement Hierarchy | 5 | PFROM | Start of Settlement Period | nvarchar | 8 | 0 | | |
| 22 | VISCSETTL | Settlement Identification with Log Reference | 7 | PFROM | Start of Settlement Period | nvarchar | 8 | 0 | | |
| 23 | VISCS_RENT | Rental period | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 24 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 25 | VISCS_SU_RO | Sum of All Costs and Measurement Amounts for a Rental Object | 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
| 26 | VISCS_SU_SUM | Sum of All Costs and Measurement Amounts for Settlment Unit | 6 | PFROM | Period Start Date | nvarchar | 8 | 0 | | |
