Table: Custom Field Entity

Table: Custom Field Entity

Custom fields hold static information that needs to be updated manually. Use computation fields for information that needs automated updating.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
namevarchar(50)Entity name
descriptionvarchar(255)The description of the entity instance
typechar(100)Type of data stored in custom fieldcustomfield.type.*
auto_calculatechar(100)Autocalculate code for custom fieldcustomfield.autoCalculate.*
auto_calculate_operation_typechar(100)Autocalculate operation code for custom field
credit_report_enabledtinyint(1)Whether or not custom field will appear on a credit report1 - yes, 0 - no
requiredtinyint(1)Whether or not a field is requried to create an entity instance1 - yes, 0 - no
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
max_lengthsmallint(6)The maximum length of the value
searchabletinyint(1)Whether or not this custom field will be indexed for searching1 - yes, 0 - no
report_enabledtinyint(1)Whether or not this custom field can be used in a report1 - yes, 0 - no
archive_enabletinyint(1)Whether or not the entity is archivable1 - yes, 0 - no
summary_enabledtinyint(1)Whether or not the custom field is shown in the entity's summary section1 - yes, 0 - no
default_valuevarchar(255)The defualt value for the custom field
entity_typechar(100)Type of the associated entity
section_identifierchar(50)Identifier for the section for the custom field
display_orderint(11)Sort order used when displaying on the UI
select_optionstextEncoded options for a drop-down menu
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List