验证规则 (窗口 ID-103)
窗口: 验证规则
描述: Maintain dynamic Validation Rules for columns and fields
幫助: 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: 验证
描述: 验证规则
幫助 The Validation Rules Tab defines all dynamic rules used when entering and maintaining columns and fields.
File:验证规则 - 验证 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Dynamic Validation | 动态验证 | 验证规则 | The Validation Rule indicates a unique validation rule. These rules define how an entry is determined to valid or invalid. | AD_Val_Rule_ID numeric(10) NOT NULL ID |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL 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. | Name character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Entity Type | 实体类型 | 字典实体类型; 确定所有者和同步性 | 实体类型"字典/Dictionary", "Adempiere" 和 "应用/Application" 能够自动的同步因此客户化的工作将被删除或覆盖
要客户化,请复制实体并选择"用户/User"! |
EntityType character varying(40) NOT NULL 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 character(1) List |
| Validation code | 错误信息 | Validation Code 错误信息 | The Validation Code displays the date, time and message of the error. | Code character varying(2000) Text |
TAB: Used in Column
描述: Used in Column
幫助 null
File:验证规则 - Used in Column - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Table | 表 | 字段所在表 | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL 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. | ColumnName character varying(30) NOT NULL String |
| System Element | 系统元素 | 系统元素使得我们能够对列的描述和帮助进行集中维护。 | 系统元素使得我们能够对数据库字段的描述、帮助和词汇进行集中维护。 | 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. | Name character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Comment/Help | 注释/帮助 | 注释或提示 | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Length | 长度 | Length of the column in the database | The Length indicates the length of a column as defined in the database. | FieldLength numeric(10) Integer |
| Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_ID numeric(10) NOT NULL 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 numeric(10) Table |
| Dynamic Validation | 动态验证 | 验证规则 | The Validation Rule indicates a unique validation rule. These rules define how an entry is determined to valid or invalid. | AD_Val_Rule_ID numeric(10) Table Direct |
.png){kind=link}
.png){kind=link}