| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConfirmations |
| 1 | AFRD | Default values for collective confirmation | 61 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 2 | AFRP0 | Table of planned changes for confirmation (PDC) | 13 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 3 | AFRU | Order Confirmations | 69 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 4 | AFRV | Confirmation pool | 145 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 5 | AFRV_DEL | Backup Copy for Confirmation Pool | 145 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| TOPPlant Data Collection |
| 6 | RUECK | Temp. storage for subsystem confirmations | 140 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| TOPProduction Orders |
| 7 | AFSPOPR | Split Operations in an Order Split | 6 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 8 | AFVC | Operation within an order | 77 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 9 | COWIPB_CHVW | WIP Batches with Where-Used List | 27 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| 10 | ORDCOM | Communication control Operation download | 7 | APLFL | Sequence | nvarchar | 6 | 0 | | |
| TOPSimulation |
| 11 | VSAFVC_CN | Version: Operation in order | 78 | APLFL | Sequence | nvarchar | 6 | 0 | | |
