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