data-dictionary

FPSAPP.MNT_PARTS

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.