New Oper_Item_Spec Table (in FI_Data)
- Last UpdatedDec 18, 2018
- 2 minute read
Contains setup parameters specific to an operation being done which will produce or consume a specific item or an item from a specific item class. 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 |
|---|---|---|---|---|
|
process_id |
string40 |
Y |
N |
Identify process |
|
oper_id |
string40 |
Y |
N |
Identify operation |
|
step_no |
int32 |
Y |
N |
Identify step no. Default = -1 (not associated with a step) |
|
item_id |
string40 |
Y |
Y |
Identify item |
|
item_class_id |
string40 |
Y |
Y |
Identify item class |
|
ver_id |
string40 |
Y |
N |
Identify spec version |
|
spec_id |
string40 |
Y |
N |
Identify spec for operation |
|
spec_value |
string1700 |
N |
N |
Value for this spec |
|
assoc_file |
string254 |
N |
Y |
Associated file |
|
assoc_file_type |
string20 |
N |
Y |
Associated file’s type |
|
comments |
string1700 |
N |
Y |
Comments/instructions to operator |
|
min_value |
string80 |
N |
Y |
Minimum acceptable value for the spec. Default = null which means no minimum value defined. |
|
max_value |
string80 |
N |
Y |
Maximum acceptable value for the spec. Default = null which means no maximum value defined. |
|
access_level |
int32 |
N |
Y |
Required security access level for modifying this spec. Default = null which means no extra security defined (null has same meaning as value = 0). |
|
last_edit_comment |
string254 |
N |
Y |
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 0 |
N |
N |
Unique row identifier, for audit trail |
FK from process_id, oper_id, ver_id to oper_spec_ver. (Cascade delete)
FK from spec_id to spec. (Cascade delete)
FK from assoc_file_type to doc_type. (Inhibit delete)
FK from item_id to item. (Cascade delete)
FK from item_class_id to item_class. (Cascade delete)