| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | S981 | OF ARTICLES POSTES | 31 | IEDD | Fin réelle : exécuter (date) | nvarchar | 8 | 0 | | |
| TOPCapacity Leveling |
| 2 | ISTBED | Actual requirements records | 22 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| TOPConfirmations |
| 3 | AFRD | Default values for collective confirmation | 51 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| 4 | AFRP0 | Table of planned changes for confirmation (PDC) | 40 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| 5 | AFRU | Order Confirmations | 55 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| 6 | AFRV | Confirmation pool | 139 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| 7 | AFRV_DEL | Backup Copy for Confirmation Pool | 139 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| TOPData Collection |
| 8 | S022 | SFIS: Order Operation Data for Work Center | 47 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPInformation System |
| 9 | MCAFVGV | Versions: Order Procedure | 36 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| 10 | MCSFIS | R/2 SFIS Data: Old | 98 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPLogistics Information System LIS |
| 11 | S281 | Order Operation, BW | 31 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| 12 | S281BIW1 | S281BIW1 * Order Process, BW | 31 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| 13 | S281BIW2 | S281BIW2 * Order Process, BW | 31 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPMaintenance History |
| 14 | HIVG | PM order history - operations | 28 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPPlant Data Collection |
| 15 | RUECK | Temp. storage for subsystem confirmations | 134 | IEDD | Confirmed date for execution finish | nvarchar | 8 | 0 | | |
| TOPProduction Orders |
| 16 | AFVV | DB structure of the quantities/dates/values in the operation | 96 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| 17 | ORDLY | Table of delays for production order | 12 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPScheduling |
| 18 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 58 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| TOPSimulation |
| 19 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 97 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
| 20 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 59 | IEDD | Actual finish: Execution (date) | nvarchar | 8 | 0 | | |
