New Sublot_Attr Table (in FI_Data)

item_id

string40

Y

N

Identify item

lot_no

string40

Y

N

Lot to which this sublot ultimately belongs

sublot_no

string40

Y

N

Identify sublot

attr_id

int32

Y

N

Identify attribute

attr_value

string1700

N

Y

Value for this combination

notes

notes

N

Y

Notes for this combination

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

N

N

Unique row identifier, for audit trail