GL ACCOUNT Table
View exposing general ledger account master data, including account identifiers, account type classifications, balance sheet and profit/loss indicators, cost element attributes, effective dates, status flags, and reporting hierarchy attributes used for financial reporting and controlling.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_CATEGORY |
Cost element category associated with the account. |
VARCHAR2 |
60 |
COST_ELEMENT_EFFECTIVE_DATE |
Date the cost element becomes effective. |
DATE |
|
COST_ELEMENT_EXPIRATION_DATE |
Date the cost element expires. |
DATE |
|
GL_ACCOUNT_COUNTER |
System-generated counter used to track record versions. |
NUMBER |
|
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 record. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
Descriptive name of the general ledger account. |
VARCHAR2 |
50 |
GL_ACCOUNT_TYPE_CODE |
Code identifying the account type classification. |
VARCHAR2 |
4 |
GL_ACCOUNT_TYPE_DESCRIPTION |
Description of the account type classification. |
VARCHAR2 |
30 |
IS_BALANCE_SHEET_ACCOUNT |
Indicator identifying whether the account is classified as a balance sheet account. |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_PLANNING |
Indicator identifying whether the account is blocked for planning activities. |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_POSTING |
Indicator identifying whether postings to the account are blocked. |
VARCHAR2 |
1 |
IS_CLOSED_COST_ELEMENT |
Indicator identifying whether the cost element is closed. |
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_MARKED_FOR_DELETION |
Indicator identifying whether the account is marked for deletion in the source system. |
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 |
PROFIT_CENTER |
Profit center associated with the account for reporting purposes. |
VARCHAR2 |
7 |
SECTION_CODE |
Code identifying the reporting section associated with the account. |
VARCHAR2 |
3 |
SECTION_NAME |
Name of the reporting section associated with the account. |
VARCHAR2 |
60 |
SUPERVISOR |
Name of the individual responsible for the account. |
VARCHAR2 |
30 |
SURCHARGE_BASE_PATTERN_KEY |
Identifier of the surcharge base pattern associated with the account. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |