EExpeUserAccess

Last updated
Save as PDF

EExpeUserAccess contains the user access information that is set in the Security block of each expense record. For example, it includes whether each user that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EExpeUserAccess (E_EXPE_USER_ACCESS)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments	Commonly used in:
								Rules	Temp/Wiz
isRead	IS_READ (NUMBER)	Read check box	x			int	Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected). This attribute does not determine whether the operations are allowed or denied. (See allow DenyIID.)
isUpdate	IS_ UPDATE (NUMBER)	Update check box	x			int	Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected). This attribute does not determine whether the operations are allowed or denied. (See allow DenyIID.)
isDelete	IS_DELETE (NUMBER)	Delete check box	x			int	Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected). This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)
isPerm	IS_PERM (NUMBER)	Perm check box	x			int	Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected). This attribute does not determine whether the operations are allowed or denied. (See allow DenyIID.)
allowDeny IID	ALLOW_ DENY_IID (NUMBER)	Option	x			char	Indicates whether the user is allowed or denied access to the record. a - Allow d - Deny
isManual	IS_ MANUAL (NUMBER)		x			boolean	Indicates whether the user rights were assigned manually through the Security block of the record or automatically by the system. 0 - Assigned manually 1 - Assigned automatically
owner-->	ENTERPRISE_ OBJECT_ ID (NUMBER)		x	x	Expense	object	8 The expense record with which this user access setting is associated. --> Links to the specific information about the expense record.
primary Key	PRIMARY_KEY (NUMBER)		x			int	Unique ID for the user access rights.
user-->	USER_ID (NUMBER	List	x	x	YUser	object	8 Specifies the user the access rights pertain to. --> Links to the specific information about the user account.
version	VERSION (NUMBER)		x			int	Indicates how many times the user access rights have been updated.