ManPageW ValidationRules
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Window: Validation Rules
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
Description : Validation Rules
Help : The Validation Rules Tab defines all dynamic rules used when entering and maintaining columns and fields.
Table Name : AD_Val_Rule
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| 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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten.
For customizations, copy the entity and select "User"! |
EntityType
VARCHAR2 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. | Type
CHAR(1) List |
| Validation code | Validation Code | The Validation Code displays the date, time and message of the error. | Code
NVARCHAR2(2000) Text |
Tab: Used in Column
Description : Used in Column
Help :
Table Name : AD_Column
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Table | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID
NUMBER(10) TableDir |
| 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. | ColumnName
VARCHAR2 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_Element_ID
NUMBER(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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
| Length | Length of the column in the database | The Length indicates the length of a column as defined in the database. | FieldLength
NUMBER(10) Integer |
| Reference | System Reference and Validation | The Reference could be a display type, list or table validation. | AD_Reference_ID
NUMBER(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_Reference_Value_ID
NUMBER(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_Val_Rule_ID
NUMBER(10) TableDir |
