Skip to main content

Window: GL Category

[Created: 29/06/1999 - Updated: 02/01/2000 ]
Description: Maintain General Ledger Categories
Help: The GL Category Window allows you to define categories to be used in journals. These categories provide a method of optionally grouping and reporting on journals.

Tab: GL Category

[Created: 29/06/1999 - Updated: 02/01/2000 ]
Description: Define General Ledger Categories
Help: The GL Category Tab defines optional identifiers for a document or journal. Each Category may be used on a document, manual journal or import
Tab Level: 0

Table 10: GL Category - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.gl_category.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.gl_category.AD_Org_ID numeric(10)
Table Direct
Search KeySearch key for the record in the format required - must be uniqueA search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).gl_category.Value character varying(60)
String
NameAlphanumeric identifier of the entityThe 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.gl_category.Name character varying(60)
String
Print TextThe label text to be printed on a document or correspondence.The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters.gl_category.PrintName character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.gl_category.Description character varying(255)
String
ActiveThe record is active in the systemThere 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.gl_category.IsActive character(1)
Yes-No
Document Base TypeLogical type of documentThe Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.gl_category.DocBaseType character(3)
List
DefaultDefault valueThe Default Checkbox indicates if this record will be used as a default value.gl_category.IsDefault character(1)
Yes-No
Category TypeSource of the Journal with this categoryThe Category Type indicates the source of the journal for this category. Journals can be generated from a document, entered manually or imported.gl_category.CategoryType character(1)
List

Tab: Translation

[Created: 21/03/2014 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1

Table 20: Translation - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.gl_category_trl.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.gl_category_trl.AD_Org_ID numeric(10)
Table Direct
GL CategoryGeneral Ledger CategoryThe General Ledger Category is an optional, user defined method of grouping journal lines.gl_category_trl.GL_Category_ID numeric(10)
Search
LanguageLanguage for this entityThe Language identifies the language to use for display and formattinggl_category_trl.AD_Language character varying(6)
Table
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.gl_category_trl.IsTranslated character(1)
Yes-No
ActiveThe record is active in the systemThere 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.gl_category_trl.IsActive character(1)
Yes-No
NameAlphanumeric identifier of the entityThe 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.gl_category_trl.Name character varying(60)
String
Print TextThe label text to be printed on a document or correspondence.The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters.gl_category_trl.PrintName character varying(60)
String