item_process_link
- Last UpdatedNov 20, 2024
- 1 minute read
The item_process_link table specifies the process(es) used to produce a particular item. For a given item_id the item_pref field specifies the preferred process to make that item. This is useful when instantiating work orders when the data from the ERP system may only specify the item.
The ‘status’ field has exactly the same meaning as the process_status field in the process table. The difference is that in this table this status applies to the process "as used by this item", which thus allows us to have the same process with different statuses for different items.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
item_id |
string40 |
Y |
N |
Identify item to be made |
|
process_id |
string40 |
Y |
N |
Identify process to make it |
|
item_pref |
int32 |
N |
N |
Starts at 1; process with lowest number is the preferred one. |
|
status |
int32 |
N |
N |
Enumeration of the status of this combination: -1 = Disabled 1 = Experimental (default) 2 = Approved 3 = Certified |
|
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 |
item_id, item_pref is UK.
FK from item_id to item. (Cascade delete)
FK from process_id to process. (Cascade delete)