View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system


Contents

AD_Client

This table contains the following columns:

Name Nullable Data Type Description


RequestUser Yes NVARCHAR (40) 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.
IsMultiLingualDocument No CHAR (1) 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.
AD_Language Yes VARCHAR (6) The Language identifies the language to use for display
RequestEMail Yes NVARCHAR (40) 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.
IsSmtpAuthorization No CHAR (1) 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.
RequestFolder Yes NVARCHAR (20) Email folder used to read emails to process as requests, If left empty the default mailbox (INBOX) will be used. Requires IMAP services.
RequestUserPW Yes NVARCHAR (60) Password of the user name (ID) for mail processing
Name No NVARCHAR (60) 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.
C_Currency_ID Yes VARCHAR (32) Indicates the currency to be used when processing this document.
Acctdim_Centrally_Maintained No CHAR (1) The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table.
Project_Acctdim_Isenable No CHAR (1) Identifier of a project defined within the Project & Service Management module.
Project_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
Project_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
Project_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
Bpartner_Acctdim_Isenable No CHAR (1) A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
Bpartner_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
Bpartner_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
Bpartner_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
Product_Acctdim_Isenable No CHAR (1) Identifies an item which is either purchased or sold in this organization.
Product_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
Product_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
Product_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
Costcenter_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
Costcenter_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
Costcenter_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
User1_Acctdim_Isenable No CHAR (1) The user defined element displays the optional elements that have been defined for this account combination.
User1_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
User1_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
User1_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
User2_Acctdim_Isenable No CHAR (1) The user defined element displays the optional elements that have been defined for this account combination.
User2_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
User2_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
User2_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
Costcenter_Acctdim_Isenable No CHAR (1) Division that adds to the cost of an organization. Internal structure for cost allocation.
Org_Acctdim_Isenable No CHAR (1)
Org_Acctdim_Header No CHAR (1) This flag indicates whether the accounting dimension is displayed on document header tab.
Org_Acctdim_Lines No CHAR (1) This flag indicates whether the accounting dimension is displayed on document lines tab.
Org_Acctdim_Breakdown No CHAR (1) This flag indicates whether the accounting dimension is displayed on document break down tab.
DaysToPasswordExpiration Yes DECIMAL (10,0) Define the days that user password must be valid from previous password change, if value is set to 0 no update will be required, for value greater than 0, password must be updated when the last password update date of the user plus the days defined here achieves. It will affect to all users depending the client.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Value No NVARCHAR (40) 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.

SMTPHost Yes NVARCHAR (60) The host name of the Mail Server for this client with SMTP services to send mail, and IMAP to process incoming mail.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
IsActive No CHAR (1) 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.

AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.

Columns

Request User



top


Multilingual Documents



top


Language


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

top


Request Email



top


SMTP Authentification



top


Request Folder



top


Request User Password



top


Name


top


Currency


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

top


Acctdim_Centrally_Maintained



top


Project_Acctdim_Isenable



top


Project_Acctdim_Header



top


Project_Acctdim_Lines



top


Project_Acctdim_Breakdown



top


Bpartner_Acctdim_Isenable



top


Bpartner_Acctdim_Header



top


Bpartner_Acctdim_Lines



top


Bpartner_Acctdim_Breakdown



top


Product_Acctdim_Isenable



top


Product_Acctdim_Header



top


Product_Acctdim_Lines



top


Product_Acctdim_Breakdown



top


Costcenter_Acctdim_Header



top


Costcenter_Acctdim_Lines



top


Costcenter_Acctdim_Breakdown



top


User1_Acctdim_Isenable



top


User1_Acctdim_Header



top


User1_Acctdim_Lines



top


User1_Acctdim_Breakdown



top


User2_Acctdim_Isenable



top


User2_Acctdim_Header



top


User2_Acctdim_Lines



top


User2_Acctdim_Breakdown



top


Costcenter_Acctdim_Isenable



top


Org_Acctdim_Isenable



top


Org_Acctdim_Header



top


Org_Acctdim_Lines



top


Org_Acctdim_Breakdown



top


DaysToPasswordExpiration



top


Description



top


Client



It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Search Key



top


Mail Host



top


Updated



top


Updated By


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

top


Created By


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

top


Creation Date



top


Active



top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.ad.system

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

This page has been accessed 4,988 times. This page was last modified on 1 December 2016, at 02:14. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.