ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.system/AD System Info
AD_System_Info
- Name:ADSystemInformation
- Classname:SystemInformation
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_System_Info_ID | N | VARCHAR2(32) | null |
| 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 |
| System_Identifier | Y | VARCHAR2(60) | Unique ID identying this instance of Openbravo. |
| Isheartbeatactive | Y | CHAR(1) | Disable Heartbeat process |
| Postpone_Date | Y | DATE | Date set when user selects 'Later' |
| Isproxyrequired | Y | CHAR(1) | Proxy configuration required to access internet. |
| Proxy_Server | Y | NVARCHAR2(100) | Proxy server used to access the internet. |
| Proxy_Port | Y | NUMBER(10, 0) | Proxy port on the proxy server used to access the internet. |
| Testproxy | Y | VARCHAR2(60) | Test the current proxy configuration. |
| ANT_Version | Y | NVARCHAR2(60) | The version of Ant used to build the application. |
| OB_Version | Y | NVARCHAR2(20) | The version of Openbravo. |
| OB_Installmode | Y | NVARCHAR2(20) | The method used to install Openbravo. |
| Code_Revision | Y | VARCHAR2(60) | The code revision of the installed system |
| Servlet_Container | Y | NVARCHAR2(20) | The type of servlet container Openbravo runs in. |
| Servlet_Container_Version | Y | NVARCHAR2(20) | The version of Servlet Container Openbravo runs in. |
| Webserver | Y | NVARCHAR2(20) | The Web Server being used by Openbravo |
| Webserver_Version | Y | NVARCHAR2(20) | The version of Web Server |
| Customization_Allowed | N | CHAR(1) | Allow customizations in CORE module. |
| Last_Build | Y | DATE | Last time the system was built |
| Last_DBUpdate | Y | DATE | Last database update |
| DB_Checksum | Y | VARCHAR2(32) | It is a checksum for the whole database |
| Your_Company_Login_Image | Y | VARCHAR2(32) | null |
| Your_It_Service_Login_Image | Y | VARCHAR2(32) | null |
| Your_Company_Menu_Image | Y | VARCHAR2(32) | null |
| Your_Company_Big_Image | Y | VARCHAR2(32) | null |
| Your_Company_Document_Image | Y | VARCHAR2(32) | null |
| Support_Contact | Y | NVARCHAR2(200) | IT service support contact |
| System_Status | Y | VARCHAR2(60) | null |
| Maturity_Update | N | VARCHAR2(60) | Minimum Maturity Status of modules for update |
| Maturity_Search | N | VARCHAR2(60) | Minimum Maturity Status of modules for search |
| IsProxy_Authenticated | N | CHAR(1) | Is authentication requiered to use the proxy |
| Proxy_User | Y | VARCHAR2(100) | User for the authenticated proxy |
| Proxy_Password | Y | VARCHAR2(100) | Password for the authenticated proxy |
| Instance_Purpose | Y | VARCHAR2(60) | null |
| IsUsageAuditEnabled | N | CHAR(1) | null |
| Change_Instance_Purpose | Y | CHAR(1) | null |
| Show_Community_Branding | N | CHAR(1) | null |
| Production_Banner_Image_ID | Y | VARCHAR2(32) | null |
| ShowForgeLogo | N | CHAR(1) | Show Openbravo Forge Logo in Login. |
| YourCompanyURL | Y | NVARCHAR2(200) | URL of your Comapany. |
| IsCustomQueryEnabled | N | CHAR(1) | Send Custom Queries to Heartbeat |
Other Info
Check constraints
These are the check constraints for this table:
- AD_SYSTEMINFO_USAGEAUDITENAB: ISUSAGEAUDITENABLED IN ('Y', 'N')
- AD_SYSTEM_INFO_CHANGE_PURPOSE: CHANGE_INSTANCE_PURPOSE IN ('Y', 'N')
- AD_SYSTEM_INFO_CUSTOMIZATI_CHK: CUSTOMIZATION_ALLOWED IN ('Y', 'N')
- AD_SYSTEM_INFO_QRYENABLED: ISCUSTOMQUERYENABLED IN ('Y', 'N')
- AD_SYSTEM_INFO_SHOWFORGE: SHOWFORGELOGO IN ('Y', 'N')
- AD_SYSTEM_INFO_SHOW_COMMBRAND: SHOW_COMMUNITY_BRANDING 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_SYSTEM_INFO_KEY
Columns
AD_System_Info_ID
- Physical column name: AD_System_Info_ID
- Property Name: id
- Reference: ID
Callout: Activation_Message
This element is linked to a callout.
Inform the user about the legal issues on Heartbeat activation
It is implemented by org.openbravo.erpCommon.ad_callouts.Activation_Message Java class.
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
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@)
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
- Default value: SYSDATE
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
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
- 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)
System Identifier
Unique ID identying this instance of Openbravo.
- Physical column name: System_Identifier
- Property Name: systemIdentifier
- Reference: String
- This column is part of the table's identifier
Disable Heartbeat
Disable Heartbeat process
- Physical column name: Isheartbeatactive
- Property Name: enableHeartbeat
- Reference: Button
Postpone_Date
Date set when user selects 'Later'
- Physical column name: Postpone_Date
- Property Name: postponeDate
- Reference: Date
Proxy Required
Proxy configuration required to access internet.
- Physical column name: Isproxyrequired
- Property Name: proxyRequired
- Reference: YesNo
- Default value: N
Proxy Server
Proxy server name.
- Physical column name: Proxy_Server
- Property Name: proxyServer
- Reference: String
Proxy Port
Proxy port on the proxy server.
- Physical column name: Proxy_Port
- Property Name: proxyPort
- Reference: Integer
Test Heartbeat
Test the current proxy configuration.
- Physical column name: Testproxy
- Property Name: testHeartbeat
- Reference: Button
- Default value: N
Callout: Activation_Message
This element is linked to a callout.
Inform the user about the legal issues on Heartbeat activation
It is implemented by org.openbravo.erpCommon.ad_callouts.Activation_Message Java class.
Ant Version
The version of Ant used to build the application.
- Physical column name: ANT_Version
- Property Name: antVersion
- Reference: String
Openbravo Version
The version of this installed Openbravo instance
- Physical column name: OB_Version
- Property Name: openbravoVersion
- Reference: String
- This column is part of the table's identifier
Openbravo Install Mode
The method used to install Openbravo.
- Physical column name: OB_Installmode
- Property Name: openbravoInstallMode
- Reference: String
Code Revision
The code revision of the installed system
- Physical column name: Code_Revision
- Property Name: codeRevision
- Reference: String
- Default value: 0
Servlet Container
The type of servlet container Openbravo runs in.
- Physical column name: Servlet_Container
- Property Name: servletContainer
- Reference: String
Servlet Container Version
The version of Servlet Container Openbravo runs in.
- Physical column name: Servlet_Container_Version
- Property Name: servletContainerVersion
- Reference: String
Web Server
The Web Server being used by Openbravo
- Physical column name: Webserver
- Property Name: webServer
- Reference: String
Web Server Version
The version of Web Server
- Physical column name: Webserver_Version
- Property Name: webServerVersion
- Reference: String
Customization Allowed
In order to customize the CORE module, it's necessary to create an industry template. Checking this field the industry template is auto-generated.
- Physical column name: Customization_Allowed
- Property Name: customizationAllowed
- Reference: YesNo
- Default value: N
Last Build
Indicates the last time the system was built, its purpose is to add the ability of knowing which are the modifications done since that time in order to determinate the objects that need to be re-created.
- Physical column name: Last_Build
- Property Name: lastBuild
- Reference: DateTime
- Default value: SYSDATE
Last DB Update
Indicates the last time the database was updated using dbsm its purpose is to add the ability of knowing which are the modifications done since that time in order to determinate if it is necessary to export them or not.
- Physical column name: Last_DBUpdate
- Property Name: lastDBUpdate
- Reference: DateTime
- Default value: SYSDATE
DB Checksum
Database checksum maintains a checksum for the whole database structure, it is used just in PostgreSQL databases to know if it was modified after the last update from xml files.
- Physical column name: DB_Checksum
- Property Name: dBChecksum
- Reference: String
Your Company Login Image
Default Company Login image
- Physical column name: Your_Company_Login_Image
- Property Name: yourCompanyLoginImage
- Reference: Image BLOB
Your It Service Login Image
- Physical column name: Your_It_Service_Login_Image
- Property Name: yourItServiceLoginImage
- Reference: Image BLOB
Your Company Menu Image
- Physical column name: Your_Company_Menu_Image
- Property Name: yourCompanyMenuImage
- Reference: Image BLOB
Your Company Big Image
- Physical column name: Your_Company_Big_Image
- Property Name: yourCompanyBigImage
- Reference: Image BLOB
Your Company Document Image
- Physical column name: Your_Company_Document_Image
- Property Name: yourCompanyDocumentImage
- Reference: Image BLOB
Support_Contact
IT service support contact
- Physical column name: Support_Contact
- Property Name: supportContact
- Reference: String
System_Status
- Physical column name: System_Status
- Property Name: systemStatus
- Reference: List
List values: AD_System System Status
The allowed values for this list are:
- RB45 (Copy files)
- RB41 (WAD generation)
- RB11 (Database Model Load)
- RB12 (Generation of change list)
- RB44 (WebContent folder generation)
- RB00 (System was built successfuly)
- RB42 (xsql class generation)
- RB50 (Rebuild successful, context needs to be restarted)
- RB43 (Java compilation)
- RB10 (Database Update)
- RB20 (Entity generation)
- RB30 (Reference data and translation info loading)
- RB13 (Database structure update)
- RB14 (Database data update)
- RB40 (Source compilation)
Maturity_Update
Defines the minimum accepted maturity status of modules when they are scanned for update.
- Physical column name: Maturity_Update
- Property Name: maturityUpdate
- Reference: String
- Default value: 500
Maturity_Search
Defines the minimum accepted maturity status of modules when they are searched for installation.
- Physical column name: Maturity_Search
- Property Name: maturitySearch
- Reference: String
- Default value: 500
Requires Proxy Authentication
Check this field in case the proxy requires authenticated user/password
- Physical column name: IsProxy_Authenticated
- Property Name: requiresProxyAuthentication
- Reference: YesNo
- Default value: N
Proxy User
User for the authenticated proxy
- Physical column name: Proxy_User
- Property Name: proxyUser
- Reference: String
Proxy Password
Password for the authenticated proxy
- Physical column name: Proxy_Password
- Property Name: proxyPassword
- Reference: String
Instance_Purpose
Determines which is the purpose of the Openbravo ERP instance
- Physical column name: Instance_Purpose
- Property Name: instancePurpose
- Reference: List
List values: InstancePurpose
The allowed values for this list are:
- D (Development)
- E (Evaluation)
- P (Production)
- T (Testing)
Isusageauditenabled
When the Usage Audit is enabled each request to the backend is stored on the audit table (AD_Session_Usage_Audit). For each request is stored the object_id, the module_id, the session_id and the command.
If the Heartbeat is also enabled the number of requests per module on the last 30 days is sent on each beat.
- Physical column name: IsUsageAuditEnabled
- Property Name: isusageauditenabled
- Reference: YesNo
- Default value: Y
Change_Instance_Purpose
Button to change the purpose of Community Edition instances.
- Physical column name: Change_Instance_Purpose
- Property Name: changeInstancePurpose
- Reference: Button
- Default value: Y
Show_Community_Branding
Sets whether the Community Branding is shown to all users or only to the System Administrator.
- Physical column name: Show_Community_Branding
- Property Name: showCommunityBranding
- Reference: YesNo
- Default value: Y
Production_Banner_Image_ID
Image used to be shown on instances with Production purpose.
There is an example image on the Login folder of the Default skin.
- Physical column name: Production_Banner_Image_ID
- Property Name: productionBannerImage
- Reference: Image BLOB
Show Forge Logo in Login
Show Openbravo Forge Logo in Login window.
- Physical column name: ShowForgeLogo
- Property Name: showForgeLogoInLogin
- Reference: YesNo
- Default value: Y
Your Company URL
URL of your Comapany. This info is used to make linkable the Comapany logo in the login page.
- Physical column name: YourCompanyURL
- Property Name: yourCompanyURL
- Reference: Link
Enable Custom Queries
The Custom Queries are queries that can be sent by the Heartbeat server to be executed on the Openbravo ERP instance. This queries are used the get more extended information about the usage of the instance.
By disabling this option standard beats will be sent to HeartBeat server, but not these Custom Queries.
- Physical column name: IsCustomQueryEnabled
- Property Name: enableCustomQueries
- Reference: YesNo
- Default value: Y