View source for ERP/3.0/Developers Guide/Database Model/org.openbravo.model.ad.process/AD PInstance Para

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

= AD_PInstance_Para =
*'''Name''':AD_PInstance_Para
*'''Classname''':ADParameter
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_Para#AD_PInstance_Para_ID|AD_PInstance_Para_ID]] 
| No
| VARCHAR (32)
| 

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#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_Para#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_Para#Comments|Info]] 
| Yes
| NVARCHAR (60)
| The Information displays data from the source document line.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#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_Para#Creation Date|Created]] 
| Yes
| 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_Para#Info To|Info_To]] 
| Yes
| NVARCHAR (60)
| The Information displays data from the source document line.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#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_Para#P_String|P_String]] 
| Yes
| NVARCHAR (60)
| String passed as parameter to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#P_String_To|P_String_To]] 
| Yes
| NVARCHAR (60)
| String passed as maximum string range to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#Parameter Name|ParameterName]] 
| Yes
| NVARCHAR (60)
| Name describing the parameter.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#Process Date|P_Date]] 
| Yes
| TIMESTAMP (7)
| Date passed as parameter to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#Process Date To|P_Date_To]] 
| Yes
| TIMESTAMP (7)
| Date passed as maximum date as parameter to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#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_Para#Process Number|P_Number]] 
| Yes
| DECIMAL
| Number passed as parameter to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#Process Number To|P_Number_To]] 
| Yes
| DECIMAL
| Number passed as maximum range as parameter to a process instance.

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#Sequence Number|SeqNo]] 
| No
| VARCHAR (32)
| The Sequence indicates the order of records

|-
| [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance_Para#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_Para#Updated By|UpdatedBy]] 
| Yes
| VARCHAR (32)
| The Updated By field indicates the user who updated this record.

|}

== Columns ==

=== AD_PInstance_Para_ID ===
*'''Physical column name''': AD_PInstance_Para_ID
* '''Property Name''': id
*'''Reference''': ID





[[#AD_PInstance_Para|top]]


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




[[#AD_PInstance_Para|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_Para|top]]


=== Comments ===
*'''Physical column name''': Info
* '''Property Name''': comments
*'''Reference''': String





[[#AD_PInstance_Para|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_Para|top]]


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




[[#AD_PInstance_Para|top]]


=== Info To ===
*'''Physical column name''': Info_To
* '''Property Name''': infoTo
*'''Reference''': String





[[#AD_PInstance_Para|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_Para|top]]


=== P_String ===
*'''Physical column name''': P_String
* '''Property Name''': string
*'''Reference''': String





[[#AD_PInstance_Para|top]]


=== P_String_To ===
*'''Physical column name''': P_String_To
* '''Property Name''': stringTo
*'''Reference''': String





[[#AD_PInstance_Para|top]]


=== Parameter Name ===
*'''Physical column name''': ParameterName
* '''Property Name''': parameterName
*'''Reference''': String

* This column is part of the table's identifier



[[#AD_PInstance_Para|top]]


=== Process Date ===
*'''Physical column name''': P_Date
* '''Property Name''': processDate
*'''Reference''': Date





[[#AD_PInstance_Para|top]]


=== Process Date To ===
*'''Physical column name''': P_Date_To
* '''Property Name''': processDateTo
*'''Reference''': Date





[[#AD_PInstance_Para|top]]


=== Process Instance ===
*'''Physical column name''': AD_PInstance_ID
* '''Property Name''': processInstance
*'''Reference''': TableDir


* This column is a child for a business object (is Parent)
Foreign key column  to [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance|AD_PInstance]] table, (column: [[ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.ad.process/AD_PInstance#AD_PInstance_ID|AD_PInstance_ID]])

[[#AD_PInstance_Para|top]]


=== Process Number ===
*'''Physical column name''': P_Number
* '''Property Name''': processNumber
*'''Reference''': Number
* '''Default value''': 0




[[#AD_PInstance_Para|top]]


=== Process Number To ===
*'''Physical column name''': P_Number_To
* '''Property Name''': processNumberTo
*'''Reference''': Number
* '''Default value''': 0




[[#AD_PInstance_Para|top]]


=== Sequence Number ===
*'''Physical column name''': SeqNo
* '''Property Name''': sequenceNumber
*'''Reference''': ID





[[#AD_PInstance_Para|top]]


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




[[#AD_PInstance_Para|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_Para|top]]


== Other Info ==



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


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