bom_item_oper_spec
- Last UpdatedNov 20, 2024
- 2 minute read
The bom_item_oper_spec table contains setup parameters specific to a BOM item being added at an operation, independent of the entity on which this occurs. The data may be downloaded from the ERP system if it maintains this data, or it may be maintained within our database if necessary. The data can be displayed on the shop floor or automatically downloaded to a PLC or equivalent when a job is started.
The step_no field is used to allow a spec to optionally be linked to a step. This field is set = –1 for specs that apply to the operation as a whole and not any specific step.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
item_id |
string40 |
Y |
N |
The ID of the item being made. |
|
ver_id |
string40 |
Y |
N |
The BOM version ID. |
|
BOM_pos |
int32 |
Y |
N |
The BOM position. |
|
process_id |
string40 |
Y |
N |
The ID of the process in which the item is being made. |
|
oper_id |
string40 |
Y |
N |
The ID of the operation in which the item is being made. |
|
step_no |
int32 |
Y |
N |
The number of the step in which the item is being made. Default = –1 (not associated with a step). |
|
spec_ver_id |
string40 |
Y |
N |
The spec version ID. |
|
spec_id |
string40 |
Y |
N |
The ID of the spec for the operation. |
|
spec_value |
string1700 |
N |
N |
The value for the spec. |
|
assoc_file |
string254 |
N |
Y |
The path and file name of the file that is associated with the spec. |
|
assoc_file_type |
string254 |
N |
Y |
The file type of the file that is associated with the spec. This value is entered internally, based on the file extension of the file specified in the assoc_file field. |
|
comments |
string1700 |
N |
Y |
Comments or instructions for the operator regarding the spec. |
|
min_value |
string80 |
N |
Y |
Minimum acceptable value for the spec. Default = null, which means no minimum value is defined. |
|
max_value |
string80 |
N |
Y |
Maximum acceptable value for the spec. Default = null, which means no maximum value is defined. |
|
access_level |
int32 |
N |
Y |
The minimum user security level required to modify the spec. Default = null, which means no extra security is defined (null has same meaning as user level = 0). |
|
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 item_id, ver_id, bom_pos to bom_item. (Cascade delete)
FK from process_id, oper_id, spec_ver_id to oper_spec_ver. (Cascade delete)
FK from spec_id to spec. (Cascade delete)