ERP/2.50/Developers Guide/Database Model/org.openbravo.model.ad.access/AD User

Contents 1 AD_User 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Non Unique 1.1.2.2 Unique 1.2 Columns 1.2.1 User/Contact 1.2.2 Client 1.2.3 Organization 1.2.4 Active 1.2.5 Creation Date 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 User 1.2.9.1 Callout: SL_User_Name 1.2.10 Description 1.2.11 Password 1.2.12 Email 1.2.13 Supervisor 1.2.14 Business Partner 1.2.15 Process Now 1.2.16 Email Server Username 1.2.17 Email Server Password 1.2.18 Partner Address 1.2.19 Greeting 1.2.20 Position 1.2.21 Comments 1.2.22 Phone 1.2.23 Alternative Phone 1.2.24 Fax 1.2.25 Last Contact Date 1.2.26 Last Contact Result 1.2.27 Birthday 1.2.28 Trx Organization 1.2.29 First Name 1.2.29.1 Callout: SL_User_Name 1.2.30 Last Name 1.2.30.1 Callout: SL_User_Name 1.2.31 Username 1.2.32 Default Client 1.2.33 Default Language 1.2.34 Default Organization 1.2.35 Default Role 1.2.36 Default Warehouse 1.2.37 Locked 1.3 Related tables

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.
Email	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')

top

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
  • Email
• AD_USER_NAME
  • AD_Client_ID
  • Name

Unique

• AD_USER_KEY
  • AD_User_ID
• AD_USER_UN_USERNAME
  • UserName

top

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

top

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@)

top

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)

top

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

top

Creation Date

The Created field indicates the date that this record was created.

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

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.

top

Description

A description is limited to 255 characters.

• Physical column name: Description
• Property Name: description
• Reference: String

top

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

top

Email

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

top

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

top

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)

top

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

top

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

top

Email Server Password

Required if the mail server requires authentification to send emails.

• Physical column name: EmailUserPW
• Property Name: emailServerPassword
• Reference: String

top

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@

top

Greeting

• Physical column name: C_Greeting_ID
• Property Name: greeting
• Reference: TableDir

Foreign key column to C_Greeting table, (column: C_Greeting_ID)

top

Position

The Title indicates the name that an entity is referred to as.

• Physical column name: Title
• Property Name: position
• Reference: String

top

Comments

The Comments field allows for free form entry of additional information.

• Physical column name: Comments
• Property Name: comments
• Reference: Text

top

Phone

The Phone field identifies a telephone number

• Physical column name: Phone
• Property Name: phone
• Reference: String

top

Alternative Phone

The 2nd Phone field identifies an alternate telephone number.

• Physical column name: Phone2
• Property Name: alternativePhone
• Reference: String

top

Fax

The Fax identifies a facsimile number for this Business Partner or Location

• Physical column name: Fax
• Property Name: fax
• Reference: String

top

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

top

Last Contact Result

The Last Result identifies the result of the last contact made.

• Physical column name: LastResult
• Property Name: lastContactResult
• Reference: String

top

Birthday

Birthday or Anniversary day

• Physical column name: Birthday
• Property Name: birthday
• Reference: Date

top

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'

top

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.

top

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.

top

Username

Name that identifies the user in the System

• Physical column name: UserName
• Property Name: username
• Reference: String

top

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')

top

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'

top

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@)

top

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@)

top

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@

top

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

top

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

top