Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_MOVE_TYPES
Gets the move types to display on the dashboard
|
Column |
Comment |
|---|---|
|
MOVE_TYPE |
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. (* inherited from FPSBASE.WIP_STEP_HIST) |
|
MOVE_TYPE_DISPLAY |
|
|
SORT_ORDER |
This is used to sort within the grouping. SORT_ORDER always has a deferrable unique key to ensure uniqueness while allowing the user to make changes without erroring until the commit is attempted. Because of this you must be careful to not violate the unique key otherwise you will lose all of your edits. (* inherited from FPSINPUT.GEN_FACILITIES) |
|
HTML_BG_COLOR |
|
|
HTML_TEXT_COLOR |