Table idempiere9.adempiere.ad_role
Responsibility Role

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_role_id numeric 10
ad_alertrecipient.ad_role_id adrole_adaltertrecipient R
ad_broadcastmessage.ad_role_id adrole_adbroadcastmessage R
ad_column_access.ad_role_id adrole_adcolumnaccess R
ad_document_action_access.ad_role_id adrole_addocumentactionaccess R
ad_form_access.ad_role_id adrole_adformaccess C
ad_importtemplateaccess.ad_role_id adrole_adimporttemplateaccess R
ad_infowindow_access.ad_role_id adrole_adinfowindowaccess R
ad_package_exp_common.ad_role_id adrole_adpackageexpcommon R
ad_package_exp_detail.ad_role_id adrole_adpackageexpdetail R
ad_process_access.ad_role_id adrole_adprocessaccess C
ad_recentitem.ad_role_id adrole_adrecentitem C
ad_record_access.ad_role_id adrole_ardecordaccess R
ad_role_included.ad_role_id ad_role_included_parent C
ad_role_included.included_role_id ad_role_included_role R
ad_role_orgaccess.ad_role_id adrole_adroleorgaccess C
ad_schedulerrecipient.ad_role_id adrole_adschedulerrecipient R
ad_session.ad_role_id adrole_adsession R
ad_table_access.ad_role_id adrole_adtableaccess C
ad_task_access.ad_role_id adrole_adtaskaccess C
ad_toolbarbuttonrestrict.ad_role_id adrole_adtoolbarbuttonrestrict R
ad_user_roles.ad_role_id adrole_aduserroles C
ad_userdef_info.ad_role_id adrole_aduserdefinfo C
ad_userdef_proc.ad_role_id adrole_aduserdefproc C
ad_userdef_win.ad_role_id adrole_aduserdefwin R
ad_userquery.ad_role_id adrole_aduserquery C
ad_wf_responsible.ad_role_id adrole_adwfresponsible R
ad_window_access.ad_role_id adrole_adwindowaccess C
ad_workflow_access.ad_role_id adrole_adworkflowaccess C
cm_accesslistrole.ad_role_id adrole_cmalistrole C
pa_dashboardcontent.ad_role_id adrole_padashboardcontent R
pa_dashboardcontent_access.ad_role_id adrole_padashboardcontentacces R
pa_dashboardpreference.ad_role_id adrole_padashboardpreference R
pa_documentstatus.ad_role_id adrole_padocumentstatus C
pa_documentstatusaccess.ad_role_id adrole_padocumentstatusaccess C
pa_goal.ad_role_id adrole_pagoal R
r_request.ad_role_id adrole_rrequest R
r_requestaction.ad_role_id adrole_rrequestaction R
u_rolemenu.ad_role_id adrole_urolemenu R
ws_webservicetypeaccess.ad_role_id adrole_wswebservicetypeaccess R
Responsibility Role
ad_client_id numeric 10
ad_client.ad_client_id ad_roleclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id ad_roleorg R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
name varchar 60 Alphanumeric identifier of the entity
updatedby numeric 10 User who updated this records
description varchar 255  √  null Optional short description of the record
userlevel bpchar 3 ' O'::bpchar System Client Organization
c_currency_id numeric 10  √  null
c_currency.c_currency_id c_currency_ad_role R
The Currency for this record
amtapproval numeric 0  √  0 The approval amount limit for this role
ad_tree_menu_id numeric 10  √  null
ad_tree.ad_tree_id adtree_adrole R
Tree of the menu
ismanual bpchar 1 'Y'::bpchar This is a manual process
isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
ispersonallock bpchar 1 'N'::bpchar Allow users with role to lock access to personal records
ispersonalaccess bpchar 1 'N'::bpchar Allow access to all personal records
iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
supervisor_id numeric 10  √  null
ad_user.ad_user_id adusersupervisor_adrole R
Supervisor for this user/organization - used for escalation and approval
iscanapproveowndoc bpchar 1 'Y'::bpchar Users with this role can approve their own documents
isaccessallorgs bpchar 1 'N'::bpchar Access all Organizations (no org access control) of the client
ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
ad_tree_org_id numeric 10  √  null
ad_tree.ad_tree_id adtreeorg_adrole R
Trees are used for (financial) reporting and security access (via role)
confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
maxqueryrecords numeric 10 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
allow_info_account bpchar 1 'Y'::bpchar Allow Info Account
allow_info_asset bpchar 1 'Y'::bpchar Allow Info Asset
allow_info_bpartner bpchar 1 'Y'::bpchar Allow Info BPartner
allow_info_cashjournal bpchar 1 'N'::bpchar Allow Info CashJournal
allow_info_inout bpchar 1 'Y'::bpchar Allow Info InOut
allow_info_invoice bpchar 1 'Y'::bpchar Allow Info Invoice
allow_info_order bpchar 1 'Y'::bpchar Allow Info Order
allow_info_payment bpchar 1 'Y'::bpchar Allow Info Payment
allow_info_product bpchar 1 'Y'::bpchar Allow Info Product
allow_info_resource bpchar 1 'Y'::bpchar Allow Info Resource
allow_info_schedule bpchar 1 'Y'::bpchar Allow Info Schedule
userdiscount numeric 22,2  √  null UserDiscount
allow_info_mrp bpchar 1 'N'::bpchar Allow Info MRP
allow_info_crp bpchar 1 'N'::bpchar Allow Info CRP
isdiscountuptolimitprice bpchar 1 'N'::bpchar IsDiscountUptoLimitPrice
isdiscountallowedontotal bpchar 1 'N'::bpchar IsDiscountAllowedOnTotal
amtapprovalaccum numeric 0  √  null The approval amount limit for this role accumulated on a period
daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
ismenuautoexpand bpchar 1 'N'::bpchar If ticked, the menu is automatically expanded
ismasterrole bpchar 1 'N'::bpchar A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
isaccessadvanced bpchar 1  √  'N'::bpchar Access Advanced
roletype varchar 2  √  NULL::character varying Role Type

Table contained 5 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_role_id Primary key Asc ad_role_pkey
ad_role_uu Must be unique Asc ad_role_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.