GL ACCOUNT CUR Table
View exposing current-company general ledger account reference data including account identifiers, account type classifications, financial-statement groupings, cost element dates, posting indicators, and reporting attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_ELEMENT_CATEGORY |
Cost element category associated with the record. |
VARCHAR2 |
60 |
COST_ELEMENT_EFFECTIVE_DATE |
Date associated with cost element effective. |
DATE |
|
COST_ELEMENT_EXPIRATION_DATE |
Date associated with cost element expiration. |
DATE |
|
FINANCIAL_STATEMENT_GROUP |
Financial statement group associated with the record. |
VARCHAR2 |
40 |
FINANCIAL_STATEMENT_GROUP_CODE |
Code identifying financial statement group. |
VARCHAR2 |
4 |
GL_ACCOUNT_COUNTER |
Gl account counter associated with the record. |
NUMBER |
|
GL_ACCOUNT_ID |
Business identifier for the gl account. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
Gl account name associated with the record. |
VARCHAR2 |
50 |
GL_ACCOUNT_TYPE_CODE |
Code identifying gl account type. |
VARCHAR2 |
4 |
GL_ACCOUNT_TYPE_DESCRIPTION |
Description of gl account type. |
VARCHAR2 |
30 |
IS_BALANCE_SHEET_ACCOUNT |
Indicator identifying whether balance sheet account (Y/N). |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_POSTING |
Indicator identifying whether blocked for posting (Y/N). |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_POSTING_IN_CUR |
Indicator identifying whether blocked for posting in cur (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED_COST_ELEMENT |
Indicator identifying whether closed cost element (Y/N). |
VARCHAR2 |
1 |
IS_EXPENSE_ACCOUNT |
Indicator identifying whether expense account (Y/N). |
VARCHAR2 |
1 |
IS_FIXED_ASSET_ACCOUNT |
Indicator identifying whether fixed asset account (Y/N). |
VARCHAR2 |
1 |
IS_FUND_ACCOUNT |
Indicator identifying whether fund account (Y/N). |
VARCHAR2 |
1 |
IS_IN_MTDC_BASE |
Indicator identifying whether in mtdc base (Y/N). |
VARCHAR2 |
1 |
IS_LIABILITY_ACCOUNT |
Indicator identifying whether liability account (Y/N). |
VARCHAR2 |
1 |
IS_LIQUID_ASSET_ACCOUNT |
Indicator identifying whether liquid asset account (Y/N). |
VARCHAR2 |
1 |
IS_MARKED_FOR_DELETION |
Indicator identifying whether marked for deletion (Y/N). |
VARCHAR2 |
1 |
IS_PRINCIPAL_ACCOUNT |
Indicator identifying whether principal account (Y/N). |
VARCHAR2 |
1 |
IS_PROFIT_AND_LOSS_ACCOUNT |
Indicator identifying whether profit and loss account (Y/N). |
VARCHAR2 |
1 |
IS_REVENUE_ACCOUNT |
Indicator identifying whether revenue account (Y/N). |
VARCHAR2 |
1 |
IS_SETTLEMENT_ACCOUNT |
Indicator identifying whether settlement account (Y/N). |
VARCHAR2 |
1 |
PROFIT_CENTER |
Profit center associated with the record. |
VARCHAR2 |
7 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
3 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
60 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SURCHARGE_BASE_PATTERN_KEY |
Surrogate key identifying the surcharge base pattern. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |