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