| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConfirmations |
| 1 | AFRD | Default values for collective confirmation | 65 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| 2 | AFRP0 | Table of planned changes for confirmation (PDC) | 49 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| 3 | AFRU | Order Confirmations | 74 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| 4 | AFRV | Confirmation pool | 84 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| 5 | AFRV_DEL | Backup Copy for Confirmation Pool | 84 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| TOPPlant Data Collection |
| 6 | RUECK | Temp. storage for subsystem confirmations | 79 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| TOPProduction Orders |
| 7 | AFVC | Operation within an order | 87 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| TOPScheduling |
| 8 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 21 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| TOPSimulation |
| 9 | VSAFVC_CN | Version: Operation in order | 88 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
| 10 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 22 | LEK01 | Indicator: No remaining activity expected | nvarchar | 1 | 0 | | |
