| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCross-Application Components |
1 | PLLPO | Task list - operation/activity | 98 | EHOFFE | Unit for offset to finish | nvarchar | 3 | 0 | | |
TOPMaster Data Distribution |
2 | /ISDFPS/TL1 | Task List - Operation/Activity | 98 | EHOFFE | Unit for offset to finish | nvarchar | 3 | 0 | | |
TOPMaterial Master |
3 | MFHM_TMP | File for Incorrect Data in Direct Input | 28 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
4 | MVHM | MRP material version | 25 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
TOPProduction Orders |
5 | AFVV | DB structure of the quantities/dates/values in the operation | 141 | EHOFFE | Unit for offset to finish | nvarchar | 3 | 0 | | |
TOPProduction ResourcesTools |
6 | AFFH | PRT assignment data for the work order | 27 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
7 | CRFH | CIM production resource/tool master data | 37 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
TOPRouting |
8 | PLFH | Task list - production resources/tools | 29 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
9 | PLPO | Task list - operation/activity | 98 | EHOFFE | Unit for offset to finish | nvarchar | 3 | 0 | | |
TOPSimulation |
10 | VSAFFH_CN | Version: PRT allocation to work order | 28 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | |
11 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 142 | EHOFFE | Unit for offset to finish | nvarchar | 3 | 0 | | |