| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConfirmations |
| 1 | AFRD | Default values for collective confirmation | 99 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| 2 | AFRP0 | Table of planned changes for confirmation (PDC) | 66 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| 3 | AFRU | Order Confirmations | 118 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| 4 | AFRV | Confirmation pool | 162 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| 5 | AFRV_DEL | Backup Copy for Confirmation Pool | 162 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| TOPProduction Orders |
| 6 | AFVV | DB structure of the quantities/dates/values in the operation | 177 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
| TOPSimulation |
| 7 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 178 | IPRE1 | Unit of measurement for conf. quantity for business process | nvarchar | 3 | 0 | | |
