Wikiadmin: Created page with "{{BackTo | ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process }} = AD_PInstance = '''Name''':AD_PInstance '''Classname''':ADProcessInstance This table c..."

2022-01-05T10:55:48Z

Created page with "{{BackTo | ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process }} = AD_PInstance = *'''Name''':AD_PInstance *'''Classname''':ADProcessInstance This table c..."

New page

{{BackTo | ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process }}

= AD_PInstance =
*'''Name''':AD_PInstance
*'''Classname''':ADProcessInstance
This table contains the following columns:
{| class="prettytable sortable" border="1"
|-
| class="tittle" |Name
| class="tittle" |Nullable
| class="tittle" |Data Type
| class="tittle" |Description

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Active|IsActive]]
| Yes
| 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.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Client|AD_Client_ID]]
| Yes
| VARCHAR (32)
| A Client is a company or a legal entity. You cannot share data between Clients.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Created By|CreatedBy]]
| Yes
| VARCHAR (32)
| The Created By field indicates the user who created this record.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Creation Date|Created]]
| No
| TIMESTAMP (7)
| The Created field indicates the date that this record was created.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Error Msg|ErrorMsg]]
| Yes
| NVARCHAR (2000)
| In this filed is stored the error message in case the process fails.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Organization|AD_Org_ID]]
| Yes
| VARCHAR (32)
| An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Process|AD_Process_ID]]
| No
| VARCHAR (32)
| The Process field identifies a unique Process or Report in the system.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Process Instance|AD_PInstance_ID]]
| No
| VARCHAR (32)
| Process Instance identifies the instance of a process. Every time a process is executed a new instance of it is created.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Processing|IsProcessing]]
| No
| CHAR (1)
| When the process is being accomplished this record has 'Y' value, otherwise it has 'N'.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Record ID|Record_ID]]
| No
| VARCHAR (32)
| The Record ID is the internal unique identifier of a record

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Result|Result]]
| Yes
| DECIMAL (10,0)
| The Result indicates the result of any action taken on this request.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Updated|Updated]]
| Yes
| TIMESTAMP (7)
| The Updated field indicates the date that this record was updated.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#Updated By|UpdatedBy]]
| No
| VARCHAR (32)
| The Updated By field indicates the user who updated this record.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#User/Contact|AD_User_ID]]
| Yes
| VARCHAR (32)
| The User identifies a unique user in the system. This could be an internal user or a business partner contact

|}

== Columns ==

=== Active ===
*'''Physical column name''': IsActive
* '''Property Name''': active
*'''Reference''': YesNo
* '''Default value''': Y

[[#AD_PInstance|top]]

=== Client ===
*'''Physical column name''': AD_Client_ID
* '''Property Name''': client
*'''Reference''': TableDir

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_Client|AD_Client]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.system/AD_Client#AD_Client_ID|AD_Client_ID]])
It has a validation "AD_Client Security validation", with the following code
<code lang="sql">
AD_Client.AD_Client_ID in (@#User_Client@)
</code>

[[#AD_PInstance|top]]

=== Created By ===
*'''Physical column name''': CreatedBy
* '''Property Name''': createdBy
*'''Reference''': Search

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User|AD_User]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User#AD_User_ID|AD_User_ID]])

[[#AD_PInstance|top]]

=== Creation Date ===
*'''Physical column name''': Created
* '''Property Name''': creationDate
*'''Reference''': DateTime
* '''Default value''': SYSDATE

[[#AD_PInstance|top]]

=== Error Msg ===
*'''Physical column name''': ErrorMsg
* '''Property Name''': errorMsg
*'''Reference''': String

[[#AD_PInstance|top]]

=== Organization ===
*'''Physical column name''': AD_Org_ID
* '''Property Name''': organization
*'''Reference''': TableDir

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.enterprise/AD_Org|AD_Org]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.enterprise/AD_Org#AD_Org_ID|AD_Org_ID]])

[[#AD_PInstance|top]]

=== Process ===
*'''Physical column name''': AD_Process_ID
* '''Property Name''': process
*'''Reference''': TableDir

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.ui/AD_Process|AD_Process]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.ui/AD_Process#AD_Process_ID|AD_Process_ID]])

[[#AD_PInstance|top]]

=== Process Instance ===
*'''Physical column name''': AD_PInstance_ID
* '''Property Name''': id
*'''Reference''': ID

* This column is part of the table's identifier

[[#AD_PInstance|top]]

=== Processing ===
*'''Physical column name''': IsProcessing
* '''Property Name''': processing
*'''Reference''': YesNo
* '''Default value''': N

[[#AD_PInstance|top]]

=== Record ID ===
*'''Physical column name''': Record_ID
* '''Property Name''': recordID
*'''Reference''': String

[[#AD_PInstance|top]]

=== Result ===
*'''Physical column name''': Result
* '''Property Name''': result
*'''Reference''': Integer

[[#AD_PInstance|top]]

=== Updated ===
*'''Physical column name''': Updated
* '''Property Name''': updated
*'''Reference''': DateTime
* '''Default value''': SYSDATE

[[#AD_PInstance|top]]

=== Updated By ===
*'''Physical column name''': UpdatedBy
* '''Property Name''': updatedBy
*'''Reference''': Search

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User|AD_User]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User#AD_User_ID|AD_User_ID]])

[[#AD_PInstance|top]]

=== User/Contact ===
*'''Physical column name''': AD_User_ID
* '''Property Name''': userContact
*'''Reference''': TableDir

Foreign key column to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User|AD_User]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.access/AD_User#AD_User_ID|AD_User_ID]])

[[#AD_PInstance|top]]

== Other Info ==

=== Indices ===

These are the indices for this table (for each index there is a list of all the columns included within it):
* '''AD_PINSTANCE_RECORD''' Not Unique. Columns:
** AD_PROCESS_ID
** RECORD_ID
[[#AD_PInstance|top]]

=== Check Constraints ===
These are the check constraints for this table:
* '''AD_PINSTANCE_ISACTIVE_CHECK''': ISPROCESSING IN ('Y', 'N')
[[#AD_PInstance|top]]

{{BackTo | org.openbravo.model.ad.process }}

[[Category:Database_Entity_Model]] [[Category:Generated Doc]]

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process/AD PInstance - Revision history

Wikiadmin: Created page with "{{BackTo | ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process }} = AD_PInstance = *'''Name''':AD_PInstance *'''Classname''':ADProcessInstance This table c..."

Wikiadmin: Created page with "{{BackTo | ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process }} = AD_PInstance = '''Name''':AD_PInstance '''Classname''':ADProcessInstance This table c..."