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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.ui/AD Process Request

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.ad.ui

Index

Contents

AD_Process_Request

Create a new Process Request to be executed immediately, at a later date or on a recurring basis.

This table contains the following columns:

Name Nullable Data Type Description
AD_Process_Request_ID NVARCHAR2(32)Request to run a Process.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
Isactive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
AD_Process_ID NVARCHAR2(32)A series of actions carried out in sequential order.
Description YVARCHAR2(255)A space to write additional related information.
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
Isrolesecurity YCHAR(1)A flag indicating whether access to an item should be based on a user's role within the system.
OB_Context YCLOB(4000)The context in which a Process Request was scheduled or executed.
Status YVARCHAR2(60)A defined state or position of a payment.
Next_Fire_Time YDATEThe next time a process will execute.
Previous_Fire_Time YDATEThe last time this Process Request was executed.
Scheduled_Finish YDATEThe date and time a Process Request is due to finish (repeating).
Channel YVARCHAR2(20)The method by which this Process request was executed/scheduled.
Timing_Option YVARCHAR2(60)When to run a Process Request - either immediately, at a later date or on a recurring basis.
Start_Time YDATEThe time at which an item is due to, or did, start.
Start_Date YDATEThe date on which an item is due to start.
Frequency YVARCHAR2(60)The number of times something occurs during a specified time period.
Secondly_Interval YNUMBER(10, 0)Interval in hours between an event (such as a process execution).
Minutely_Interval YNUMBER(10, 0)Interval in minutes between an event (such as a process execution).
Hourly_Interval YNUMBER(10, 0)Interval in hours between an event (such as a process execution).
Daily_Interval YNUMBER(10, 0)The daily interval between executions of a process.
Secondly_Repetitions YNUMBER(10, 0)The number of times this element will repeat.
Minutely_Repetitions YNUMBER(10, 0)The number of times this element will repeat.
Hourly_Repetitions YNUMBER(10, 0)The number of times this element will repeat.
DAY_Mon YCHAR(1)The day of the week Monday.
DAY_Tue YCHAR(1)The day of the week Tuesday.
DAY_Wed YCHAR(1)The day of the week Wednesday.
DAY_Thu YCHAR(1)The day of the week Thursday.
DAY_Fri YCHAR(1)The day of the week Friday.
DAY_Sat YCHAR(1)The day of the week Saturday.
DAY_Sun YCHAR(1)The day of the week Sunday.
Monthly_Option YVARCHAR2(60)An option by which to schedule a Process in a monthly manner.
Monthly_Specific_Day YNUMBERThe specific date within each month.
Monthly_Day_Of_Week YVARCHAR2(60)A day within a week.
Finishes YCHAR(1)Specifiy that this item should finish.
Finishes_Time YDATEThe time that this item will finish.
Finishes_Date YDATEThe date that this item will finish.
Daily_Option YVARCHAR2(60)Option to run a Process Request on a daily basis.
Cron YVARCHAR2(60)A Quartz cron expression to schedule this Process Request.
AD_Process_Set_ID YVARCHAR2(32)Unique identifier for a Process Set (a collection of Process Requests).
Schedule YCHAR(1)Schedule a Process to be executed, either immediately, at a later date or on a recurring basis.
Reschedule YCHAR(1)Reschedule a previoulsy (or currently) scheduled Process Request.
Unschedule YCHAR(1)Unschedule the Process.
Params YVARCHAR2(4000)null

Other Info

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

AD_Process_Request_ID

Request to run a Process, either directly or scheduled for a later date.

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

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


Validation Rule AD_Org Security validation: Organizations of the Client with user acces rights. With the following code:

 
(@AD_Client_ID@='0' AND AD_Org.AD_Org_ID='0') OR (@AD_Client_ID@!='0' AND ((AD_Org.AD_Client_ID IN (@#User_Client@) AND AD_Org.AD_Org_ID IN (@#User_Org@)) OR AD_Org.AD_Org_ID='0' AND AD_Org.IsSummary='N'))

top

Active

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

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

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

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

top

Process

Foreign key column to AD_Process table, (column: AD_Process_ID)


Validation Rule AD_Process isBackground: null. With the following code:

 
AD_Process.IsBackground='Y'

top

Description

A description is limited to 255 characters.

top

User/Contact

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

top

Security Based on Role

A flag indicating whether access to an item should be based on a user's role within the system.

top

Openbravo Context

The context in which a Process Request was scheduled or executed. The context contains information such as user, client, organization, language, date format etc.

top

Status

Current status of a debt/payment.

List values: Process Status

The allowed values for this list are:

top

Next Execution

The next time a process will execute.

top

Previous Execution

The last time this Process Request was executed.

top

Finish

The date and time a Process Request is due to finish (repeating).

top

Channel

The method by which this Process request was executed/scheduled (Direct, Scheduled, Webservice)

top

Timing

When to run a Process Request - either immediately, at a later date or on a recurring basis.

List values: Process Timing Option

The allowed values for this list are:

top

Start Time

The time at which an item is due to, or did, start.

top

Start Date

The date on which an item is due to start.

top

Frequency

The frequency is used in conjunction with the frequency type in determining an event. Example: If the Frequency Type is Week and the Frequency is 2 - it is every two weeks.

List values: Process Frequency

The allowed values for this list are:

top

Interval in Seconds

Interval in hours between an event (such as a process execution).

top

Interval in Minutes

Interval in minutes between an event (such as a process execution).

top

Hourly Interval

Interval in hours between an event (such as a process execution).

top

Daily_Interval

The daily interval between executions of a process.

top

Repetitions

The number of times this element will repeat.

top

Num Repetitions

The number of times this element will repeat.

top

Number of Repetitions

The number of times this element will repeat.

top

Monday

The day of the week Monday.

top

Tuesday

The day of the week Tuesday.

top

Wednesday

The day of the week Wednesday.

top

Thursday

The day of the week Thursday.

top

Friday

The day of the week Friday.

top

Saturday

The day of the week Saturday.

top

Sunday

The day of the week Sunday.

top

Monthly Option

An option by which to schedule a Process in a monthly manner. The option can be a specific date within each month, the last day of each month, or the Nth selected day within each month, such as the first Wednesday of each month.

List values: Process Month Option

The allowed values for this list are:

top

Day in Month

The specific date within each month. For example, specifying 15 will signify the 15th of each month.

top

Day of the Week

A day within a week.

List values: Weekdays

The allowed values for this list are:

top

Finishes

Specifiy that this item should finish.

top

Finish Time

The time that this item will finish.

top

Finish Date

The date that this item will finish.

top

Daily Option

Option to run a Process Request on a daily basis.

List values: Process Daily Option

The allowed values for this list are:

top

Cron Expression

A Quartz cron expression to schedule this Process Request. More information on Quartz cron expression can be found at http://quartz.sourceforge.net/javadoc/org/quartz/CronTrigger.html and

top

AD_Process_Set_ID

Unique identifier for a Process Set (a collection of Process Requests).

top

Schedule Process

Schedule a Process to be executed, either immediately, at a later date or on a recurring basis.

top

Reschedule Process

Reschedule a previoulsy (or currently) scheduled Process Request.

top

Unschedule Process

Unschedule the Process.

top

Params

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.ad.ui/AD_Process_Request"

This page has been accessed 4,158 times. This page was last modified on 14 June 2011, at 11:03. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.