EExpeDetail

Last updated
Save as PDF

EExpeDetail contains all categories added to expense records. Each time a category is added to an expense record, an entry is made in this table.

In Object Navigator, each table Category displays only categories belonging to the selected object. From each category, you can traverse to a table called Detail Fields, which displays only 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: EExpeDetail (E_EXPE_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	8 The category of the expense with which the details are associated. --> Links to the definition information of the category.
owner-->	ENTERPRISE_ OBJECT_ ID (NUMBER)			x	Expense	object	The expense with which the custom fields are associated.
isManual	IS_ MANUAL (NUMBER)		x			boolean	Specifies whether the category is added manually or automatically to the expense. 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 expense category record.
version	VERSION (NUMBER)		x			int	Indicates how many times the added category was updated.