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

job_bom_step

  • Last UpdatedNov 20, 2024
  • 1 minute read

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

Field

Datatype

PK

Nulls?

Description

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

step_no

int32

Y

N

Identify step

qty_per_parent_

item

tfloat

N

N

Qty of item per unit of parent item (<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 wo_id, oper_id, seq_no, bom_pos to job_bom. (Cascade delete)

FK from wo_id, oper_id, seq_no, step_no to job_step. (Cascade delete implemented by SP)

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