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