ManPageW TextIndex

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Window: Text Index

Description : Maintain Text Search Index

Help : Text search index keyword and excerpt across documents



Tab: Index

Description : Text Search Index

Help : Text search index keyword and excerpt across documents

Table Name  : K_Index

Fields

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

NUMBER(10)

TableDir

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

NUMBER(10)

TableDir

Keyword Case insensitive keyword Case insensitive keyword for matching. The individual keywords can be separated by space, comma, semicolon, tab or new line. Do not use filler words like "a", "the". At this point, there are NO text search operators like "or" and "and". Keyword

NVARCHAR2(255)

String

Excerpt Surrounding text of the keyword A passage or segment taken from a document, Excerpt

NVARCHAR2(2000)

Text

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

CHAR(1)

YesNo

Table Database Table information The Database Table provides the information of the table definition AD_Table_ID

NUMBER(10)

TableDir

Record ID Direct internal record ID The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. Record_ID

NUMBER(10)

Button

Source Updated Date the source document was updated SourceUpdated

DATE

DateTime

Document Type Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID

NUMBER(10)

TableDir

Request Type Type of request (e.g. Inquiry, Complaint, ..) Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc. R_RequestType_ID

NUMBER(10)

TableDir

Web Project A web project is the main data container for Containers, URLs, Ads, Media etc. A web project is the meta definition which will contain later on all data within the Web Content Management Project. CM_WebProject_ID

NUMBER(10)

TableDir

Contributions

Personal tools