| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPReal Estate |
| 1 | CMS_RE_OBJ | Real estate header details | 32 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 2 | CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here | 15 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 3 | CMS_RE_OBJ_DOC | Link between Real estate objects and Doc is stored here | 12 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 4 | CMS_RE_OBJ_PRT | Real Estate Object part details | 111 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 5 | CMS_RE_OBJ_RL | Real Estate Object role details | 12 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 6 | CMS_RE_OBJ_SPC | Space Details to describe a real estate object | 27 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 7 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 36 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 8 | CMS_RE_PRT_BP | Real Estate Part BP details | 18 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 9 | CMS_RE_PRT_CST | Real Estate Part Cost details | 26 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 10 | CMS_RE_PRT_DOC | Real Estate Document details | 18 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 11 | CMS_RE_PRT_LR | Real Estate Part LR details | 13 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
| 12 | CMS_RE_PRT_VAL | Real Estate Part value details | 21 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | |
