bom_item_oper_link

parent_item_id

string40

Y

N

Identify item being made

ver_id

string40

Y

N

Version of BOM

bom_pos

int32

Y

N

BOM position – not necessarily sequential

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation in process

qty_per_parent_item

tfloat

N

N

Qty of item at this operation per unit of immediate parent item (<0 for byproducts)

reqd_start_pct

tfloat

N

N

Portion of this component (or of input quantity of item itself if bom_pos = 0) required before operation becomes READY. Default = 0.

def_reas_cd

int32

N

Y

Default consumption or production code for item. If null will default to value specified for BOM_item.

def_lot_no

string40

N

Y

Default lot number from which to consume. If null will default to the lot specified for BOM_item.

def_sublot_no

string40

N

Y

Default sublot number from which to consume. If null will default to the sublot specified for BOM_item.

def_storage_ent_id

int32

N

Y

Default storage entity to get component or put (by)product. If null will default to the storage entity specified for BOM_item.

def_reject_ent_id

int32

N

Y

Default storage entity for reject production items; if null use def_storage_ent_id

update_inv

logical

N

N

Update inventory table with item consumption? Default = No.

backflush

logical

N

N

Backflush consumption? Default = No.

must_consume_
from_inv

logical

N

N

Must consumption occur from inventory or not for this item? Default = No.

may_choose_alt_inv_loc

logical

N

N

May the user select alternate inventory locations when consuming or producing this item? Default = Yes.

may_create_new_lots

logical

N

N

May the user create new lots when consuming or producing this item? Only relevant if not consuming from inventory. Default = Yes.

must_consume_
from_wip

logical

N

N

Specifies whether the lots consumed during a job must be limited to those lots produced to the item_inv table for the same wo_id in an upstream job. Default = No.

must_consume_
before_prod

logical

N

N

To specify whether to prevent any production transactions until ‘acceptable’ quantities of BOM components have been consumed – as specified by the ‘max_qty_per_parent_item’ and ‘min_qty_per_parent_item’ fields (if not null). Default = No.

constant_qty

logical

N

N

To specify whether the quantities consumed of this item are independent of qty of parent item produced. Default = No.

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

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.