| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 48 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 48 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
3 | REFXCN_GLMAP | Mapping of General Ledger | 3 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
4 | VIXCITIRE2MIGR | IRE2 Migrated Data (also log) | 4 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
5 | VIYCCOST2DC | Application of Distribution / Denominator Method | 6 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
6 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 6 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
7 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 5 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
8 | YVIM_1ITEM | Document Item | 48 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
TOPBasic Data |
9 | VIBDPLANOCC | Planned Occupancy of Usage Objects | 4 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
TOPBasic Functions |
10 | FDRE | Cash Management Line Items from RE-FX (Real Estate) | 17 | RECNNR | Number of Real Estate Contract (RE-FX) | nvarchar | 13 | 0 | | |
TOPFinancial Accounting |
11 | /OPT/VIM_1ITEM | Document Item | 48 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
12 | KMZEI | FI: Account Assignment Model Item Information | 89 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
13 | KOMU | Account Assignment Templates for G/L Account Items | 89 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
TOPFlexible Real Estate Management |
14 | VIAKHOPO | WEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen | 11 | RECNNR | Vertragsnummer Immobilien | nvarchar | 13 | 0 | | |
15 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 8 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
TOPLocalization |
16 | VIXCCORRVIIR | Invoice Item Reference for Corr/Rev Invoices | 23 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
TOPOffer and Rental Request |
17 | VIOROF | Contract Offer | 23 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
TOPProfit Center Accounting |
18 | KE1_WU_IM_ITEM | PCA Where-Used List: Itemization for Real Estate | 17 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
19 | TRM_PT_LEANHIS | BRFPlus trace reference | 6 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
TOPReal Estate Contract |
20 | VICNCN | Real Estate Contract | 4 | RECNNR | Contract Number | nvarchar | 13 | 0 | | |
TOPReal Estate Management |
21 | VIBEPP | Flow data - Planned items for real estate management | 79 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
22 | VICN01 | Real Estate Contract: Contract Data | 5 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |
23 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 15 | RECNNR | Real Estate Contract Number | nvarchar | 13 | 0 | | |