Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

bom_item_oper_step_link

  • Last UpdatedNov 20, 2024
  • 1 minute read

The bom_item_oper_step_link table specifies the required quantities of each component item required at each step of each operation to complete a single unit of the parent item.

Field

Datatype

PK

Nulls?

Description

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, but tied to a tag

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation in process

step_no

int32

Y

N

Identify step of operation

qty_per_parent_

item

tfloat

N

N

Nominal qty of item per unit of immediate parent item for this step (<0 for byproducts)

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

FK from parent_item_id, ver_id, bom_pos, process_id, oper_id to bom_item_oper_link. (Cascade delete)

Related Links
TitleResults for “How to create a CRG?”Also Available in