rework_process_usage
- Last UpdatedNov 20, 2024
- 2 minute read
The rework_process_usage table specifies rework behavior for a given item reason and rework code, and optionally a given manufacturing process and manufactured item. This includes which rework process to use, the maximum number of times rework is permitted for a particular group of production, and if rework is part of the original work order, the point at which the reworked material re-enters the normal routing.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
reas_cd |
int32 |
N |
N |
Reason entered for item, which necessitates rework |
|
orig_rework_cd |
string40 |
N |
N |
Rework code of the job(s) from which rework originates |
|
orig_process_id |
string40 |
N |
Y |
ID of the process of the work order from which rework originates; null (default) if rework requirements not differentiated by process |
|
item_id |
string40 |
N |
Y |
Identify item produced; null (default) if rework requirements not differentiated by item |
|
rework_process_id |
string40 |
N |
N |
Identify set of rework operations to be done |
|
max_times_rework |
int32 |
N |
Y |
How many times the smallest identifiable group of production may be reworked for this; null (default) if no limit. |
|
reentry_rework_cd |
string40 |
N |
Y |
Rework code of the next downstream job to which the material is to be returned once reworked, if rework is part of the original work order. If null (default), it is the very next job. |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
Y |
N |
Unique identifier for row (a job event) |
FK from reas_cd to item_reas. (Cascade delete)
FK from orig_process_id to process. (Cascade delete)
FK from item_id to item. (Cascade delete)
FK from rework_process_id to process. (Cascade delete implemented by SP)
reas_cd, orig_rework_cd, orig_process_id, item_id is UK.