About user-extended tables (UETs)

The user-extended tables (UET) feature gives system administrators 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.

This application comes with SQL tables that contain predetermined fields. Using the UET capability, you can add your 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 add your own fields to any form that uses the 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 extensible on that form.

When data is entered into pre-existing 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