| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 109 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
2 | VIYCRECEIVABLE | Receivables from Settlement | 37 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPFlexible Real Estate Management |
3 | TIVCACTCNTYPE | Contract-Type-Dependent Settings for Diff. Condition Crcy | 3 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
4 | TIVCACTRULE | Currency Translation Rule | 2 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
5 | TIVCACTRULET | Currency Translation Rule (Text) | 3 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
6 | TIVCACTUSTYPE | Usage-Type-Dependent Settings for Differing Condition Crcy | 3 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPReal Estate Contract |
7 | VICDCFOBJ | Object-Related Cash Flow | 99 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
8 | VICDCFPAY | Payment-Related Cash Flow | 105 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPRent Adjustment |
9 | TIVAJRULE | Adjustment Rules | 49 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
10 | VIAJRULE | Contract/Rental Object: Adjustment Rule | 54 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPRental Accounting |
11 | VIRAADVPAY | OBSOLETE: Advance Payment | 31 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
12 | VIRAADVPAYPROC | Advance Payments per Settlement | 30 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
13 | VIRAADVPAYSPLIT | Split Advance Payments | 38 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
14 | VIRADOC | RE Document Header | 29 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
15 | VIRADOCITEM | RE Document Item | 59 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
16 | VIRAINVITEM | RE Invoice Item | 45 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
17 | VITMPY | Term: Posting Rule | 26 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPSales-Based Rent and Settlement |
18 | VISRCALCCTFC | Amounts in Foreign Currency | 5 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
19 | VISRCALCSUM | Calculation Results per Sales Rule | 53 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
20 | VISRCRSPLIT | Split Receivable | 20 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
21 | VISRMODIRESULT | Changed Sales-Based Settlement Results | 18 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
22 | VISRMOSPLIT | Split Receivable | 20 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
TOPService Charge Settlement |
23 | VISCCRSPLIT | Split Receivable | 29 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |
24 | VISCRECEIVABLE | Receivables from Settlement | 47 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | | |