ManPageW User
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: User
Description : Maintain Users of the system
Help : The User Window allows you to maintain User of the system. Users can log into the system and have access to functionality via one or more roles. A user can also be a business partner contact.
Tab: User Contact
Description : Maintain User or Business Partner Contact
Help : The User Tab defines the log in for Users who have access to the system. For application access, users need to have a role assigned.
Table Name : AD_User
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Search Key | Search key for the record in the format required | 7 bit lower case alpha numeric - max length 8 - can be used for operating system names. | Value
NVARCHAR2(40) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comments | Comments or additional information | The Comments field allows for free form entry of additional information. | Comments
NVARCHAR2(2000) Text |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | C_BPartner_Location_ID
NUMBER(10) TableDir |
EMail Address | Electronic Mail Address | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web. | EMail
NVARCHAR2(60) String |
Password | Password of any length (case sensitive) | The Password for this User. Passwords are required to identify authorized users. For Adempiere Users, you can change the password via the Process "Reset Password". | Password
NVARCHAR2(40) String |
Title | Name this entity is referred to as | The Title indicates the name that an entity is referred to as. | Title
NVARCHAR2(40) String |
UserPIN | UserPIN
NVARCHAR2(20) String | ||
Birthday | Birthday or Anniversary day | Birthday or Anniversary day | Birthday
DATE Date |
Phone | Identifies a telephone number | The Phone field identifies a telephone number | Phone
NVARCHAR2(40) String |
2nd Phone | Identifies an alternate telephone number. | The 2nd Phone field identifies an alternate telephone number. | Phone2
NVARCHAR2(40) String |
Fax | Facsimile number | The Fax identifies a facsimile number for this Business Partner or Location | Fax
NVARCHAR2(40) String |
Notification Type | Type of Notifications | Emails or Notification sent out for Request Updates, etc. | NotificationType
CHAR(1) List |
Position | Job Position | C_Job_ID
NUMBER(10) TableDir | |
Full BP Access | The user/concat has full access to Business Partner information and resources | If selected, the user has full access to the Business Partner (BP) information (Business Documents like Orders, Invoices - Requests) or resources (Assets, Downloads). If you deselet it, the user has no access rights unless, you explicitly grant it in tab "BP Access" | IsFullBPAccess
CHAR(1) YesNo |
EMail User ID | User Name (ID) in the Mail System | 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. | EMailUser
NVARCHAR2(60) String |
EMail User Password | Password of your email user id | Required if the mail server requires authentification to send emails. | EMailUserPW
NVARCHAR2(20) String |
Supervisor | Supervisor for this user/organization - used for escalation and approval | The Supervisor indicates who will be used for forwarding and escalating issues for this user - or for approvals. | Supervisor_ID
NUMBER(10) Search |
LDAP User Name | User Name used for authorization via LDAP (directory) services | Optional LDAP system user name for the user. If not defined, the normal Name of the user is used. This allows to use the internal (LDAP) user id (e.g. jjanke) and the normal display name (e.g. Jorg Janke). The LDAP User Name can also be used without LDAP enables (see system window). This would allow to sign in as jjanke and use the display name of Jorg Janke. | LDAPUser
NVARCHAR2(60) String |
Trx Organization | Performing or initiating organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | AD_OrgTrx_ID
NUMBER(10) Table |
Connection Profile | How a Java Client connects to the server(s) | Depending on the connection profile, different protocols are used and tasks are performed on the server rather then the client. Usually the user can select different profiles, unless it is enforced by the User or Role definition. The User level profile overwrites the Role based profile. | ConnectionProfile
CHAR(1) List |
Greeting | Greeting to print on correspondence | The Greeting identifies the greeting to print on correspondence. | C_Greeting_ID
NUMBER(10) TableDir |
EMail Verify | Date Email was verified | EMailVerifyDate
DATE DateTime | |
Last Contact | Date this individual was last contacted | The Last Contact indicates the date that this Business Partner Contact was last contacted. | LastContact
DATE Date |
Verification Info | Verification information of EMail Address | The field contains additional information how the EMail Address has been verified | EMailVerify
NVARCHAR2(40) String |
Last Result | Result of last contact | The Last Result identifies the result of the last contact made. | LastResult
NVARCHAR2(255) String |
Tab: User Roles
Description : User Roles
Help : The User Roles Tab define the Roles each user may have. The Roles will determine what windows, tasks, processes and workflows that a User has access to.
Table Name : AD_User_Roles
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) Search |
Role | Responsibility Role | The Role determines security and access a user who has this Role will have in the System. | AD_Role_ID
NUMBER(10) Search |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Tab: User Substitute
Description : Substitute of the user
Help : A user who can act for this user.
Table Name : AD_User_Substitute
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) Search |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Substitute | Entity which can be used in place of this entity | The Substitute identifies the entity to be used as a substitute for this entity. | Substitute_ID
NUMBER(10) Search |
Valid from | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom
DATE Date |
Valid to | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo
DATE Date |
Tab: Org Assignment
Description : User Assigment to Organization
Help : Assign Users to Organizations
Table Name : C_OrgAssignment
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) Search |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Valid from | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom
DATE Date |
Valid to | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo
DATE Date |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Tab: Org Access
Description : Maintain User Org Access
Help : Add the client and organizations the user has access to. Entries here are ignored, if in the Role, User Org Access is not selected or the role has access to all roles.
Note that access information is cached and requires re-login or reset of cache.
Table Name : AD_User_OrgAccess
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) TableDir |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Read Only | Field is read only | The Read Only indicates that this field may only be Read. It may not be updated. | IsReadOnly
CHAR(1) YesNo |
Tab: User Mail
Description : Mail sent to the user
Help : Archive of mails sent to users
Table Name : AD_UserMail
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) Search |
Mail Template | Text templates for mailings | The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object). So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name. |
R_MailText_ID
NUMBER(10) TableDir |
Mail Message | Web Store Mail Message Template | W_MailMsg_ID
NUMBER(10) TableDir | |
Created | Date this record was created | The Created field indicates the date that this record was created. | Created
DATE DateTime |
Message ID | EMail Message ID | SMTP Message ID for tracking purposes | MessageID
VARCHAR2 String |
Subject | Email Message Subject | Subject of the EMail | Subject
NVARCHAR2(255) String |
Mail Text | Text used for Mail message | The Mail Text indicates the text used for mail messages. | MailText
NVARCHAR2(2000) Text |
Delivery Confirmation | EMail Delivery confirmation | DeliveryConfirmation
VARCHAR2 String | |
Delivered | IsDelivered
CHAR(1) List |
Tab: Queries
Description : View and maintain saved queries
Help :
Table Name : AD_UserQuery
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) Search |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | 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 reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
Validation code | Validation Code | The Validation Code displays the date, time and message of the error. | Code
NVARCHAR2(2000) TextLong |
Tab: LDAP Access
Description : User Access via LDAP
Help :
Table Name : AD_LdapAccess
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | AD_User_ID
NUMBER(10) TableDir |
Ldap Processor | LDAP Server to authenticate and authorize external systems based on Adempiere | The LDAP Server allows third party software (e.g. Apache) to use the users defined in the system to authentificate and authorize them. There is only one server per Adempiere system. The "o" is the Client key and the optional "ou" is the Interest Area key. | AD_LdapProcessor_ID
NUMBER(10) TableDir |
Interest Area | Interest Area or Topic | Interest Areas reflect interest in a topic by a contact. Interest areas can be used for marketing campaigns. | R_InterestArea_ID
NUMBER(10) TableDir |
Created | Date this record was created | The Created field indicates the date that this record was created. | Created
DATE DateTime |
Error | An Error occured in the execution | IsError
CHAR(1) YesNo | |
Summary | Textual summary of this request | The Summary allows free form text entry of a recap of this request. | Summary
NVARCHAR2(2000) Text |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |