oper_type
- Last UpdatedNov 20, 2024
- 1 minute read
Note: This table is currently not used.
The oper_type table supplies a set of possible oper_types for oper records, and default time standards and batch size for their related oper_ent_link records.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
oper_type |
string80 |
Y |
N |
Possible operation type |
|
oper_type_desc |
string80 |
N |
Y |
Description of operation type |
|
est_fixed_lab |
tfloat |
N |
Y |
Default fixed labor hours – setup/cleanup |
|
est_lab_rate |
tfloat |
N |
Y |
Default variable labor batch time, depending on prod_uom. |
|
est_setup_time |
tfloat |
N |
Y |
Default entity hours for setup |
|
est_teardown_time |
tfloat |
N |
Y |
Default entity hours for teardown |
|
est_prod_rate |
tfloat |
N |
Y |
Default 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 |
Y |
Default batch size |
|
est_transfer_time |
tfloat |
N |
Y |
Default transfer time after operation - hours |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
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 |