| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S983 | SUIVI ATELIER | 20 | ILE01 | Unité de mesure de la première prestation à confirmer | nvarchar | 3 | 0 | | |
2 | S983E | S983 - Info structurelles | 13 | ILE01 | Unité de mesure de la première prestation à confirmer | nvarchar | 3 | 0 | | |
TOPConfirmations |
3 | AFRD | Default values for collective confirmation | 11 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
4 | AFRP0 | Table of planned changes for confirmation (PDC) | 47 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
5 | AFRU | Order Confirmations | 15 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
6 | AFRV | Confirmation pool | 80 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
7 | AFRV_DEL | Backup Copy for Confirmation Pool | 80 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
TOPPlant Data Collection |
8 | RUECK | Temp. storage for subsystem confirmations | 75 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
TOPProduction Orders |
9 | AFVV | DB structure of the quantities/dates/values in the operation | 169 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
TOPScheduling |
10 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 74 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
TOPSimulation |
11 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 170 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |
12 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 75 | ILE01 | Unit of measure for the activity to be confirmed | nvarchar | 3 | 0 | | |