| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____01BY | SID-Tabelle fuer Catalog profile | 3 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
2 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 103 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
3 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 38 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
4 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 103 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
5 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 38 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPAudit Management |
6 | PLMM_QUEST_RES | Audit Question/Reply List/Item | 42 | RBNR | Catalog Profile for FMEA | nvarchar | 9 | 0 | | |
TOPCompany Pension Scheme Germany |
7 | P01RBM_STAT | Notification Status: Pension Receipt Notifications | 7 | RBNR | Pension Receipt Number (Internal) | nvarchar | 8 | 0 | | |
8 | P01RBM_STAT_R | Status of Confirmations (Pension Receipt Notifications) | 7 | RBNR | Pension Receipt Number (Internal) | nvarchar | 8 | 0 | | |
TOPEquipment |
9 | EQUZ | Equipment time segment | 34 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
10 | IEQT_WL_ITEMS | Interim Statuses - Items | 52 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
11 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 53 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPFunctional Locations |
12 | IFLOT | Functional Location (Table) | 32 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
13 | IFLOT_VS | Functional Location (Version Table) | 33 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
14 | IRLOT | Reference Functional Location (Table) | 26 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPKnowledge Base |
15 | ISMP | SDB: Symptom table | 16 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
16 | ISOL | SDB: Solution table | 5 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
17 | T0KBA | SDB: Customizing Symptom Type | 9 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
18 | T0KBB | SDB: Customizing Solution Type | 6 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPMaintenance Notifications |
19 | QMEL | Quality Notification | 36 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
20 | T352B | Technical report | 2 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
21 | T352B_T | Catalog profile texts | 3 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
22 | TQ80 | Notification Types | 4 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPQuality Notifications |
23 | T352C | Catalog types for each catalog profile | 2 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |
TOPResults Recording |
24 | TQ86 | Report category for defects recording | 4 | RBNR | Catalog Profile | nvarchar | 9 | 0 | | |