| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | DFKKBPLOCKH | FI-CA: Business Partner Locks - History | 3 | VAL_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
| 2 | MEV_D_AD_ITEM | Period-End Valuation: Accruals Document Item | 9 | VAL_DATE | Valuation Key Date for Worklist | nvarchar | 8 | 0 | | |
| 3 | MEV_D_WL_ITEM | Period-end valuation: Worklist item | 11 | VAL_DATE | Valuation Key Date for Worklist | nvarchar | 8 | 0 | | |
| TOPBasic Functions |
| 4 | LFSSTN_CERT | Vendor sustainability certificates | 4 | VAL_DATE | Validity End Date | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 5 | CMS_OMS_VAL_LNK | Value Link | 11 | VAL_DATE | Date of First Valuation | nvarchar | 8 | 0 | | |
| TOPMulti Currency Accounting |
| 6 | GLE_MCA_RV_HSTRY | FX Revaluation History | 18 | VAL_DATE | Valuation Key Date | nvarchar | 8 | 0 | | |
| TOPReal Estate |
| 7 | CMS_RE_PRT_VAL | Real Estate Part value details | 12 | VAL_DATE | Date on which Real Estate Valuation was Performed | nvarchar | 8 | 0 | | |
| TOPSecurities |
| 8 | CMS_SEC_ACC | Securities account details | 9 | VAL_DATE | Date of last valuation | nvarchar | 8 | 0 | | |
| TOPTransaction Data Pool |
| 9 | JBDVTTO | Variable Transaction - Turnovers | 7 | VAL_DATE | Value Date for Turnover | nvarchar | 8 | 0 | | |
| TOPTransaction Manager |
| 10 | THAHRT_EFF_HEAD | Effectiveness test result header | 8 | VAL_DATE | Date of calculation | nvarchar | 8 | 0 | | |
| 11 | THAHRT_EXT_RETRO | External Retrospective Assessment | 6 | VAL_DATE | Valuation date of the hedging relationship | nvarchar | 8 | 0 | | |
| 12 | THMHRT_EXT_PROS | External Prospective Assessment | 6 | VAL_DATE | Valuation date of the hedging relationship | nvarchar | 8 | 0 | | |
| 13 | THMHRT_HR_VAL | Valuation details for the hedging relationship | 6 | VAL_DATE | Valuation date of the hedging relationship | nvarchar | 8 | 0 | | |
| 14 | TPMHRT_EXT_RETRO | External Retrospective Assessment | 6 | VAL_DATE | Valuation date of the hedging relationship | nvarchar | 8 | 0 | | |
