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

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

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

Index

Contents

AD_System_Info

This table contains the following columns:

Name Nullable Data Type Description
AD_System_Info_ID NVARCHAR2(32)null
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
System_Identifier YVARCHAR2(60)Unique ID identying this instance of Openbravo.
Isheartbeatactive YCHAR(1)Disable Heartbeat process
Postpone_Date YDATEDate set when user selects 'Later'
Isproxyrequired YCHAR(1)Proxy configuration required to access internet.
Proxy_Server YNVARCHAR2(100)Proxy server used to access the internet.
Proxy_Port YNUMBER(10, 0)Proxy port on the proxy server used to access the internet.
Testproxy YVARCHAR2(60)Test the current proxy configuration.
ANT_Version YNVARCHAR2(60)The version of Ant used to build the application.
OB_Version YNVARCHAR2(20)The version of Openbravo.
OB_Installmode YNVARCHAR2(20)The method used to install Openbravo.
Code_Revision YVARCHAR2(60)The code revision of the installed system
Servlet_Container YNVARCHAR2(20)The type of servlet container Openbravo runs in.
Servlet_Container_Version YNVARCHAR2(20)The version of Servlet Container Openbravo runs in.
Webserver YNVARCHAR2(20)The Web Server being used by Openbravo
Webserver_Version YNVARCHAR2(20)The version of Web Server
Customization_Allowed NCHAR(1)Allow customizations in CORE module.
Last_Build YDATELast time the system was built
Last_DBUpdate YDATELast database update
DB_Checksum YVARCHAR2(32)It is a checksum for the whole database
Your_Company_Login_Image YVARCHAR2(32)null
Your_It_Service_Login_Image YVARCHAR2(32)null
Your_Company_Menu_Image YVARCHAR2(32)null
Your_Company_Big_Image YVARCHAR2(32)null
Your_Company_Document_Image YVARCHAR2(32)null
Support_Contact YNVARCHAR2(200)IT service support contact
System_Status YVARCHAR2(60)null
Maturity_Update NVARCHAR2(60)Minimum Maturity Status of modules for update
Maturity_Search NVARCHAR2(60)Minimum Maturity Status of modules for search
IsProxy_Authenticated NCHAR(1)Is authentication requiered to use the proxy
Proxy_User YVARCHAR2(100)User for the authenticated proxy
Proxy_Password YVARCHAR2(100)Password for the authenticated proxy
Instance_Purpose YVARCHAR2(60)null
IsUsageAuditEnabled NCHAR(1)null
Change_Instance_Purpose YCHAR(1)null
Show_Community_Branding NCHAR(1)null
Production_Banner_Image_ID YVARCHAR2(32)null
ShowForgeLogo NCHAR(1)Show Openbravo Forge Logo in Login.
YourCompanyURL YNVARCHAR2(200)URL of your Comapany.
IsCustomQueryEnabled NCHAR(1)Send Custom Queries to Heartbeat

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

AD_System_Info_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

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

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

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

top

Updated

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

top

Updated By

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

top

System Identifier

Unique ID identying this instance of Openbravo.

top

Disable Heartbeat

Disable Heartbeat process

top

Postpone_Date

Date set when user selects 'Later'

top

Proxy Required

Proxy configuration required to access internet.

top

Proxy Server

Proxy server name.

top

Proxy Port

Proxy port on the proxy server.

top

Test Heartbeat

Test the current proxy configuration.

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.

top

Openbravo Version

The version of this installed Openbravo instance

top

Openbravo Install Mode

The method used to install Openbravo.

top

Code Revision

The code revision of the installed system

top

Servlet Container

The type of servlet container Openbravo runs in.

top

Servlet Container Version

The version of Servlet Container Openbravo runs in.

top

Web Server

The Web Server being used by Openbravo

top

Web Server Version

The version of Web Server

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.

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.

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.

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.

top

Your Company Login Image

Default Company Login image

top

Your It Service Login Image

top

Your Company Menu Image

top

Your Company Big Image

top

Your Company Document Image

top

Support_Contact

IT service support contact

top

System_Status

List values: AD_System System Status

The allowed values for this list are:

top

Maturity_Update

Defines the minimum accepted maturity status of modules when they are scanned for update.

top

Maturity_Search

Defines the minimum accepted maturity status of modules when they are searched for installation.

top

Requires Proxy Authentication

Check this field in case the proxy requires authenticated user/password

top

Proxy User

User for the authenticated proxy

top

Proxy Password

Password for the authenticated proxy

top

Instance_Purpose

Determines which is the purpose of the Openbravo ERP instance

List values: InstancePurpose

The allowed values for this list are:

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.

top

Change_Instance_Purpose

Button to change the purpose of Community Edition instances.

top

Show_Community_Branding

Sets whether the Community Branding is shown to all users or only to the System Administrator.

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.

top

Show Forge Logo in Login

Show Openbravo Forge Logo in Login window.

top

Your Company URL

URL of your Comapany. This info is used to make linkable the Comapany logo in the login page.

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.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_System_Info"

This page has been accessed 4,610 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.