ManPageW KnowledgeBase

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



Contents

Window: Knowledge Base

= BETA FUNCTIONALITY =

Description : Maintain Knowledge Base

Help : Maintain Type, Topics, Entries and theit Comments, Categories, Related Entries



Tab: Type

Description : Knowledge Type

Help : Area of knowlege - A Type has multiple Topics

Table Name  : K_Type

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

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

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

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

Public Public can read entry If selected, public users can read/view the entry. Public are users without a Role in the system. Use security rules for more specic access control. IsPublic

CHAR(1)

YesNo

Public Write Public can write entries If selected, public users can write/create entries. Public are users without a Role in the system. Use security rules for more specic access control. IsPublicWrite

CHAR(1)

YesNo


Tab: Topic

Description : Knowledge Topic

Help : Topic or Discussion Thead

Table Name  : K_Topic

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

Knowldge Type Knowledge Type Area of knowlege - A Type has multiple Topics K_Type_ID

NUMBER(10)

TableDir

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

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

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

Public Public can read entry If selected, public users can read/view the entry. Public are users without a Role in the system. Use security rules for more specic access control. IsPublic

CHAR(1)

YesNo

Public Write Public can write entries If selected, public users can write/create entries. Public are users without a Role in the system. Use security rules for more specic access control. IsPublicWrite

CHAR(1)

YesNo


Tab: Entry

Description : Knowledge Entry

Help : The searchable Knowledge Entry

Table Name  : K_Entry

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

Knowledge Topic Knowledge Topic Topic or Discussion Thead K_Topic_ID

NUMBER(10)

TableDir

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

NVARCHAR2(60)

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.

IsActive

CHAR(1)

YesNo

Text Message Text Message TextMsg

NVARCHAR2(2000)

Text

Keywords List of Keywords - separated by space, comma or semicolon List if individual keywords for search relevancy. The keywords are separated by space, comma or semicolon. Keywords

NVARCHAR2(255)

String

Rating Classification or Importance The Rating is used to differentiate the importance Rating

NUMBER(10)

Integer

Knowledge Source Source of a Knowledge Entry The Source of a Knowlegde Entry is a pointer to the originating system. The Knowledge Entry has an additional entry (Description URL) for more detailed info. K_Source_ID

NUMBER(10)

TableDir

Description URL URL for the description DescriptionURL

NVARCHAR2(120)

Unknown (40)

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Table

Updated Date this record was updated The Updated field indicates the date that this record was updated. Updated

DATE

DateTime

Updated By User who updated this records The Updated By field indicates the user who updated this record. UpdatedBy

NUMBER(10)

Table

Public Public can read entry If selected, public users can read/view the entry. Public are users without a Role in the system. Use security rules for more specic access control. IsPublic

CHAR(1)

YesNo

Valid to Valid to including this date (last day) The Valid To date indicates the last day of a date range ValidTo

DATE

Date


Tab: Category

Description : Knowledge Category

Help : Assiged Category - Value for the Knowlede Entry

Table Name  : K_EntryCategory

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

Entry Knowledge Entry The searchable Knowledge Entry K_Entry_ID

NUMBER(10)

Search

Knowledge Category Knowledge Category Set up knowledge categories and values as a search aid. Examples are Release Version, Product Area, etc. Knowledge Category values act like keyworks. K_Category_ID

NUMBER(10)

TableDir

Category Value The value of the category The value of the category is a keyword K_CategoryValue_ID

NUMBER(10)

TableDir

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


Tab: Related

Description : Related Knowlege Entry

Help : Related Knowlege Entry for this Knowledge Entry

Table Name  : K_EntryRelated

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

Entry Knowledge Entry The searchable Knowledge Entry K_Entry_ID

NUMBER(10)

Search

Related Entry Related Entry for this Enntry Related Knowlege Entry for this Knowledge Entry K_EntryRelated_ID

NUMBER(10)

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. Name

NVARCHAR2(60)

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.

IsActive

CHAR(1)

YesNo


Tab: Comment

Description : Knowledge Entry Comment

Help : Comment regarding a knowledge entry

Table Name  : K_Comment

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

Entry Knowledge Entry The searchable Knowledge Entry K_Entry_ID

NUMBER(10)

Search

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

Text Message Text Message TextMsg

NVARCHAR2(2000)

Text

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Table

Updated Date this record was updated The Updated field indicates the date that this record was updated. Updated

DATE

DateTime

Updated By User who updated this records The Updated By field indicates the user who updated this record. UpdatedBy

NUMBER(10)

Table

Rating Classification or Importance The Rating is used to differentiate the importance Rating

NUMBER(10)

Integer

Public Public can read entry If selected, public users can read/view the entry. Public are users without a Role in the system. Use security rules for more specic access control. IsPublic

CHAR(1)

YesNo

Contributions

Personal tools