New Lot Table (in FI_Large)

item_id

string40

Y

N

Identify item

lot_no

string40

Y

N

Identify lot

grade_cd

int32

N

Y

Grade of this lot if not overridden for a sublot or a particular inventory record

status_cd

int32

N

Y

Status of this lot if not overridden for a sublot or a particular inventory record

expiry_date

tdatetime

N

Y

Expiry date of this lot if not overridden for a sublot or a particular inventory record

is_serial_no

logical

N

N

True if lot no is the serial no; default false

spare1

string80

N

Y

Use defined by language term 5173

spare2

string80

N

Y

Use defined by language term 5174

spare3

string80

N

Y

Use defined by language term 5175

spare4

string80

N

Y

Use defined by language term 5176

spare5

string80

N

Y

Use defined by language term 5177

spare6

string80

N

Y

Use defined by language term 5178

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