item_reas_grp
- Last UpdatedNov 20, 2024
- 1 minute read
The item_reas_grp table defines groups of reasons for rejects/scrap, to help organize their display.
Hidden groups are usually used by automatic collection mechanisms and not displayed to users for manual selection. Production and Consumption group types are used to filter the selection of production and consumption codes. Waste types are used to filter reason selections for reject or waste entry.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
reas_grp_desc |
string80 |
N |
N |
Description of reason group, must be unique |
|
reas_grp_type |
int32 |
N |
N |
Enumeration of reason group type: 0 = hidden 1 = production 2 = consumption 3 = waste (default) |
|
display_seq |
int32 |
N |
N |
Specifies the display sequence of item reason groups |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
reas_grp_id |
ID 1 |
Y |
N |
Identify reason group |
reas_grp_desc is UK.