| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPReal Estate |
| 1 | CMS_RE_OBJ | Real estate header details | 28 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 2 | CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here | 11 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 3 | CMS_RE_OBJ_DOC | Link between Real estate objects and Doc is stored here | 8 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 4 | CMS_RE_OBJ_PRT | Real Estate Object part details | 107 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 5 | CMS_RE_OBJ_RL | Real Estate Object role details | 8 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 6 | CMS_RE_OBJ_SPC | Space Details to describe a real estate object | 23 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 7 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 32 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 8 | CMS_RE_PRT_BP | Real Estate Part BP details | 14 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 9 | CMS_RE_PRT_CST | Real Estate Part Cost details | 22 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 10 | CMS_RE_PRT_DOC | Real Estate Document details | 14 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 11 | CMS_RE_PRT_LR | Real Estate Part LR details | 9 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
| 12 | CMS_RE_PRT_VAL | Real Estate Part value details | 17 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | |
