oper_ent_item_link

process_id

string40

Y

N

Identify process

oper_id

string40

Y

N

Identify operation for this process

ent_id

int32

Y

N

Entity on which operation could be done

item_id

string40

Y

N

Item produced in this operation

est_fixed_lab

tfloat

N

Y

Est. fixed labor hours – setup/cleanup

est_lab_rate

tfloat

N

Y

Est. variable labor batch time, depending on prod_uom.

est_setup_time

tfloat

N

Y

Est. entity hours for setup

est_teardown_time

tfloat

N

Y

Est. entity hours for teardown

est_prod_rate

tfloat

N

N

Est. entity batch rate or time, depending on prod_uom.

prod_uom

int32

N

N

Unit of measure for est_lab_rate and est_prod_rate:

0 = hours/batch (default)

1 = minutes/batch

2 = seconds/batch

3 = batches/hour

4 = batches/minute

5 = batches/second

batch_size

tfloat

N

N

Amount or number per batch (default = 1)

est_transfer_time

tfloat

N

Y

Transfer time after operation - hours

init_prod_pct

tfloat

N

Y

Specifies the initial production % required at this entity (if the first operation is done at multiple entities), null for other cases.

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