| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCommodity Pricing Engine |
| 1 | CPED_PERIODDTOUT | CPE Term - Result Data of Period Determination | 10 | BASEDATE | CPE Term - Calculated Base Date and Time | nvarchar | 14 | 0 | | |
| TOPDB2 Universal Database for UNIX NT |
| 2 | DB6PMHT | DB6: Detail Record of Table and Index Space Statistics | 5 | BASEDATE | | nvarchar | 8 | 0 | | |
| 3 | DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics | 5 | BASEDATE | | nvarchar | 8 | 0 | | |
| 4 | DB6PMHXT | DB6: Detail Record of Tablespace and DB Table/Index Stats | 4 | BASEDATE | | nvarchar | 8 | 0 | | |
| 5 | DB6PM_TIME | DB6: Protocol Record of Statistical Data Collection | 4 | BASEDATE | | nvarchar | 8 | 0 | | |
| TOPFlexible Real Estate Management |
| 6 | TIVCACTBASEDATE | Translation Base Date | 1 | BASEDATE | Translation Base Date | nvarchar | 10 | 0 | | |
| 7 | TIVCACTBASEDATET | Translation Base Date (Text) | 2 | BASEDATE | Translation Base Date | nvarchar | 10 | 0 | | |
| 8 | TIVCACTDATERPROC | Settings for Translation Date Rule | 5 | BASEDATE | Translation Base Date | nvarchar | 10 | 0 | | |
| 9 | TIVCACTPROCBASE | Allowed Translation Base Dates | 2 | BASEDATE | Translation Base Date | nvarchar | 10 | 0 | | |
| TOPService Charge Settlement |
| 10 | VISCCNPART | Settlement Participation for Service Charge Settlement | 16 | BASEDATE | Date of Base Year Settlement | nvarchar | 8 | 0 | | |
| 11 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 37 | BASEDATE | Date of Base Year Settlement | nvarchar | 8 | 0 | | |
