GL ACCOUNT REPORT Table
View exposing financial reporting hierarchies and categorization structures for general ledger accounts by report type, including multi-level sort order, category groupings, account classifications, and financial reporting indicators used for structured financial statement presentation and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_CATEGORY |
Cost element category associated with the account. |
VARCHAR2 |
50 |
GL_ACCOUNT_ID |
Business identifier for the general ledger account defined in the source financial system. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate identifier for the general ledger account. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
Descriptive name of the general ledger account. |
VARCHAR2 |
50 |
GL_ACCOUNT_TYPE_CODE |
Code identifying the general ledger account type classification. |
VARCHAR2 |
4 |
GL_ACCOUNT_TYPE_DESCRIPTION |
Description of the general ledger account type classification. |
VARCHAR2 |
30 |
IS_BALANCE_SHEET_ACCOUNT |
Indicator identifying whether the account is classified as a balance sheet account. |
VARCHAR2 |
1 |
IS_EXPENSE_ACCOUNT |
Indicator identifying whether the account is classified as an expense account. |
VARCHAR2 |
1 |
IS_FIXED_ASSET_ACCOUNT |
Indicator identifying whether the account is classified as a fixed asset account. |
VARCHAR2 |
1 |
IS_FUND_ACCOUNT |
Indicator identifying whether the account represents a fund account. |
VARCHAR2 |
1 |
IS_IN_MTDC_BASE |
Indicator identifying whether the account is included in the MTDC base. |
VARCHAR2 |
1 |
IS_LIABILITY_ACCOUNT |
Indicator identifying whether the account is classified as a liability account. |
VARCHAR2 |
1 |
IS_LIQUID_ASSET_ACCOUNT |
Indicator identifying whether the account is classified as a liquid asset account. |
VARCHAR2 |
1 |
IS_PRINCIPAL_ACCOUNT |
Indicator identifying whether the account represents a principal account. |
VARCHAR2 |
1 |
IS_PROFIT_AND_LOSS_ACCOUNT |
Indicator identifying whether the account is classified as a profit and loss account. |
VARCHAR2 |
1 |
IS_REVENUE_ACCOUNT |
Indicator identifying whether the account is classified as a revenue account. |
VARCHAR2 |
1 |
IS_SETTLEMENT_ACCOUNT |
Indicator identifying whether the account is used for settlement postings. |
VARCHAR2 |
1 |
IS_TRANSFER_ACCOUNT |
Indicator identifying whether the account is used for transfer postings. |
VARCHAR2 |
1 |
LEVEL1_CATEGORY |
Level 1 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL1_SORT |
Sort order for level 1 reporting category. |
NUMBER |
6 |
LEVEL2_CATEGORY |
Level 2 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL2_SORT |
Sort order for level 2 reporting category. |
NUMBER |
6 |
LEVEL3_CATEGORY |
Level 3 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL3_SORT |
Sort order for level 3 reporting category. |
NUMBER |
6 |
LEVEL4_CATEGORY |
Level 4 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL4_SORT |
Sort order for level 4 reporting category. |
NUMBER |
6 |
LEVEL5_CATEGORY |
Level 5 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL5_SORT |
Sort order for level 5 reporting category. |
NUMBER |
6 |
LEVEL6_CATEGORY |
Level 6 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL6_SORT |
Sort order for level 6 reporting category. |
NUMBER |
6 |
LEVEL7_CATEGORY |
Level 7 reporting category used for financial statement grouping. |
VARCHAR2 |
40 |
LEVEL7_SORT |
Sort order for level 7 reporting category. |
NUMBER |
6 |
REPORT_TYPE |
Descriptive name of the financial report type. |
VARCHAR2 |
40 |
REPORT_TYPE_CODE |
Code identifying the financial report type associated with the reporting hierarchy. |
VARCHAR2 |
12 |
SURCHARGE_BASE_PATTERN_KEY |
Identifier of the surcharge base pattern associated with the account. |
NUMBER |
5 |