New Sublot Table (in FI_Large)

item_id

string40

Y

N

Identify item

lot_no

string40

Y

N

Lot to which this sublot ultimately belongs; same as parent if lvl = 1

sublot_no

string40

Y

N

Identify this sublot

parent

string40

N

N

Identify lot or sublot that is the parent of this one

lvl

int32

N

N

Level of this sublot; 1 if parent is a lot, else > 1

grade_cd

int32

N

Y

Grade of this sublot if not overridden for a lower-level sublot or a particular inventory record

status_cd

int32

N

Y

Status of this sublot if not overridden for a lower-level sublot or a particular inventory record

expiry_date

tdatetime

N

Y

Expiry date of this sublot if not overridden for a lower-level sublot or a particular inventory record

is_serial_no

logical

N

N

Yes if sublot no is the serial no; default no

spare1

string80

N

Y

Use defined by language term 5179

spare2

string80

N

Y

Use defined by language term 5180

spare3

string80

N

Y

Use defined by language term 5181

spare4

string80

N

Y

Use defined by language term 5182

spare5

string80

N

Y

Use defined by language term 5183

spare6

string80

N

Y

Use defined by language term 5184

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