Data Dictionary
>
FPSAPP Tables
> FPSAPP.MNT_PARTS
Table FPSAPP.MNT_PARTS"
Current information on counter-based PMs based on information from EQP_MNT_FUTURE.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: PART_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
PART_ID |
VARCHAR2(64) |
N |
A unique identifier for the parts. |
|
PART_DISPLAY |
NVARCHAR2(1024) |
A more user-friendly way of displaying the parts, could possible also be the name or the Part_ID. |
|
|
QTY_AVAIL |
NUMBER(12) |
How many of any part is available at this point in time. |