Table idempiere11.adempiere.ad_user
User within the system - Internal or Business Partner Contact

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_user_id numeric 10
a_asset.ad_user_id aduser_aasset R
a_asset_change.ad_user_id aduser_aassetchange R
a_asset_delivery.ad_user_id aduser_aassetdelivery R
a_asset_group_trl.createdby createdby_aassetgrouptrl R
a_asset_group_trl.updatedby updatedby_aassetgrouptrl R
a_registration.ad_user_id aduser_aregistration R
ad_alertprocessor.supervisor_id aduser_calertprocessor R
ad_alertrecipient.ad_user_id aduser_adalertrecipient R
ad_attachmentnote.ad_user_id aduser_adattachmentnote R
ad_authorizationaccount.ad_user_id aduser_adauthorizationaccount R
ad_broadcastmessage.ad_user_id aduser_adbroadcastmessage R
ad_broadcastmessage_trl.createdby createdby_adbroadcastmessagetr R
ad_broadcastmessage_trl.updatedby updatedby_adbroadcastmessagetr R
ad_chart_trl.createdby createdby_adcharttrl R
ad_chart_trl.updatedby updatedby_adcharttrl R
ad_color_trl.createdby createdby_adcolortrl R
ad_color_trl.updatedby updatedby_adcolortrl R
ad_ctxhelpsuggestion.ad_user_id aduser_adctxhelpsuggestion R
ad_fieldsuggestion.ad_user_id aduser_adfieldsuggestion R
ad_importtemplate.createdby createdby_adimporttemplate R
ad_importtemplate.updatedby updatedby_adimporttemplate R
ad_importtemplateaccess.createdby createdby_adimporttemplateacce R
ad_importtemplateaccess.updatedby updatedby_adimporttemplateacce R
ad_inforelated.createdby createdby_adinforelated R
ad_inforelated.updatedby updatedby_adinforelated R
ad_label_trl.createdby createdby_adlabeltrl R
ad_label_trl.updatedby updatedby_adlabeltrl R
ad_labelcategory_trl.createdby createdby_adlabelcategorytrl R
ad_labelcategory_trl.updatedby updatedby_adlabelcategorytrl R
ad_ldapaccess.ad_user_id aduser_adldapaccess R
ad_ldapprocessor.supervisor_id aduser_adldapprocessor R
ad_modelgeneratortemplate.createdby createdby_admodelgeneratortemp R
ad_modelgeneratortemplate.updatedby updatedby_admodelgeneratortemp R
ad_note.ad_user_id aduser_adnote R
ad_orginfo.supervisor_id aduser_adorginfo N
ad_password_history.ad_user_id aduser_adpasswordhistory R
ad_password_history.createdby createdby_adpasswordhistory R
ad_password_history.updatedby updatedby_adpasswordhistory R
ad_pinstance.ad_user_id aduser_pinstance R
ad_postit.createdby createdby_adpostit R
ad_postit.updatedby updatedby_adpostit R
ad_preference.ad_user_id ad_user_preference R
ad_printcolor_trl.createdby createdby_adprintcolortrl R
ad_printcolor_trl.updatedby updatedby_adprintcolortrl R
ad_private_access.ad_user_id aduser_adprivateaccess R
ad_recentitem.ad_user_id aduser_adrecentitem C
ad_reportview_column.createdby createdby_adreportviewcolumn R
ad_reportview_column.updatedby updatedby_adreportviewcolumn R
ad_role.supervisor_id adusersupervisor_adrole R
ad_scheduler.supervisor_id aduser_adscheduler R
ad_schedulerrecipient.ad_user_id aduser_adschedulerrecipient R
ad_statusline.createdby createdby_adstatusline R
ad_statusline.updatedby updatedby_adstatusline R
ad_statuslineusedin.createdby createdby_adstatuslineusedin R
ad_statuslineusedin.updatedby updatedby_adstatuslineusedin R
ad_tab_customization.ad_user_id aduser_adtabcustomization C
ad_tree_favorite.ad_user_id aduser_adtreefavorite R
ad_treebar.ad_user_id aduser_adtreebar C
ad_user.salesrep_id salesrep_aduser R
ad_user.supervisor_id aduser_supervisor R
ad_user_orgaccess.ad_user_id aduser_aduserorgaccess R
ad_user_roles.ad_user_id aduser_userroles C
ad_user_substitute.ad_user_id aduser_adusersub C
ad_user_substitute.substitute_id adusersub_ad_usersub C
ad_userbpaccess.ad_user_id aduser_aduserbpaccess C
ad_userdef_info.ad_user_id aduser_aduserdefinfo R
ad_userdef_proc.ad_user_id aduser_aduserdefproc R
ad_userdef_win.ad_user_id aduser_aduserdefwin R
ad_usermail.ad_user_id aduser_adusermail C
ad_userpreference.ad_user_id aduser_aduserpreference C
ad_userpreference.createdby createdby_aduserpreference R
ad_userpreference.updatedby updatedby_aduserpreference R
ad_userquery.ad_user_id aduser_aduserquery C
ad_verifymigration.createdby createdby_adverifymigration R
ad_verifymigration.updatedby updatedby_adverifymigration R
ad_wf_activity.ad_user_id aduser_adwfactivity N
ad_wf_activityapprover.ad_user_id aduser_adwfactivityapprover R
ad_wf_eventaudit.ad_user_id aduser_adwfeventaudit R
ad_wf_process.ad_user_id aduser_adwfprocess R
ad_wf_responsible.ad_user_id aduser_adwfresponsible R
ad_wizardprocess.ad_user_id aduser_adwizardprocess R
ad_wlistbox_customization.ad_user_id aduser_adwlistboxcustomization R
ad_workflowprocessor.supervisor_id aduser_adworkflowprocessor R
b_bid.ad_user_id aduser_bbid R
b_bidcomment.ad_user_id aduser_bidcomment R
b_buyer.ad_user_id aduser_bbuyer R
b_buyerfunds.ad_user_id aduser_bbuyerfunds R
b_offer.ad_user_id aduser_boffer R
b_seller.ad_user_id aduser_bseller R
b_sellerfunds.ad_user_id aduser_bsellerfunds R
c_acctprocessor.supervisor_id aduser_cacctprocessor R
c_activity_trl.createdby createdby_cactivitytrl R
c_activity_trl.updatedby updatedby_cactivitytrl R
c_addresstransaction.createdby createdby_caddresstransaction R
c_addresstransaction.updatedby updatedby_caddresstransaction R
c_addressvalidation.createdby createdby_caddressvalidation R
c_addressvalidation.updatedby updatedby_caddressvalidation R
c_addressvalidationcfg.createdby createdby_caddressvalidationcf R
c_addressvalidationcfg.updatedby updatedby_caddressvalidationcf R
c_bp_bankaccount.ad_user_id aduser_cbpbankaccount R
c_bpartner.salesrep_id adusersalesrep_cbpartner N
c_campaign_trl.createdby createdby_ccampaigntrl R
c_campaign_trl.updatedby updatedby_ccampaigntrl R
c_contactactivity.ad_user_id aduser_ccontactactivity R
c_contactactivity.salesrep_id salesrep_ccontactactivity R
c_countrygroup.createdby createdby_ccountrygroup R
c_countrygroup.updatedby updatedby_ccountrygroup R
c_countrygroup_trl.createdby createdby_ccountrygrouptrl R
c_countrygroup_trl.updatedby updatedby_ccountrygrouptrl R
c_countrygroupcountry.createdby createdby_ccountrygroupcountry R
c_countrygroupcountry.updatedby updatedby_ccountrygroupcountry R
c_docbasegroup.createdby createdby_cperioddocgroup R
c_docbasegroup.updatedby updatedby_cperioddocgroup R
c_docbasegroupline.createdby createdby_cperioddocgroupline R
c_docbasegroupline.updatedby updatedby_cperioddocgroupline R
c_dunningrunentry.ad_user_id aduser_cdunningrunentry R
c_dunningrunentry.salesrep_id salesrep_cdunningrunentry R
c_invoice.ad_user_id aduser_cinvoice R
c_invoice.salesrep_id aduser_sr_cinvoice R
c_invoicebatch.salesrep_id aduser_cinvoicebatch R
c_invoicebatchline.ad_user_id aduser_cinvoicebatchline R
c_jobassignment.ad_user_id aduser_cjobassignment R
c_opportunity.ad_user_id aduser_copportunity R
c_opportunity.salesrep_id salesrep_copportunity R
c_order.ad_user_id aduser_corder R
c_order.bill_user_id aduserbill_corder R
c_order.dropship_user_id dropshipuser_corder R
c_order.salesrep_id aduser_sr_corder R
c_ordersource.createdby aduser1_cordersource R
c_ordersource.updatedby aduser2_cordersource R
c_orgassignment.ad_user_id aduser_corgassignment R
c_pos.salesrep_id aduser_cpos R
c_project.ad_user_id aduser_cproject N
c_project.salesrep_id aduser_sr_cproject R
c_recurringgroup.createdby createdby_crecurringgroup R
c_recurringgroup.updatedby updatedby_crecurringgroup R
c_region_trl.createdby createdby_cregiontrl R
c_region_trl.updatedby updatedby_cregiontrl R
c_revenuerecog_service.createdby createdby_crevenuerecogservice R
c_revenuerecog_service.updatedby updatedby_crevenuerecogservice R
c_rfq.ad_user_id aduser_crfq R
c_rfq.salesrep_id adusersalesrep_crfq R
c_rfq_topicsubscriber.ad_user_id aduser_arfqtopicsubcr R
c_rfqresponse.ad_user_id aduser_crfqresponse R
c_salesregion.salesrep_id salesrep_csalesregion R
c_salesregion_trl.createdby createdby_csalesregiontrl R
c_salesregion_trl.updatedby updatedby_csalesregiontrl R
c_salesstage_trl.createdby createdby_csalesstagetrl R
c_salesstage_trl.updatedby updatedby_csalesstagetrl R
c_taxprovider.createdby createdby_ctaxprovider R
c_taxprovider.updatedby updatedby_ctaxprovider R
c_taxprovidercfg.createdby createdby_adtaxprovider R
c_taxprovidercfg.updatedby updatedby_adtaxprovider R
c_userremuneration.ad_user_id aduser_cuserremuneration R
cm_chatentry.ad_user_id aduser_cmchatentry R
cm_chattypeupdate.ad_user_id aduser_cmchattypeupdate C
cm_chatupdate.ad_user_id aduser_cmchatupdate C
cm_webaccesslog.ad_user_id aduser_cmwebaccesslog R
dd_order.ad_user_id aduser_ddorder R
dd_order.salesrep_id salesrep_ddorder R
gl_category_trl.createdby createdby_glcategorytrl R
gl_category_trl.updatedby updatedby_glcategorytrl R
hr_job.supervisor_id supervisor_hrjob R
i_bpartner.ad_user_id aduser_ibpartner N
i_invoice.ad_user_id aduser_iinvoice N
i_invoice.salesrep_id adusersalesrep_iinvoice N
i_movement.ad_user_id aduser_imovement R
i_order.ad_user_id aduser_iorder N
i_order.salesrep_id adusersalesrep_iorder N
i_productplanning.planner_id planner_iproductplanning R
i_productplanning.salesrep_id salesrep_iproductplanning R
m_forecastline.salesrep_id salesrep_mforecastline R
m_inout.ad_user_id aduser_minout R
m_inout.dropship_user_id dropshipuser_minout R
m_inout.returnuser_id returnuser_minout R
m_inout.salesrep_id aduser_sr_minout R
m_locatortype.createdby createdby_mlocatortype R
m_locatortype.updatedby updatedby_mlocatortype R
m_movement.ad_user_id aduser_mmovement R
m_movement.salesrep_id salesrep_mmovement R
m_pricelist_trl.createdby createdby_mpricelisttrl R
m_pricelist_trl.updatedby updatedby_mpricelisttrl R
m_pricelist_version_trl.createdby createdby_mpricelistversiontrl R
m_pricelist_version_trl.updatedby updatedby_mpricelistversiontrl R
m_product.salesrep_id salesrep_mproduct R
m_product_category_trl.createdby createdby_mproductcategorytrl R
m_product_category_trl.updatedby updatedby_mproductcategorytrl R
m_requisition.ad_user_id aduser_mrequisition R
m_rma.salesrep_id salesrep_mrma R
m_shippingtransaction.ad_user_id aduser_mshippingtransaction R
m_shippingtransaction.returnuser_id returnuser_mshippingtransactio R
m_shippingtransaction.salesrep_id salesrep_mshippingtransaction R
m_storagereservationlog.createdby createdby_mstoragereservationl R
m_storagereservationlog.updatedby updatedby_mstoragereservationl R
mfa_registereddevice.ad_user_id aduser_mfaregistereddevice R
mfa_registration.ad_user_id aduser_mfaregistration R
pa_dashboardcontent.ad_user_id aduser_padashboardcontent R
pa_dashboardcontent_access.ad_user_id aduser_padashboardcontentacces R
pa_dashboardcontent_access.createdby createdby_padashboardcontentac R
pa_dashboardcontent_access.updatedby updatedby_padashboardcontentac R
pa_dashboardpreference.ad_user_id aduser_padashboardpreference R
pa_documentstatus.ad_user_id aduser_padocumentstatus R
pa_documentstatusaccess.ad_user_id aduser_padocumentstatusaccess R
pa_goal.ad_user_id aduser_pagoal R
pp_cost_collector.ad_user_id aduser_ppcostcollector R
pp_cost_collector.user1_id user1_ppcostcollector R
pp_cost_collector.user2_id user2_ppcostcollector R
pp_mrp.planner_id planner_ppmrp R
pp_order.planner_id planner_pporder R
pp_order_bomline.ad_user_id aduser_pporderbomline R
pp_product_planning.planner_id planner_ppproductplanning R
r_categoryupdates.ad_user_id aduser_rcategoryupdates R
r_contactinterest.ad_user_id aduser_rcontactinterest R
r_groupupdates.ad_user_id aduser_ruserupdates R
r_issueuser.ad_user_id aduser_rissueuser R
r_request.ad_user_id aduser_rrequest R
r_request.salesrep_id adusersr_rrequest R
r_requestaction.ad_user_id aduser_rrequestaction R
r_requestaction.salesrep_id adusersr_rrequestaction R
r_requestprocessor.supervisor_id aduser_rrequestprocessor R
r_requestprocessor_route.ad_user_id aduser_rrequestprocessorroute R
r_requesttypeupdates.ad_user_id aduser_rrequesttypeupdates R
r_requestupdates.ad_user_id aduser_rrequestupdates R
s_resource.ad_user_id aduser_sresource R
testuu.createdby createdby_testuu R
testuu.updatedby updatedby_testuu R
testuu_trl.createdby createdby_testuutrl R
testuu_trl.updatedby updatedby_testuutrl R
testuudet.createdby createdby_testuudet R
testuudet.updatedby updatedby_testuudet R
u_posterminal.salesrep_id salesrep_uposterminal R
w_advertisement.ad_user_id aduser_wadvertisement R
w_basket.ad_user_id aduser_wbasket R
w_click.ad_user_id aduser_wclick R
w_counter.ad_user_id aduser_wcounter R
w_store.salesrep_id salesrep_wstore R
User within the system - Internal or Business Partner Contact
ad_client_id numeric 10
ad_client.ad_client_id ad_user_client R
Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id ad_user_org R
Organizational entity within tenant
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
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
password varchar 1024  √  null Password of any length (case sensitive)
email varchar 60  √  null Electronic Mail Address
supervisor_id numeric 10  √  null
ad_user.ad_user_id aduser_supervisor R
Supervisor for this user/organization - used for escalation and approval
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_aduser C
Identifies a Business Partner
processing bpchar 1  √  null Process Now
emailuser varchar 60  √  null User Name (ID) in the Mail System
emailuserpw varchar 255  √  null Password of your email user id
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbplocation_aduser R
Identifies the (ship to) address for this Business Partner
c_greeting_id numeric 10  √  null
c_greeting.c_greeting_id cgreeting_aduser R
Greeting to print on correspondence
title varchar 40  √  null Name this entity is referred to as
comments varchar 2000  √  null Comments or additional information
phone varchar 40  √  null Identifies a telephone number
phone2 varchar 40  √  null Identifies an alternate telephone number.
fax varchar 40  √  null Facsimile number
lastcontact timestamp 29,6  √  null Date this individual was last contacted
lastresult varchar 255  √  null Result of last contact
birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_aduser R
Performing or initiating organization
emailverify varchar 40  √  null Verification information of EMail Address
emailverifydate timestamp 29,6  √  null Date Email was verified
notificationtype bpchar 1 'X'::bpchar Type of Notifications
isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
c_job_id numeric 10  √  null
c_job.c_job_id cjob_aduser R
Job Position
ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
connectionprofile bpchar 1  √  null How a Java Tenant connects to the server(s)
value varchar 40  √  null Search key for the record in the format required - must be unique
userpin varchar 20  √  null User PIN
isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
islocked bpchar 1 'N'::bpchar Locked
dateaccountlocked timestamp 29,6  √  null Date Account Locked
failedlogincount numeric 10 (0)::numeric Failed Login Count
datepasswordchanged timestamp 29,6  √  null Date Password Changed
datelastlogin timestamp 29,6  √  null Date Last Login
isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
isexpired bpchar 1 'N'::bpchar Expired
securityquestion varchar 1024  √  null Security Question
answer varchar 1024  √  NULL::character varying Answer
issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
c_location_id numeric 10  √  NULL::numeric
c_location.c_location_id clocation_aduser R
Location or Address
leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
c_campaign_id numeric 10  √  NULL::numeric
c_campaign.c_campaign_id ccampaign_aduser R
Marketing Campaign
salesrep_id numeric 10  √  NULL::numeric
ad_user.ad_user_id salesrep_aduser R
Sales Representative or Company Agent
bpname varchar 60  √  NULL::character varying BP Name
bp_location_id numeric 10  √  NULL::numeric
c_location.c_location_id bplocation_aduser R
Address of the Business Partner
isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
r_defaultmailtext_id numeric 10  √  NULL::numeric
r_mailtext.r_mailtext_id rdefaultmailtext_aduser R
Default mail template
ad_image_id numeric 10  √  NULL::numeric
ad_image.ad_image_id adimage_aduser R
Image or Icon
isnoexpire bpchar 1 'N'::bpchar No Expire
issupportuser bpchar 1 'N'::bpchar Support User
isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
authenticationtype varchar 10  √  NULL::character varying Authentication Type

Table contained 9 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_user_id Primary key Asc ad_user_pkey
c_bpartner_id Performance Asc ad_user_c_bpartner_id
email Performance Asc ad_user_email
name + ad_user_id Performance Asc/Asc ad_user_name
ad_user_uu Must be unique Asc ad_user_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.