| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 52 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 52 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
3 | YVIM_1ITEM | Document Item | 52 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
4 | /OPT/VIM_1ITEM | Document Item | 52 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
5 | KMZEI | FI: Account Assignment Model Item Information | 84 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
6 | KOMU | Account Assignment Templates for G/L Account Items | 84 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
7 | TIVHOSUPR | Einmalige Buchungen: Vorschlag Nebenkostenschlüssel | 3 | SNKSL | Nebenkostenschlüssel | nvarchar | 4 | 0 | | |
8 | TIVSCSCKATTR | OBSOLETE: Service Charge Key Attributes | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
9 | TIVXCFCSCKEYPROP | Service Charge Key: Properties for Fuel Management | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
10 | TIVXCOTPARAM | Parameter for VAT on Expense for Service Charge Key | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
11 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 9 | SNKSL | Nebenkostenschlüssel | nvarchar | 4 | 0 | | |
12 | VIAKHO21 | Mandatsverwaltung: Gesplittete Abrechnungsgrößen | 4 | SNKSL | Nebenkostenschlüssel | nvarchar | 4 | 0 | | |
13 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 15 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
14 | VIXCSCCHTAPE | Header Data for External Heating Expenses Settlement | 8 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
15 | VIXCSCCHTPSHAR | Distribution for External Heating Expenses Settlement | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPLocalization |
16 | TIVXCJPFLWTYP | Flow Type Defined for Service Charge Keys | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
17 | VIXCJPFXDUNPRICE | Fixed Unit Prices for Service Charge Settlement | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPMigration |
18 | TIVMISETMEAS | Conversion of Area Type and Apportionment Unit to Meas.Type | 27 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
19 | TIVMISETSCKEY | Mapping of Service Charge Keys | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
20 | KE1_WU_IM_ITEM | PCA Where-Used List: Itemization for Real Estate | 19 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
21 | IVBP | Line Item (Settlement: Service Charge Collector) (Obsolete) | 17 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
22 | ONRIA | Calculation unit object number index | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
23 | TIK01 | Condition types additional data for DARWIN Real Estate | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
24 | TIV05 | Definition of Service Charge Keys | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
25 | TIV06 | Service Charge Key Attributes for each Tenancy Law | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
26 | TIV52 | Key conversion accountancy firm <-> partner cost elements | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
27 | TIV54 | Fuel type + incidental expenses key as well (internal) | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
28 | TIV67 | Flow Types for Service Charge Key | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
29 | TIV68 | Flow types/SCKey for vacancy with tenant serv. charge sett. | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
30 | TIVN1 | Defaults for Settlement Participation of Service Charge Key | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
31 | TIVT5 | Incidental expenses key text | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
32 | VIAK01 | History of acct settlement runs | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
33 | VIAK02 | Settlement Participation for Service Charge Settlement | 6 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
34 | VIAK03 | Settlement Unit Master Record | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
35 | VIAK04 | Allocation of Settlement Variants to Settlement Unit | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
36 | VIAK05 | Allocation of rental units to calculation unit | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
37 | VIAK06 | Calculation unit relations | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
38 | VIAK07 | Calculation unit option rate | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
39 | VIAK08 | DME Settlement Units Master Data | 25 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
40 | VIAK09 | Assignment of Heating Systems to Calculation Units | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
41 | VIAK14 | RA credit memo/receivable:now only used as structure! | 9 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
42 | VIAK19 | Costs Directly Assigned to Lease-Out | 13 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
43 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 9 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
44 | VIAK21 | Split settlement factors for settlement variant | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
45 | VIAK22 | Heat.oil supply | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
46 | VIAK22T | Heat.oil supply texts | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
47 | VIAK25 | Cost collector for SU (per settlement period) | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
48 | VIAK26 | Master Settlement Unit: Participating Settlement Units | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
49 | VIAKBSEG | Document Line Item from SCS for Interface | 102 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
50 | VIAKT5 | Rental units allocation ID | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
51 | VIAROBJ | Archived real estate objects | 17 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
52 | VICNSCS | Real Estate Contract: Service Charge Key | 4 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
53 | VICNSCSPP | Real Estate Contract: Liability Reserves | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
54 | VICNSCSRP | Real Estate Contract: Service Charge Settlement Item | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
55 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 11 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
56 | TIVSCAJSCKATTR | Attributes of Adjustment of SCS Advance Pmnt per SC Key | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
57 | TIVSCCONDSCK | Assignment of Condition Type to Service Charge Key | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
58 | TIVSCDEFCOND | Assignment of Service Charge Key to Condition Type | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
59 | TIVSCSCK2ACCPROP | Assignment of SC Key to Account Property | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
60 | TIVSCSCKEY | Service Charge Keys | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
61 | TIVSCSCKEYSE | Settings per Settlement Purpose | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
62 | TIVSCSCKEYT | Service Charge Key (Text) | 3 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
63 | TIVSCSUDEFAULT | Defaults for Creating SU per SC Key | 2 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |
64 | VISCSU | Settlement unit | 5 | SNKSL | Service Charge Key | nvarchar | 4 | 0 | | |