Search Definition (Venster ID-53069)

Uit iDempiere nl
Ga naar:navigatie, zoeken



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


Contributions / Posts

Cookies helpen ons onze services aan te bieden. Door onze services te gebruiken stemt u in met het gebruik van onze cookies.