| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFlexible Real Estate Management |
1 | VICAPROCESSID | Process | 2 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
2 | VICASTEPSTATUS | Status of Process Step | 2 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
3 | VIITTCCALC | Input Tax Correction: Header Information | 7 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
4 | VIXCAJRECCH01 | Adjustment Record CH01 | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPInput Tax Treatment |
5 | VIITTAXDSITEM | Distributed Tax Document Item (VIITTAXDSITEM) | 14 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPLocalization |
6 | VIXCAJTHREADS | Adjustment: processing threads | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
7 | VIXCFRPROCID | Localized Process | 2 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
8 | VIXCFRSRULOG | Log of SRU Postings | 6 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPRent Adjustment |
9 | VIAJRECCOMP | Adjustment Record COMP | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
10 | VIAJRECCOMPOBJ | Adjustment Record COMPOBJ | 4 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
11 | VIAJRECFREE | Adjustment Record FREE | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
12 | VIAJRECINDX | Adjustment Record INDX | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
13 | VIAJRECORD | Adjustment record | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
14 | VIAJRECRLRA | Adjustment Record RLRA | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
15 | VIAJRECRLRAFF | Adjustment Record RLRAFF | 4 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
16 | VIAJRECRLRAVAR | Adjustment Record RLRAVAR | 4 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
17 | VIAJRECTASK | Adjustment Record TASK | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
18 | VIAJRECTASKOBJ | Adjustment Record TASKOBJ | 4 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPRental Accounting |
19 | VIRAACRITEM | Accrual Item | 7 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
20 | VIRAADVPAY | OBSOLETE: Advance Payment | 8 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
21 | VIRAADVPAYPROC | Advance Payments per Settlement | 8 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
22 | VIRADOC | RE Document Header | 5 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
23 | VIRADOCITEM | RE Document Item | 9 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
24 | VIRAINV | RE Invoice Header | 6 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPRoom Reservations and Seating Arrangements |
25 | VIORRSCOST | Reservation - Costs | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPSales-Based Rent and Settlement |
26 | VISRCALCCTFC | Amounts in Foreign Currency | 11 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
27 | VISRCALCREFCF | Link Between Sales-Based Settlement and Cash Flow | 5 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
28 | VISRCALCSUM | Calculation Results per Sales Rule | 10 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
29 | VISRCRSPLIT | Split Receivable | 5 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
30 | VISRMODIRESULT | Changed Sales-Based Settlement Results | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
31 | VISRMOSPLIT | Split Receivable | 5 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
32 | VISRSETTL | Settlement Identification with Log Reference | 2 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
33 | VISRSTATUS | Status per Contract and Sales Rule (Dependent on Version) | 10 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
TOPService Charge Settlement |
34 | VISCACCRUAL | Accrual/Deferral | 8 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
35 | VISCAJRO | Adjustment Record SCSE per Rental Object | 5 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
36 | VISCMAPPROCSCS | Mapping Process to Settlement Hierarchy | 3 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |
37 | VISCS_SU_SUM | Sum of All Costs and Measurement Amounts for Settlment Unit | 47 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | |