| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCCAP | Capping Parameters | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
2 | VIYCMAJTENANT | Major Tenant Parameters | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
3 | VIYCMARK | Mark-up Parameters | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
4 | VIYCPROV | Provision Parameters | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
5 | VIYCRHYTHM | CAM Expense Recovery Frequency Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPCommodity Pricing Engine |
6 | CPEC_TERM | CPE Term | 6 | TERMTYPE | CPE Term - Term Calculation Type | nvarchar | 7 | 0 | | |
7 | CPEC_TERMTYPEFLD | CPE - Field Control Dependent on Term Type | 4 | TERMTYPE | CPE Term - Term Calculation Type | nvarchar | 7 | 0 | | |
8 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 3 | TERMTYPE | CPE Term - Term Calculation Type | nvarchar | 7 | 0 | | |
TOPFunds Management |
9 | FMFG_RE_PMT_EXT | RECN Condition:Payment Term Extension | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
10 | RECN_OA_SPLIT | RECN: Group Number of Organizazional Assignment Split | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPLocalization |
11 | VIXCPTRACONTRACT | The table will store the years for the rent adjustment at t | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
12 | TIVTMTERMTYPE | Term Category | 2 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
13 | TIVTMTERMTYPET | Clause Types (Text) | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
14 | TIVTMXTERMDEF | Proposed Term Name | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
15 | TIVTMXTERMDEFT | Proposed Term Name (Text) | 4 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
16 | VITMNT | Notice Term | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
17 | VITMNTPROCREL | Individual Notice Procedure | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
18 | VITMNTRULEDR | Individual Deadline Regulation | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
19 | VITMNTRULEPR | Individual Period Regulation | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
20 | VITMOBJREL | Object Assignment | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
21 | VITMRN | Renewal Term | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
22 | VITMRNRULEPR | Individual Renewal Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
23 | VITMTERM | Term | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPRental Accounting |
24 | VIEXFIWTITEM | Term: Withholding Tax Item | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
25 | VIRAADVPAY | OBSOLETE: Advance Payment | 23 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
26 | VIRAADVPAYPROC | Advance Payments per Settlement | 17 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
27 | VITMOA | Term: Organizational Assignment | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
28 | VITMPY | Term: Posting Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
29 | VITMPYSPLIT | Term: Split for Posting Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
30 | VITMRH | Terms: Frequency Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
31 | VITMWT | Term: Withholding Tax | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPSales-Based Rent and Settlement |
32 | TIVSRRHT | Type of Frequency | 1 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
33 | TIVSRRHTT | Type of Frequency (Text) | 2 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
34 | VISRCALCSUM | Calculation Results per Sales Rule | 4 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
35 | VISRSTATUS | Status per Contract and Sales Rule (Dependent on Version) | 4 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
36 | VISRTMRP | Reporting Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
37 | VISRTMRPHDR | Header Data of Reporting Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
38 | VISRTMSB | Sales Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
39 | VISRTMSBHDR | Header Data of Sales Rule | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
40 | VISCSUSE | Settings per Settlement Purpose | 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | |