| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 5 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
2 | VIYCCNPOOL | CAM Pool in CAM Recovery | 4 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
3 | VIYCCOST2DC | Application of Distribution / Denominator Method | 5 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
4 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 5 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
5 | VIYCCOST2MTC | Major Tenant deduction for lease in CAM recovery | 5 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
6 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 4 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
7 | VIYCRECEIVABLE | Receivables from Settlement | 5 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
8 | VIYCREFFACTOR | Reference Factors | 10 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
9 | VIYCSTLMTRCOST | Settled Meter Costs with lease | 11 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
TOPLand Use Management |
10 | VILMEMCN | Rights and Easements - Real Estate Contracts | 7 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
TOPLocalization |
11 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 5 | CNOBJNR | Object Number of Real Estate Contract (REC) | nvarchar | 22 | 0 | | |
TOPService Charge Settlement |
12 | VISCAJRO | Adjustment Record SCSE per Rental Object | 6 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
13 | VISCAJROSU | Adjustment Record SCSE per RO and SU | 14 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | |
14 | VISCCOSTSEXT | Costs per Object - Legacy Data Transfer | 5 | CNOBJNR | Object Number of Real Estate Contract (REC) | nvarchar | 22 | 0 | | |