User/Contact
AD_User
User within the system - Internal or Business Partner Contact
Overview
| Table Name | AD_User |
|---|---|
| Access Level | All Levels |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Image |
| Wiki | View on iDempiere Wiki |
Columns (95)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Image_ID |
Image(22) | No | - | System Image or Icon |
AD_Language |
Table(6) | No | - | Language for this entity |
AD_OrgTrx_ID |
Table(22) | No | - | Performing or initiating organization |
Answer |
String(1024) | No | - | - |
Birthday |
Date(7) | No | - | Birthday or Anniversary day |
BPartner_SalesRep2_ID |
Table(10) | No | - | - |
BPartner_SalesRep_ID |
Table(10) | No | - | - |
BPEMail |
String(60) | No | - | BP Electronic Mail Address |
BPNameHash |
String(32) | No | - | - |
BPPhone |
String(40) | No | - | Identifies a telephone number for business partner |
C_BPartner_Location_ID |
Table Direct(22) | No | - | Identifies the (ship to) address for this Business Partner |
C_Greeting_ID |
Table Direct(22) | No | - | Greeting to print on correspondence |
C_Industry_ID |
Table Direct(10) | No | - | Define Lead or Business Partners Industry |
C_LeadSource_ID |
Table Direct(10) | No | - | - |
Comments |
Text(2000) | No | - | Comments or additional information |
DateAccountLocked |
Date+Time(7) | No | - | - |
DateLastLogin |
Date+Time(7) | No | - | - |
DatePasswordChanged |
Date+Time(7) | No | - | - |
Department |
String(60) | No | - | Department belonging to User/Contact |
EMailUser |
String(60) | No | - | User Name (ID) in the Mail System |
EMailUserPW |
String(528) | No | - | Password of your email user id |
EMailVerify |
String(40) | No | - | Verification information of EMail Address |
FailedLoginCount |
Integer(14) | Yes | 0 | - |
Fax |
String(40) | No | - | Facsimile number |
FirstName |
String(60) | No | - | - |
IsAddMailTextAutomatically |
Yes-No(1) | Yes | N | The selected mail template will be automatically inserted when creating an email |
IsBillTo |
Yes-No(1) | Yes | N | Business Partner Invoice/Bill Address |
IsCurrentDunningPerson |
Yes-No(1) | Yes | N | Contact Person to which will be sent dunning letters |
IsDriver |
Yes-No(1) | No | N | This contact is a driver |
IsExpired |
Yes-No(1) | Yes | N | - |
IsInPayroll |
Yes-No(1) | Yes | N | Defined if any User Contact will be used for Calculate Payroll |
IsLocked |
Yes-No(1) | Yes | 'N' | - |
IsMenuAutoExpand |
List(1) | No | - | If ticked, the menu is automatically expanded |
IsNoExpire |
Yes-No(1) | Yes | N | - |
IsNoPasswordReset |
Yes-No(1) | Yes | 'N' | - |
IsShipTo |
Yes-No(1) | Yes | N | Business Partner Shipment Address |
IsShowStock |
Yes-No(1) | Yes | N | Defines if Business Partner can see Stock |
IsSupportUser |
Yes-No(1) | Yes | N | - |
IsVendorLead |
Yes-No(1) | Yes | N | This contact is a vendor lead |
IsWebStoreAccount |
Yes-No(1) | Yes | N | This user/contact is Web Store account |
JobDescription |
String(60) | No | - | - |
LastContact |
Date(7) | No | - | Date this individual was last contacted |
LastContactAge |
Integer(14) | No | - | Age of Last Contact calculated in Days |
LastName |
String(120) | No | - | - |
LastResult |
String(255) | No | - | Result of last contact |
LDAPUser |
String(60) | No | - | Authorize via LDAP (directory) services |
LeadIndustry |
List(10) | No | OTH | Define Lead or Business Partners Industry |
LeadRating |
List(10) | No | C | Indicates value or prospect of the lead, for example, Hot, Warm, Cold. |
MiddleName |
String(60) | No | - | - |
Mobile |
String(40) | No | - | Identifies a mobile number |
MonthlyCreditLimit |
Amount(22) | No | 0 | - |
NumberEmployees |
Integer(22) | No | - | Number of employees |
PA_Dashboard_ID |
Table Direct(22) | No | - | - |
Phone |
String(40) | No | - | Identifies a telephone number |
Phone2 |
String(40) | No | - | Identifies an alternate telephone number. |
Processing |
Button(1) | No | - | - |
R_DefaultMailText_ID |
Table(10) | No | - | - |
Salt |
String(16) | No | - | Random data added to improve password hash effectiveness |
SecurityQuestion |
String(1024) | No | - | - |
Sex |
List(1) | No | - | - |
Suffix |
String(10) | No | - | Suffix after the number |
Title |
String(40) | No | - | Name this entity is referred to as |
URL |
URL(120) | No | - | URL |
W_Store_ID |
Table(10) | No | - | A Web Store of the Tenant |
Name |
String(60) | No | - | Alphanumeric identifier of the entity |
BPName |
String(120) | No | - | - |
C_BPartner_ID |
Search(22) | No | - | Identifies a Business Partner |
UserPIN |
String(20) | 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_User_ID |
ID(22) | Yes | - | User within the system - Internal or Business Partner Contact |
AD_User_UU |
String(36) | No | - | - |
BP_Location_ID |
Location (Address)(10) | No | - | Address of the Business Partner |
C_Campaign_ID |
Table Direct(10) | No | - | Marketing Campaign |
C_Job_ID |
Table Direct(1) | No | - | Job Position |
C_Location_ID |
Location (Address)(10) | No | - | Location or Address |
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 |
EMail |
String(60) | No | - | Electronic Mail Address |
EMailVerifyDate |
Date+Time(7) | No | - | Date Email was verified |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsFullBPAccess |
Yes-No(1) | Yes | Y | The user/contact has full access to Business Partner information and resources |
IsSalesLead |
Yes-No(1) | Yes | N | This contact is a sales lead |
LeadSource |
List(10) | No | - | The source of this lead/opportunity |
LeadSourceDescription |
Text(255) | No | - | Additional information on the source of this lead/opportunity |
LeadStatus |
List(10) | No | N | The status of this lead/opportunity in the sales cycle |
LeadStatusDescription |
Text(255) | No | - | Additional information on the status of this lead/opportunity |
NotificationType |
List(1) | Yes | X | Type of Notifications |
Password |
String(4144) | No | - | Password of any length (case sensitive) |
SalesRep_ID |
Table(10) | No | @#AD_User_ID@ | Sales Representative or Company Agent |
Supervisor_ID |
Search(22) | No | - | Supervisor for this user/organization - used for escalation and approval |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Value |
String(40) | Yes | - | Search key for the record in the format required - must be unique |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Image_ID |
AD_Image.AD_Image_ID | System Image or Icon |
AD_OrgTrx_ID |
AD_OrgTrx.AD_OrgTrx_ID | Performing or initiating organization |
BPartner_SalesRep2_ID |
BPartner_SalesRep2.BPartner_SalesRep2_ID | - |
BPartner_SalesRep_ID |
BPartner_SalesRep.BPartner_SalesRep_ID | - |
C_BPartner_Location_ID |
C_BPartner_Location.C_BPartner_Location_ID | Identifies the (ship to) address for this Business Partner |
C_Greeting_ID |
C_Greeting.C_Greeting_ID | Greeting to print on correspondence |
C_Industry_ID |
C_Industry.C_Industry_ID | Define Lead or Business Partners Industry |
C_LeadSource_ID |
C_LeadSource.C_LeadSource_ID | - |
PA_Dashboard_ID |
PA_Dashboard.PA_Dashboard_ID | - |
R_DefaultMailText_ID |
R_DefaultMailText.R_DefaultMailText_ID | - |
W_Store_ID |
W_Store.W_Store_ID | A Web Store of the Tenant |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
BP_Location_ID |
BP_Location.BP_Location_ID | Address of the Business Partner |
C_Campaign_ID |
C_Campaign.C_Campaign_ID | Marketing Campaign |
C_Job_ID |
C_Job.C_Job_ID | Job Position |
C_Location_ID |
C_Location.C_Location_ID | Location or Address |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
Supervisor_ID |
Supervisor.Supervisor_ID | Supervisor for this user/organization - used for escalation and approval |
Generated on 2026-05-03T16:36:57.241020035Z