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