| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CPED_EXTENSION | CPE Extension Data | 4 | TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | | |
2 | REFXCN_SMAP | Mapping of Store and Contract | 4 | TERMNO | Reporting Rule Number | nvarchar | 4 | 0 | | |
3 | VIYCCAP | Capping Parameters | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
4 | VIYCMAJTENANT | Major Tenant Parameters | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
5 | VIYCMARK | Mark-up Parameters | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
6 | VIYCPROV | Provision Parameters | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
7 | VIYCRHYTHM | CAM Expense Recovery Frequency Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPCommodity Pricing Engine |
8 | CPEC_TERMGRP | CPE Term - Grouping of Terms | 5 | TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | | |
9 | CPED_DEFTERMGRP | CPE Term - Default for Grouping and General Data in Docume | 3 | TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | | |
10 | CPED_TERMGRPOUT | CPE Term - Changed Grouping and General Term Result | 3 | TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | | |
11 | CPED_TERMOUT | CPE Term - General Result | 4 | TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | | |
TOPFlexible Real Estate Management |
12 | VIXCAJOBJCH01 | Contract/Rental Object: Adjustment Term Data CH01 | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
13 | VIXCAJSPECH01 | Contract/Rental Object: Adjustment Rule CH01 | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPFunds Management |
14 | FMFG_RE_PMT_EXT | RECN Condition:Payment Term Extension | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
15 | RECN_OA_SPLIT | RECN: Group Number of Organizazional Assignment Split | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPLocalization |
16 | VIXCPTRACONTRACT | The table will store the years for the rent adjustment at t | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
17 | TFMCA_PT_TAXCOND | Customizing for Tax Conditions (Property Tax) | 9 | TERMNO | Number of Frequency Term | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
18 | TIVTMXTERMDEF | Proposed Term Name | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
19 | TIVTMXTERMDEFT | Proposed Term Name (Text) | 5 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
20 | VITMNT | Notice Term | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
21 | VITMNTPROCREL | Individual Notice Procedure | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
22 | VITMNTRULEDR | Individual Deadline Regulation | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
23 | VITMNTRULEPR | Individual Period Regulation | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
24 | VITMOBJREL | Object Assignment | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
25 | VITMRN | Renewal Term | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
26 | VITMRNRULEPR | Individual Renewal Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
27 | VITMTERM | Term | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPRent Adjustment |
28 | VIAJNEXTADJM | Date of Next Adjustment to Condition | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
29 | VIAJOBJCOMP | Contract/Rental Object: COMP | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
30 | VIAJOBJINDX | Contract/Rental Object: INDX | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
31 | VIAJRECORD | Adjustment record | 5 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
32 | VIAJRULE | Contract/Rental Object: Adjustment Rule | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
33 | VIAJSPECINDX | Contract/Rental Object: Adjustment Method INDX | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
34 | VIAJTERM | Contract/Rental Object: Adjustment Term | 3 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPRental Accounting |
35 | VIEXFIWTITEM | Term: Withholding Tax Item | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
36 | VIRAADVPAY | OBSOLETE: Advance Payment | 24 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
37 | VIRAADVPAYPROC | Advance Payments per Settlement | 18 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
38 | VITMOA | Term: Organizational Assignment | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
39 | VITMPY | Term: Posting Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
40 | VITMPYSPLIT | Term: Split for Posting Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
41 | VITMRH | Terms: Frequency Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
42 | VITMWT | Term: Withholding Tax | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPSales-Based Rent and Settlement |
43 | VISRCALCSALES | Reference to Sales Report Used | 4 | TERMNO | Term Number of Reporting Rule | nvarchar | 4 | 0 | | |
44 | VISRCALCSUM | Calculation Results per Sales Rule | 5 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
45 | VISRREPORT | Sales Report | 3 | TERMNO | Term Number of Reporting Rule | nvarchar | 4 | 0 | | |
46 | VISRSETTL | Settlement Identification with Log Reference | 9 | TERMNO | Term Number of Reporting Rule | nvarchar | 4 | 0 | | |
47 | VISRSTATUS | Status per Contract and Sales Rule (Dependent on Version) | 5 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
48 | VISRTMRP | Reporting Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
49 | VISRTMRPHDR | Header Data of Reporting Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
50 | VISRTMSB | Sales Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
51 | VISRTMSBHDR | Header Data of Sales Rule | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
52 | VISCSUSE | Settings per Settlement Purpose | 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | |