| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | DMC_PTT_03 | Performance Test Tool Table | 4 | GUID2 | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | | |
| 2 | J_3RF_BK_GUID | GUIDs for XML. Sales and Purchase Books | 9 | GUID2 | Second GUID | nvarchar | 36 | 0 | | |
| TOPIntegrated Product and Process Engineering |
| 3 | PRELACT | Relationships for the SNP and Workshop Plan | 11 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 4 | PRELDEX | External Indicator Deleted iPPE Relationships | 7 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 5 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 7 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 6 | PRGEN | GEN Relationships - Relationships Table | 11 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 7 | PRPVR | Relationship Between Variants: Identification and Attributes | 9 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 8 | PRSET | Set Relationships: Table of Links | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 9 | PRTST | Test Relationships - Relationships Table | 12 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| TOPLogistical Requirements |
| 10 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 7 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| TOPManagement of Internal Controls |
| 11 | FOPCCASERELA | MIC: Relationship Between Cases | 3 | GUID2 | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
| TOPMaterial Categories |
| 12 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 7 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 13 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 7 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| TOPPortfolio Management |
| 14 | /RPM/RELATION_D | Portofolio relation object persisted data | 5 | GUID2 | Guid for application objects | varbinary | 16 | 0 | | |
| 15 | RPM_RELATION_CD | Portofolio Relations - Pseudo table for change documents | 5 | GUID2 | Guid for application objects | varbinary | 16 | 0 | | |
| TOPProcess Controls |
| 16 | GRPCCASERELA | PC: Relationship Between Cases | 3 | GUID2 | Technical Case Key (Case GUID) | nvarchar | 32 | 0 | | |
| TOPResourcen Management |
| 17 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 18 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 19 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 20 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 21 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| 22 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 10 | GUID2 | Internal Identification for PVS Objects | varbinary | 16 | 0 | | |
| TOPWarranty Claim Processing |
| 23 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 7 | GUID2 | Internal Number of iPPE Node | varbinary | 16 | 0 | | |
