| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S981 | OF ARTICLES POSTES | 32 | ISDD | Début réel : exécuter (date) | nvarchar | 8 | 0 | | |
TOPCapacity Leveling |
2 | ISTBED | Actual requirements records | 20 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
TOPConfirmations |
3 | AFRD | Default values for collective confirmation | 41 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
4 | AFRP0 | Table of planned changes for confirmation (PDC) | 30 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
5 | AFRU | Order Confirmations | 45 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
6 | AFRV | Confirmation pool | 129 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
7 | AFRV_DEL | Backup Copy for Confirmation Pool | 129 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
TOPData Collection |
8 | S022 | SFIS: Order Operation Data for Work Center | 43 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPInformation System |
9 | MCAFVGV | Versions: Order Procedure | 32 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
10 | MCSFIS | R/2 SFIS Data: Old | 94 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPLogistics Information System LIS |
11 | S281 | Order Operation, BW | 32 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
12 | S281BIW1 | S281BIW1 * Order Process, BW | 32 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
13 | S281BIW2 | S281BIW2 * Order Process, BW | 32 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPMaintenance History |
14 | HIVG | PM order history - operations | 26 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPPlant Data Collection |
15 | RUECK | Temp. storage for subsystem confirmations | 124 | ISDD | Confirmed date for start of execution | nvarchar | 8 | 0 | | |
TOPProduction Orders |
16 | AFVV | DB structure of the quantities/dates/values in the operation | 86 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPScheduling |
17 | KBEZ | Add. data for table KBED (for indiv. capacities/splits) | 48 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
TOPSimulation |
18 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 87 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |
19 | VSKBEZ_CN | Version: Additional data for table KBED (ind. capacities) | 49 | ISDD | Actual start: Execution (date) | nvarchar | 8 | 0 | | |