Role
AD_Role
Responsibility Role
Overview
| Table Name | AD_Role |
|---|---|
| Access Level | System + Client |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Tree_Menu |
| Wiki | View on iDempiere Wiki |
Columns (63)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Tree_Menu_ID |
Table(22) | No | - | Tree of the menu |
AIAccessLevel |
List(1) | Yes | N | - |
AllowChangeLimitPrice |
Yes-No(1) | No | N | Allow Change Limit Price on Documents |
AmtApprovalAccum |
Amount(22) | No | - | The approval amount limit for this role accumulated on a period |
BusinessFunction |
List(2) | No | - | The Business function determines system wide business context |
DashboardAccessLevel |
List(1) | Yes | A | Dashboard Access Level determines the visibility of dashboards based on your role and assignments. |
DaysApprovalAccum |
Integer(10) | No | - | The days approval indicates the days to take into account to verify the accumulated approval amount. |
InvoiceTaxValidation |
List(3) | No | - | Enables tax consistency check during invoice processing |
IsAccessAdvanced |
Yes-No(1) | No | Y | - |
IsAccessAllOrgs |
Yes-No(1) | Yes | N | Access all Organizations (no org access control) of the tenant |
isAllowDefinePOListPrice |
Yes-No(1) | No | N | When selected, then user can define specific PO ListPrice on Purchase Product - List Price can be different from PO Price field |
IsCanApproveOwnDoc |
Yes-No(1) | Yes | - | Users with this role can approve their own documents |
IsCanExport |
Yes-No(1) | Yes | Y | Users with this role can export data |
IsCanReport |
Yes-No(1) | Yes | Y | Users with this role can create reports |
IsChangeLog |
Yes-No(1) | Yes | N | Maintain a log of changes |
IsClientAdministrator |
Yes-No(1) | Yes | N | This role is a tenant administrator |
IsDMSAdmin |
Yes-No(1) | No | N | - |
IsDMSSignSupport |
Yes-No(1) | No | N | Allow Save Signature In DMS Upload Dialog |
IsManual |
Yes-No(1) | Yes | Y | This is a manual process |
IsMasterRole |
Yes-No(1) | Yes | N | A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles |
IsMenuAutoExpand |
Yes-No(1) | Yes | N | If ticked, the menu is automatically expanded |
IsPersonalAccess |
Yes-No(1) | Yes | N | Allow access to all personal records |
IsPersonalLock |
Yes-No(1) | Yes | N | Allow users with role to lock access to personal records |
IsShowAcct |
Yes-No(1) | Yes | N | Users with this role can see accounting information |
OrderTaxValidation |
List(3) | No | - | Enables tax consistency check during order processing |
OverwritePriceLimit |
Yes-No(1) | Yes | N | Overwrite Price Limit if the Price List enforces the Price Limit |
PA_Dashboard_ID |
Table Direct(22) | No | - | - |
PreferenceType |
List(1) | Yes | O | Determines what preferences the user can set |
RoleLicence |
List(3) | Yes | - | Determines what Role Licences the user can set |
RoleType |
List(2) | Yes | ZK | - |
Supervisor_ID |
Search(22) | No | - | Supervisor for this user/organization - used for escalation and approval |
WarningOnPriceLimit |
Yes-No(1) | No | N | Warn User when Sales Price is Under Price Limit and Price List enforces the Price Limit |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
UserDiscount |
Number(22) | No | - | - |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
AD_Role_ID |
ID(22) | Yes | - | Responsibility Role |
AD_Role_UU |
String(36) | No | - | - |
AD_Tree_Org_ID |
Table(10) | No | - | Tree to determine organizational hierarchy |
Allow_Info_Account |
Yes-No(1) | Yes | Y | - |
Allow_Info_Asset |
Yes-No(1) | Yes | Y | - |
Allow_Info_BPartner |
Yes-No(1) | Yes | Y | - |
Allow_Info_InOut |
Yes-No(1) | Yes | Y | - |
Allow_Info_Invoice |
Yes-No(1) | Yes | Y | - |
Allow_Info_Order |
Yes-No(1) | Yes | Y | - |
Allow_Info_Payment |
Yes-No(1) | Yes | Y | - |
Allow_Info_Product |
Yes-No(1) | Yes | Y | - |
Allow_Info_Resource |
Yes-No(1) | Yes | Y | - |
Allow_Info_Schedule |
Yes-No(1) | Yes | Y | - |
AmtApproval |
Amount(22) | No | - | The approval amount limit for this role |
C_Currency_ID |
Table Direct(22) | No | @$C_Currency_ID@ | The Currency for this record |
ConfirmQueryRecords |
Integer(10) | Yes | 0 | Require Confirmation if more records will be returned by the query (If not defined 500) |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsDiscountAllowedOnTotal |
Yes-No(1) | Yes | - | - |
IsDiscountUptoLimitPrice |
Yes-No(1) | Yes | - | - |
IsUseUserOrgAccess |
Yes-No(1) | Yes | N | Use Org Access defined by user instead of Role Org Access |
MaxQueryRecords |
Integer(10) | Yes | 0 | If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
UserLevel |
List(3) | Yes | - | System Tenant Organization |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Tree_Menu_ID |
AD_Tree_Menu.AD_Tree_Menu_ID | Tree of the menu |
PA_Dashboard_ID |
PA_Dashboard.PA_Dashboard_ID | - |
Supervisor_ID |
Supervisor.Supervisor_ID | Supervisor for this user/organization - used for escalation and approval |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_Tree_Org_ID |
AD_Tree_Org.AD_Tree_Org_ID | Tree to determine organizational hierarchy |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
Generated on 2026-05-03T18:02:46.838791526Z