Log in / create account

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

Toolbox

What links here

Help

Search

Participate

Talk to us now!

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.ad.system/AD Client

AD_Client

The Client Definition Tab defines a unique client. Do not create a new client in this window, but use "Initial Client Setup" (System Administrator Role) to set up the required security and access rules. If you create a new client here, you will not be abl

Name:ADClient
Classname:Client

This table contains the following columns:

Name	Nullable	Data Type	Description
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
Value	N	NVARCHAR2(40)	A fast method for finding a particular record.
Name	N	NVARCHAR2(60)	A non-unique identifier for a record/document often used as a search tool.
Description	Y	NVARCHAR2(255)	A space to write additional related information.
SMTPHost	Y	NVARCHAR2(60)	Hostname of Mail Server for SMTP and IMAP
RequestEMail	Y	NVARCHAR2(40)	EMail address to send automated mails from or receive mails for automated processing (fully qualified)
RequestUser	Y	NVARCHAR2(20)	User Name (ID) of the email owner
RequestUserPW	Y	NVARCHAR2(60)	Password of the user name (ID) for mail processing
RequestFolder	Y	NVARCHAR2(20)	EMail folder to process incoming emails; if empty INBOX is used
AD_Language	Y	VARCHAR2(6)	A method of communication being used.
IsMultiLingualDocument	N	CHAR(1)	Documents are Multi Lingual
IsSmtpAuthorization	N	CHAR(1)	Your mail server requires Authentification
C_Currency_ID	Y	VARCHAR2(32)	Base Currency of the Client.

Other Info

Check constraints

These are the check constraints for this table:

AD_CLIENT_ISACTIVE_CHECK: ISACTIVE 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):

Unique

AD_CLIENT_KEY
- AD_Client_ID
AD_CLIENT_NAME
- Name

Columns

Client

A Client is a company or a legal entity. You cannot share data between Clients.

Physical column name: AD_Client_ID
Property Name: id
Reference: ID
Default value: @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
Default value: Y

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
Default value: 0

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)

Search Key

A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

Physical column name: Value
Property Name: searchKey
Reference: String

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

Physical column name: Name
Property Name: name
Reference: String
This column is part of the table's identifier

Description

A description is limited to 255 characters.

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

Mail Host

The host name of the Mail Server for this client with SMTP services to send mail, and IMAP to process incoming mail.

Physical column name: SMTPHost
Property Name: mailHost
Reference: String

Request Email

EMails for requests, alerts and escalation are sent from this email address as well as delivery information if the sales rep does not have an email account. The address must be filly qualified (e.g. joe.smith@company.com) and should be a valid address.

Physical column name: RequestEMail
Property Name: requestEmail
Reference: String

Request User

EMail user name for requests, alerts and escalation are sent from this email address as well as delivery information if the sales rep does not have an email account. Required, if your mail server requires authentification as well as for processing incoming mails.

Physical column name: RequestUser
Property Name: requestUser
Reference: String

Request User Password

Password of the user name (ID) for mail processing

Physical column name: RequestUserPW
Property Name: requestUserPassword
Reference: String

Request Folder

Email folder used to read emails to process as requests, If left empty the default mailbox (INBOX) will be used. Requires IMAP services.

Physical column name: RequestFolder
Property Name: requestFolder
Reference: String

Language

Physical column name: AD_Language
Property Name: language
Reference: Table

Foreign key column to AD_Language table, (column: AD_Language_ID)

Reference Table AD_Language

Multilingual Documents

If selected, you enable multi lingual documents and need to maintain translations for entities used in documents (examples: Products, Payment Terms, ...).
Please note, that the base language is always English.

Physical column name: IsMultiLingualDocument
Property Name: multilingualDocuments
Reference: YesNo

SMTP Authentification

Some email servers require authentification before sending emails. If yes, users are required to define their email user name and password. If authentification is required and no user name and password is required, delivery will fail.

Physical column name: IsSmtpAuthorization
Property Name: sMTPAuthentification
Reference: YesNo
Default value: N

Base Currency

The Base Currency is taken as the currency for the amounts that do not have an explicit currency, for instance, costs.

Physical column name: C_Currency_ID
Property Name: currency
Reference: TableDir

Foreign key column to C_Currency table, (column: C_Currency_ID)

Related tables

Tables that link this table:

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_Client"

This page has been accessed 9,573 times. This page was last modified on 2 July 2011, at 20:36. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.