Minimum Version Required: 22.01
Fields And Definitions
What is a Custom Table?
Encompass has hundreds of tables that are part of the core software solution. Sometimes a business might find a need to store a set of data in a table that doesn't exist as part of that core solution; this is where Custom Tables come in. Launch the Create a Custom Table Help Resource to walk through the process of creating your own tables to meet your business needs.
Custom Table Properties
Custom Tables can be created with the following properties:
Table Name
View/Edit/Delete Permissions
Column Sequence
Multi-column Indices
Required Fields
Referenced Fields (Table Joins)
Table Maps Tool
Once a Custom Table has been created, use the Table Map tool to modify Table Properties:
Change the Table Name
Change the Default Records Shown
Delete the Custom Table
Modify Add/Edit/Delete Permissions
And modify Column Properties:
Column Name
Data Type
Max Length
View/ Edit Permissions
Required (True or False)
Display By Default (True or False)
Sort (Ascending or Descending)
Values and Default Value
Reference Table
Best Practices
Use integers over strings for unique keys
Use the smallest data type possible for each field