About User Extended Tables (UETs)

The User Extended Tables (UET) feature gives the system administrator the ability to extend existing application database tables and add custom user fields to forms in the application. Use this feature to keep track of information that is not currently in the application database schema.

Note: If you are using replication, you must click the Regenerate Replication Triggers button on the Replication Management form after UETs are changed, added, or deleted.

Tables are a systematic arrangement of data in records and fields for ready reference. The application comes with SQL tables that contain predetermined fields. With the UET feature, users can add their own fields to these tables.

Note: System administrators can use the Metadata Access Controls form to restrict access to application metadata and prevent users from altering core SQL tables. You cannot modify SQL tables that are set to in the Metadata Access Controls form. You can view SQL tables that are set to but you cannot modify them. You can view and modify SQL tables that are set to .

Once a table is extended, you can drop user fields into any application form that uses this table. If you bind a new component to a UET on a form that uses a custom load method stored procedure, an error message displays when you refresh the form. You can close the error message and continue. Only the primary table of the form's primary collection is extendible on that form.

When data is entered into preexisting fields, and if the rule expressions you defined for those fields are true, the events to arrange and display information in new custom user fields are triggered.

Reports

You can view information about UET user classes, user fields, user indexes, and user tables, on these reports:

Quick Dictionary Report
User Class Report
User Fields Report
User Index Report