| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | VIYCADVPAY | Advance Payments | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 2 | VIYCCE2POOL | Cost Elements in Pool | 4 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 3 | VIYCCNPOOL | CAM Pool in CAM Recovery | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 4 | VIYCCOST2DC | Application of Distribution / Denominator Method | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 5 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 6 | VIYCCOST2MTC | Major Tenant deduction for lease in CAM recovery | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 7 | VIYCCOST2OBJ | Determined Costs for Objects in CAM recovery | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 8 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 9 | VIYCMETERCOSTS | Meter Based Costs | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 10 | VIYCOBJ2POOL | Objects in CAM Pool | 4 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 11 | VIYCRECEIVABLE | Receivables from Settlement | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 12 | VIYCREFFACTOR | Reference Factors | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 13 | VIYCRENT | Rental period | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 14 | VIYCSETTL | Settlement Identification with Log Reference | 2 | SETTL_GUID | Generic Key of Process | varbinary | 16 | 0 | | |
| 15 | VIYCSETTLSTEP | CAM Settlement Step Information | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 16 | VIYCSTLMTRCOST | Settled Meter Costs with lease | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| TOPFlexible Real Estate Management |
| 17 | VISCSELOPT | OBSOLETE: All Select-Options of SCS (now VICARANGE) | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 18 | VISCS_COSTS | OBSOLETE: Determined Costs (Replaced by VISCSCOSTS) | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 19 | VISCS_MEAS | OBSOLETE: Measurement Amount (Replaced by VISCSMEAS) | 8 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 20 | VISCS_STATUS | OBSOLETE: Status of the Settlement Steps | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| TOPLocalization |
| 21 | VIXCFRAPLOG | Log of Calculation of Complementary Budget Amounts | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| TOPService Charge Settlement |
| 22 | VISCACCRUAL | Accrual/Deferral | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 23 | VISCCOSTDIST | Cost Distribution | 8 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 24 | VISCCRSPLIT | Split Receivable | 5 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 25 | VISCDTAPE | Data of D-Tape | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 26 | VISCITADJUST | Input tax adjustment | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 27 | VISCMAPPROCSCS | Mapping Process to Settlement Hierarchy | 4 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 28 | VISCRECEIVABLE | Receivables from Settlement | 9 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 29 | VISCSCOSTS | Determined Costs | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 30 | VISCSETTL | Settlement Identification with Log Reference | 2 | SETTL_GUID | Generic Key of Process | varbinary | 16 | 0 | | |
| 31 | VISCSMEAS | Measurement Amount Used | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 32 | VISCS_DOCS | Costs Directly Assigned to Lease-Out | 2 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 33 | VISCS_MSU_REST | Distribution of Master SU to Remaining Objects | 4 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 34 | VISCS_MSU_SU | Distribution of Master SU to Participating SUs | 4 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 35 | VISCS_RENT | Rental period | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 36 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 11 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 37 | VISCS_SU_RO | Sum of All Costs and Measurement Amounts for a Rental Object | 11 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
| 38 | VISCS_SU_SUM | Sum of All Costs and Measurement Amounts for Settlment Unit | 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | |
