Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.WIP_DELTA_TYPES
Table FPSINPUT.WIP_DELTA_TYPES"
List of FPS universal delta types. Please note that if delta_type is null in WIP_STEP_HIST that the qty did not change
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: DELTA_TYPE
-
Foreign keys: WIP_DELTA_TYPES_BG_COLOR_FK: BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
DELTA_TYPE |
VARCHAR2(12) |
N |
Delta_type is the reason why the qty changed. It is populated with a value in WIP_DELTA_TYPES (SCRAP, SPLIT, etc.) for all records where qty_delta != 0. It is null for normal moves where is_next = Y and the qty does not change. The logic to populate this is in WIP_STEP_HIST_INSERT_BEF. |
|
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) |
|
DELTA_TYPE_DISPLAY |
VARCHAR2(20) |
N |
|
|
DESCRIPTION |
VARCHAR2(256) |
Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS) |