rework_count
- Last UpdatedNov 20, 2024
- 1 minute read
The rework_count table maintains a count of the number of times a particular group of production has undergone a certain sort of rework, and thus whether further rework is allowable, as defined by rework_process_usage.max_times_rework. Fields by which rework is not differentiated (as determined by system attributes) are null.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
item_id |
string40 |
N |
N |
Identify item produced |
|
lot_no |
string40 |
N |
Y |
Lot number of the material requiring rework; would only be null if item to be reworked had no lot number |
|
sublot_no |
string40 |
N |
Y |
Sublot number requiring rework |
|
wo_id |
string40 |
N |
Y |
Identify work order of the job requiring rework |
|
oper_id |
string40 |
N |
Y |
Identify operation of the job requiring rework |
|
seq_no |
int32 |
N |
Y |
Identify row of the job requiring rework |
|
reas_cd |
int32 |
N |
Y |
Reason entered for item, which necessitates rework |
|
process_id |
string40 |
N |
Y |
Identify set of rework operations done |
|
times_rework |
int32 |
N |
N |
How many times this group of production has been reworked; default 0. |
|
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) |
item_id, lot_no, sublot_no, wo_id, oper_id, seq_no, reas_cd, process_id is UK.