GL ACCOUNT Table
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_CATEGORY |
Text categorizing the Cost Element (Example: Assessment Cost Element, External Settlement, Overhead Rates, Primary Cost Element, Revenue Element). |
VARCHAR2 |
50 |
COST_ELEMENT_EFFECTIVE_DATE |
Date the Cost Element is available for use. |
DATE |
8 |
COST_ELEMENT_EXPIRATION_DATE |
The date the Cost Element expires (is no longer in use.) |
DATE |
8 |
GL_ACCOUNT_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
GL_ACCOUNT_ID |
Identifies the GL Account. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases. |
VARCHAR2 |
20 |
GL_ACCOUNT_TYPE_CODE |
Identifies the type of GL Account (Example: ND, LIAB, REVN, STL). |
VARCHAR2 |
4 |
GL_ACCOUNT_TYPE_DESCRIPTION |
Text describing the account type. For example: Asset accounts-Fixed, Asset account-Liquid, Expenses-Primary Cost Element, Fund Accounts, Liabilities, Revenue Accounts, Settlement Accounts. |
VARCHAR2 |
30 |
IS_BALANCE_SHEET_ACCOUNT |
Y= this is a balance sheet account. N= this is not a balance sheet account. |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_PLANNING |
Y= this is blocked for posting. |
VARCHAR2 |
1 |
IS_BLOCKED_FOR_POSTING |
Y= this GL Account is blocked and cannot be posted to. N= this GL Account is not blocked and can be posted to. |
VARCHAR2 |
1 |
IS_CLOSED_COST_ELEMENT |
Y= this cost element has been closed. |
VARCHAR2 |
1 |
IS_EXPENSE_ACCOUNT |
Y= this is an expense account. N= this is not an expense account. |
VARCHAR2 |
1 |
IS_FIXED_ASSET_ACCOUNT |
Y= this is a fixed asset account. N=this is not a fixed asset account. |
VARCHAR2 |
1 |
IS_FUND_ACCOUNT |
Y= this is a fund account. N= this is not a fund account. |
VARCHAR2 |
1 |
IS_IN_MTDC_BASE |
XXX |
VARCHAR2 |
1 |
IS_LIABILITY_ACCOUNT |
Y= this is a liability account. N= this is not a liability account. |
VARCHAR2 |
1 |
IS_LIQUID_ASSET_ACCOUNT |
Y= this is a liquid asset account. N= this is not a liquid asset account. |
VARCHAR2 |
1 |
IS_MARKED_FOR_DELETION |
Y= this account is marked for deletion. N= this account is not marked for deletion. |
VARCHAR2 |
1 |
IS_PRINCIPAL_ACCOUNT |
Y= this is a principle account. N= this is not a principle account. |
VARCHAR2 |
1 |
IS_PROFIT_AND_LOSS_ACCOUNT |
Y= this is a profit and loss account. N= this is not a profit and loss account. |
VARCHAR2 |
1 |
IS_REVENUE_ACCOUNT |
Y=this is a revenue account. N=this is not a revenue account. |
VARCHAR2 |
1 |
IS_SETTLEMENT_ACCOUNT |
Y=this is a settlement account. N=this is not a settlement account. |
VARCHAR2 |
1 |
IS_TRANSFER_ACCOUNT |
XXX |
VARCHAR2 |
1 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
7 |
SECTION_CODE |
A code which classifies cost collectors into sections for financial statement reporting purposes |
VARCHAR2 |
3 |
SECTION_NAME |
Description associated with the Section Code. |
VARCHAR2 |
60 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
SURCHARGE_BASE_PATTERN_KEY |
Key used to join the GL_ACCOUNT table with SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |