| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /CFMFND/REW_CDM | Default Measurement Types | 2 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 2 | VIXCITCADRO | Temporary rental object data | 74 | USAGETYPE | Code of Usage Type | nvarchar | 4 | 0 | | |
| TOPBasic Data |
| 3 | TIVBDMEASCALC | Derivable Measurement Type | 4 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 4 | TIVBDUSGROTYPE | Allowed Usage Type per Rental Object Type | 3 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 5 | TIVBDUSTYREL | Allowed Usage Types per Usage Group | 2 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 6 | VIBDPLANOCC | Planned Occupancy of Usage Objects | 13 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 7 | VIBDPLANPS | Plan Pooled Spaces | 8 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 8 | VIBDRO | Rental Object | 73 | USAGETYPE | Code of Usage Type | nvarchar | 4 | 0 | | |
| 9 | VIBDROOCC | Occupancy History | 13 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPCustomer Interaction Center |
| 10 | EWOPSCOND | OPS: Conditions | 8 | USAGETYPE | OPS: Usage Type | nvarchar | 2 | 0 | | |
| 11 | EWOPSCONF | OPS: Configuration | 8 | USAGETYPE | OPS: Usage Type | nvarchar | 2 | 0 | | |
| 12 | EWOPSLDCONST | OPS: Language-Dependent Constants | 9 | USAGETYPE | OPS: Usage Type | nvarchar | 2 | 0 | | |
| TOPDFPS Authorized Infrastructure |
| 13 | /ISDFPS/CREIPNM | Mapping Usage View Usage Type to IPO Function | 3 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 14 | JKSDUSERGROUP | Assignment of Users to User Groups | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 15 | JKSDVIEWUSRGRP | Assignment of Quantity Planning Views to User Groups | 4 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 16 | TJKSDPLANORG | Planning Organization for Quantity Planning | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 17 | TJKSDPLANORGPLT | Assignment of Plants to Planning Organization | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 18 | TJKSDPLANORGT | Planning Organization for Quantity Planning - Texts | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 19 | TJKSDSFDETRULE | Stock Interpretation Rule | 3 | USAGETYPE | Usage of Rule | nvarchar | 1 | 0 | | |
| 20 | TJKSDUPDATERULE | Update Rule for Structure for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 21 | TJKSDUPDATERULET | Text - Update Rules for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 22 | TJKSDUPDMETHOD | Calculation Method for Update Rule in Quantity Planning | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 23 | TJKSDUPDMETHODT | Text - Calculation Method in Quantity Planning | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 24 | TJKSDUPDMETHSRCE | Source Fields for Calculation Method in Quantity Planning | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 25 | TJKSDUPDRULEMETH | Calculation Methods for Update Rule | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 26 | TJKSDUSRGRP | User Group for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 27 | TJKSDUSRGRPT | Text - User Group for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 28 | TJKSDVIEW | Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 29 | TJKSDVIEWEXFUNC | Assignment of Calculation Methods to Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 30 | TJKSDVIEWFIGURE | Quantity Planning View: Display Options for Quantity Fields | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 31 | TJKSDVIEWFLDLABL | Alternative Field Names for Quantity Planning View Field | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 32 | TJKSDVIEWFUNC | Calculation Method for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 33 | TJKSDVIEWFUNCT | Text - Calculation Method for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 34 | TJKSDVIEWT | Text for Quantity Planning View | 3 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 35 | TJKSDVIEWTA | Assignment of Quantity Planning Views to Applications | 4 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| 36 | TJKSDVIEWTCODE | Allowed Transactions for Quantity Planning Views | 4 | USAGETYPE | Use (Sales/Purchase Order Quantity Planning) | nvarchar | 1 | 0 | | |
| TOPMigration |
| 37 | TIVMISET | Basic Settings for Migration | 24 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPOffer and Rental Request |
| 38 | TIVOROOUPDATE | Control Data Update Offered Object | 3 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 39 | TIVORRRTYPEMTC | Usage Types for RE Search Request Type | 4 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| 40 | VIOROO | Offered Object | 20 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPRetention Warehouse |
| 41 | IWP_WP | Audit Packages | 7 | USAGETYPE | Audit Package Used For | nvarchar | 1 | 0 | | |
| 42 | IWP_WPP | Audit Package Template | 8 | USAGETYPE | Audit Package Used For | nvarchar | 1 | 0 | | |
| TOPRoom Reservations and Seating Arrangements |
| 43 | TIVORRSOBJBO | Derivation of Reservation Object Type from Business Object | 4 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPService Charge Settlement |
| 44 | TIVSCCHRGRO | Calculation of Surcharges Dependent on Rental Object | 3 | USAGETYPE | Usage Type of Rental Object | nvarchar | 4 | 0 | | |
| TOPUser Interface Framework |
| 45 | TPTGCLYT | GUI Layout (Enhancement Layer) | 4 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
| 46 | TPTGSLYT | GUI Layout | 3 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
| 47 | TPTLYTUTY | Layout Usage Type | 2 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
| 48 | TPTLYTUTYT | Layout Usage Type | 2 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
| 49 | TPTUCLYT | UIA Layout (Enhancement Layer) | 4 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
| 50 | TPTUSLYT | UIA Layout | 3 | USAGETYPE | Layout Usage Type | nvarchar | 10 | 0 | | |
