| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAuthorizations and Access Control Context |
1 | /PLMB/AUTH_CHP | Changepointers for updating RT | 5 | CREABY | User ID | nvarchar | 12 | 0 | | |
2 | /PLMB/AUTH_OBSID | Object - Secure Identifier Assignment | 8 | CREABY | User ID | nvarchar | 12 | 0 | | |
3 | /PLMB/AUTH_SIDRP | Secure Identifier Repository | 8 | CREABY | User ID | nvarchar | 12 | 0 | | |
4 | /PLMB/AUTH_UGSID | User Entity - Secure ID - Activity List Assignment | 8 | CREABY | User ID | nvarchar | 12 | 0 | | |
TOPCommand and Support Relationships |
5 | /ISDFPS/FORCMD | Attributes of Task Organization | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
6 | /ISDFPS/FORCMDID | Supply Relationship IDs | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
7 | /ISDFPS/FORMNT | Attributes of Maintenance Relationships | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
8 | /ISDFPS/FORMNTID | IDs of Maintenance Relationships | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
9 | /ISDFPS/FOROTH | Attributes of Additional Relationships | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
10 | /ISDFPS/FOROTHID | IDs of Other Relationships | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
11 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
12 | /ISDFPS/FORSUPID | Supply Relationship IDs | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
13 | /ISDFPS/ORCMD | Task Organizations | 20 | CREABY | Created by | nvarchar | 12 | 0 | | |
14 | /ISDFPS/ORCMD1 | Task Organization, Basic Types of Dependent Attributes | 5 | CREABY | Created by | nvarchar | 12 | 0 | | |
15 | /ISDFPS/ORMNT | Maintenance Relationships | 20 | CREABY | Created by | nvarchar | 12 | 0 | | |
16 | /ISDFPS/ORMNT1 | Maintenance Relationships, Basic Types, Dependent Attributes | 5 | CREABY | Created by | nvarchar | 12 | 0 | | |
17 | /ISDFPS/OROTH | Additional Relationships | 20 | CREABY | Created by | nvarchar | 12 | 0 | | |
18 | /ISDFPS/ORSUP | Supply Relationships | 20 | CREABY | Created by | nvarchar | 12 | 0 | | |
19 | /ISDFPS/ORSUP1 | Supply Relationships, Basic Types, Dependent Attributes | 5 | CREABY | Created by | nvarchar | 12 | 0 | | |
20 | /ISDFPS/ORTOB | Technical Object Relationships (Maintenance) | 20 | CREABY | Created by | nvarchar | 12 | 0 | | |
TOPConfiguration Control |
21 | CCMHOLE | Structure Gap Table | 9 | CREABY | Creator of Object | nvarchar | 12 | 0 | | |
TOPEngineering Change Management |
22 | EDGE | Relation Between Change Numbers | 9 | CREABY | User who created record | nvarchar | 12 | 0 | | |
23 | ENODE | Nodes ECH | 7 | CREABY | User who created record | nvarchar | 12 | 0 | | |
TOPForce Element |
24 | /ISDFPS/FORBE | Attributes of HR - BE Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
25 | /ISDFPS/FORBEID | IDs of HR - BE Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
26 | /ISDFPS/FORCE | Force Element (Database) | 33 | CREABY | Created by | nvarchar | 12 | 0 | | |
27 | /ISDFPS/FORCEM | Authorized Materials | 23 | CREABY | Created by | nvarchar | 12 | 0 | | |
28 | /ISDFPS/FORCEP | Material Packages | 15 | CREABY | Created by | nvarchar | 12 | 0 | | |
29 | /ISDFPS/FORCER | Reference Force Element (Database) | 9 | CREABY | Created by | nvarchar | 12 | 0 | | |
30 | /ISDFPS/FORCE_PR | Individual Threshold Values for Readiness | 17 | CREABY | Created by | nvarchar | 12 | 0 | | |
31 | /ISDFPS/FORCN | Attributes of REC - HR Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
32 | /ISDFPS/FORCNID | IDs of HR - REC Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
33 | /ISDFPS/FORDEL | Planned Delimitation and Deletion Operations | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
34 | /ISDFPS/FOREPA | Attributes of the Force Element - EPA Relationships | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
35 | /ISDFPS/FOREPAID | IDs of the Force Element - EPA Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
36 | /ISDFPS/FORIPO | FORCER: Authorized Infrastructure: Attributes | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
37 | /ISDFPS/FORIPOID | FORCER: Authorized Infrastructure: IDs | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
38 | /ISDFPS/FORMC | Attributes of the Material Container-Force Element Relatshp | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
39 | /ISDFPS/FORMCH | Attributes of the Material Container - HR Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
40 | /ISDFPS/FORMCHID | IDs of the HR - MC Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
41 | /ISDFPS/FORMCID | IDs of Material Container - Force Element Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
42 | /ISDFPS/FORMPH | Attributes of the HR - MPO Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
43 | /ISDFPS/FORMPHID | IDs of the HR - MPO Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
44 | /ISDFPS/FORMPO | Attributes of the Force Element - MPO Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
45 | /ISDFPS/FORMPOID | IDs of the Force Element - MPO Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
46 | /ISDFPS/FORRIC | Attributes of the Force Element - RIC Relationship | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
47 | /ISDFPS/FORRICID | IDs of the Force Element - RIC Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
48 | /ISDFPS/FORRR | FORCER: RE Search Request: Attributes | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
49 | /ISDFPS/FORRRID | FORCER: RE Search Request: IDs | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
50 | /ISDFPS/FORTOB | Attributes of Relationship to Technical Objects | 14 | CREABY | Created by | nvarchar | 12 | 0 | | |
51 | /ISDFPS/FORTOBID | IDs of Relationship to Technical Objects | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
52 | /ISDFPS/FORVPA | Attributes of the Force Element - PPA Relationships | 11 | CREABY | Created by | nvarchar | 12 | 0 | | |
53 | /ISDFPS/FORVPAID | IDs of the Force Element - PPA Relationships | 10 | CREABY | Created by | nvarchar | 12 | 0 | | |
TOPIntegrated Product and Process Engineering |
54 | CMIG_STATUS | Status Table (iPPE Migration) | 8 | CREABY | User who created record | nvarchar | 12 | 0 | | |
55 | CPATYPE | Customizing Table for iPPE Alternative Types | 11 | CREABY | User who created record | nvarchar | 12 | 0 | | |
56 | CPNTYPE | Customizing Table for iPPE Node Type | 22 | CREABY | User who created record | nvarchar | 12 | 0 | | |
57 | CPPECNTL | General iPPE Customizing | 24 | CREABY | User who created record | nvarchar | 12 | 0 | | |
58 | CPRTYPE | Customizing: iPPE Relationships | 24 | CREABY | User who created record | nvarchar | 12 | 0 | | |
59 | CPVSMDL | Model Associations between the PVS Objects | 9 | CREABY | User who created record | nvarchar | 12 | 0 | | |
60 | CPVSMDLC | Model Associations between the Customer-Spec. PVS Objects | 9 | CREABY | User who created record | nvarchar | 12 | 0 | | |
61 | CPVTYPE | Customizing Table for the iPPE Variant Types | 17 | CREABY | User who created record | nvarchar | 12 | 0 | | |
62 | INSTANCEID | Geometric Instance: Identification | 11 | CREABY | User who created record | nvarchar | 12 | 0 | | |
63 | LINEBAL | Line Balance Versions in iPPE | 8 | CREABY | User who created record | nvarchar | 12 | 0 | | |
64 | MODMIXH | Model Mix Header Data | 6 | CREABY | User who created record | nvarchar | 12 | 0 | | |
65 | OMC_BASIC | Basic Settings: Enhanced Dependency Editor | 4 | CREABY | User who created record | nvarchar | 12 | 0 | | |
66 | OMC_MCDEP | Define Scheme for Enhanced Dependency Editor | 56 | CREABY | User who created record | nvarchar | 12 | 0 | | |
67 | OMC_MDEP | Enhanced Dependency Editor: Assign Scheme | 29 | CREABY | User who created record | nvarchar | 12 | 0 | | |
68 | PALTID | iPPE Alternative: Time-Independent ID and Attributes | 11 | CREABY | User who created record | nvarchar | 12 | 0 | | |
69 | PCOLMR | Color Key Master Record | 4 | CREABY | User who created record | nvarchar | 12 | 0 | | |
70 | PFOBJID | Assignment of Leading Focus Obj: Node to Focus Master Record | 10 | CREABY | User who created record | nvarchar | 12 | 0 | | |
71 | PFOBJR | Assignment of Focus Object: Relationship to Focus Master Rec | 10 | CREABY | User who created record | nvarchar | 12 | 0 | | |
72 | PFOBJV | Assignment of Focus Object: Variant to Focus Master Record | 9 | CREABY | User who created record | nvarchar | 12 | 0 | | |
73 | PFOCID | iPPE Focus Master Record | 8 | CREABY | User who created record | nvarchar | 12 | 0 | | |
74 | PNDALT | Alternativensegment zum Positionsknoten | 7 | CREABY | Sachbearbeiter, der den Satz angelegt hat | nvarchar | 12 | 0 | | |
75 | PNDREL | Positionsknotenbeziehung in der PVS | 8 | CREABY | Sachbearbeiter, der den Satz angelegt hat | nvarchar | 12 | 0 | | |
76 | PNODE | Positionsknoten in der PVS | 9 | CREABY | Sachbearbeiter, der den Satz angelegt hat | nvarchar | 12 | 0 | | |
77 | PNODID | iPPE Node: Identification | 12 | CREABY | User who created record | nvarchar | 12 | 0 | | |
78 | POSVID | iPPE Variant: Identification | 11 | CREABY | User who created record | nvarchar | 12 | 0 | | |
79 | PPECPROOBJLNK | iPPE Assignment Table: Object Links with cProjects | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
80 | PPEHDR | iPPE Access Object | 19 | CREABY | User who created record | nvarchar | 12 | 0 | | |
81 | PPESPRECOND | iPPE Status Precondition, Central Data | 7 | CREABY | User who created record | nvarchar | 12 | 0 | | |
82 | PPESSTATUS | iPPE Status, Central Data | 10 | CREABY | User who created record | nvarchar | 12 | 0 | | |
83 | PRELACT | Relationships for the SNP and Workshop Plan | 16 | CREABY | User who created record | nvarchar | 12 | 0 | | |
84 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
85 | PRGEN | GEN Relationships - Relationships Table | 16 | CREABY | User who created record | nvarchar | 12 | 0 | | |
86 | PROJID | iPPE Assignment Table: PS Objects | 16 | CREABY | User who created record | nvarchar | 12 | 0 | | |
87 | PRPVR | Relationship Between Variants: Identification and Attributes | 14 | CREABY | User who created record | nvarchar | 12 | 0 | | |
88 | PRSET | Set Relationships: Table of Links | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
89 | PRTST | Test Relationships - Relationships Table | 17 | CREABY | User who created record | nvarchar | 12 | 0 | | |
90 | PVS_VSHEME | Variance Scheme for Structure Node | 11 | CREABY | User who created record | nvarchar | 12 | 0 | | |
91 | PXARCID | Table for Archiving Indicators for iPPE Objects | 14 | CREABY | User who created record | nvarchar | 12 | 0 | | |
92 | RPPNT | iPPE Reporting Points | 6 | CREABY | User who created record | nvarchar | 12 | 0 | | |
93 | USRTICLASS | Class Assignment for Tabular Maintenance of iPPE | 8 | CREABY | User who created record | nvarchar | 12 | 0 | | |
TOPLine Maintenance |
94 | /ISDFPS/LM_MIS | Mission | 7 | CREABY | Created by | nvarchar | 12 | 0 | | |
TOPLOGFAS |
95 | /ISDFPS/GEOLOC | Geolocation Database Table | 27 | CREABY | Created by | nvarchar | 12 | 0 | | |
96 | /ISDFPS/RIC | Reportable Item Code | 15 | CREABY | Created by | nvarchar | 12 | 0 | | |
TOPLogistical Requirements |
97 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
TOPMaster Data Distribution |
98 | /ISDFPS/CCMHOLER | Replication Table CCMHOLE | 9 | CREABY | Creator of Object | nvarchar | 12 | 0 | | |
TOPMaterial |
99 | RSADD | Additional fields for reservation | 27 | CREABY | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
TOPMaterial Categories |
100 | /ISDFPS/PRMPO | Attributes of BOM Relationships | 12 | CREABY | User who created record | nvarchar | 12 | 0 | | |
101 | /ISDFPS/PRMPOC | Attributes of Relationships Between Matl Container and MPO | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
102 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
103 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 13 | CREABY | User who created record | nvarchar | 12 | 0 | | |
TOPProduct and Process Modeling |
104 | RLMFWOH | Release Order - Header Data | 9 | CREABY | Created by | nvarchar | 12 | 0 | | |
TOPResourcen Management |
105 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
106 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
107 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
108 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
109 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
110 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 15 | CREABY | User who created record | nvarchar | 12 | 0 | | |
111 | RMSAT_STD_LAY_H | RMS-ATL: Header Table Layout Standardization | 4 | CREABY | Created By | nvarchar | 12 | 0 | | |
112 | RMSAT_STD_PARA_H | RMS-ATL: Header Table Parameter Standardization | 11 | CREABY | Created By | nvarchar | 12 | 0 | | |
113 | RMSLA_HD | Header Data of Label Set | 4 | CREABY | Created By | nvarchar | 12 | 0 | | |
TOPRouting EBOM Assignment |
114 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 17 | CREABY | User Who Created the Object | nvarchar | 12 | 0 | | |
115 | /PLMI/RTGRCASCOH | RCA Planning Scope Version | 8 | CREABY | User Who Created the Object | nvarchar | 12 | 0 | | |
TOPSimulation |
116 | VSRSADD_CN | Version: Additional fields for reservation | 28 | CREABY | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
TOPWarranty Claim Processing |
117 | PNWTYH | Warranty Claim Header (PVS Node) | 45 | CREABY | User Who Created Record | nvarchar | 12 | 0 | | |
118 | PNWTYV | Warranty Claim Version (PVS Node) | 41 | CREABY | User Who Created Record | nvarchar | 12 | 0 | | |
119 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 13 | CREABY | User Who Created Record | nvarchar | 12 | 0 | | |
120 | PVWTY | Warranty Claim Item (PPE Variant) | 50 | CREABY | User Who Created Record | nvarchar | 12 | 0 | | |
121 | WTY_PARTNER_TAB | Partner for Warranty Claim | 11 | CREABY | User Who Created Record | nvarchar | 12 | 0 | | |
122 | WTY_RCLHST | Recall Actions | 9 | CREABY | User who Created the Claim | nvarchar | 12 | 0 | | |