| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 40 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 40 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
3 | YVIM_1ITEM | Document Item | 40 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
TOPElectronic Bank Statement |
4 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 80 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
5 | FEB_ACT | Acct Assignment Templates | 80 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
TOPFinancial Accounting |
6 | /OPT/VIM_1ITEM | Document Item | 40 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
7 | KMZEI | FI: Account Assignment Model Item Information | 86 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
8 | KOMU | Account Assignment Templates for G/L Account Items | 86 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
TOPFlexible Real Estate Management |
9 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 13 | SMIVE | Vertragsnummer Immobilien | nvarchar | 13 | 0 | | |
10 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 3 | SMIVE | Vertragsnummer eines Hausgeldvertrages | nvarchar | 13 | 0 | | |
TOPGL Account Posting |
11 | TCJ_POSITIONS | Cash Journal Document Items | 87 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
TOPMigration |
12 | VIGWMI08 | CRE: Umlegungseinheiten pro Mietfläche | 5 | SMIVE | Vuokrasopimuksen numero | nvarchar | 13 | 0 | | |
TOPReal Estate Management |
13 | ONRIV | Rental agreement item object number index | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
14 | S401 | RE standard analysis partner | 18 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
15 | S407 | Rental agreements | 122 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
16 | VIAK02 | Settlement Participation for Service Charge Settlement | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
17 | VIAK11 | Inclusion of acct settlement results from D-tape | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
18 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 12 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
19 | VIAK14 | RA credit memo/receivable:now only used as structure! | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
20 | VIAK17 | Interface for settlement / transfer of advance payments | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
21 | VIAK18 | Management fee surcharge for service charges settlement | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
22 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
23 | VIARMV | Key for archived lease-outs | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
24 | VIAROBJ | Archived real estate objects | 14 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
25 | VIBEPP | Flow data - Planned items for real estate management | 8 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
26 | VILIR | IRE Historical data | 6 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
27 | VILIS | IRE Office data | 9 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
28 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
29 | VIMI07 | Reported Sales for Sales-Based Lease-Out | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
30 | VIMI09 | Graded Lease-Out | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
31 | VIMI10 | Rental agreement additional text | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
32 | VIMI14 | RA: Adjustment block for terms types | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
33 | VIMI16 | RE: Records of a Rent Adjustment Run | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
34 | VIMI18 | Rent Adjustment History for Lease-Out | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
35 | VIMI23 | Determination of Year and Percent for Sls-Bsd LO | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
36 | VIMI24 | Percentage for Sales for Sales-Based Lease-Out | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
37 | VIMI25 | Sales reports | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
38 | VIMI26 | Notice of rental agreement | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
39 | VIMI28 | Sales settlement histories | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
40 | VIMI32 | Other collateral | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
41 | VIMI39 | Tenant change; data for apartment inspection | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
42 | VIMI40 | Tenant change: Data on release of rental deposits | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
43 | VIMI47 | Tenant change: Alloc.of maint.orders to sec.deposit release | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
44 | VIMIEV | Supplementary lease-outs | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
45 | VIMIMV | Lease-Out | 4 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
46 | VIMIRD | Log for Real Estate invoice print | 3 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
47 | VIMITH | Rental agreement number and doc.number for printing invoices | 5 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
48 | VIRPS407 | Rental agreements | 122 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |
49 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 9 | SMIVE | Lease-Out Number | nvarchar | 13 | 0 | | |