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

Contents 1 AD_System_Info 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Unique 1.2 Columns 1.2.1 AD_System_Info_ID 1.2.1.1 Callout: Activation_Message 1.2.2 Client 1.2.3 Organization 1.2.4 Active 1.2.5 Creation Date 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 System Identifier 1.2.10 Disable Heartbeat 1.2.11 Postpone_Date 1.2.12 Proxy Required 1.2.13 Proxy Server 1.2.14 Proxy Port 1.2.15 Test Heartbeat 1.2.15.1 Callout: Activation_Message 1.2.16 Ant Version 1.2.17 Openbravo Version 1.2.18 Openbravo Install Mode 1.2.19 Code Revision 1.2.20 Servlet Container 1.2.21 Servlet Container Version 1.2.22 Web Server 1.2.23 Web Server Version 1.2.24 Customization Allowed 1.2.25 Last Build 1.2.26 Last DB Update 1.2.27 DB Checksum 1.2.28 Your Company Login Image 1.2.29 Your It Service Login Image 1.2.30 Your Company Menu Image 1.2.31 Your Company Big Image 1.2.32 Your Company Document Image 1.2.33 Support_Contact 1.2.34 System_Status 1.2.34.1 List values: AD_System System Status 1.2.35 Maturity_Update 1.2.36 Maturity_Search 1.2.37 Requires Proxy Authentication 1.2.38 Proxy User 1.2.39 Proxy Password 1.2.40 Instance_Purpose 1.2.40.1 List values: InstancePurpose 1.2.41 Isusageauditenabled 1.2.42 Change_Instance_Purpose 1.2.43 Show_Community_Branding 1.2.44 Production_Banner_Image_ID 1.2.45 Show Forge Logo in Login 1.2.46 Your Company URL 1.2.47 Enable Custom Queries

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')

top

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
  • AD_System_Info_ID

top

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.

top

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@)

top

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)

top

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

top

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

top

Created By

• Physical column name: Createdby
• Property Name: createdBy
• Reference: Search

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

top

Updated

The Updated field indicates the date that this record was updated.

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

• Physical column name: Updatedby
• Property Name: updatedBy
• Reference: Search

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

top

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

top

Disable Heartbeat

Disable Heartbeat process

• Physical column name: Isheartbeatactive
• Property Name: enableHeartbeat
• Reference: Button

top

Postpone_Date

Date set when user selects 'Later'

• Physical column name: Postpone_Date
• Property Name: postponeDate
• Reference: Date

top

Proxy Required

Proxy configuration required to access internet.

• Physical column name: Isproxyrequired
• Property Name: proxyRequired
• Reference: YesNo
• Default value: N

top

Proxy Server

Proxy server name.

• Physical column name: Proxy_Server
• Property Name: proxyServer
• Reference: String

top

Proxy Port

Proxy port on the proxy server.

• Physical column name: Proxy_Port
• Property Name: proxyPort
• Reference: Integer

top

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.

top

Ant Version

The version of Ant used to build the application.

• Physical column name: ANT_Version
• Property Name: antVersion
• Reference: String

top

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

top

Openbravo Install Mode

The method used to install Openbravo.

• Physical column name: OB_Installmode
• Property Name: openbravoInstallMode
• Reference: String

top

Code Revision

The code revision of the installed system

• Physical column name: Code_Revision
• Property Name: codeRevision
• Reference: String
• Default value: 0

top

Servlet Container

The type of servlet container Openbravo runs in.

• Physical column name: Servlet_Container
• Property Name: servletContainer
• Reference: String

top

Servlet Container Version

The version of Servlet Container Openbravo runs in.

• Physical column name: Servlet_Container_Version
• Property Name: servletContainerVersion
• Reference: String

top

Web Server

The Web Server being used by Openbravo

• Physical column name: Webserver
• Property Name: webServer
• Reference: String

top

Web Server Version

The version of Web Server

• Physical column name: Webserver_Version
• Property Name: webServerVersion
• Reference: String

top

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

top

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

top

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

top

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

top

Your Company Login Image

Default Company Login image

• Physical column name: Your_Company_Login_Image
• Property Name: yourCompanyLoginImage
• Reference: Image BLOB

top

Your It Service Login Image

• Physical column name: Your_It_Service_Login_Image
• Property Name: yourItServiceLoginImage
• Reference: Image BLOB

top

Your Company Menu Image

• Physical column name: Your_Company_Menu_Image
• Property Name: yourCompanyMenuImage
• Reference: Image BLOB

top

Your Company Big Image

• Physical column name: Your_Company_Big_Image
• Property Name: yourCompanyBigImage
• Reference: Image BLOB

top

Your Company Document Image

• Physical column name: Your_Company_Document_Image
• Property Name: yourCompanyDocumentImage
• Reference: Image BLOB

top

Support_Contact

IT service support contact

• Physical column name: Support_Contact
• Property Name: supportContact
• Reference: String

top

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:

• RB00 (System was built successfuly)
• RB10 (Database Update)
• RB11 (Database Model Load)
• RB12 (Generation of change list)
• RB13 (Database structure update)
• RB14 (Database data update)
• RB20 (Entity generation)
• RB30 (Reference data and translation info loading)
• RB40 (Source compilation)
• RB41 (WAD generation)
• RB42 (xsql class generation)
• RB43 (Java compilation)
• RB44 (WebContent folder generation)
• RB45 (Copy files)
• RB50 (Rebuild successful, context needs to be restarted)

top

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

top

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

top

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

top

Proxy User

User for the authenticated proxy

• Physical column name: Proxy_User
• Property Name: proxyUser
• Reference: String

top

Proxy Password

Password for the authenticated proxy

• Physical column name: Proxy_Password
• Property Name: proxyPassword
• Reference: String

top

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)

top

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

top

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

top

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

top

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

top

Show Forge Logo in Login

Show Openbravo Forge Logo in Login window.

• Physical column name: ShowForgeLogo
• Property Name: showForgeLogoInLogin
• Reference: YesNo
• Default value: Y

top

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

top

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

top