FRC GL ACCOUNT Table
View exposing general ledger account reference data used in Financial Review and Control review and monitoring processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_CATEGORY |
Cost element category associated with the record. |
VARCHAR2 |
50 |
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_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_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 |
IS_TRANSFER_ACCOUNT |
Indicator identifying whether transfer account (Y/N). |
VARCHAR2 |
1 |
LEVEL10_CATEGORY |
Level10 category associated with the record. |
VARCHAR2 |
40 |
LEVEL10_ID |
Business identifier for the level10. |
VARCHAR2 |
10 |
LEVEL10_SORT |
Level10 sort associated with the record. |
NUMBER |
6 |
LEVEL1_CATEGORY |
Level1 category associated with the record. |
VARCHAR2 |
40 |
LEVEL1_ID |
Business identifier for the level1. |
VARCHAR2 |
10 |
LEVEL1_SORT |
Level1 sort associated with the record. |
NUMBER |
6 |
LEVEL2_CATEGORY |
Level2 category associated with the record. |
VARCHAR2 |
40 |
LEVEL2_ID |
Business identifier for the level2. |
VARCHAR2 |
10 |
LEVEL2_SORT |
Level2 sort associated with the record. |
NUMBER |
6 |
LEVEL3_CATEGORY |
Level3 category associated with the record. |
VARCHAR2 |
40 |
LEVEL3_ID |
Business identifier for the level3. |
VARCHAR2 |
10 |
LEVEL3_SORT |
Level3 sort associated with the record. |
NUMBER |
6 |
LEVEL4_CATEGORY |
Level4 category associated with the record. |
VARCHAR2 |
40 |
LEVEL4_ID |
Business identifier for the level4. |
VARCHAR2 |
10 |
LEVEL4_SORT |
Level4 sort associated with the record. |
NUMBER |
6 |
LEVEL5_CATEGORY |
Level5 category associated with the record. |
VARCHAR2 |
40 |
LEVEL5_ID |
Business identifier for the level5. |
VARCHAR2 |
10 |
LEVEL5_SORT |
Level5 sort associated with the record. |
NUMBER |
6 |
LEVEL6_CATEGORY |
Level6 category associated with the record. |
VARCHAR2 |
40 |
LEVEL6_ID |
Business identifier for the level6. |
VARCHAR2 |
10 |
LEVEL6_SORT |
Level6 sort associated with the record. |
NUMBER |
6 |
LEVEL7_CATEGORY |
Level7 category associated with the record. |
VARCHAR2 |
40 |
LEVEL7_ID |
Business identifier for the level7. |
VARCHAR2 |
10 |
LEVEL7_SORT |
Level7 sort associated with the record. |
NUMBER |
6 |
LEVEL8_CATEGORY |
Level8 category associated with the record. |
VARCHAR2 |
40 |
LEVEL8_ID |
Business identifier for the level8. |
VARCHAR2 |
10 |
LEVEL8_SORT |
Level8 sort associated with the record. |
NUMBER |
6 |
LEVEL9_CATEGORY |
Level9 category associated with the record. |
VARCHAR2 |
40 |
LEVEL9_ID |
Business identifier for the level9. |
VARCHAR2 |
10 |
LEVEL9_SORT |
Level9 sort associated with the record. |
NUMBER |
6 |
REPORT_TYPE |
Report type associated with the record. |
VARCHAR2 |
40 |
REPORT_TYPE_CODE |
Code identifying report type. |
VARCHAR2 |
12 |
SURCHARGE_BASE_PATTERN_KEY |
Surrogate key identifying the surcharge base pattern. |
NUMBER |
5 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |