attr
- Last UpdatedNov 20, 2024
- 2 minute read
The attr table holds user-defined attributes that may be assigned to various objects or entities in the system.
The predefined flag is set if the attribute must be assigned from a predefined set of values (as specified in the attr_set table).
The data_type field is used to aid display and editing of the attribute, and to determine left or right justification etc.
The attr_grp field is used to define which sets of attributes are available to different things in the system. Neither this table nor attr_set deal with system attributes.
Attribute IDs are not reused for various groups.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
predefined |
logical |
N |
N |
If yes must have set defined. Default = No. |
|
data_type |
int32 |
N |
N |
Enumeration to identify data type of attribute even though they are all stored as strings: 0 = string (<= 80 chars.) (default) 1 = drop down from values defined in attr_set table 2 = integer 3 = currency 4 = color 5 = datetime 6 = floating point number 7 = percent 8 = checkbox 9 = non-editable 10 = time of day 11 = item reason (only if attr_grp = 3) 12 = long string (> 80 chars.). May be extended in future. |
|
attr_desc |
string80 |
N |
N |
Attribute description; must be unique within a given attr_group. |
|
attr_grp |
int32 |
N |
N |
Enumeration of the group to which the attribute belongs: 1=Items 2=Entities 3=Lots 4=Item Classes 5=Jobs 6=WO 7=Operations 8=Processes 9=Sublot 10=(QM) Samples 11=(QM) Results 12=Line 13=Shift |
|
filtr |
string254 |
N |
Y |
To what situations does this attribute apply? e.g., for item reason attributes, this is a reason_grp_id. |
|
entry_type |
int32 |
N |
N |
Enumeration of type of entry to allow for this attribute: 0 (default) = value only, 1 = notes only, 2 = value and notes |
|
visible_in_queue |
logical |
N |
N |
Is this attribute to be visible in the queue of jobs? Default = No. May be Yes only if attr_grp = 1, 5, or 6 and entry_type is not 1 and data_type is not 12. |
|
visible_in_inv |
logical |
N |
N |
Is this attribute to be visible in the inventory? Default = No. May be Yes only if attr_grp = 1 or 3 and entry_type is not 1 and data_type is not 12. |
|
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 |
|
attr_id |
ID 1 |
Y |
N |
Attribute identifier |
attr_desc, attr_grp is UK.