View source | Discuss this page | Page history | Printable version   

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

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

Index

Contents

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

This table contains the following columns:

Name Nullable Data Type Description
AD_User_ID NVARCHAR2(32)An acquaintance to reach for information related to the business partner.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Name NNVARCHAR2(60)Alphanumeric identifier of the entity
Description YNVARCHAR2(255)A space to write additional related information.
Password YNVARCHAR2(40)A secret code used to allow access to a specified window or tab.
Email YNVARCHAR2(40)An email address for a specified business partner.
Supervisor_ID YVARCHAR2(32)Supervisor for this user - used for escalation
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Processing YCHAR(1)A request to process the respective document or task.
EmailUser YNVARCHAR2(20)User Name (ID) in the Mail System
EmailUserPW YNVARCHAR2(40)Password of your email user id
C_BPartner_Location_ID YVARCHAR2(32)The location of the selected business partner.
C_Greeting_ID YVARCHAR2(32)A description, often abbreviated, of how to address a business partner.
Title YNVARCHAR2(40)A defined job, title, or ranking within a company.
Comments YNVARCHAR2(2000)A space to write additional related information.
Phone YNVARCHAR2(40)A telephone number for a specified business partner.
Phone2 YNVARCHAR2(40)A second contact telephone number for a business partner.
Fax YNVARCHAR2(40)A fax number for a specified business partner.
LastContact YDATEDate this individual was last contacted
LastResult YNVARCHAR2(255)A statement related to the result of the last interaction with a business partner.
Birthday YDATEAn anniversary of birth for a business partner.
AD_OrgTrx_ID YVARCHAR2(32)The organization which performs or initiates the transaction.
Firstname YNVARCHAR2(60)Name of the contact
Lastname YNVARCHAR2(60)Last name of the contact
UserName YVARCHAR2(60)User Name
Default_Ad_Client_ID YVARCHAR2(32)Default Session Client
Default_Ad_Language YVARCHAR2(6)Default Language
Default_Ad_Org_ID YVARCHAR2(32)Default Organization
Default_Ad_Role_ID YVARCHAR2(32)Defautl Role
Default_M_Warehouse_ID YVARCHAR2(32)Default Warehouse
IsLocked NCHAR(1)The user is locked and cannot log in the application

Other Info

Check constraints

These are the check constraints for this table:

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

Unique

top

Columns

User/Contact

The User identifies a unique user in the system. This could be an internal user or a business partner contact

top

Client

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

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.

top

Creation Date

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

top

Created By

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

top

Updated

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

top

Updated By

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.

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.

top

Password

The Password indicates the Password for this User Id. Passwords are required to identify authorized users.

top

Email

The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).

top

Supervisor

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


Reference Table AD_User

top

Business Partner

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.

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.

top

Email Server Password

Required if the mail server requires authentification to send emails.

top

Partner Address

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

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.

top

Comments

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

top

Phone

The Phone field identifies a telephone number

top

Alternative Phone

The 2nd Phone field identifies an alternate telephone number.

top

Fax

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

top

Last Contact Date

The Last Contact indicates the date that this Business Partner Contact was last contacted.

top

Last Contact Result

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

top

Birthday

Birthday or Anniversary day

top

Trx Organization

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

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

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

top

Default Client

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

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

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

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

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.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User"

This page has been accessed 5,315 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.