New Rework_Process_Usage Table (in FI_Data_2)

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 this 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

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 0

Y

N

Unique row identifier, for audit trail