| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRE/TRADE_ASSET | Trade Assets table for category | 3 | TYPTX | Equipment category description | nvarchar | 30 | 0 | | |
2 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 176 | TYPTX | Equipment category description | nvarchar | 30 | 0 | | |
3 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 123 | TYPTX | Description of functional location category | nvarchar | 30 | 0 | | |
TOPEquipment |
4 | IEQT_WL_HDR_BAC | Interim Statuses - Header Data (Backup) | 10 | TYPTX | Technical type text | nvarchar | 30 | 0 | | |
5 | IEQT_WL_HEADER | Interim Statuses - Header Data | 9 | TYPTX | Technical type text | nvarchar | 30 | 0 | | |
6 | T370U | Language-dependent texts for T370T | 4 | TYPTX | Equipment category description | nvarchar | 30 | 0 | | |
TOPFunctional Locations |
7 | T370F_T | Language-Dependent Texts for T370F | 4 | TYPTX | Description of functional location category | nvarchar | 30 | 0 | | |
8 | T370R_T | Language-Dependent Texts for T370R | 4 | TYPTX | Description of the reference functional location category | nvarchar | 30 | 0 | | |
TOPMaintenance History |
9 | T370N_T | Language dependent texts for T370N | 4 | TYPTX | Description of object link category | nvarchar | 30 | 0 | | |
TOPProgress Tracking |
10 | TSTNTYT | Language-Dependent Texts for Status Info Type | 5 | TYPTX | Description of Status Information Type | nvarchar | 40 | 0 | | |