ERP/2.50/Developers Guide/Database Model/org.openbravo.model.ad.access/AD Role
AD_Role
Define the role and add the client and organizations the role has access to. You can give users access to this role and modify the access of this role to windows, forms, processes and reports as well as tasks.
If the Role User Level is Manual, the as
Select Role for with Data Access Restrictions
- Name:ADRole
- Classname:Role
This table contains the following columns:
Name | Nullable | Data Type | Description |
AD_Role_ID | N | VARCHAR2(32) | The profile of security for the user defining what windows and tabs they can see. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
UserLevel | N | VARCHAR2(60) | System Client Organization |
ClientList | N | NVARCHAR2(2000) | Clients this Role can access |
OrgList | N | NVARCHAR2(2000) | List of Organizations this Role can access |
C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
AmtApproval | Y | NUMBER | The approval amount limit for this role |
AD_Tree_Menu_ID | Y | VARCHAR2(32) | Tree Menu |
IsManual | Y | CHAR(1) | A task or process completed directly by the user, not automatically by the application. |
Processing | Y | CHAR(1) | A request to process the respective document or task. |
IS_Client_Admin | N | CHAR(1) | null |
Other Info
Check constraints
These are the check constraints for this table:
- AD_ROLE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- AD_ROLE_ISCLIENTADMIN_CHECK: IS_CLIENT_ADMIN IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- AD_ROLE_KEY
- AD_ROLE_NAME_UN
Columns
Role
The Role determines security and access a user who has this Role will have in the System.
- Physical column name: AD_Role_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Name
A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
User Level
The User Level field determines if users of this Role will have access to System level data, Organization level data, Client level data or Client and Organization level data.
- Physical column name: UserLevel
- Property Name: userLevel
- Reference: List
List values: AD_Role User Level
The allowed values for this list are:
- O (Organization)
- C (Client)
- CO (Client+Organization)
- S (System)
Client List
Indicates the Clients (by client id) that this Role can access. Multiple Clients are delimited by a comma ','.
- Physical column name: ClientList
- Property Name: clientList
- Reference: String
- Default value: @AD_Client_ID@
Organization List
The Organization List indicates the Organizations (by organization id) that this Role can access. Multiple Organizations are delimited by a comma ','.
- Physical column name: OrgList
- Property Name: organizationList
- Reference: String
- Default value: @AD_Org_ID@
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
- Default value: @$C_Currency_ID@
Foreign key column to C_Currency table, (column: C_Currency_ID)
Approval Amount
The Approval Amount field indicates the amount limit this Role has for approval of documents.
- Physical column name: AmtApproval
- Property Name: approvalAmount
- Reference: Amount
Primary Tree Menu
- Physical column name: AD_Tree_Menu_ID
- Property Name: primaryTreeMenu
- Reference: Table
Foreign key column to AD_Tree table, (column: AD_Tree_ID)
Reference Table AD_Tree
Validation Rule AD_Tree Menu: Only menu items. With the following code:
AD_Tree.TreeType='MM'
Manual
The Manual check box indicates if the process will done manually.
- Physical column name: IsManual
- Property Name: manual
- Reference: YesNo
Process Now
When this field is set as 'Y' a process is being performed on this record.
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
ClientAdmin
Defines the role as an administrator of the client it belongs to.
- Physical column name: IS_Client_Admin
- Property Name: clientAdmin
- Reference: YesNo
- Default value: N
Related tables
Tables that link this table:
- ADAlert.Role
- ADAlertRecipient.Role
- ADColumnAccess.Role
- ADFormAccess.Role
- ADPreference.Visible at Role
- ADProcessAccess.Role
- ADRecordAccess.Role
- ADRoleOrganization.Role
- ADTableAccess.Role
- ADTaskAccess.Role
- ADUser.Default Role
- ADUserRoles.Role
- ADWindowAccess.Role
- ADWorkflowAccess.Role