New Queue_WO_Attr Table (in FI_Data)
- Last UpdatedDec 18, 2018
- 1 minute read
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
queue_wo_wo_id |
string40 |
Y |
N |
Identify work order whose attributes are to be displayed in the queue |
|
attr<attr_id> |
string80 |
N |
Y |
Value of the work order attribute whose ID is the numeric part of the field name following "attr" |
|
attr<attr_id>d_h |
string80 |
N |
N |
Description of the attribute whose ID is the numeric part of the field name following "attr" and preceding "d_h". This will be the same for every row |
|
... |
string80 |
N |
Y |
(additional pairs of rows per above, one for every item attribute where "visible_in_queue" is true) |
|
... |
string80 |
N |
N |
FK from queue_wo_wo_id to wo. (Cascade delete)