ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.system/AD System Info
AD_System_Info
- Name:AD_System_Info
- Classname:ADSystemInformation
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
- Physical column name: AD_System_Info_ID
- Property Name: id
- Reference: ID
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Ant Version
- Physical column name: ANT_Version
- Property Name: antVersion
- Reference: String
Change_Instance_Purpose
- Physical column name: Change_Instance_Purpose
- Property Name: changeInstancePurpose
- Reference: Button
- Default value: Y
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
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@)
Company_Logo
- Physical column name: Company_Logo
- Property Name: companyLogo
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Company_Logo_Dark
- Physical column name: Company_Logo_Dark
- Property Name: companyLogoDark
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Company_Logo_For_Docs
- Physical column name: Company_Logo_For_Docs
- Property Name: companyLogoForDocs
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Company_Logo_For_Receipts
- Physical column name: Company_Logo_For_Receipts
- Property Name: companyLogoForReceipts
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Company_Logo_Submark
- Physical column name: Company_Logo_Submark
- Property Name: companyLogoSubmark
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Company_Logo_Submark_Dark
- Physical column name: Company_Logo_Submark_Dark
- Property Name: companyLogoSubmarkDark
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Customization Allowed
- Physical column name: Customization_Allowed
- Property Name: customizationAllowed
- Reference: YesNo
- Default value: N
Callout: SysInfoCustomAllowed
This column has a callout associated.
It is implemented by [1] Java Class.
DB Checksum
- Physical column name: DB_Checksum
- Property Name: dBChecksum
- Reference: String
Enable Heartbeat
- Physical column name: Isheartbeatactive
- Property Name: enableHeartbeat
- Reference: Button
Instance_Purpose
- Physical column name: Instance_Purpose
- Property Name: instancePurpose
- Reference: List
List values: InstancePurpose
The allowed values for this list are:
- T (Testing)
- P (Production)
- D (Development)
- E (Evaluation)
Isusageauditenabled
- Physical column name: IsUsageAuditEnabled
- Property Name: isusageauditenabled
- Reference: YesNo
- Default value: Y
Last Build
- Physical column name: Last_Build
- Property Name: lastBuild
- Reference: DateTime
- Default value: SYSDATE
Last DB Update
- Physical column name: Last_DBUpdate
- Property Name: lastDBUpdate
- Reference: DateTime
- Default value: SYSDATE
Maturity_Search
- Physical column name: Maturity_Search
- Property Name: maturitySearch
- Reference: String
- Default value: 500
Maturity_Update
- Physical column name: Maturity_Update
- Property Name: maturityUpdate
- Reference: String
- Default value: 500
Openbravo Install Mode
- Physical column name: OB_Installmode
- Property Name: openbravoInstallMode
- Reference: String
Openbravo Version
- Physical column name: OB_Version
- Property Name: openbravoVersion
- Reference: String
- This column is part of the table's identifier
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Postpone_Date
- Physical column name: Postpone_Date
- Property Name: postponeDate
- Reference: Date
Production_Banner_Image_ID
- Physical column name: Production_Banner_Image_ID
- Property Name: productionBannerImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Proxy Password
- Physical column name: Proxy_Password
- Property Name: proxyPassword
- Reference: Password (decryptable)
Proxy Port
- Physical column name: Proxy_Port
- Property Name: proxyPort
- Reference: Integer
Proxy Required
- Physical column name: Isproxyrequired
- Property Name: proxyRequired
- Reference: YesNo
- Default value: N
Proxy Server
- Physical column name: Proxy_Server
- Property Name: proxyServer
- Reference: String
Proxy User
- Physical column name: Proxy_User
- Property Name: proxyUser
- Reference: String
Requires Proxy Authentication
- Physical column name: IsProxy_Authenticated
- Property Name: requiresProxyAuthentication
- Reference: YesNo
- Default value: N
Show_Community_Branding
- Physical column name: Show_Community_Branding
- Property Name: showCommunityBranding
- Reference: YesNo
- Default value: Y
Support_Contact
- Physical column name: Support_Contact
- Property Name: supportContact
- Reference: String
System Identifier
- Physical column name: System_Identifier
- Property Name: systemIdentifier
- Reference: String
- This column is part of the table's identifier
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:
- 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)
- RB45 (Copy files)
- RB41 (WAD generation)
- RB11 (Database Model Load)
- RB40 (Source compilation)
Test Heartbeat
- Physical column name: Testproxy
- Property Name: testHeartbeat
- Reference: List
- Default value: N
List values: AD_Heartbeat - Status
The allowed values for this list are:
- N (Enable Heartbeat)
- Y (Disable Heartbeat)
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)
Web Server
- Physical column name: Webserver
- Property Name: webServer
- Reference: String
Web Server Version
- Physical column name: Webserver_Version
- Property Name: webServerVersion
- Reference: String
Your Company Big Image
- Physical column name: Your_Company_Big_Image
- Property Name: yourCompanyBigImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Your Company Document Image
- Physical column name: Your_Company_Document_Image
- Property Name: yourCompanyDocumentImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Your Company Login Image
- Physical column name: Your_Company_Login_Image
- Property Name: yourCompanyLoginImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Your Company Menu Image
- Physical column name: Your_Company_Menu_Image
- Property Name: yourCompanyMenuImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Your Company URL
- Physical column name: YourCompanyURL
- Property Name: yourCompanyURL
- Reference: Link
Your It Service Login Image
- Physical column name: Your_It_Service_Login_Image
- Property Name: yourItServiceLoginImage
- Reference: Image BLOB
Foreign key column to AD_Image table, (column: AD_Image_ID)
Other Info
Check Constraints
These are the check constraints for this table:
- AD_SYSTEM_INFO_CHANGE_PURPOSE: CHANGE_INSTANCE_PURPOSE IN ('Y', 'N')
- AD_SYSTEM_INFO_CUSTOMIZATI_CHK: CUSTOMIZATION_ALLOWED IN ('Y', 'N')
- AD_SYSTEM_INFO_SHOW_COMMBRAND: SHOW_COMMUNITY_BRANDING IN ('Y', 'N')
- AD_SYSTEMINFO_USAGEAUDITENAB: ISUSAGEAUDITENABLED IN ('Y', 'N')
![]() | Back to org.openbravo.model.ad.system |