Data Dictionary
>
FPSBASE Tables
> FPSBASE.MNT_PARTS
Table FPSBASE.MNT_PARTS"
Current information on counter-based PMs based on information from EQP_MNT_FUTURE.
-
Schema: FPSBASE
-
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. |