InternalFields


Description

Internal field definitions that define system-internal fields and metadata used for application processing, workflow management, and internal data operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AccessLevel Unknown 0 null

Access level - Required access level to view or modify this field

FieldId Unknown 0 null

Primary key - InternalFields unique identifier for each internal field

FieldName Unknown 0 null

Field name - Name of the internal field

FieldPurpose Unknown 0 null

Field purpose - Purpose or function of the internal field

FieldType Unknown 0 null

Field type - Data type of the internal field

icsID int identity 4 null

Reference identifier - Foreign key reference to related entity or lookup table

icsFieldDescrip varchar 50 null

Description field - Detailed description or explanation of InternalFields information

IsSystemField Unknown 0 null

System field flag - Whether this is a core system field

Indexes

Constraint Name Type Sort Column(s)
PK__InternalFields__54D68207 Primary key Asc icsID

Relationships