This is version 1 2 3 4 5 6 7 8 9 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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 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
Workflow UserCalcs cannot access the NewValue of them	No change audit logging is available for UDFs
Supported by Object Security and Form Object Security
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#

Click to create a new notes page