| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_CFG_VER | Table to store ICC Configuration data versions | 4 | ACTIVE_VERSION | Active Version | nvarchar | 1 | 0 | | |
2 | /OPT/X045 | Table to store ICC Configuration data versions | 4 | ACTIVE_VERSION | Active Version | nvarchar | 1 | 0 | | |
3 | /OPT/Y045 | Table to store ICC Configuration data versions | 4 | ACTIVE_VERSION | Active Version | nvarchar | 1 | 0 | | |
4 | /OPT/Z045 | Table to store ICC Configuration data versions | 4 | ACTIVE_VERSION | Active Version | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_PM005 | Data staging - Equipment LSet - DMS Doc. Obj - complex table | 19 | ACTIVE_VERSION | Active version of the original | nvarchar | 1 | 0 | | |
6 | /SMERP/STG_PM010 | Data staging - Func. Loc. LSet - DMS Doc. Obj - complex tab | 19 | ACTIVE_VERSION | Active version of the original | nvarchar | 1 | 0 | | |
7 | CNV_ADT_DP | Transformation Summary: Data providers | 3 | ACTIVE_VERSION | Active data provider version | nvarchar | 4 | 0 | | |
8 | CNV_ADT_DP_ACT | T. Summary: Active version of DP's for auditing packages | 4 | ACTIVE_VERSION | Active data provider version | nvarchar | 4 | 0 | | |
9 | GRFNMWCNVERA | MSMP Versions | 6 | ACTIVE_VERSION | Active Version Flag | nvarchar | 1 | 0 | | |
10 | ZRDB_DEL_DIR | 16.09.2009: Delete DIR | 67 | ACTIVE_VERSION | Aktive Version des Originals | nvarchar | 1 | 0 | | |
TOPStructure |
11 | DPR_APPROVAL | Approval | 17 | ACTIVE_VERSION | Active Version of Approval | nvarchar | 1 | 0 | | |