Search Definition (窗口 ID-53069)
来自iDempiere zh
窗口: Search Definition
描述: Define transactioncodes for the QuickSearch bar
幫助: null
TAB: Searches
描述: null
幫助 null
File:Search Definition - Searches - 窗口 (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 |
Transaction Code | Transaction Code | The transaction code represents the search definition | null | TransactionCode character varying(8) 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) 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 |
Default | 缺省值 | 缺省值 | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
Search Type | Search Type | Which kind of search is used (Query or Table) | null | SearchType character varying(1) NOT NULL String |
Table | 表 | 字段所在表 | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL Table |
Column | 列 | 在表中的列 | 链接到数据库表中的列。 | AD_Column_ID numeric(10) Table |
Query | Query | SQL | null | Query character varying(2000) Text |
Data Type | 数据类型 | 数据的类型 | null | DataType character varying(1) NOT NULL String |
Window | 窗口 | 数据输入或显示视窗 | The Window field identifies a unique Window in the system. | AD_Window_ID numeric(10) NOT NULL Table |
PO Window | 采购定单视窗 | 采购定单视窗 | Window for Purchase Order (AP) Zooms | PO_Window_ID numeric(10) Table |