| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 33 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 57 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 33 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 57 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
TOPBasic Functions |
5 | ANLA | Asset Master Record Segment | 49 | TYPBZ | Asset type name | nvarchar | 15 | 0 | | |
TOPBulk Distribution Requirements Planning |
6 | OIIGMMK | GMM: General meter header table | 10 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
TOPDevice Management |
7 | TEAPPRVLNR | Alloc. of Manufacturer/Cat. Desc. to Inspection No. (B/NL) | 3 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
8 | TEMANUFCAT | Combination: Manufact./Manufact.Cat.Descr. and DevCat.(B/NL) | 3 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
TOPEquipment |
9 | EQUI | Equipment master data | 27 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
TOPFunctional Locations |
10 | IFLOT | Functional Location (Table) | 51 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
11 | IFLOT_VS | Functional Location (Version Table) | 52 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
TOPReporting |
12 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 14 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |
13 | S114 | Fahrzeugverbrauchsanalyse | 14 | TYPBZ | Typebenaming van producent | nvarchar | 20 | 0 | | |
14 | S114E | S114 - Strukturinformationen | 9 | TYPBZ | Typebenaming van producent | nvarchar | 20 | 0 | | |
TOPTraders and Schedulers Workbench |
15 | OIISOCK | SOC: Storage object characteristic segment header | 13 | TYPBZ | Manufacturer model number | nvarchar | 20 | 0 | | |