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