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

2022-01-05T10:57:11Z

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

New page

{{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]]

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

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

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