| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIntegrated Product and Process Engineering |
| 1 | INSTANCEID | Geometric Instance: Identification | 9 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 2 | PALTID | iPPE Alternative: Time-Independent ID and Attributes | 9 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 3 | PNODID | iPPE Node: Identification | 16 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 4 | POSVID | iPPE Variant: Identification | 9 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 5 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 11 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| TOPLogistical Requirements |
| 6 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 11 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| TOPMaterial Categories |
| 7 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 11 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 8 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 11 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| TOPResourcen Management |
| 9 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 10 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 11 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 12 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 13 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| 14 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 19 | HISTFLG | PVS Object Changed with History | nvarchar | 1 | 0 | | |
| TOPWarranty Claim Processing |
| 15 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 11 | HISTFLG | | nvarchar | 1 | 0 | | |
