Window: Validation Rules
[Created: 21/05/1999 - Updated: 02/01/2000 ]
Description: Maintain dynamic Validation Rules for columns and fields
Help: The Validation Rules Window defines all dynamic rules used when entering and maintaining columns and fields. This window is for System Admin use only.
Tab: Validation
[Created: 21/05/1999 - Updated: 24/08/2022 ]
Description: Validation Rules
Help: The Validation Rules Tab defines all dynamic rules used when entering and maintaining columns and fields.
Tab Level: 0
Table 10: Validation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_val_rule.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_val_rule.AD_Org_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_val_rule.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_val_rule.Description character varying(255) String |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_val_rule.IsActive character(1) Yes-No |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_val_rule.EntityType character varying(40) Table |
| Type | Type of Validation (SQL, Java Script, Java Language) | The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language. | ad_val_rule.Type character(1) List |
| Validation code | Validation Code | The Validation Code displays the date, time and message of the error. | ad_val_rule.Code character varying(4000) String |
Tab: Used in Column
[Created: 27/10/2005 - Updated: 27/10/2005 ]
Description: Used in Column
Help:
Tab Level: 1
Table 20: Used in Column - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_column.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_column.AD_Org_ID numeric(10) Table Direct |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_column.AD_Table_ID numeric(10) Table Direct |
| DB Column Name | Name of the column in the database | The Column Name indicates the name of a column on a table as defined in the database. | ad_column.ColumnName character varying(63) String |
| System Element | System Element enables the central maintenance of column description and help. | The System Element allows for the central maintenance of help, descriptions and terminology for a database column. | ad_column.AD_Element_ID numeric(10) Search |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | ad_column.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_column.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | ad_column.Help character varying(2000) Text |
| Active | The record is active in the system | 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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | ad_column.IsActive character(1) Yes-No |
| Length | Length of the column in the database | The Length indicates the length of a column as defined in the database. | ad_column.FieldLength numeric(10) Integer |
| Reference | System Reference and Validation | The Reference could be a display type, list or table validation. | ad_column.AD_Reference_ID numeric(10) Table |
| Reference Key | Required to specify, if data type is Table or List | The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List. | ad_column.AD_Reference_Value_ID numeric(10) Table |
| Dynamic Validation | Dynamic Validation Rule | These rules define how an entry is determined to valid. You can use variables for dynamic (context sensitive) validation. | ad_column.AD_Val_Rule_ID numeric(10) Table Direct |
Tab: Used in Column (Lookup)
[Created: 22/06/2019 - Updated: 24/02/2022 ]
Description: Used in Column (Lookup)
Help:
Tab Level: 1
Table 30: Used in Column (Lookup) - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Table | Database Table information | The Database Table provides the information of the table definition | ad_column.AD_Table_ID numeric(10) Table Direct |
| Column | Column in the table | Link to the database column of the table | ad_column.AD_Column_ID numeric(10) ID |
| DB Column Name | Name of the column in the database | The Column Name indicates the name of a column on a table as defined in the database. | ad_column.ColumnName character varying(63) String |