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.