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