| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFlexible Real Estate Management |
| 1 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 40 | VVABBLN | Identifikation Abrechnung -> Referenzbelegnr Buchhaltung | nvarchar | 16 | 0 | | |
| 2 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 25 | VVABBLN | Identifikation Abrechnung -> Referenzbelegnr Buchhaltung | nvarchar | 16 | 0 | | |
| 3 | VIAKHOBD | DTA externe HKA D-Band Übernahme | 21 | VVABBLN | Identifikation Abrechnung -> Referenzbelegnr Buchhaltung | nvarchar | 16 | 0 | | |
| 4 | VIAKHODD | DTA externe HKA D-Band Diskette Übernahme | 21 | VVABBLN | Identifikation Abrechnung -> Referenzbelegnr Buchhaltung | nvarchar | 16 | 0 | | |
| 5 | VIAKHOPO | WEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen | 20 | VVABBLN | Identifikation Abrechnung -> Referenzbelegnr Buchhaltung | nvarchar | 16 | 0 | | |
| TOPReal Estate Management |
| 6 | IVBP | Line Item (Settlement: Service Charge Collector) (Obsolete) | 28 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 7 | VIAK01 | History of acct settlement runs | 15 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 8 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 39 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 9 | VIAK14 | RA credit memo/receivable:now only used as structure! | 24 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 10 | VIAK16 | SCS: Identification Of Settlement With Log Reference | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 11 | VIAK17 | Interface for settlement / transfer of advance payments | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 12 | VIAK18 | Management fee surcharge for service charges settlement | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 13 | VIAK19 | Costs Directly Assigned to Lease-Out | 18 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 14 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 24 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 15 | VIAK25 | Cost collector for SU (per settlement period) | 17 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 16 | VIAKBKPF | Document Header from Service Charge Settlement for Interface | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 17 | VIAKBSEG | Document Line Item from SCS for Interface | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 18 | VIAKUV | Sales settlement histories | 12 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 19 | VIEA03 | Administration information: Objects of owner settlement | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 20 | VIEA05 | Owner acct settlement: Settlement identification | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 21 | VIEA06 | Management information: Owner for owner settlement | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 22 | VIMI17 | RE: Adjustment Run Header | 43 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 23 | VIMI28 | Sales settlement histories | 13 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
| 24 | VIVW10 | Interface prop.man.settlement/transfer advance payments | 2 | VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | nvarchar | 16 | 0 | | |
