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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Process

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


Contents

AD_Process

This table contains the following columns:

Name Nullable Data Type Description


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.

IsAdvancedFeature Yes CHAR (1) Automatic roles are granted with all non advanced features defined within application dictionary.

Advanced features are only granted to the automatic roles defined as advanced.

IsBackground No CHAR (1) This identifies a background process that will be run without any user interaction and needs to be scheduled properly before it will be run using the "Process Scheduling" window.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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.
AccessLevel No VARCHAR (60) Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed. We can classify data in 4 major categories:

- System (AD_CLIENT_ID=0, AD_ORG_ID=0) - system data (such as metadata for window, tab and field definition) - Organization (AD_CLIENT<>0, AD_ORG_ID<>0) - data particular to an organization (such as sales orders) - Client/Organization (AD_CLIENT<>0, AD_ORG_ID=anything) - data particular to an organization or shared among all organizations within one client - Client (AD_CLIENT<>0, AD_ORG_ID=0) - data that is specific to a client but can be used by all organizations within that client

or All (AD_CLIENT=anything, AD_ORG_ID=anything)

Description Yes NVARCHAR (255) A description is limited to 255 characters.
IsDirectPrint Yes CHAR (1) The Direct Print checkbox indicates that this report will print without a print dialog box being displayed.
Isexternalservice Yes CHAR (1) Sets the process as a external service that is loadable from the application menu.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
Jrname Yes NVARCHAR (256) Defines the name (including the extension) of the main tamplate (jrxml file) of the Jasper Report.
IsJasper Yes CHAR (1) Defines that the report is a jasper report.
Classname Yes NVARCHAR (200) The classname is used when generating a representation of the table in java (the entity or business object). The classname is the simplename of the class (so without the package name). Often the AD_Table.name can be used here. The combination of classname and package needs to be unique.
Iskillable No CHAR (1) Define if a background process is killable
AD_Module_ID No VARCHAR (32) Indicates the module the element forms part of.
Name No NVARCHAR (60) A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
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.
PreventConcurrent No CHAR (1) When the process is scheduled as background process and this flag is set, in case there is another instance of this process already in execution, a new instance is not executed.
ProcedureName Yes NVARCHAR (60) The Procedure indicates the name of the database procedure called by this report or process.
AD_Process_ID No VARCHAR (32) The Process field identifies a unique Process or Report in the system.
IsReport No CHAR (1) The Report checkbox indicates that this record is a report as opposed to a process
Is_Explicit_Access No CHAR (1) When processes are executed from a button in a window, by default, they inherit permissions granted to the window. So if the window is accessible it can be executed without the need of explicitly granting access for that role to the process.

This behavior can be overwritten by the "Secured Process" preference.

Processes with "Requires Explicit Access Permission" flag set to true, do not inherit permissions from the window but they always require the role to be explicitly granted to this process.

Value No NVARCHAR (40) A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

UIPattern No VARCHAR (60) Defines the UI Pattern that the object implements.
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.
IsUserStartable Yes CHAR (1) The User can start Process checkbox indicates that this process can be initiated by the user (as opposed to system initiated)

Columns

Active



top


Advanced Feature



top


Background



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


Created By


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

top


Creation Date



top


Data Access Level



List values: AD_Table Access Levels

The allowed values for this list are:

top


Description



top


Direct print



top


External Service



top


Help/Comment



top


JR Template name



top


Jasper Report



top


Java Class Name



top


Killable



top


Module


Foreign key column to AD_Module table, (column: AD_Module_ID) It has a validation "Ad_Module_ID IsInDevelopment", with the following code

IsInDevelopment = 'Y' and type != 'T'

top


Name


top


Organization


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

top


Prevent Concurrent Executions



top


Procedure



top


Process



top


Report



top


Requires Explicit Access Permission



top


Search Key



top


UI Pattern


List values: AD_Process UIPattern

The allowed values for this list are:

top


Updated



top


Updated By


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

top


User can start process



top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.ad.ui

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.ui/AD_Process"

This page has been accessed 5,153 times. This page was last modified on 15 November 2023, at 09:36. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.