item

item_id

string40

Y

N

Uniquely identify item

item_desc

string80

N

N

Description of item

item_class_id

string40

N

N

Identify item class

uom_id

int32

N

N

Units of measure for item

template

logical

N

N

Yes = generic

No = real manufacturable part (the default)

lifetime

int32

N

Y

Lifetime of item before expiry in days; if null, never expires

unit_cost

tfloat

N

Y

Optional cost of acquisition per unit

obsolete

logical

N

N

Default = No.

purchased

logical

N

N

Is this item purchased? Default = No.

sold

logical

N

N

Is this item sold? Default = Yes.

num_decimals

int32

N

N

Default = 7.

must_complete_steps

logical

N

N

If Yes, when producing this item, require all steps to be completed/bypassed to end job, regardless of job_exec setting. Default = No.

must_prod_reqd_qty

logical

N

N

If Yes, when producing this item, qty_prod must be at least = qty_reqd to end job, regardless of job_exec setting. Default = No.

min_grade

int32

N

Y

Lowest grade considered shippable.

min_state

int32

N

Y

Lowest state considered shippable.

min_inv_level

tfloat

N

Y

The overall amount of this item in inventory below which a replnishment order should be generated.

reorder_amt

tfloat

N

Y

The minimum quantity of the replenishment order.

auto_reorder

logical

N

N

Whether the replenishment order should be generated automatically. Default = No.

lot_no_format

string40

N

Y

Lot number format

last_lot_no

string40

N

Y

Last lot number assigned to this item

max_lot_size

tfloat

N

Y

Maximum size of a lot of this item, in uom_id units. If 1.0, this item is essentially serialized, as each unit of production will have its own lot number.

sublot_no_format

string40

N

Y

Sublot number format

last_sublot_no

string40

N

Y

Last sublot number assigned to this item

serial_no_lvl

int32

N

N

0 if lot_no is the serial number,> 0 if a particular sublot level is the serial number, and -1 (default) if there are no serial numbers

max_sublot_size

tfloat

N

Y

Maximum size of a sublot of this item, in uom_id units. If 1.0, this item is essentially serialized, as each unit of production will have its own sublot number.

max_order_size

tfloat

N

Y

The largest starting quantity for a work order for this item.

min_trace_inv

tfloat

N

Y

The minimum amount of inventory of a particular lot that will be maintained in a storage entity where indistinguishable_lots is true; lesser amounts will be merged into another lot of the same item in the same location.

inv_unique_by_job

logical

N

N

If Yes, item_inv records for this item include wo_id, oper_id, and seq_no in their effective PK; default = No

notes

nvarchar(max)

N

Y

Notes about this item

spare1

string80

N

Y

Use defined by language term 521

spare2

string80

N

Y

Use defined by language term 522

spare3

string80

N

Y

Use defined by language term 523

spare4

string80

N

Y

Use defined by language term 524

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

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.