Data Dictionary
>
FPSBASE Tables
> FPSBASE.MHS_EXTERNAL_TRANSPORT_MODES
Table FPSBASE.MHS_EXTERNAL_TRANSPORT_MODES"
List of allowed transport modes that are used at the site. These modes are mapped to the standard FPSADMIN transport modes which are used by various applications.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: EXTL_TRANSPORT_MODE
-
Foreign keys: MHS_EXTERNAL_TRANSPORT_MODE_FK: TRANSPORT_MODE REFERENCES FPSADMIN.MHS_TRANSPORT_MODES (TRANSPORT_MODE)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
EXTL_TRANSPORT_MODE |
VARCHAR2(16) |
N |
Name of the site transport mode which represents how material is moved from one location to another. |
|
IS_DEFAULT |
CHAR(1) |
Is this transport mode the default mode if nothing is specified. |
|
|
TRANSPORT_MODE |
VARCHAR2(10) |
Name of the standard FPS transport mode which represents how material is moved from one location to another. |