| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConfirmations |
1 | AFRD | Default values for collective confirmation | 45 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
2 | AFRP0 | Table of planned changes for confirmation (PDC) | 34 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
3 | AFRU | Order Confirmations | 49 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
4 | AFRV | Confirmation pool | 133 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
5 | AFRV_DEL | Backup Copy for Confirmation Pool | 133 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
TOPPlant Data Collection |
6 | RUECK | Temp. storage for subsystem confirmations | 128 | ISBD | Confirmed date for 'Processing start' | nvarchar | 8 | 0 | | |
TOPProduction Orders |
7 | AFVV | DB structure of the quantities/dates/values in the operation | 90 | ISBD | Actual start: Processing (date) | nvarchar | 8 | 0 | | |
TOPScheduling |
8 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 52 | ISBD | Actual start: Processing (date) | nvarchar | 8 | 0 | | |
TOPSimulation |
9 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 91 | ISBD | Actual start: Processing (date) | nvarchar | 8 | 0 | | |
10 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 53 | ISBD | Actual start: Processing (date) | nvarchar | 8 | 0 | | |