| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIntegrated Product and Process Engineering |
| 1 | PRELACT | Relationships for the SNP and Workshop Plan | 12 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 2 | PRELDEX | External Indicator Deleted iPPE Relationships | 8 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 3 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 8 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 4 | PRGEN | GEN Relationships - Relationships Table | 12 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 5 | PRPVR | Relationship Between Variants: Identification and Attributes | 10 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 6 | PRSET | Set Relationships: Table of Links | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 7 | PRTST | Test Relationships - Relationships Table | 13 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| TOPLogistical Requirements |
| 8 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 8 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| TOPMaterial Categories |
| 9 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 8 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 10 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 8 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| TOPResourcen Management |
| 11 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 12 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 13 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 14 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 15 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 16 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 11 | APPLOBJ_TYPE2 | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| TOPWarranty Claim Processing |
| 17 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 8 | APPLOBJ_TYPE2 | | nvarchar | 4 | 0 | | |
