Description
Contains detailed information on custom fields.
Dependencies
Columns
CustomFieldNbr : smallint, allows null: no
The number of the custom field (1 through 90).
DateCreated : datetime, allows null: no, default: Current date and time
The date and time when the custom field was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no, default: Current date and time
The date and time when the custom field was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EntityCode : varchar (max 100 chars), allows null: no
The module where the custom field is used.
You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.
FieldId : int, allows null: no, default: auto generated
The unique identifier of the field.
FieldName : varchar (max 30 chars), allows null: no
The name of the custom field.
FieldRule : varchar (max 500 chars), allows null: yes
The column is reserved for system use only.
FieldSize : smallint, allows null: no
The size of the defined custom field.
FieldType : varchar (max 30 chars), allows null: no
The type of the custom field: Check Box, Look Up, Date, Numeric, Phone, SSN, Text, and so on.
GroupId : int, allows null: no, default: (0)
The ID of the project where the custom field is used.
IsInternalUseOnly : varchar (max 1 char), allows null: yes, default: N
The column is reserved for system use only.
IsRequired : char (max 1 char), allows null: no, default: N
Indicates whether the custom field is required.
LookupName : varchar (max 100 chars), allows null: yes
A reference label for the Validations Table table used for choice lists. The value of the LookupName column equals the value of the Code column of the corresponding record in the Validations table.
UpdateUserId : int, allows null: no
The ID of the user who last updated the custom field definition.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the custom field definition, in the Last name, First name format.