| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RSCRMPACK_LOG | Packaging log | 2 | TIMSTMP | | nvarchar | 22 | 0 | | |
TOPCommand and Support Relationships |
2 | /ISDFPS/FORCMD | Attributes of Task Organization | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
3 | /ISDFPS/FORCMDID | Supply Relationship IDs | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
4 | /ISDFPS/FORMNT | Attributes of Maintenance Relationships | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
5 | /ISDFPS/FORMNTID | IDs of Maintenance Relationships | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | /ISDFPS/FOROTH | Attributes of Additional Relationships | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | /ISDFPS/FOROTHID | IDs of Other Relationships | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
8 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
9 | /ISDFPS/FORSUPID | Supply Relationship IDs | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
10 | /ISDFPS/ORCMD | Task Organizations | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
11 | /ISDFPS/ORMNT | Maintenance Relationships | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
12 | /ISDFPS/OROTH | Additional Relationships | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
13 | /ISDFPS/ORSUP | Supply Relationships | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
14 | /ISDFPS/ORTOB | Technical Object Relationships (Maintenance) | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPEngineering Change Management |
15 | EDGE | Relation Between Change Numbers | 7 | TIMSTMP | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
16 | ENODE | Nodes ECH | 5 | TIMSTMP | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
TOPForce Element |
17 | /ISDFPS/FORBE | Attributes of HR - BE Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
18 | /ISDFPS/FORBEID | IDs of HR - BE Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
19 | /ISDFPS/FORCE | Force Element (Database) | 25 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
20 | /ISDFPS/FORCEM | Authorized Materials | 18 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
21 | /ISDFPS/FORCEP | Material Packages | 11 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
22 | /ISDFPS/FORCER | Reference Force Element (Database) | 7 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
23 | /ISDFPS/FORCN | Attributes of REC - HR Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
24 | /ISDFPS/FORCNID | IDs of HR - REC Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
25 | /ISDFPS/FORDEL | Planned Delimitation and Deletion Operations | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
26 | /ISDFPS/FOREPA | Attributes of the Force Element - EPA Relationships | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
27 | /ISDFPS/FOREPAID | IDs of the Force Element - EPA Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
28 | /ISDFPS/FORIPO | FORCER: Authorized Infrastructure: Attributes | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
29 | /ISDFPS/FORIPOID | FORCER: Authorized Infrastructure: IDs | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
30 | /ISDFPS/FORMC | Attributes of the Material Container-Force Element Relatshp | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
31 | /ISDFPS/FORMCH | Attributes of the Material Container - HR Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
32 | /ISDFPS/FORMCHID | IDs of the HR - MC Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
33 | /ISDFPS/FORMCID | IDs of Material Container - Force Element Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
34 | /ISDFPS/FORMPH | Attributes of the HR - MPO Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
35 | /ISDFPS/FORMPHID | IDs of the HR - MPO Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
36 | /ISDFPS/FORMPO | Attributes of the Force Element - MPO Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
37 | /ISDFPS/FORMPOID | IDs of the Force Element - MPO Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
38 | /ISDFPS/FORRIC | Attributes of the Force Element - RIC Relationship | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
39 | /ISDFPS/FORRICID | IDs of the Force Element - RIC Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
40 | /ISDFPS/FORRR | FORCER: RE Search Request: Attributes | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
41 | /ISDFPS/FORRRID | FORCER: RE Search Request: IDs | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
42 | /ISDFPS/FORTOB | Attributes of Relationship to Technical Objects | 12 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
43 | /ISDFPS/FORTOBID | IDs of Relationship to Technical Objects | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
44 | /ISDFPS/FORVPA | Attributes of the Force Element - PPA Relationships | 9 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
45 | /ISDFPS/FORVPAID | IDs of the Force Element - PPA Relationships | 8 | TIMSTMP | Time Stamp with Format (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPIntegrated Product and Process Engineering |
46 | CMIG_STATUS | Status Table (iPPE Migration) | 7 | TIMSTMP | Time Stamp | nvarchar | 14 | 0 | | |
47 | INSTANCEID | Geometric Instance: Identification | 8 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
48 | LINEBAL | Line Balance Versions in iPPE | 6 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
49 | MODMIXH | Model Mix Header Data | 4 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
50 | PALTID | iPPE Alternative: Time-Independent ID and Attributes | 8 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
51 | PFOBJID | Assignment of Leading Focus Obj: Node to Focus Master Record | 11 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
52 | PFOBJR | Assignment of Focus Object: Relationship to Focus Master Rec | 11 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
53 | PFOBJV | Assignment of Focus Object: Variant to Focus Master Record | 10 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
54 | PFOCID | iPPE Focus Master Record | 12 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
55 | PNODID | iPPE Node: Identification | 10 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
56 | POSVID | iPPE Variant: Identification | 8 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
57 | PPEHDR | iPPE Access Object | 17 | TIMSTMP | Short Time Stamp in PPEHDR | decimal | 15 | 0 | | |
58 | PPESSTATUS | iPPE Status, Central Data | 8 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
59 | PRELACT | Relationships for the SNP and Workshop Plan | 4 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
60 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 17 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
61 | PRGEN | GEN Relationships - Relationships Table | 4 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
62 | PROJID | iPPE Assignment Table: PS Objects | 14 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
63 | PRTST | Test Relationships - Relationships Table | 4 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
64 | PVSCSQ | Change Sequence in the PVS | 4 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
65 | TIMSTMP_TAB | Time Stamp Aggregation in iPPE | 7 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
TOPLogistical Requirements |
66 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 17 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
TOPMaterial Categories |
67 | /ISDFPS/PRMPO | Attributes of BOM Relationships | 10 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
68 | /ISDFPS/PRMPOC | Attributes of Relationships Between Matl Container and MPO | 11 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
69 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 17 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
70 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 17 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
TOPResourcen Management |
71 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
72 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
73 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
74 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
75 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
76 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 20 | TIMSTMP | Time Stamp - Short Format | decimal | 15 | 0 | | |
77 | RMSAT_STD_PARA_H | RMS-ATL: Header Table Parameter Standardization | 9 | TIMSTMP | Time Stamp Database | decimal | 21 | 7 | | |
TOPWarranty Claim Processing |
78 | PNWTYH | Warranty Claim Header (PVS Node) | 43 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
79 | PNWTYV | Warranty Claim Version (PVS Node) | 39 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
80 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 17 | TIMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
81 | PVWTY | Warranty Claim Item (PPE Variant) | 48 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
82 | WTY_PARTNER_TAB | Partner for Warranty Claim | 9 | TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
TOPWeb Service and SOAP - ABAP |
83 | SRT_TF_LP | Table for storing all LP of the TF and delete it afterwards | 3 | TIMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |