!!Features of User Defined Columns

||Pro||Con
|End users can create these and no special knowledge of the system is required|The data is stored in an abstraction table and is not natively linked to the table it is related to.
|[Date Sensitive|DATE SENSITIVE] changes will carry forward the values|This abstraction has the potential, if there are a lot of user defined fields, to impact performance
|UserCalcs can read (not update) these values|Any use of a user defined field in any kind of processing (programming, where clauses, lists of values) is not recommended.  Instead, please consider the use of a [user defined column|USER DEFINED COLUMN]
|Workflow UserCalcs cannot access the NewValue of them|No change audit logging is available for UDFs
|Supported by [Object Security|IMOS] and [Form Object Security|IMFOS]|
|Interface programs like [UEEF] and [UPPHF] can access these natively, within the tables identified|
|Can be accessed using the [P2K_SMGETUDF] function by external report writers and by [P2K_SMPUTUDF] by stored procedures to set the value.|
|Does not require database access or system restart|

!!Setup and Use of a User Defined Column 
Use the [IMUF] screen to define the User Defined Field on the table you want the data related to.  Note that in a parent-child table relationship where there are date-sensitive children, the parent table is often not permitted to have user defined fields (as seen on [IMTD])


----
![Notes|Edit:Internal.USER DEFINED COLUMN]
[{InsertPage page='Internal.USER DEFINED COLUMN' default='Click to create a new notes page'}]