| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ARBERP_D_STIVSEL | Last run data of Invoice selection report | 4 | LAST_CHG_DATE | Last changed date | nvarchar | 8 | 0 | | |
2 | CMS_BLK_PACK_ITM | Package Parameter Item for Blocking report | 12 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
TOPMonitoring |
3 | ALDTSCTRL | Control Table for CCMS Evaluated Data Service | 8 | LAST_CHG_DATE | System Date | nvarchar | 8 | 0 | | |
TOPReal Estate |
4 | CMS_RE_OBJ | Real estate header details | 30 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
5 | CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here | 13 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
6 | CMS_RE_OBJ_DOC | Link between Real estate objects and Doc is stored here | 10 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
7 | CMS_RE_OBJ_PRT | Real Estate Object part details | 109 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
8 | CMS_RE_OBJ_RL | Real Estate Object role details | 10 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
9 | CMS_RE_OBJ_SPC | Space Details to describe a real estate object | 25 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
10 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 34 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
11 | CMS_RE_PRT_BP | Real Estate Part BP details | 16 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
12 | CMS_RE_PRT_CST | Real Estate Part Cost details | 24 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
13 | CMS_RE_PRT_DOC | Real Estate Document details | 16 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
14 | CMS_RE_PRT_LR | Real Estate Part LR details | 11 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
15 | CMS_RE_PRT_VAL | Real Estate Part value details | 19 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
TOPSecurities |
16 | CMS_SEC_ACC | Securities account details | 37 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | |
17 | CMS_SEC_ACC_BP | Link between securities account and BuPa is stored here | 14 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | |
18 | CMS_SEC_ACC_DOC | Link between securities account and Documents is stored here | 14 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | |
19 | CMS_SEC_ACC_POS | Securities position details | 34 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | |