Search Definition (jendela ID-53069)
Dari iDempiere id
jendela: Search Definition
deskripsi: Define transactioncodes for the QuickSearch bar
membantu: null
TAB: Searches
deskripsi: null
membantu null
Berkas:Search Definition - Searches - jendela (iDempiere 1.0.0).png
nama | nama | deskripsi | membantu | spesifikasi |
---|---|---|---|---|
Client | 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 numeric(10) NOT NULL Table Direct |
Organization | 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 numeric(10) NOT NULL Table Direct |
Transaction Code | Transaction Code | The transaction code represents the search definition | null | TransactionCode character varying(8) String |
Name | 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 | Penjelasan | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
Active | 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 character(1) NOT NULL Yes-No |
Default | Default | Default value | 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 | Table | Table for the Fields | The Table indicates the table in which a field or fields reside. | AD_Table_ID numeric(10) NOT NULL Table |
Column | Column | Column in the table | Link to the database column of the table | AD_Column_ID numeric(10) Table |
Query | Query | SQL | null | Query character varying(2000) Text |
Data Type | Data Type | Type of data | null | DataType character varying(1) NOT NULL String |
Window | Window | Data entry or display window | The Window field identifies a unique Window in the system. | AD_Window_ID numeric(10) NOT NULL Table |
PO Window | PO Window | Purchase Order Window | Window for Purchase Order (AP) Zooms | PO_Window_ID numeric(10) Table |