ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system/AD Client
AD_Client
- Name:AD_Client
- Classname:ADClient
This table contains the following columns:
Name | Nullable | Data Type | Description
|
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. |
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. |
Bpartner_Acctdim_Breakdown | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document break down tab. |
Bpartner_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header 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_Lines | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document lines tab. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
Costcenter_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_Isenable | No | CHAR (1) | Division that adds to the cost of an organization. Internal structure for cost allocation. |
Costcenter_Acctdim_Lines | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document lines tab. |
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. |
C_Currency_ID | Yes | VARCHAR (32) | Indicates the currency to be used when processing this document. |
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_Language | Yes | VARCHAR (6) | The Language identifies the language to use for display |
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. |
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. |
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. |
Org_Acctdim_Breakdown | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document break down tab. |
Org_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header tab. |
Org_Acctdim_Isenable | No | CHAR (1) | |
Org_Acctdim_Lines | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document lines tab. |
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. |
Product_Acctdim_Breakdown | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document break down tab. |
Product_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header tab. |
Product_Acctdim_Isenable | No | CHAR (1) | Identifies an item which is either purchased or sold in this organization. |
Product_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. |
Project_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header tab. |
Project_Acctdim_Isenable | No | CHAR (1) | Identifier of a project defined within the Project & Service Management module. |
Project_Acctdim_Lines | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document lines tab. |
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. |
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. |
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. |
RequestUserPW | Yes | NVARCHAR (60) | Password of the user name (ID) for mail processing |
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. |
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. |
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. |
User1_Acctdim_Breakdown | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document break down tab. |
User1_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header 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_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. |
User2_Acctdim_Header | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document header 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_Lines | No | CHAR (1) | This flag indicates whether the accounting dimension is displayed on document lines tab. |
Columns
Acctdim_Centrally_Maintained
- Physical column name: Acctdim_Centrally_Maintained
- Property Name: acctdimCentrallyMaintained
- Reference: YesNo
- Default value: N
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Bpartner_Acctdim_Breakdown
- Physical column name: Bpartner_Acctdim_Breakdown
- Property Name: bpartnerAcctdimBreakdown
- Reference: YesNo
- Default value: N
Bpartner_Acctdim_Header
- Physical column name: Bpartner_Acctdim_Header
- Property Name: bpartnerAcctdimHeader
- Reference: YesNo
- Default value: N
Bpartner_Acctdim_Isenable
- Physical column name: Bpartner_Acctdim_Isenable
- Property Name: bpartnerAcctdimIsenable
- Reference: YesNo
- Default value: N
Bpartner_Acctdim_Lines
- Physical column name: Bpartner_Acctdim_Lines
- Property Name: bpartnerAcctdimLines
- Reference: YesNo
- Default value: N
Client
- Physical column name: AD_Client_ID
- Property Name: id
- Reference: ID
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Costcenter_Acctdim_Breakdown
- Physical column name: Costcenter_Acctdim_Breakdown
- Property Name: costcenterAcctdimBreakdown
- Reference: YesNo
- Default value: N
Costcenter_Acctdim_Header
- Physical column name: Costcenter_Acctdim_Header
- Property Name: costcenterAcctdimHeader
- Reference: YesNo
- Default value: N
Costcenter_Acctdim_Isenable
- Physical column name: Costcenter_Acctdim_Isenable
- Property Name: costcenterAcctdimIsenable
- Reference: YesNo
- Default value: N
Costcenter_Acctdim_Lines
- Physical column name: Costcenter_Acctdim_Lines
- Property Name: costcenterAcctdimLines
- Reference: YesNo
- Default value: N
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
DaysToPasswordExpiration
- Physical column name: DaysToPasswordExpiration
- Property Name: daysToPasswordExpiration
- Reference: Integer
- Default value: 0
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Language
- Physical column name: AD_Language
- Property Name: language
- Reference: Table
Foreign key column to AD_Language table, (column: AD_Language)
Mail Host
- Physical column name: SMTPHost
- Property Name: mailHost
- Reference: String
Multilingual Documents
- Physical column name: IsMultiLingualDocument
- Property Name: multilingualDocuments
- Reference: YesNo
- Default value: N
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Org_Acctdim_Breakdown
- Physical column name: Org_Acctdim_Breakdown
- Property Name: orgAcctdimBreakdown
- Reference: YesNo
- Default value: N
Org_Acctdim_Header
- Physical column name: Org_Acctdim_Header
- Property Name: orgAcctdimHeader
- Reference: YesNo
- Default value: N
Org_Acctdim_Isenable
- Physical column name: Org_Acctdim_Isenable
- Property Name: orgAcctdimIsenable
- Reference: YesNo
- Default value: N
Org_Acctdim_Lines
- Physical column name: Org_Acctdim_Lines
- Property Name: orgAcctdimLines
- Reference: YesNo
- Default value: N
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Product_Acctdim_Breakdown
- Physical column name: Product_Acctdim_Breakdown
- Property Name: productAcctdimBreakdown
- Reference: YesNo
- Default value: N
Product_Acctdim_Header
- Physical column name: Product_Acctdim_Header
- Property Name: productAcctdimHeader
- Reference: YesNo
- Default value: N
Product_Acctdim_Isenable
- Physical column name: Product_Acctdim_Isenable
- Property Name: productAcctdimIsenable
- Reference: YesNo
- Default value: N
Product_Acctdim_Lines
- Physical column name: Product_Acctdim_Lines
- Property Name: productAcctdimLines
- Reference: YesNo
- Default value: N
Project_Acctdim_Breakdown
- Physical column name: Project_Acctdim_Breakdown
- Property Name: projectAcctdimBreakdown
- Reference: YesNo
- Default value: N
Project_Acctdim_Header
- Physical column name: Project_Acctdim_Header
- Property Name: projectAcctdimHeader
- Reference: YesNo
- Default value: N
Project_Acctdim_Isenable
- Physical column name: Project_Acctdim_Isenable
- Property Name: projectAcctdimIsenable
- Reference: YesNo
- Default value: N
Project_Acctdim_Lines
- Physical column name: Project_Acctdim_Lines
- Property Name: projectAcctdimLines
- Reference: YesNo
- Default value: N
Request Email
- Physical column name: RequestEMail
- Property Name: requestEmail
- Reference: String
Request Folder
- Physical column name: RequestFolder
- Property Name: requestFolder
- Reference: String
Request User
- Physical column name: RequestUser
- Property Name: requestUser
- Reference: String
Request User Password
- Physical column name: RequestUserPW
- Property Name: requestUserPassword
- Reference: Password (decryptable)
SMTP Authentification
- Physical column name: IsSmtpAuthorization
- Property Name: sMTPAuthentification
- Reference: YesNo
- Default value: N
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
User1_Acctdim_Breakdown
- Physical column name: User1_Acctdim_Breakdown
- Property Name: user1AcctdimBreakdown
- Reference: YesNo
- Default value: N
User1_Acctdim_Header
- Physical column name: User1_Acctdim_Header
- Property Name: user1AcctdimHeader
- Reference: YesNo
- Default value: N
User1_Acctdim_Isenable
- Physical column name: User1_Acctdim_Isenable
- Property Name: user1AcctdimIsenable
- Reference: YesNo
- Default value: N
User1_Acctdim_Lines
- Physical column name: User1_Acctdim_Lines
- Property Name: user1AcctdimLines
- Reference: YesNo
- Default value: N
User2_Acctdim_Breakdown
- Physical column name: User2_Acctdim_Breakdown
- Property Name: user2AcctdimBreakdown
- Reference: YesNo
- Default value: N
User2_Acctdim_Header
- Physical column name: User2_Acctdim_Header
- Property Name: user2AcctdimHeader
- Reference: YesNo
- Default value: N
User2_Acctdim_Isenable
- Physical column name: User2_Acctdim_Isenable
- Property Name: user2AcctdimIsenable
- Reference: YesNo
- Default value: N
User2_Acctdim_Lines
- Physical column name: User2_Acctdim_Lines
- Property Name: user2AcctdimLines
- Reference: YesNo
- Default value: N
Other Info
Check Constraints
These are the check constraints for this table:
- AD_CLIENT_BP_BD_CHCK: BPARTNER_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_BP_DIM_CHCK: BPARTNER_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_BP_H_CHCK: BPARTNER_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_BP_L_CHCK: BPARTNER_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_CCENTER_BD_CHCK: COSTCENTER_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_CCENTER_CHCK: COSTCENTER_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_CCENTER_H_CHCK: COSTCENTER_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_CCENTER_L_CHCK: COSTCENTER_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_CENTMAINT_CHCK: ACCTDIM_CENTRALLY_MAINTAINED IN ('Y', 'N')
- AD_CLIENT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- AD_CLIENT_ORG_BD_CHCK: ORG_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_ORG_DIM_CHCK: ORG_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_ORG_H_CHCK: ORG_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_ORG_L_CHCK: ORG_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_PRODUCT_BD_CHCK: PRODUCT_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_PRODUCT_DIM_CHCK: PRODUCT_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_PRODUCT_H_CHCK: PRODUCT_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_PRODUCT_L_CHCK: PRODUCT_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_PROJECT_BD_CHCK: PROJECT_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_PROJECT_DIM_CHCK: PROJECT_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_PROJECT_H_CHCK: PROJECT_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_PROJECT_L_CHCK: PROJECT_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_USER1_BD_CHCK: USER1_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_USER1_DIM_CHCK: USER1_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_USER1_H_CHCK: USER1_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_USER1_L_CHCK: USER1_ACCTDIM_LINES IN ('Y', 'N')
- AD_CLIENT_USER2_BD_CHCK: USER2_ACCTDIM_BREAKDOWN IN ('Y', 'N')
- AD_CLIENT_USER2_DIM_CHCK: USER2_ACCTDIM_ISENABLE IN ('Y', 'N')
- AD_CLIENT_USER2_H_CHCK: USER2_ACCTDIM_HEADER IN ('Y', 'N')
- AD_CLIENT_USER2_L_CHCK: USER2_ACCTDIM_LINES IN ('Y', 'N')
![]() | Back to org.openbravo.model.ad.system |