Window: Search Definition
[Created: 18/02/2009 - Updated: 18/02/2009 ]
Description: Define transactioncodes for the QuickSearch bar
Help:
Tab: Searches
[Created: 18/02/2009 - Updated: 18/02/2009 ]
Description:
Help:
Tab Level: 0
Table 10: Searches - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | ad_searchdefinition.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | ad_searchdefinition.AD_Org_ID numeric(10) Table Direct |
| Transaction Code | The transaction code represents the search definition | ad_searchdefinition.TransactionCode character varying(8) String | |
| Entity Type | Dictionary Entity Type; Determines ownership and synchronization | The Entity Types "Dictionary", "iDempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"! | ad_searchdefinition.EntityType character varying(40) Table |
| 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. | ad_searchdefinition.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | ad_searchdefinition.Description character varying(255) String |
| 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. | ad_searchdefinition.IsActive character(1) Yes-No |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | ad_searchdefinition.IsDefault character(1) Yes-No |
| Search Type | Which kind of search is used (Query or Table) | ad_searchdefinition.SearchType character varying(1) String | |
| Table | Database Table information | The Database Table provides the information of the table definition | ad_searchdefinition.AD_Table_ID numeric(10) Table |
| Column | Column in the table | Link to the database column of the table | ad_searchdefinition.AD_Column_ID numeric(10) Table |
| Query | SQL | ad_searchdefinition.Query character varying(2000) Text | |
| Data Type | Type of data | ad_searchdefinition.DataType character varying(1) String | |
| Message | System Message | Information and Error messages | ad_searchdefinition.AD_Message_ID numeric(10) Search |
| Style | CSS style for field and label | ad_searchdefinition.AD_Style_ID numeric(10) Table Direct | |
| Window | Data entry or display window | The Window field identifies a unique Window in the system. | ad_searchdefinition.AD_Window_ID numeric(10) Table |
| PO Window | Purchase Order Window | Window for Purchase Order (AP) Zooms | ad_searchdefinition.PO_Window_ID numeric(10) Table |