system_attr

attr_id

int32

Y

N

System attribute identifier

attr_desc

string80

N

N

System attribute description

attr_value

string80

N

N

System attribute value

grp_id

int32

N

N

Specify to which group this system attribute belongs

attr_seq

int32

N

N

Specify sequence of displaying and editing the attribute within a group

edit_type

int32

N

N

Enumeration of the type of data this attribute contains, and thus how to edit the attribute; same coding as in attr.data_type, plus 13 for values to be indirectly selected from a table.

attr_constraints

string254

N

Y

Extra editing data e.g., set of values for DDLB, or min / max values etc. If edit_type is 13, format is "table_name:display_field_name:
value_field_name{:where_clause}"

reqd_lic

string1700

N

Y

Which licenses are required for this system attribute to be editable. Format is one or more product numbers joined by "+" for AND or "|"’for OR, evaluated left to right.

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