ad_role

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_role_id numeric 10 null
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_activity.ad_role_id adrole_adwfactivity 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
cof_access.ad_role_id Implied Constraint R
cof_c_bankintegration.ad_role_id adrole_cofcbankintegration C
cof_configovs.cof_role_id cofrole_cofconfigovs R
cof_restricaoacesso.cof_role_id cofrole_cofrestricaoacesso R
cof_rv_customization.ad_role_id Implied Constraint R
cof_rv_requestpartner.ad_role_id Implied Constraint R
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_documentstatusaccess.ad_role_id adrole_padocumentstatusaccess C
pa_goal.ad_role_id adrole_pagoal R
r_request.ad_role_id adrole_rrequest R
r_request_v.ad_role_id Implied Constraint 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
ad_client_id numeric 10 null
ad_client.ad_client_id ad_roleclient R
ad_org_id numeric 10 null
ad_org.ad_org_id ad_roleorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
name varchar 60 null
updatedby numeric 10 null
description varchar 255 √ null
userlevel bpchar 3 ' O'::bpchar
c_currency_id numeric 10 √ null
c_currency.c_currency_id c_currency_ad_role R
amtapproval numeric 0 √ 0
ad_tree_menu_id numeric 10 √ null
ad_tree.ad_tree_id adtree_adrole R
ismanual bpchar 1 'Y'::bpchar
isshowacct bpchar 1 'Y'::bpchar
ispersonallock bpchar 1 'N'::bpchar
ispersonalaccess bpchar 1 'N'::bpchar
iscanexport bpchar 1 'Y'::bpchar
iscanreport bpchar 1 'Y'::bpchar
supervisor_id numeric 10 √ null
ad_user.ad_user_id adusersupervisor_adrole R
iscanapproveowndoc bpchar 1 'Y'::bpchar
isaccessallorgs bpchar 1 'N'::bpchar
ischangelog bpchar 1 'N'::bpchar
preferencetype bpchar 1 'C'::bpchar
overwritepricelimit bpchar 1 'N'::bpchar
isuseuserorgaccess bpchar 1 'N'::bpchar
ad_tree_org_id numeric 10 √ null
ad_tree.ad_tree_id adtreeorg_adrole R
confirmqueryrecords numeric 10 0
maxqueryrecords numeric 10 0
connectionprofile bpchar 1 √ null
allow_info_account bpchar 1 'Y'::bpchar
allow_info_asset bpchar 1 'Y'::bpchar
allow_info_bpartner bpchar 1 'Y'::bpchar
allow_info_cashjournal bpchar 1 'N'::bpchar
allow_info_inout bpchar 1 'Y'::bpchar
allow_info_invoice bpchar 1 'Y'::bpchar
allow_info_order bpchar 1 'Y'::bpchar
allow_info_payment bpchar 1 'Y'::bpchar
allow_info_product bpchar 1 'Y'::bpchar
allow_info_resource bpchar 1 'Y'::bpchar
allow_info_schedule bpchar 1 'Y'::bpchar
userdiscount numeric 22,2 √ null
allow_info_mrp bpchar 1 'N'::bpchar
allow_info_crp bpchar 1 'N'::bpchar
isdiscountuptolimitprice bpchar 1 'N'::bpchar
isdiscountallowedontotal bpchar 1 'N'::bpchar
amtapprovalaccum numeric 0 √ null
daysapprovalaccum numeric 10 √ null
ad_role_uu varchar 36 √ NULL::character varying
ismenuautoexpand bpchar 1 'N'::bpchar
ismasterrole bpchar 1 'N'::bpchar
isaccessadvanced bpchar 1 √ 'N'::bpchar
cof_processing bpchar 1 √ NULL::bpchar
cof_rolelevel varchar 3 '100'::character varying
cof_processing2 bpchar 1 √ NULL::bpchar
roletype varchar 2 √ NULL::character varying
isclientadministrator bpchar 1 'N'::bpchar
predefinedcontextvariables varchar 4000 √ NULL::character varying

Indexes

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

Check Constraints

Constraint Name Constraint
ad_role_allow_info_mrp_check ((allow_info_mrp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_isclientadministrator_check ((isclientadministrator = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_ismasterrole_check ((ismasterrole = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_allow_info_crp_check ((allow_info_crp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_isaccessadvanced_check ((isaccessadvanced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_role_ismenuautoexpand_check ((ismenuautoexpand = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation