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 System Info

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_System_Info

This table contains the following columns:

Name Nullable Data Type Description


AD_System_Info_ID No VARCHAR (32)
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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.
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.

Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Createdby No VARCHAR (32) The Created By field indicates the user who created this record.
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.
System_Identifier Yes VARCHAR (60) Unique ID identying this instance of Openbravo.
Isheartbeatactive Yes CHAR (1) Disable Heartbeat process
Postpone_Date Yes TIMESTAMP (7) Date set when user selects 'Later'
Isproxyrequired No CHAR (1) Proxy configuration required to access internet.
Proxy_Server Yes NVARCHAR (100) Proxy server name.
Proxy_Port Yes DECIMAL (10,0) Proxy port on the proxy server.
Testproxy No VARCHAR (60) Test the current proxy configuration.
ANT_Version Yes NVARCHAR (60) The version of Ant used to build the application.
OB_Version Yes NVARCHAR (20) The version of this installed Openbravo instance
OB_Installmode Yes NVARCHAR (20) The method used to install Openbravo.
Servlet_Container Yes NVARCHAR (20) The type of servlet container Openbravo runs in.
Servlet_Container_Version Yes NVARCHAR (20) The version of Servlet Container Openbravo runs in.
Webserver Yes NVARCHAR (20) The Web Server being used by Openbravo
Webserver_Version Yes NVARCHAR (20) The version of Web Server
Code_Revision Yes VARCHAR (60) The code revision of the installed system
Customization_Allowed No CHAR (1) In order to customize the CORE module, it's necessary to create an industry template. Checking this field the industry template is auto-generated.
Last_Build Yes TIMESTAMP (7) 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.
Last_DBUpdate Yes TIMESTAMP (7) 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.
DB_Checksum Yes VARCHAR (32) 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.
Your_Company_Login_Image Yes VARCHAR (32) Default Company Login image
Your_It_Service_Login_Image Yes VARCHAR (32)
Your_Company_Menu_Image Yes VARCHAR (32)
Your_Company_Big_Image Yes VARCHAR (32)
Your_Company_Document_Image Yes VARCHAR (32)
Support_Contact Yes NVARCHAR (200) IT service support contact
System_Status Yes VARCHAR (60) System Status changes on different build, deploy and servlet container events.
Maturity_Update No VARCHAR (60) Defines the minimum accepted maturity status of modules when they are scanned for update.
Maturity_Search No VARCHAR (60) Defines the minimum accepted maturity status of modules when they are searched for installation.
IsProxy_Authenticated No CHAR (1) Check this field in case the proxy requires authenticated user/password
Proxy_User Yes VARCHAR (100) User for the authenticated proxy
Proxy_Password Yes VARCHAR (100) Password for the authenticated proxy
Instance_Purpose Yes VARCHAR (60) Determines which is the purpose of the Openbravo ERP instance
IsUsageAuditEnabled No CHAR (1) 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.

Change_Instance_Purpose Yes CHAR (1) Button to change the purpose of Community Edition instances.
Show_Community_Branding No CHAR (1) Sets whether Openbravo News are shown to all users or only to the System Administrator.
Production_Banner_Image_ID Yes VARCHAR (32) Image used to be shown on instances with Production purpose.

There is an example image on the Login folder of the Default skin.

ShowForgeLogo No CHAR (1) Show Openbravo Forge Logo in Login window.
YourCompanyURL Yes NVARCHAR (200) URL of your Comapany. This info is used to make linkable the Comapany logo in the login page.
IsCustomQueryEnabled No CHAR (1) 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.

Columns

AD_System_Info_ID



Callout: Activation_Message

This column has a callout associated. Inform the user about the legal issues on Heartbeat activation It is implemented by [1] Java Class.

top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", 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



top


Creation Date



top


Created By


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

top


Updated



top


Updated By


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

top


System Identifier


top


Enable Heartbeat



top


Postpone_Date



top


Proxy Required



top


Proxy Server



top


Proxy Port



top


Test Heartbeat


Callout: Activation_Message

This column has a callout associated. Inform the user about the legal issues on Heartbeat activation It is implemented by [2] Java Class.

List values: AD_Heartbeat - Status

The allowed values for this list are:

top


Ant Version



top


Openbravo Version


top


Openbravo Install Mode



top


Servlet Container



top


Servlet Container Version



top


Web Server



top


Web Server Version



top


Code Revision



top


Customization Allowed


Callout: SysInfoCustomAllowed

This column has a callout associated.

It is implemented by [3] Java Class.

top


Last Build



top


Last DB Update



top


DB Checksum



top


Your Company Login Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your It Service Login Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your Company Menu Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your Company Big Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Your Company Document Image


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Support_Contact



top


System_Status



List values: AD_System System Status

The allowed values for this list are:

top


Maturity_Update



top


Maturity_Search



top


Requires Proxy Authentication



top


Proxy User



top


Proxy Password



top


Instance_Purpose



List values: InstancePurpose

The allowed values for this list are:

top


Isusageauditenabled



top


Change_Instance_Purpose



top


Show_Community_Branding



top


Production_Banner_Image_ID


Foreign key column to AD_Image table, (column: AD_Image_ID)

top


Show Forge Logo in Login



top


Your Company URL



top


Enable Custom Queries



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_System_Info"

This page has been accessed 1,876 times. This page was last modified on 30 September 2015, at 13:46. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.