| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCapacity Leveling |
1 | ISTBED | Actual requirements records | 23 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
TOPConfirmations |
2 | AFRD | Default values for collective confirmation | 52 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
3 | AFRP0 | Table of planned changes for confirmation (PDC) | 41 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
4 | AFRU | Order Confirmations | 56 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
5 | AFRV | Confirmation pool | 140 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
6 | AFRV_DEL | Backup Copy for Confirmation Pool | 140 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
TOPMaintenance History |
7 | HIVG | PM order history - operations | 29 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |
TOPPlant Data Collection |
8 | RUECK | Temp. storage for subsystem confirmations | 135 | IEDZ | Confirmed time for 'Execution finish' | nvarchar | 6 | 0 | | |
TOPProduction Orders |
9 | AFVV | DB structure of the quantities/dates/values in the operation | 97 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |
10 | ORDLY | Table of delays for production order | 13 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |
TOPScheduling |
11 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 59 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |
TOPSimulation |
12 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 98 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |
13 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 60 | IEDZ | Actual finish: Execution (time) | nvarchar | 6 | 0 | | |