lot

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

tdatetime20

N

Y

Expiry date and time of this lot if not overridden for a sublot or a particular inventory record. This value is treated as static local time value, meaning that it does not change when moving from one time zone to another.

Note: This field is currently not used.

is_serial_no

logical

N

N

Yes if lot no is the serial no.; default no

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

Reserved for internal use to indicate 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 1

N

N

Unique row identifier, for audit trail