| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IWBEP/I_SBD_GA | SB: DM node generated artifact | 6 | LAST_CHG_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
2 | /IWBEP/I_SBD_PR | SB: DM node project | 6 | LAST_CHG_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | | |
3 | ARBERP_D_STIVSEL | Last run data of Invoice selection report | 5 | LAST_CHG_TIME | Last changed time | nvarchar | 6 | 0 | | |
TOPMonitoring |
4 | ALDTSCTRL | Control Table for CCMS Evaluated Data Service | 9 | LAST_CHG_TIME | System Time | nvarchar | 6 | 0 | | |
TOPReal Estate |
5 | CMS_RE_OBJ | Real estate header details | 31 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
6 | CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here | 14 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
7 | CMS_RE_OBJ_DOC | Link between Real estate objects and Doc is stored here | 11 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
8 | CMS_RE_OBJ_PRT | Real Estate Object part details | 110 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
9 | CMS_RE_OBJ_RL | Real Estate Object role details | 11 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
10 | CMS_RE_OBJ_SPC | Space Details to describe a real estate object | 26 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
11 | CMS_RE_PRT_ACS | Real Estate Part accessory details | 35 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
12 | CMS_RE_PRT_BP | Real Estate Part BP details | 17 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
13 | CMS_RE_PRT_CST | Real Estate Part Cost details | 25 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
14 | CMS_RE_PRT_DOC | Real Estate Document details | 17 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
15 | CMS_RE_PRT_LR | Real Estate Part LR details | 12 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
16 | CMS_RE_PRT_VAL | Real Estate Part value details | 20 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
TOPSecurities |
17 | CMS_SEC_ACC | Securities account details | 38 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
18 | CMS_SEC_ACC_BP | Link between securities account and BuPa is stored here | 15 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
19 | CMS_SEC_ACC_DOC | Link between securities account and Documents is stored here | 15 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
20 | CMS_SEC_ACC_POS | Securities position details | 35 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | |
TOPStorage and Retention Service |
21 | DAS_STORES | ILM SRS: Store Administration | 8 | LAST_CHG_TIME | Last Changed at (Timestamp; UTC) | decimal | 15 | 0 | | |