| 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 | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
2 | /ISDFPS/FORMNT | Attributes of Maintenance Relationships | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
3 | /ISDFPS/FOROTH | Attributes of Additional Relationships | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
4 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
5 | /ISDFPS/FRC_IDX | Index for Changes to Force Assignments | 12 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
TOPForce Element |
6 | /ISDFPS/FORBE | Attributes of HR - BE Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
7 | /ISDFPS/FORCN | Attributes of REC - HR Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
8 | /ISDFPS/FORDEL | Planned Delimitation and Deletion Operations | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
9 | /ISDFPS/FOREPA | Attributes of the Force Element - EPA Relationships | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
10 | /ISDFPS/FORIPO | FORCER: Authorized Infrastructure: Attributes | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
11 | /ISDFPS/FORMC | Attributes of the Material Container-Force Element Relatshp | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
12 | /ISDFPS/FORMCH | Attributes of the Material Container - HR Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
13 | /ISDFPS/FORMPH | Attributes of the HR - MPO Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
14 | /ISDFPS/FORMPO | Attributes of the Force Element - MPO Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
15 | /ISDFPS/FORRIC | Attributes of the Force Element - RIC Relationship | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
16 | /ISDFPS/FORRR | FORCER: RE Search Request: Attributes | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
17 | /ISDFPS/FORTOB | Attributes of Relationship to Technical Objects | 11 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
18 | /ISDFPS/FORVPA | Attributes of the Force Element - PPA Relationships | 8 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
TOPLogistical Requirements |
19 | /ISDFPS/PNEPAM | Materials Within an Equipment Package | 9 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
TOPMaterial Categories |
20 | /ISDFPS/PRMPO | Attributes of BOM Relationships | 9 | DGUID | Identifier of Relationships for Distribution | nvarchar | 32 | 0 | | |
21 | /ISDFPS/PRMPOC | Attributes of Relationships Between Matl Container and MPO | 10 | DGUID | Identifier of Relationships for Distribution | nvarchar | 32 | 0 | | |
TOPMaterials Management |
22 | /ISDFPS/FORCEP_M | Assignment FE/PPA/Matl for Status Management Initial Supply | 7 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
23 | /ISDFPS/FRC_IDX1 | Index for Changes to Force Assignments | 13 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
TOPStructures Workbench |
24 | /ISDFPS/MATSPPLN | Materials Planned for Force Element | 39 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |
25 | HRT1981 | Table Section Infotype 1981 | 15 | DGUID | Distribution Assignment ID | nvarchar | 32 | 0 | | |