New Rework_Count Table (in FI_Data)

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 job requiring rework

oper_id

string40

N

Y

Identify operation of job requiring rework

seq_no

int32

N

Y

Identify sequence number of 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 for this; default 0.

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