EHistDetail

Last updated
Save as PDF

EHistDetail contains all categories added to history records.

Each time a category is added to a history record, an entry is made in this table in the database.

In Object Navigator, EHistDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EHistDetail (E_HIST_DETAIL)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments	Commonly used in:
								Rules	Temp/Wiz
category-->	CATEGORY_ ID (NUMBER)	Category	x	x	YRecentlyViewedRecord	object	The category of the history with which the details are associated.
detailDate ValueList -->	n/a			x			Links to the information for history custom fields of type Date.
detail Memo ValueList-->	n/a			x			Links to the information for history custom fields of type Memo Text.
detailNumbValueList -->	n/a			x			Links to the information for history custom fields of type Number and Check Box.
detailObje ValueList -->	n/a			x			Links to the information for history custom fields of type List (drop-down or radio button lists).
detailObjf ValueList -->	n/a			x			Links to the information for history custom fields of type Custom Object.
detailText ValueList-- >	n/a			x			Links to the information for history custom fields of type Text.
owner-->	ENTERPRISE_ OBJECT_ ID (NUMBER)			x	THistory	object	The history with which the custom fields are associated.
isManual	IS_ MANUAL (NUMBER)		x			boolean	Specifies whether the category is added manually or automatically to the history. Categories are added automatically when they are the parent of the category that is added manually. 0 - Added Automatically 1 - Added Manually
primary Key	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the history category record.
version	VERSION (NUMBER)		x			int	Indicates how many times the added category was updated.