| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPForce Element |
1 | /ISDFPS/CMATQUAL | Material Indicators | 5 | FORCE_ID | Initial Supplier of Materials | nvarchar | 32 | 0 | | |
2 | /ISDFPS/FORCE | Force Element (Database) | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
3 | /ISDFPS/FORCEM | Authorized Materials | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
4 | /ISDFPS/FORCEP | Material Packages | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
5 | /ISDFPS/FORCER | Reference Force Element (Database) | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
6 | /ISDFPS/FORCE_PR | Individual Threshold Values for Readiness | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
7 | /ISDFPS/FOREPAID | IDs of the Force Element - EPA Relationships | 14 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
8 | /ISDFPS/FORLOSYS | Logical System for System Switch Process | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
9 | /ISDFPS/FORMCID | IDs of Material Container - Force Element Relationships | 14 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
10 | /ISDFPS/FORMPOID | IDs of the Force Element - MPO Relationships | 14 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
11 | /ISDFPS/FORRICID | IDs of the Force Element - RIC Relationships | 14 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
12 | /ISDFPS/FORVPAID | IDs of the Force Element - PPA Relationships | 14 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPImplementation of Organizational Flexibility in Logistics |
13 | /ISDFPS/REL_DEL | Relocation: Deliveries | 3 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
14 | /ISDFPS/REL_L | Relationship Table | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
15 | /ISDFPS/REL_TPN | Relocation Information for Shipment Document | 4 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPLine Maintenance |
16 | /ISDFPS/LM_MIS | Mission | 3 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPMaster Data Distribution |
17 | /ISDFPS/EXPO_LIS | Additional Objects | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
18 | /ISDFPS/FE2CMFLD | Assignment Folder to Folder Element | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPMaterial Categories |
19 | /ISDFPS/MPO_PROT | Log of Data Transfers into MPO | 23 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPMaterials Management |
20 | /ISDFPS/FORCEP_M | Assignment FE/PPA/Matl for Status Management Initial Supply | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
21 | /ISDFPS/LES_INFD | LES Information: Change of Force Elements | 3 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPPurchasing |
22 | EKKO | Purchasing Document Header | 95 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPStructures Workbench |
23 | /ISDFPS/EQUIPLN | Materials Planned for Force Element (Serialized) | 3 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
24 | /ISDFPS/FORSUPLC | Control Data: Logistics | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
25 | /ISDFPS/MATPLN | Materials Planned for Force Element | 3 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
26 | /ISDFPS/RELFELOC | Infrastructure Material Storage Locations Supplied by FEs | 2 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |
TOPTransportation |
27 | VTRDI | Shipment Planning Index | 32 | FORCE_ID | Internal Key for Force Element | nvarchar | 32 | 0 | | |