| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIndustry-Specific Component Automotive |
1 | MHIS_UNPACKED | Copy of DB table MHIS (Data category INT4 replaced by NUMC) | 37 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | | |
TOPMaintenance Task Lists |
2 | MHIS | Maintenance plan history | 37 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | | |
3 | MPLA | Maintenance plan | 41 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | | |
4 | T351P | Maintenance packages | 11 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | | |
5 | T351P_OLD | Old Version of Maintenance Packages | 11 | PUFFP | Lead Float in Days | nvarchar | 3 | 0 | | |
TOPProduction Orders |
6 | AFVV | DB structure of the quantities/dates/values in the operation | 152 | PUFFP | Free float (from forecast) | decimal | 3 | 0 | | |
TOPSimulation |
7 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 153 | PUFFP | Free float (from forecast) | decimal | 3 | 0 | | |