job_bom

wo_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify operation

seq_no

int32

Y

N

Identify row in job table

bom_pos

int32

Y

N

BOM position

item_id

string40

N

N

Component item ID

reqd_grade_cd

int32

N

Y

Null=disabled, else specifies req’d grade code for BOM item

instruction

string1700

N

Y

Optional - Instruction

qty_per_parent_item

tfloat

N

N

Nominal qty of item required per unit of parent item

max_qty_per_parent_
item

tfloat

N

Y

Specifies the maximum acceptable quantity of this BOM component..

min_qty_per_parent_
item

tfloat

N

Y

Specifies the minimum acceptable quantity of this BOM component.

reqd_start_val

tfloat

N

N

Amount of this component (or of input quantity of item itself if bom_pos = 0) before job becomes READY. (Default = 0)

reqd_start_val_is_pct

logical

N

N

Yes if above amount is percent, No if absolute quantity. Default = Yes as it usually originates from bom_item_oper_link table.

update_inv

logical

N

N

Update inventory table with item consumption? Default = No.

backflush

logical

N

N

Backflush consumption? Default = No.

def_reas_cd

int32

N

Y

Default item reason code. If null will default to value specified for entity on which the job is run.

def_lot_no

string40

N

Y

Default lot from which to consume

def_sublot_no

string40

N

Y

Default sublot from which to consume

def_storage_ent_id

int32

N

Y

Default storage entity to get item (put byproduct)

def_reject_ent_id

int32

N

Y

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

scaling_factor

tfloat

N

Y

Scaling factor to get correct units from counts if counts are item dependent. Default = 1

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? 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. ‘Acceptable’ quantities or tolerances of each Bom component are 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.

est_time

tfloat

N

Y

Number of entity hours it ought to take to consume or produce this component, per unit of BOM_pos 0. Null for BOM_pos 0.

current_subst

int32

N

Y

Holds the alt_no of the currently-used substitute from job_BOM_subst. Null if not being substituted for.

qty_reqd

tfloat

N

Y

For disassembly only, the amount required for outputs. Used like job.qty_reqd is for assembly jobs where there’s only one product.

serial_no_source

logical

N

N

Yes if the produced item is to inherit its serial number from this component; default No.

spare1

string1000

N

Y

Use defined by language term 1819

spare2

string1000

N

Y

Use defined by language term 1820

spare3

string1000

N

Y

Use defined by language term 1821

spare4

string1000

N

Y

Use defined by language term 1822

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.