GL_LEDGERS_
GL_LEDGERS contains information about the ledgers defined in the Accounting Setup Manager and the ledger sets defined in the Ledger Set form. Each row includes the ledger or ledger set name, short name, description, ledger currency, calendar, period type, chart of accounts, and other information. Some columns in this table are not applicable for ledger sets. In this case, default values would be inserted into these columns for ledger sets.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_LEDGERS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Unique ledger identifier. | |
| NAME | VARCHAR2 | 30 | User entered unique ledger name. | ||
| SHORT_NAME | VARCHAR2 | 20 | User entered unique ledger short name. | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of the ledger definition. | ||
| LEDGER_CATEGORY_CODE | VARCHAR2 | 30 | Type of ledger. Valid values are PRIMARY, SECONDARY and ALC. | ||
| ALC_LEDGER_TYPE_CODE | VARCHAR2 | 30 | Reporting currency type (NONE, TARGET, and SOURCE). | ||
| OBJECT_TYPE_CODE | VARCHAR2 | 1 | Ledger type (ledger or ledger set). | ||
| LE_LEDGER_TYPE_CODE | VARCHAR2 | 1 | Ledger legal type (legal or management). | ||
| COMPLETION_STATUS_CODE | VARCHAR2 | 30 | Ledger setup status (Not Started, Incomplete, and Complete). | ||
| CONFIGURATION_ID | NUMBER | 18 | Link to an accounting setup identifier. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure identifier. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Functional currency of the ledger. | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | A period of time, extending from one date to another, defined by a party to quantify the fiscal position of the business. It can be divided into accounting periods. | ||
| ACCOUNTED_PERIOD_TYPE | VARCHAR2 | 15 | Period type assigned to the ledger. | ||
| FIRST_LEDGER_PERIOD_NAME | VARCHAR2 | 15 | First ledger accounting period name. | ||
| RET_EARN_CODE_COMBINATION_ID | NUMBER | 18 | Retained earnings key flexfield identifier. | ||
| SUSPENSE_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether suspense posting is allowed. | ||
| ALLOW_INTERCOMPANY_POST_FLAG | VARCHAR2 | 1 | Allow intercompany posting flag. | ||
| TRACK_ROUNDING_IMBALANCE_FLAG | VARCHAR2 | 1 | Indicates whether rounding imbalances are tracked. | ||
| ENABLE_AVERAGE_BALANCES_FLAG | VARCHAR2 | 1 | Indicates whether average balances are maintained for the ledger. | ||
| CUM_TRANS_CODE_COMBINATION_ID | NUMBER | 18 | Cumulative translation adjustment key flexfield identifier. | ||
| RES_ENCUMB_CODE_COMBINATION_ID | NUMBER | 18 | Reserve for encumbrance key flexfield identifier. | ||
| NET_INCOME_CODE_COMBINATION_ID | NUMBER | 18 | Net income key flexfield identifier. | ||
| ROUNDING_CODE_COMBINATION_ID | NUMBER | 18 | Track rounding imbalances key flexfield identifier. | ||
| ENABLE_BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Indicates whether budgetary control is enabled. | ||
| REQUIRE_BUDGET_JOURNALS_FLAG | VARCHAR2 | 1 | Journal required for budget flag. | ||
| ENABLE_JE_APPROVAL_FLAG | VARCHAR2 | 1 | Enable journal entry approval flag. | ||
| ENABLE_AUTOMATIC_TAX_FLAG | VARCHAR2 | 1 | Indicates whether automatic tax is enabled. | ||
| CONSOLIDATION_LEDGER_FLAG | VARCHAR2 | 1 | Indicates whether the ledger is a consolidation ledger. | ||
| TRANSLATE_EOD_FLAG | VARCHAR2 | 1 | Indicates whether the end of day average balances are translated. | ||
| TRANSLATE_QATD_FLAG | VARCHAR2 | 1 | Whether or not Quarter To Date Average balances are translated. | ||
| TRANSLATE_YATD_FLAG | VARCHAR2 | 1 | Whether or not Year To Date Average balances are translated. | ||
| TRANSACTION_CALENDAR_ID | NUMBER | 18 | Transaction calendar identifier. Foreign key to GL_TRANSACTION_CALENDAR. | ||
| DAILY_TRANSLATION_RATE_TYPE | VARCHAR2 | 30 | Rate type to be used for translaton of average balances. | ||
| AUTOMATICALLY_CREATED_FLAG | VARCHAR2 | 1 | Automatically created flag used for ledger sets. | ||
| BAL_SEG_VALUE_OPTION_CODE | VARCHAR2 | 1 | Indicates whether all segment values or specific segment values are assiged to ledger. | ||
| BAL_SEG_COLUMN_NAME | VARCHAR2 | 25 | Ledger chart of accounts balancing segment name. | ||
| MGT_SEG_VALUE_OPTION_CODE | VARCHAR2 | 1 | Management segment value option. | ||
| MGT_SEG_COLUMN_NAME | VARCHAR2 | 25 | Ledger chart of accounts management segment name. | ||
| BAL_SEG_VALUE_SET_ID | NUMBER | 18 | Ledger chart of accounts balancing segment value set identifier. | ||
| MGT_SEG_VALUE_SET_ID | NUMBER | 18 | Management segment value set identifier. | ||
| IMPLICIT_ACCESS_SET_ID | NUMBER | 18 | Implicit access set identifier.Foreign key to GL_ACCESS_SETS. | ||
| CRITERIA_SET_ID | NUMBER | 18 | Journal reversal criteria set identifier. | ||
| FUTURE_ENTERABLE_PERIODS_LIMIT | NUMBER | 18 | Number of future enterable periods. | ||
| LEDGER_ATTRIBUTES | VARCHAR2 | 2000 | Compiled values of any segment qualifier assigned to the segment value. | ||
| IMPLICIT_LEDGER_SET_ID | NUMBER | 18 | Implicit ledger set created during ledger creation. | ||
| LATEST_OPENED_PERIOD_NAME | VARCHAR2 | 15 | Latest opened accounting period name. | ||
| LATEST_ENCUMBRANCE_YEAR | NUMBER | 18 | Latest open year for encumbrances. | ||
| PERIOD_AVERAGE_RATE_TYPE | VARCHAR2 | 30 | Default balances level period average rate type used for actual translation. | ||
| PERIOD_END_RATE_TYPE | VARCHAR2 | 30 | Default balances level period end rate type used for actual translation. | ||
| BUDGET_PERIOD_AVG_RATE_TYPE | VARCHAR2 | 30 | Default balances level period average rate type used for budget translation. | ||
| BUDGET_PERIOD_END_RATE_TYPE | VARCHAR2 | 30 | Default balances level period end rate type used for budget translation. | ||
| SLA_ACCOUNTING_METHOD_CODE | VARCHAR2 | 30 | Subledger accounting method code. | ||
| SLA_ACCOUNTING_METHOD_TYPE | VARCHAR2 | 1 | Subledger accounting method type. | ||
| SLA_DESCRIPTION_LANGUAGE | VARCHAR2 | 15 | Subledger accounting description language. | ||
| SLA_ENTERED_CUR_BAL_SUS_CCID | NUMBER | 18 | Suspense account used for balancing subledger journal entries by entered currency. | ||
| SLA_SEQUENCING_FLAG | VARCHAR2 | 1 | Whether or not subledger sequencing is required. | ||
| SLA_BAL_BY_LEDGER_CURR_FLAG | VARCHAR2 | 1 | Subledger balance by ledger currency flag. | ||
| SLA_LEDGER_CUR_BAL_SUS_CCID | NUMBER | 18 | Suspense account used for balancing subledger journal entries by ledger currency. | ||
| ENABLE_SECONDARY_TRACK_FLAG | VARCHAR2 | 1 | Enable secondary tracking for closing and translation flag. | ||
| ENABLE_REVAL_SS_TRACK_FLAG | VARCHAR2 | 1 | Enable secondary tracking for revaluation flag. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ENABLE_RECONCILIATION_FLAG | VARCHAR2 | 1 | Enable journal reconciliation flag. | ||
| CREATE_JE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| SLA_LEDGER_CASH_BASIS_FLAG | VARCHAR2 | 1 | Subledger cash basis accounting flag. | ||
| COMPLETE_FLAG | VARCHAR2 | 1 | Ledger configuration completion status flag. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| USSGL_OPTION_CODE | VARCHAR2 | 1 | Journal import validates USSGL transaction codes when this value is 'Yes'. | ||
| VALIDATE_JOURNAL_REF_DATE | VARCHAR2 | 1 | Journal reference date will be validated to ensure the date falls into an open or future enterable period. | ||
| JRNLS_GROUP_BY_DATE_FLAG | VARCHAR2 | 1 | Indicates how journal import will group journal lines by accounting date. | ||
| REVAL_FROM_PRI_LGR_CURR | VARCHAR2 | 1 | Indicates which currency to use when creating revaluation entries for the additional ledger currency. | ||
| AUTOREV_AFTER_OPEN_PRD_FLAG | VARCHAR2 | 1 | General Ledger automatically submits the AutoReverse program when a new period is first opened when this flag is enabled. | ||
| PRIOR_PRD_NOTIFICATION_FLAG | VARCHAR2 | 1 | When this flag is enabled, Oracle Fusion General Ledger notifies a user when a journal is entered for a prior period. | ||
| POP_UP_STAT_ACCOUNT_FLAG | VARCHAR2 | 1 | If this flag is enabled, then users can enter statistical amounts along with monetary amounts in the Enter Journals window. | ||
| THRESHOLD_AMOUNT | NUMBER | Threshold amount allows to create an additional balancing journal line if accounted debit and accounted credit offset is more than a certain amount. | |||
| NUMBER_OF_PROCESSORS | NUMBER | 9 | Used by Subledger Accounting to indicate the number of processors. | ||
| PROCESSING_UNIT_SIZE | NUMBER | 9 | Used by Subledger Accounting to indicate the processing unit size. | ||
| RELEASE_UPGRADE_FROM | VARCHAR2 | 15 | Indicates the release that the ledger is upgraded from. | ||
| CROSS_LGR_CLR_ACC_CCID | NUMBER | 18 | Cross ledger clearing account combination identifier. | ||
| INTERCO_GAIN_LOSS_CCID | NUMBER | 18 | Intercompany gain loss code combination identifier. | ||
| SEQUENCING_MODE_CODE | VARCHAR2 | 2 | Sequencing Code to identify the level of Sequencing. Valid values are - No Sequencing, Ledger level Sequencing and Legal Entity level Sequencing. | ||
| DOC_SEQUENCING_OPTION_CODE | VARCHAR2 | 1 | Document Sequencing Option. Valid values are - General Ledger, Payables and Receivables. | ||
| ENF_SEQ_DATE_CORRELATION_CODE | VARCHAR2 | 1 | Option to enforce correlation between sequence date and subledger trasaction sequence number for subledger transactions. | ||
| AR_DOC_SEQUENCING_OPTION_FLAG | VARCHAR2 | 1 | Document sequencing option enforced for receivables. | ||
| AP_DOC_SEQUENCING_OPTION_FLAG | VARCHAR2 | 1 | Document sequencing option enforced for payables. | ||
| NET_CLOSING_BAL_FLAG | VARCHAR2 | 1 | Yes or No indicates whether Closing Journals programs will create net closing journal entries or accumulated closing journal entries. | ||
| AUTOMATE_SEC_JRNL_REV_FLAG | VARCHAR2 | 1 | Yes or No indicates whether a replicated secondary ledger journal can be reversed or not when the parent primary ledger journal is reversed. | ||
| MINIMUM_THRESHOLD_AMOUNT | NUMBER | Minimum threshold used to determine whether the difference between accounted debits and accounted credits is a rounding error or a balancing issue. The actual threshold used may be larger. | |||
| STRICT_PERIOD_CLOSE_FLAG | VARCHAR2 | 1 | STRICT_PERIOD_CLOSE_FLAG is used to determine for given period whether the period close process should error out if period in certain set of subledgers is not yet closed or any unprocessed/partly processed transactions lying in both subledgers and general ledger. | ||
| INCOME_STMT_ADB_STATUS_CODE | VARCHAR2 | 30 | The status of maintaining average balances for income statement accounts. Some possible values are ENABLED and DISABLED. | ||
| BALANCE_MJE_BY_CURRENCY_FLAG | VARCHAR2 | 1 | Indicates whether to require manually created journals are balanced by currency. | ||
| SINGLE_CURRENCY_JOURNAL_FLAG | VARCHAR2 | 1 | Indicates whether to limit a journal to a single currency. | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information for this ledger which when combined with the journal or balance period, determines the database partition in which journals or balances for this ledger are stored. | ||
| POSTING_CUTOFF_FLAG | VARCHAR2 | 1 | Indicates whether to limit posting to journals with accounting dates on or before the cutoff date. Valid values are Y and N. | ||
| POSTING_CUTOFF_DATE | DATE | Date that accounting date on each journal is evaluated against to determine posting eligibility. Journals with accounting dates on or before the specified cutoff are eligible for posting. | |||
| POSTING_CUTOFF_TIMEZONE_CODE | VARCHAR2 | 50 | Time zone used to derive the cutoff date that the accounting date on each journal is evaluated against to determine whether a journal is eligible for posting. | ||
| LEDGER_SET_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification of a ledger set. Valid values are ORA_GL_CURRENCY_SPECIFIC for ledger sets with a specific currency and ORA_GL_GAAP_VIEW for ledger sets with a full accounting view. | ||
| LEDGER_SET_CURRENCY_CODE | VARCHAR2 | 15 | Currency associated with the ledger set. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_LEDGERS_N1_ | Non Unique | Default | LEDGER_ID |
| GL_LEDGERS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, LEDGER_ID |