Item

Before "notes":

• Add "sublot_no_format" (string40, nullable) as the default sublot number format for this item.

• Add "last_sublot_no" (string40, nullable) to record the last-used sublot number for this item.

• Add "serial_no_lvl" (int32, not nullable) to define the level of sublot or lot (if = 0) used to designate individual serial numbers (-1 for default for non-serialized parts).

• Add "max_sublot_size" (tfloat, nullable) to set the maximum size of a sublot.

• Add "max_order_size" (tfloat, nullable) to set the maximum starting quantity for a work order for this item.

• Add "min_trace_inv" (tfloat, nullable) to set the smallest amount of inventory maintained for a particular lot that is stored in an entity where indistinguishable_lots is true.

• Add "inv_unique_by_job" (logical, default false) to indicate whether item_inv records for this item should include wo_id, oper_id, and seq_no in their effective primary key, thus making inventory for this item unique by the job that produced it.