引用 (窗口 ID-101)
窗口: 引用
描述: 维护系统引用
幫助: The Reference Window defines each field type and its parameters. This window is for System Admin use only.
TAB: 引用
描述: 引用定义
幫助 The Reference Tab defines the references that are used to validate data
File:引用 - 引用 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_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 |
| 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 |
| Entity Type | 实体类型 | 字典实体类型; 确定所有者和同步性 | 实体类型"字典/Dictionary", "Adempiere" 和 "应用/Application" 能够自动的同步因此客户化的工作将被删除或覆盖
要客户化,请复制实体并选择"用户/User"! |
EntityType character varying(40) NOT NULL Table |
| Validation type | 验证类型 | Different method of validating data | The Validation Type indicates the validation method to use. These include list, table or data type validation. | ValidationType character(1) NOT NULL List |
| Value Format | 值格式 | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | 验证元素:(空格)任何的个性
_ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters &数字无空格 A any Letters & Digits NO space converted to upper case c any Letters &数字或空间 C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
VFormat character varying(40) String |
| Order By Value | Order By Value | Order list using the value column instead of the name column | Order list using the value column instead of the name column | IsOrderByValue character(1) Yes-No |
TAB: 引用翻译
描述: null
幫助 null
File:引用 - 引用翻译 - 窗口 (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 |
| Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_ID numeric(10) NOT NULL Table Direct |
| Language | 语言 | 本客户使用的语言 | The Language identifies the language to use for display | AD_Language character varying(6) NOT NULL Table |
| 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 |
| Translated | 已翻译 | 列被翻译 | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) Yes-No |
| 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 |
TAB: 引用列表验证
描述: 引用列表
幫助 The List Validation Tab defines lists to validate data
File:引用 - 引用列表验证 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Reference List | 引用列表 | 基于表的引用列表 | The Reference List field indicates a list of reference values from a database tables. Reference lists populate drop down list boxes in data entry screens | AD_Ref_List_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 |
| Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_ID numeric(10) NOT NULL Table Direct |
| Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
Value character varying(60) NOT NULL String |
| 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 |
| Valid from | 开始有效 | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom timestamp without time zone Date |
| Valid to | 结束有效 | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo timestamp without time zone Date |
TAB: 列表翻译
描述: null
幫助 null
File:引用 - 列表翻译 - 窗口 (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 |
| Reference List | 引用列表 | 基于表的引用列表 | The Reference List field indicates a list of reference values from a database tables. Reference lists populate drop down list boxes in data entry screens | AD_Ref_List_ID numeric(10) NOT NULL Table Direct |
| Language | 语言 | 本客户使用的语言 | The Language identifies the language to use for display | AD_Language character varying(6) NOT NULL Table |
| 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 |
| Translated | 已翻译 | 列被翻译 | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) NOT NULL Yes-No |
| 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 |
TAB: 表验证
描述: 表验证
幫助 The Table Validation Tab defines tables to validate data
File:引用 - 表验证 - 窗口 (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 |
| Reference | 引用 | 系统引用 | The Reference indicates the type of reference field | AD_Reference_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 |
| Key column | 主键列 | 记录的唯一标识符 | 主键列标明了它是这个表的一条记录的唯一标示符。 | AD_Key numeric(10) NOT NULL Table |
| Display column | 显示列 | 将会显示的列 | The Display Column indicates the column that will display. 显示列指明了将显示的列。 | AD_Display numeric(10) NOT NULL Table |
| Display Value | 显示值 | Displays Value column with the Display column | The Display Value checkbox indicates if the value column will display with the display column. | IsValueDisplayed character(1) NOT NULL Yes-No |
| 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 |
| Sql WHERE | SQL的Where子句 | Fully qualified WHERE clause | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". | WhereClause character varying(2000) Text |
| Sql ORDER BY | SQL的Order By子句 | Fully qualified ORDER BY clause | The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection | OrderByClause character varying(2000) Text |
| Window | 窗口 | 数据输入或显示视窗 | The Window field identifies a unique Window in the system. | AD_Window_ID numeric(10) Table Direct |
TAB: Used in Column
描述: Used in Column (Reference)
幫助 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}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}