| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SDF/HIS_KPI_DIC | Dictionary of KPIs used in /SDF/HIS | 7 | RETENTION | | tinyint | 3 | 0 | | |
2 | TILM_STOR_MON_C | ILM DB Store: Monitoring KPI Command | 6 | RETENTION | ILM DB Store: Retention Time (in days) | int | 10 | 0 | | |
3 | TILM_STOR_MON_DH | ILM DB Store: Monitoring KPI Details - Historical Data | 9 | RETENTION | ILM DB Store: Retention Date | nvarchar | 8 | 0 | | |
4 | TILM_STOR_MON_KH | ILM DB Store: Monitoring KPI Result - Historical Data | 6 | RETENTION | ILM DB Store: Retention Date | nvarchar | 8 | 0 | | |
5 | TILM_STOR_MON_KL | ILM DB Store: Monitoring KPI Last Run Results | 7 | RETENTION | ILM DB Store: Retention Date | nvarchar | 8 | 0 | | |
TOPCustomer Contact |
6 | BCONTA | Contact Activities | 6 | RETENTION | Retention Period (in Days) | nvarchar | 4 | 0 | | |
TOPProduction and Revenue Accounting |
7 | OIUP_PDM_MONTHS | PDM: Set number of storage months by Box/Table | 4 | RETENTION | Number of storage months | nvarchar | 5 | 0 | | |