| 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 | | |