UIItem Table

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for UIItem table

Database Column

Details

UIItemID

Type: integer. Key. Generated ID

TargetTypeID

Type: integer. Key

Type of object. Foreign key to the TargetType table.

ItemResourceName

Type: text (max 256 characters). Key

Name of the item

ItemName

Type: text (max 256 characters)

Name of the item

UIFieldTypeID

Type: integer. Nullable

UI field type if the elemet type is of type ‘field’. Foreign key to the UIFieldType table.

UIInsertTypeID

Type: integer

Insert type. Foreign key to UIInsertType table.

UIAlignmentTypeID

Type: integer. Nullable

Alignment type. Foreign key to UIAlignmentType table.

TabName

Type: text (max 80 characters)

Name of the object to place the UI item.

RelativePositionTo

Type: text (max 80 characters)

Name of the object to place the UI item.

Position

Type: integer

Width

Type: integer

DataSource

Type: XML. Nullable

Date source for item of element type ‘field’ and of field type combo box . .

SequenceNumber

Type: integer

Sequence where items to be added into UI

FromTable

Type: text. Nullable

The name of the database table where the field can be found.

SelectName

Type: text. Nullable

The name of the field in the database.

WhereClause

Type: text. Nullable

The SQL “WHERE” statement that limits the information returned.

Required

Type: boolean

Is the field a mandatory field.

StringLength

Type: integer

String length.

ReadOnly

Type: boolean

Is the field a readonly field.