验证规则 (窗口 ID-103)

来自iDempiere zh
跳转至:导航搜索



窗口: 验证规则

描述: 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


Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。