ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Process
AD_Process
- Name:AD_Process
- Classname:ADProcess
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
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Advanced Feature
- Physical column name: IsAdvancedFeature
- Property Name: advancedFeature
- Reference: YesNo
- Default value: N
Background
- Physical column name: IsBackground
- Property Name: background
- Reference: YesNo
- Default value: N
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@)
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
Data Access Level
- Physical column name: AccessLevel
- Property Name: dataAccessLevel
- Reference: List
List values: AD_Table Access Levels
The allowed values for this list are:
- 1 (Organization)
- 3 (Client/Organization)
- 4 (System only)
- 7 (All)
- 6 (System/Client)
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Direct print
- Physical column name: IsDirectPrint
- Property Name: directPrint
- Reference: YesNo
- Default value: N
External Service
- Physical column name: Isexternalservice
- Property Name: externalService
- Reference: YesNo
- Default value: N
Help/Comment
- Physical column name: Help
- Property Name: helpComment
- Reference: Text
JR Template name
- Physical column name: Jrname
- Property Name: jRTemplateName
- Reference: Text
Jasper Report
- Physical column name: IsJasper
- Property Name: jasperReport
- Reference: YesNo
- Default value: N
Java Class Name
- Physical column name: Classname
- Property Name: javaClassName
- Reference: String
Killable
- Physical column name: Iskillable
- Property Name: killable
- Reference: YesNo
- Default value: N
Module
- Physical column name: AD_Module_ID
- Property Name: module
- Reference: TableDir
- Default value: 0
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'
Name
- Physical column name: Name
- Property Name: name
- 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)
Prevent Concurrent Executions
- Physical column name: PreventConcurrent
- Property Name: preventConcurrentExecutions
- Reference: YesNo
- Default value: N
Procedure
- Physical column name: ProcedureName
- Property Name: procedure
- Reference: String
Process
- Physical column name: AD_Process_ID
- Property Name: id
- Reference: ID
Report
- Physical column name: IsReport
- Property Name: report
- Reference: YesNo
- Default value: Y
Requires Explicit Access Permission
- Physical column name: Is_Explicit_Access
- Property Name: requiresExplicitAccessPermission
- Reference: YesNo
- Default value: N
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
UI Pattern
- Physical column name: UIPattern
- Property Name: uIPattern
- Reference: List
- Default value: S
List values: AD_Process UIPattern
The allowed values for this list are:
- S (Standard)
- M (Manual)
- OBUIAPP_PickAndExecute (Pick and Execute)
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)
User can start process
- Physical column name: IsUserStartable
- Property Name: userCanStartProcess
- Reference: YesNo
- Default value: Y
Other Info
Check Constraints
These are the check constraints for this table:
- AD_PROCESS_ADV_CHCK: ISADVANCEDFEATURE IN ('Y', 'N')
- AD_PROCESS_CONCURRENT_CHCK: PREVENTCONCURRENT IN ('Y', 'N')
- AD_PROCESS_EXPLICITACCESS_CK: IS_EXPLICIT_ACCESS IN ('Y', 'N')
- AD_PROCESS_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- AD_PROCESS_ISBACKGROUND_CHK: ISBACKGROUND IN ('Y', 'N')
- AD_PROCESS_ISDIRECTPRINT_CHK: ISDIRECTPRINT IN ('Y', 'N')
- AD_PROCESS_ISEXTERNALSERVI_CHK: ISEXTERNALSERVICE IN ('Y', 'N')
- AD_PROCESS_ISKILLABLE_CHK: ISKILLABLE IN ('Y', 'N')
- AD_PROCESS_ISREPORT_CHK: ISREPORT IN ('Y', 'N')
- AD_PROCESS_ISUSERSTARTABLE_CHK: ISUSERSTARTABLE IN ('Y', 'N')
- AD_PROCESS_UIPATTERN_CHK: UIPATTERN IN ('S', 'M')
![]() | Back to org.openbravo.model.ad.ui |