ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.access/AD User
AD_User
The User Tab defines the log in for Users who have access to the system.
The User identifies a unique user in the system. This could be an internal user or a business partner contact
- Name:ADUser
- Classname:User
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_User_ID | N | VARCHAR2(32) | An acquaintance to reach for information related to the business partner. |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | N | DATE | The date that this record is completed. |
| CreatedBy | N | VARCHAR2(32) | User who created this records |
| Updated | N | DATE | x not implemented |
| UpdatedBy | N | VARCHAR2(32) | User who updated this records |
| Name | N | NVARCHAR2(60) | Alphanumeric identifier of the entity |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| Password | Y | NVARCHAR2(40) | A secret code used to allow access to a specified window or tab. |
| Y | NVARCHAR2(40) | An email address for a specified business partner. | |
| Supervisor_ID | Y | VARCHAR2(32) | Supervisor for this user - used for escalation |
| C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| Processing | Y | CHAR(1) | A request to process the respective document or task. |
| EmailUser | Y | NVARCHAR2(20) | User Name (ID) in the Mail System |
| EmailUserPW | Y | NVARCHAR2(40) | Password of your email user id |
| C_BPartner_Location_ID | Y | VARCHAR2(32) | The location of the selected business partner. |
| C_Greeting_ID | Y | VARCHAR2(32) | A description, often abbreviated, of how to address a business partner. |
| Title | Y | NVARCHAR2(40) | A defined job, title, or ranking within a company. |
| Comments | Y | NVARCHAR2(2000) | A space to write additional related information. |
| Phone | Y | NVARCHAR2(40) | A telephone number for a specified business partner. |
| Phone2 | Y | NVARCHAR2(40) | A second contact telephone number for a business partner. |
| Fax | Y | NVARCHAR2(40) | A fax number for a specified business partner. |
| LastContact | Y | DATE | Date this individual was last contacted |
| LastResult | Y | NVARCHAR2(255) | A statement related to the result of the last interaction with a business partner. |
| Birthday | Y | DATE | An anniversary of birth for a business partner. |
| AD_OrgTrx_ID | Y | VARCHAR2(32) | The organization which performs or initiates the transaction. |
| Firstname | Y | NVARCHAR2(60) | Name of the contact |
| Lastname | Y | NVARCHAR2(60) | Last name of the contact |
| UserName | Y | VARCHAR2(60) | User Name |
| Default_Ad_Client_ID | Y | VARCHAR2(32) | Default Session Client |
| Default_Ad_Language | Y | VARCHAR2(6) | Default Language |
| Default_Ad_Org_ID | Y | VARCHAR2(32) | Default Organization |
| Default_Ad_Role_ID | Y | VARCHAR2(32) | Defautl Role |
| Default_M_Warehouse_ID | Y | VARCHAR2(32) | Default Warehouse |
| IsLocked | N | CHAR(1) | The user is locked and cannot log in the application |
Other Info
Check constraints
These are the check constraints for this table:
- AD_USER_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- AD_USER_ISLOCKED_CHECK: ISLOCKED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- AD_USER_EMAIL
- AD_USER_NAME
Unique
- AD_USER_KEY
- AD_USER_UN_USERNAME
Columns
User/Contact
The User identifies a unique user in the system. This could be an internal user or a business partner contact
- Physical column name: AD_User_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
User
The User Name which contact will have access to application. It must be registered in user window as application user.
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Callout: SL_User_Name
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_User_Name Java class.
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Password
The Password indicates the Password for this User Id. Passwords are required to identify authorized users.
- Physical column name: Password
- Property Name: password
- Reference: String
The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).
- Physical column name: Email
- Property Name: email
- Reference: String
Supervisor
- Physical column name: Supervisor_ID
- Property Name: supervisor
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Process Now
When this field is set as 'Y' a process is being performed on this record.
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
Email Server Username
The user name in the mail system is usually the string before the @ of your email address. Required if the mail server requires authentification to send emails.
- Physical column name: EmailUser
- Property Name: emailServerUsername
- Reference: String
Email Server Password
Required if the mail server requires authentification to send emails.
- Physical column name: EmailUserPW
- Property Name: emailServerPassword
- Reference: String
Partner Address
- Physical column name: C_BPartner_Location_ID
- Property Name: partnerAddress
- Reference: TableDir
Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)
Validation Rule C_BPartner Location: null. With the following code:
C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@
Greeting
- Physical column name: C_Greeting_ID
- Property Name: greeting
- Reference: TableDir
Foreign key column to C_Greeting table, (column: C_Greeting_ID)
Position
The Title indicates the name that an entity is referred to as.
- Physical column name: Title
- Property Name: position
- Reference: String
Comments
The Comments field allows for free form entry of additional information.
- Physical column name: Comments
- Property Name: comments
- Reference: Text
Phone
The Phone field identifies a telephone number
- Physical column name: Phone
- Property Name: phone
- Reference: String
Alternative Phone
The 2nd Phone field identifies an alternate telephone number.
- Physical column name: Phone2
- Property Name: alternativePhone
- Reference: String
Fax
The Fax identifies a facsimile number for this Business Partner or Location
- Physical column name: Fax
- Property Name: fax
- Reference: String
Last Contact Date
The Last Contact indicates the date that this Business Partner Contact was last contacted.
- Physical column name: LastContact
- Property Name: lastContactDate
- Reference: Date
Last Contact Result
The Last Result identifies the result of the last contact made.
- Physical column name: LastResult
- Property Name: lastContactResult
- Reference: String
Birthday
Birthday or Anniversary day
- Physical column name: Birthday
- Property Name: birthday
- Reference: Date
Trx Organization
- Physical column name: AD_OrgTrx_ID
- Property Name: trxOrganization
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
Reference Table AD_Org (Trx) With the following where clause:
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'
First Name
First Name of the contact
- Physical column name: Firstname
- Property Name: firstName
- Reference: String
Callout: SL_User_Name
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_User_Name Java class.
Last Name
Last name of the contact
- Physical column name: Lastname
- Property Name: lastName
- Reference: String
Callout: SL_User_Name
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_User_Name Java class.
Username
Name that identifies the user in the System
- Physical column name: UserName
- Property Name: username
- Reference: String
Default Client
- Physical column name: Default_Ad_Client_ID
- Property Name: defaultClient
- Reference: Table
Foreign key column to AD_Client table, (column: AD_Client_ID)
Reference Table AD_Client
Validation Rule AD_Client of Role: Filter Role's Clients. With the following code:
AD_CLIENT.ISACTIVE = 'Y' AND EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS WHERE AD_ROLE_ORGACCESS.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID AND AD_ROLE_ORGACCESS.AD_ROLE_ID = @Default_AD_Role_ID@ AND AD_ROLE_ORGACCESS.ISACTIVE = 'Y')
Default Language
- Physical column name: Default_Ad_Language
- Property Name: defaultLanguage
- Reference: Table
Foreign key column to AD_Language table, (column: AD_Language_ID)
Reference Table AD_Language system With the following where clause:
(IsSystemLanguage='Y' OR isBaseLanguage='Y') AND isActive='Y'
Default Organization
- Physical column name: Default_Ad_Org_ID
- Property Name: defaultOrganization
- Reference: Table
Foreign key column to AD_Org table, (column: AD_Org_ID)
Reference Table AD_Org (all)
Validation Rule AD_Org of a Role: Filter Organization by Role. With the following code:
EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS A_R_O, ad_role r WHERE A_R_O.AD_ORG_ID = AD_ORG.AD_Org_ID AND A_R_O.ISACTIVE = 'Y' AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID AND r.ad_role_id = @Default_AD_Role_ID@ AND R.ISACTIVE = 'Y' AND (LPAD(TO_CHAR(R.USERLEVEL), 1, '1')='S' OR AD_ORG.AD_ORG_ID <> '0') AND A_R_O.AD_ROLE_ID = @Default_AD_Role_ID@)
Default Role
- Physical column name: Default_Ad_Role_ID
- Property Name: defaultRole
- Reference: Table
Foreign key column to AD_Role table, (column: AD_Role_ID)
Reference Table AD_Role
Validation Rule AD_Role_of_User: Filter User's Role. With the following code:
EXISTS ( SELECT 1 FROM AD_USER_ROLES A_U_R WHERE A_U_R.AD_ROLE_ID = AD_Role.AD_Role_ID AND A_U_R.ISACTIVE = 'Y' AND A_U_R.AD_USER_ID = @AD_User_ID@)
Default Warehouse
- Physical column name: Default_M_Warehouse_ID
- Property Name: defaultWarehouse
- Reference: Table
Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)
Reference Table M_Warehouse of Client With the following where clause:
M_Warehouse.AD_Client_ID=@#AD_Client_ID@ AND (select ad.isactive from ad_org ad where ad.ad_org_id = M_Warehouse.AD_Org_ID) = 'Y'
Validation Rule M_Warehouse of Role: Filter Warehouse filter by Role. With the following code:
M_Warehouse.AD_Client_ID = @Default_AD_Client_ID@
Locked
The user is locked and cannot log in the application. This field can be manually set or automatically if login.trial.user.lock property is configured in Openbravo.properties file and there has been that number of failed log in attempts.
- Physical column name: IsLocked
- Property Name: locked
- Reference: YesNo
- Default value: N
Related tables
Tables that link this table:
- ADAlert.User/Contact
- ADAlertRecipient.User/Contact
- ADNote.User/Contact
- ADPreference.User/Contact
- ADProcessInstance.User/Contact
- ADTreeBar.User/Contact
- ADUser.Supervisor
- ADUserRoles.User/Contact
- AD_Audit_Trail.User/Contact
- AcctSchemaTableDocType.Created By
- AcctSchemaTableDocType.Updated By
- ActiveProposalV.User/Contact
- BusinessPartnerBankAccount.User/Contact
- ContactEmailInteraction.User/Contact
- ContactInterest.User/Contact
- DataImportBusinessPartner.User/Contact
- DataImportInvoice.Sales Representative
- DataImportInvoice.User/Contact
- DataImportOrder.Sales Representative
- DataImportOrder.User/Contact
- DataPackage.Created By
- DataPackage.Updated By
- DataSet.Created By
- DataSet.Updated By
- DataSetColumn.Created By
- DataSetColumn.Updated By
- DataSetTable.Created By
- DataSetTable.Updated By
- ExternalPOS.Sales Representative
- FinancialMgmtAsset.User/Contact
- Invoice.Sales Representative
- Invoice.User/Contact
- InvoiceDay.Sales Representative
- InvoiceHeaderV.Sales Representative
- InvoiceLineV2.Sales Representative
- InvoiceMonth.Sales Representative
- InvoiceV2.Sales Representative
- InvoiceV2.User/Contact
- InvoiceWeek.Sales Representative
- ManufacturingMeasureShift.User/Contact
- MaterialMgmtShipmentInOut.Sales Representative
- MaterialMgmtShipmentInOut.User/Contact
- ModelImplementationParameter.Created By
- ModelImplementationParameter.Updated By
- ModuleDBPrefix.Created By
- ModuleDBPrefix.Updated By
- ModuleDependency.Created By
- ModuleDependency.Updated By
- ModuleLog.Created By
- ModuleLog.Updated By
- ModuleTrl.Created By
- ModuleTrl.Updated By
- Order.Drop Ship Contact
- Order.Sales Representative
- Order.User/Contact
- OrderHeaderV.Sales Representative
- OrderOpen.Sales Representative
- OrderOpen.User/Contact
- OrganizationAcctSchema.Created By
- OrganizationAcctSchema.Updated By
- OrganizationAssignment.User/Contact
- OrganizationType.Created By
- OrganizationType.Updated By
- PeriodControlLog.Created By
- PeriodControlLog.Updated By
- ProcessExecution.User/Contact
- ProcessRequest.User/Contact
- ProcurementRequisition.User/Contact
- ProcurementRequisitionLine.Locked by
- Product.Sales Representative
- Project.Sales Representative
- Project.User/Contact
- ProjectHeaderV.Sales Representative
- ProjectProjectProposalTask.User/Contact
- ProjectProposal.User/Contact
- ReferenceDataStore.Created By
- ReferenceDataStore.Updated By
- Request.Sales Representative
- Request.User/Contact
- RequestProcessor.Supervisor
- RequestProcessorRoute.User/Contact
- RequestionAction.Sales Representative
- RequestionAction.User/Contact
- Resource.User/Contact
- SalesRegion.Sales Representative