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

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

ANT_Version Yes NVARCHAR (60) The version of Ant used to build the application.
Change_Instance_Purpose Yes CHAR (1) Button to change the purpose of Community Edition instances.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Company_Logo Yes VARCHAR (32) This logo will be used in the login screen and inside all Openbravo applications
Company_Logo_Dark Yes VARCHAR (32) This logo will be used in the login screen and inside all Openbravo applications when they use

a Dark theme. Note that this logo should have different colors or more contrast than the original logo in order to be seen properly in a dark background.

Company_Logo_For_Docs Yes VARCHAR (32) Company Logo used to be printed in invoices or other documents
Company_Logo_For_Receipts Yes VARCHAR (32) Company Logo used to be printed in receipts. Usually those receipts are printed using only black ink, so this logo should be adapted to be able to print it properly using only one ink.
Company_Logo_Submark Yes VARCHAR (32) The submark logo is a simplified version of the Company Logo which is consistent with your brand and can be used to replace the Company Logo in places where this logo does not fit, such as in an application in a narrow screen where the Company Logo has no room to be showed properly
Company_Logo_Submark_Dark Yes VARCHAR (32) The submark logo is a simplified version of the Company Logo which is consistent with your brand and can be used to replace the Company Logo in places where this logo does not fit, such as in an application on a narrow screen where the Company Logo has no room to be showed properly. Note that this logo should have different colors or more contrast than the original logo in order to be seen properly over a dark background.
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.
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.
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.
Isheartbeatactive Yes CHAR (1) Disable Heartbeat process
Instance_Purpose Yes VARCHAR (60) Determines which is the purpose of the Openbravo 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.

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.
Maturity_Search No VARCHAR (60) Defines the minimum accepted maturity status of modules when they are searched for installation.
Maturity_Update No VARCHAR (60) Defines the minimum accepted maturity status of modules when they are scanned for update.
OB_Installmode Yes NVARCHAR (20) The method used to install Openbravo.
OB_Version Yes NVARCHAR (20) The version of this installed Openbravo instance
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.
Postpone_Date Yes TIMESTAMP (7) Date set when user selects 'Later'
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.

Proxy_Password Yes VARCHAR (100) Password for the authenticated proxy
Proxy_Port Yes DECIMAL (10,0) Proxy port on the proxy server.
Isproxyrequired No CHAR (1) Proxy configuration required to access internet.
Proxy_Server Yes NVARCHAR (100) Proxy server name.
Proxy_User Yes VARCHAR (100) User for the authenticated proxy
IsProxy_Authenticated No CHAR (1) Check this field in case the proxy requires authenticated user/password
Show_Community_Branding No CHAR (1) Sets whether Openbravo News are shown to all users or only to the System Administrator.
Support_Contact Yes NVARCHAR (200) IT service support contact
System_Identifier Yes VARCHAR (60) Unique ID identying this instance of Openbravo.
System_Status Yes VARCHAR (60) System Status changes on different build, deploy and servlet container events.
Testproxy No VARCHAR (60) Test the current proxy configuration.
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.
Webserver Yes NVARCHAR (20) The Web Server being used by Openbravo
Webserver_Version Yes NVARCHAR (20) The version of Web Server
Your_Company_Big_Image Yes VARCHAR (32)
Your_Company_Document_Image Yes VARCHAR (32)
Your_Company_Login_Image Yes VARCHAR (32) Default Company Login image
Your_Company_Menu_Image Yes VARCHAR (32)
YourCompanyURL Yes NVARCHAR (200) URL of your Comapany. This info is used to make linkable the Comapany logo in the login page.
Your_It_Service_Login_Image Yes VARCHAR (32)

Columns

AD_System_Info_ID



top


Active



top


Ant Version



top


Change_Instance_Purpose



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



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

top


Company_Logo_Dark


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

top


Company_Logo_For_Docs


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

top


Company_Logo_For_Receipts


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

top


Company_Logo_Submark


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

top


Company_Logo_Submark_Dark


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

top


Created By


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

top


Creation Date



top


Customization Allowed


Callout: SysInfoCustomAllowed

This column has a callout associated.

It is implemented by [1] Java Class.

top


DB Checksum



top


Enable Heartbeat



top


Instance_Purpose



List values: InstancePurpose

The allowed values for this list are:

top


Isusageauditenabled



top


Last Build



top


Last DB Update



top


Maturity_Search



top


Maturity_Update



top


Openbravo Install Mode



top


Openbravo Version


top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Postpone_Date



top


Production_Banner_Image_ID


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

top


Proxy Password



top


Proxy Port



top


Proxy Required



top


Proxy Server



top


Proxy User



top


Requires Proxy Authentication



top


Show_Community_Branding



top


Support_Contact



top


System Identifier


top


System_Status



List values: AD_System System Status

The allowed values for this list are:

top


Test Heartbeat


List values: AD_Heartbeat - Status

The allowed values for this list are:

top


Updated



top


Updated By


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

top


Web Server



top


Web Server Version



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


Your Company 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 URL



top


Your It Service Login Image


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

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 6,400 times. This page was last modified on 6 February 2023, at 01:40. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.