New Assigned_Lot Table (in FI_Data)

item_id

string40

N

N

Identify item

lot_no

string40

N

N

Identify lot

sublot_no

string40

N

Y

Identify sublot; will be null if entire lot is assigned to the same work order

wo_id

string40

N

N

Work order to which this lot or sublot is assigned

oper_id

string40

N

Y

The operation of the specific job to which this lot or sublot is assigned, if any

seq_no

int32

N

Y

Identify the specific job to which this lot or sublot is assigned, if any

status

int32

N

N

Enumeration of the status of this lot in this work order or job:

0 = unstarted (default)

1 = in process

2 = done

spare1

string80

N

Y

Use defined by language term 5169

spare2

string80

N

Y

Use defined by language term 5170

spare3

string80

N

Y

Use defined by language term 5171

spare4

string80

N

Y

Use defined by language term 5172

last_edit_comment

string254

N

Y

Why this record was changed

last_edit_by

string40

N

N

Who last changed this record

created_by

string40

N

N

ID of user who created record

last_edit_at

tdatetime

N

N

When this record was last changed

created_at

tdatetime

N

N

When record created

row_id

ID 0

Y

N

Unique row identifier, for audit trail