| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | S980 | ORDRES DE FABRICATION | 26 | ETRMP | Date d'ouverture de l'ordre planifié | nvarchar | 8 | 0 | | |
| 2 | ZEIM_AFPO | Order item | 10 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| TOPInformation System |
| 3 | MCAFPOV | Versions: Order Item | 8 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| 4 | MCSFIS | R/2 SFIS Data: Old | 42 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| TOPLogistics Information System LIS |
| 5 | S280 | Order header and item, BW | 26 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| 6 | S280BIW1 | S280BIW1 * Order header and item, BW | 26 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| 7 | S280BIW2 | S280BIW2 * Order Header and Item, BW | 26 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| TOPProduction Orders |
| 8 | AFPO | Order item | 10 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
| TOPSimulation |
| 9 | VSAFPO_CN | Version: Order items in PP orders | 11 | ETRMP | Opening date of the planned order | nvarchar | 8 | 0 | | |
