Search Definition (Window ID-53069)

From iDempiere en

Table of Contents

Window: Search Definition

Description: Define transactioncodes for the QuickSearch bar

Help:

Tab: Searches

Description:

Help:

Search Definition - Searches - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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
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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.