Show/Hide Toolbars

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 allowDenyIID.)

 

 

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 allowDenyIID.)

 

 

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 allowDenyIID.)

 

 

allowDenyIID

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.

 

 

primaryKey

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.