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


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

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.

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.
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.
Isexternalservice Yes CHAR (1) Sets the process as a external service that is loadable from the application menu.
Service_Type Yes VARCHAR (60) Indicates the type of the external service
Service_Source Yes NVARCHAR (2000) Indicates where is located the external service. It can be an URL or a path.
AD_Module_ID No VARCHAR (32) Indicates the module the element forms part of.
UIPattern No VARCHAR (60) Defines the UI Pattern that the object implements.
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.

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

Iskillable No CHAR (1) Define if a background process is killable
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.

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.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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
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)
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.
IsDirectPrint Yes CHAR (1) The Direct Print checkbox indicates that this report will print without a print dialog box being displayed.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
ProcedureName Yes NVARCHAR (60) The Procedure indicates the name of the database procedure called by this report or process.
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
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.

Columns

Name


top


Data Access Level



List values: AD_Table Access Levels

The allowed values for this list are:

top


Search Key



top


Background



top


JR Template name



top


Jasper Report



top


External Service



top


Service Type



List values: External Services

The allowed values for this list are:

top


Service Source



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


UI Pattern


List values: AD_Process UIPattern

The allowed values for this list are:

top


Advanced Feature



top


Prevent Concurrent Executions



top


Requires Explicit Access Permission



top


Killable



top


Active



top


Organization


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

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


Process



top


Report



top


User can start process



top


Java Class Name



top


Direct print



top


Updated



top


Procedure



top


Help/Comment



top


Description



top


Updated By


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

top


Created By


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

top


Creation Date



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 1,810 times. This page was last modified on 1 December 2016, at 02:14. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.