| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 29 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 53 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 29 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 53 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPBasic Functions |
5 | ANGA | Asset catalog general data | 16 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
6 | ANKA | Asset classes: general data | 36 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
7 | ANLA | Asset Master Record Segment | 37 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPBulk Distribution Requirements Planning |
8 | OIIGMMK | GMM: General meter header table | 7 | HERST | Manufacturer of equipment | nvarchar | 30 | 0 | | |
TOPDevice Management |
9 | TE063 | Manufacturer | 2 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
10 | TEAPPRVLNR | Alloc. of Manufacturer/Cat. Desc. to Inspection No. (B/NL) | 2 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
11 | TEMANUFCAT | Combination: Manufact./Manufact.Cat.Descr. and DevCat.(B/NL) | 2 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPEquipment |
12 | EQUI | Equipment master data | 23 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPFunctional Locations |
13 | IFLOT | Functional Location (Table) | 47 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
14 | IFLOT_VS | Functional Location (Version Table) | 48 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPReporting |
15 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 12 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
16 | S062 | Object class and manufacturer | 10 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
17 | S062E | S062 - Structural Information | 5 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
18 | S065 | Object statistics | 10 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
19 | S065E | S065 - Structural Information | 5 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
20 | S114 | Fahrzeugverbrauchsanalyse | 13 | HERST | Producent van het vast actief | nvarchar | 30 | 0 | | |
21 | S114E | S114 - Strukturinformationen | 8 | HERST | Producent van het vast actief | nvarchar | 30 | 0 | | |
TOPSAP Utilities |
22 | SCODE_IN | Seal code | 6 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | | |
TOPTraders and Schedulers Workbench |
23 | OIISOCK | SOC: Storage object characteristic segment header | 9 | HERST | Manufacturer of equipment | nvarchar | 30 | 0 | | |
TOPWarranty Claim Processing |
24 | PVWTY | Warranty Claim Item (PPE Variant) | 25 | HERST | Partner Number Manufacturer/Vendor | nvarchar | 10 | 0 | | |