| 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 | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
2 | /ISDFPS/FORCMDID | Supply Relationship IDs | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
3 | /ISDFPS/FORMNT | Attributes of Maintenance Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
4 | /ISDFPS/FORMNTID | IDs of Maintenance Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
5 | /ISDFPS/FOROTH | Attributes of Additional Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
6 | /ISDFPS/FOROTHID | IDs of Other Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
7 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
8 | /ISDFPS/FORSUPID | Supply Relationship IDs | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
TOPForce Element |
9 | /ISDFPS/FORBE | Attributes of HR - BE Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
10 | /ISDFPS/FORBEID | IDs of HR - BE Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
11 | /ISDFPS/FORCN | Attributes of REC - HR Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
12 | /ISDFPS/FORCNID | IDs of HR - REC Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
13 | /ISDFPS/FORDEL | Planned Delimitation and Deletion Operations | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
14 | /ISDFPS/FOREPA | Attributes of the Force Element - EPA Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
15 | /ISDFPS/FOREPAID | IDs of the Force Element - EPA Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
16 | /ISDFPS/FORIPO | FORCER: Authorized Infrastructure: Attributes | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
17 | /ISDFPS/FORIPOID | FORCER: Authorized Infrastructure: IDs | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
18 | /ISDFPS/FORMC | Attributes of the Material Container-Force Element Relatshp | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
19 | /ISDFPS/FORMCH | Attributes of the Material Container - HR Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
20 | /ISDFPS/FORMCHID | IDs of the HR - MC Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
21 | /ISDFPS/FORMCID | IDs of Material Container - Force Element Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
22 | /ISDFPS/FORMPH | Attributes of the HR - MPO Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
23 | /ISDFPS/FORMPHID | IDs of the HR - MPO Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
24 | /ISDFPS/FORMPO | Attributes of the Force Element - MPO Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
25 | /ISDFPS/FORMPOID | IDs of the Force Element - MPO Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
26 | /ISDFPS/FORRIC | Attributes of the Force Element - RIC Relationship | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
27 | /ISDFPS/FORRICID | IDs of the Force Element - RIC Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
28 | /ISDFPS/FORRR | FORCER: RE Search Request: Attributes | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
29 | /ISDFPS/FORRRID | FORCER: RE Search Request: IDs | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
30 | /ISDFPS/FORTOB | Attributes of Relationship to Technical Objects | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
31 | /ISDFPS/FORTOBID | IDs of Relationship to Technical Objects | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
32 | /ISDFPS/FORVPA | Attributes of the Force Element - PPA Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
33 | /ISDFPS/FORVPAID | IDs of the Force Element - PPA Relationships | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
TOPMaterials Management |
34 | /ISDFPS/FRC_IDX1 | Index for Changes to Force Assignments | 7 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |
35 | /ISDFPS/OPENPOS2 | Open MM Documents Intended for Collective Processing | 2 | FRGUID | Material Assignment ID | nvarchar | 32 | 0 | | |