GL ACCOUNT Table
Stores general ledger account master data, including account identifiers, names, classifications, account type attributes, cost element details, and financial reporting flags used for financial processing and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_CATEGORY |
Cost element category associated with the general ledger 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 counter/version value for the general ledger account record. |
NUMBER |
|
GL_ACCOUNT_ID |
Business identifier for the general ledger account. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Key identifier for the general ledger account. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
Name of the general ledger account. |
VARCHAR2 |
50 |
GL_ACCOUNT_TYPE_CODE |
Code identifying the general ledger account type. |
VARCHAR2 |
4 |
GL_ACCOUNT_TYPE_DESCRIPTION |
Description of the general ledger account type code. |
VARCHAR2 |
30 |
IS_BALANCE_SHEET_ACCOUNT |
Indicator identifying whether the account is a balance sheet account (Y/N). |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_PLANNING |
Indicator identifying whether the account is blocked for planning (Y/N). |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_POSTING |
Indicator identifying whether the account is blocked for posting (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED_COST_ELEMENT |
Indicator identifying whether the cost element is closed (Y/N). |
VARCHAR2 |
1 |
IS_EXPENSE_ACCOUNT |
Indicator identifying whether the account is an expense account (Y/N). |
VARCHAR2 |
1 |
IS_FIXED_ASSET_ACCOUNT |
Indicator identifying whether the account is a fixed asset account (Y/N). |
VARCHAR2 |
1 |
IS_FUND_ACCOUNT |
Indicator identifying whether the account is a fund account (Y/N). |
VARCHAR2 |
1 |
IS_IN_MTDC_BASE |
Indicator identifying whether the account is included in the MTDC base (Y/N). |
VARCHAR2 |
1 |
IS_LIABILITY_ACCOUNT |
Indicator identifying whether the account is a liability account (Y/N). |
VARCHAR2 |
1 |
IS_LIQUID_ASSET_ACCOUNT |
Indicator identifying whether the account is a liquid asset account (Y/N). |
VARCHAR2 |
1 |
IS_MARKED_FOR_DELETION |
Indicator identifying whether the account is marked for deletion (Y/N). |
VARCHAR2 |
1 |
IS_PRINCIPAL_ACCOUNT |
Indicator identifying whether the account is a principal account (Y/N). |
VARCHAR2 |
1 |
IS_PROFIT_AND_LOSS_ACCOUNT |
Indicator identifying whether the account is a profit and loss account (Y/N). |
VARCHAR2 |
1 |
IS_REVENUE_ACCOUNT |
Indicator identifying whether the account is a revenue account (Y/N). |
VARCHAR2 |
1 |
IS_SETTLEMENT_ACCOUNT |
Indicator identifying whether the account is a settlement account (Y/N). |
VARCHAR2 |
1 |
IS_TRANSFER_ACCOUNT |
Indicator identifying whether the account is a transfer account (Y/N). |
VARCHAR2 |
1 |
PROFIT_CENTER |
Profit center associated with the general ledger account. |
VARCHAR2 |
7 |
SECTION_CODE |
Code identifying the section associated with the account. |
VARCHAR2 |
3 |
SECTION_NAME |
Name/description of the section associated with the account. |
VARCHAR2 |
60 |
SUPERVISOR |
Name of the supervisor associated with the general ledger account. |
VARCHAR2 |
30 |
SURCHARGE_BASE_PATTERN_KEY |
Key identifying the surcharge base pattern associated with the account. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the warehouse. |
DATE |