Data Dictionary
>
FPSBASE Tables
> FPSBASE.WIP_MOVE_TYPES
Table FPSBASE.WIP_MOVE_TYPES"
List of FPS universal move types.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: MOVE_TYPE
-
Foreign keys: WIP_MOVE_TYPES_BG_COLOR_FK: BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MOVE_TYPE |
VARCHAR2(9) |
N |
Move_type is populated with a value in WIP_MOVE_TYPES (COMP, ISKIP, etc.) for all records where is_next = Y. It is null when the qty changes but is_next = N and these "delta only" records will always have a delta_type. Note that it is possible and not unusual to have both move_type and delta_type when the lot both moves and changes qty with the same event. (* from FPSBASE.WIP_STEP_HIST) |
|
BG_COLOR |
VARCHAR2(24) |
N |
Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS) |
|
DESCRIPTION |
VARCHAR2(256) |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |
|
|
IS_MOVE_IF_NOT_FROM_BANK |
CHAR(1) |
N |
|
|
MOVE_TYPE_DISPLAY |
VARCHAR2(18) |
N |