Search Definition (Venster ID-53069)

Venster: Search Definition

Beschrijving: Define transactioncodes for the QuickSearch bar

Help: null

TAB: Searches

Beschrijving: null

Help null

Bestand:Search Definition - Searches - Venster (iDempiere 1.0.0).png

Naam	Naam	Beschrijving	Help	Specificaties
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	Beschrijving	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Active	Actief	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	Standaard	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	Tabel	Database Table information	The Database Table provides the information of the table definition	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	Scherm	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