Ledger
A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.
Business Views
** Available for extracting data- ledgersExtract**
A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.
Label
Ledgers
Data Source
Read-optimized data store
Fields
- allowIntercompanyPostFlag (boolean)
Indicates whether intercompany accounting is enabled for the ledger. If Y, then intercompany accounting is enabled. If N, then intercompany accounting isn't enabled.
Label
Enable intercompany accounting
Properties
- searchable
- sortable
- not readable
- not nullable
- automateSecondaryJournalReversalFlag (boolean)
Indicates whether a replicated secondary ledger journal can be reversed when the parent primary ledger journal is reversed. If Y, then replicated secondary ledger journals can be reversed when the parent primary ledger journal is reversed. If N, then secondary ledger journals can't be reversed when the parent primary ledger journal is reversed.
Label
Synchronize Reversals Between Primary and Secondary Ledgers
Properties
- searchable
- sortable
- not readable
- automaticallyRevalueAfterPeriodOpenFlag (boolean)
Indicates whether to automatically submit the AutoReverse process when a new period is opened. Possible values include Y for automatically submit the AutoReverse process and N for don't automatically submit the AutoReverse process.
Label
AutoReverse After Open Period
Properties
- searchable
- sortable
- not readable
- balancingSegmentValueOptionCode (enumeration: BalancingSegmentValueOption)
Indicates whether all balancing segment values or specific balancing segment values are assigned to the ledger. If I, then specific balancing segment values are assigned to the ledger and if A, then all balancing segment values are assigned to the ledger.
Label
Balancing Segment Value Option Code
Type
-
Module: oraErpCoreStructure
-
Enumeration Type: BalancingSegmentValueOption
Properties
- searchable
- sortable
- not readable
- not nullable
Valid Values
- A
- I
-
- completeFlag (boolean)
Indicates the completion status of the ledger configuration. A list of accepted values is defined in the lookup type YES_NO.
Label
Configuration Complete
Properties
- searchable
- sortable
- completionStatusCode (enumeration: CompletionStatus)
Status of the ledger setup. Valid values are Confirmed, Not Started, Incomplete, and Complete.
Label
The meaning assigned to the journal completion code
Type
-
Module: oraErpCoreStructure
-
Enumeration Type: CompletionStatus
Properties
- searchable
- sortable
- not readable
Valid Values
- CONFIRMED
- ERROR
- NOT_STARTED
-
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not readable
- not nullable
- description (string)
The description of the ledger provided by the user or source application.
Label
Description
Properties
- searchable
- sortable
- enableAutomaticTaxFlag (boolean)
Indicates whether automatic tax is enabled. If Y, then automatic tax is enabled. If N, then automatic tax isn't enabled.
Label
Enable journal tax
Properties
- searchable
- sortable
- not nullable
- enableAverageBalancesFlag (boolean)
Indicates whether average balances are maintained for the ledger. A list of accepted values is defined in the lookup type YES_NO.
Label
Enable average balances
Properties
- searchable
- sortable
- not nullable
- enableBudgetaryControlFlag (boolean)
Indicates whether budgetary control is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
Label
Enable budgetary control
Properties
- searchable
- sortable
- not nullable
- enableJournalApprovalFlag (boolean)
Indicates whether journal and manual subledger entries are enabled for approval. If Y, then journal and manual subledger entries are enabled for approval. If N, then journal and manual subledger entries aren't enabled for approval.
Label
Enable journal and manual subledger entry approval
Properties
- searchable
- sortable
- not nullable
- enableReconciliationFlag (boolean)
Indicates whether journal reconciliation is enabled. If Y, then journal reconciliation is enabled. If N, then journal reconciliation isn't enabled.
Label
Enable reconciliation
Properties
- searchable
- sortable
- not readable
- not nullable
- enableRevaluationSecondaryTrackFlag (boolean)
Indicates whether secondary tracking for revaluation is enabled. If Y, then secondary tracking for revaluation is enabled. If N, then secondary tracking for revaluation isn't enabled.
Label
Track Revaluation Gain or Loss by Multiple Segments
Properties
- searchable
- sortable
- not readable
- enforceSequencingDateCorrelationFlag (boolean)
Indicates whether to enforce a correlation between the sequence date and the subledger transaction sequence number for subledger transactions. If Y, then a correlation between the sequence date and the subledger transaction sequence number for subledger transactions is enforced. If N, then a correlation between the sequence date and the subledger transaction sequence number for subledger transactions isn't enforced.
Label
Enforce Sequencing Date Correlation
Properties
- searchable
- sortable
- not readable
- futureEnterablePeriodsLimit (int64)
Number of future enterable periods.
Label
Number of Future Enterable Periods
Properties
- searchable
- sortable
- not readable
- not nullable
- journalLinesGroupByDateFlag (boolean)
Indicates whether journal import should separate journals by accounting date. If Y, then individual journal entries are created for each accounting date. If N, then individual journal entries aren't created for each accounting date.
Label
Separate journals by accounting date during journal import
Properties
- searchable
- sortable
- not readable
- latestEncumbranceYear (int64)
Name of the latest open year for encumbrances, for example 2024.
Label
Latest Encumbrance Year
Properties
- searchable
- sortable
- not readable
- latestOpenedPeriodName (string)
Name of the latest open accounting period.
Label
Latest Open Period
Properties
- searchable
- sortable
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- minimumThresholdAmount (big-decimal)
Minimum threshold amount used to determine whether the difference between accounted debits and accounted credits is a rounding error or a balancing issue.
Label
Balancing Threshold Amount
Properties
- searchable
- sortable
- not readable
- name (string)
The unique name of the ledger entered by the user.
Label
Name
Properties
- searchable
- sortable
- not nullable
- netClosingBalanceFlag (boolean)
Indicates whether the closing journals processes will create net closing journal entries or accumulated closing journal entries. If Y, then the closing journals processes will create net closing journal entries or accumulated closing journal entries. If N, then the closing journals processes won't create net closing journal entries or accumulated closing journal entries.
Label
Net Closing Balance Journal
Properties
- searchable
- sortable
- not readable
- objectTypeCode (string)
Indicates the type of ledger. A list of accepted values is defined in the lookup type LEDGERS.
Label
Type
Properties
- searchable
- sortable
- not nullable
- payablesDocumentSequencingOptionFlag (boolean)
Indicates whether document sequencing is enforced for Payables. If Y, then document sequencing is enforced for Payables. If N, then document sequencing isn't enforced for Payables.
Label
Payables Document Sequencing
Properties
- searchable
- sortable
- not readable
- popUpStatisticalAccountFlag (boolean)
Indicates whether users can enter statistical amounts along with monetary amounts on a journal. If Y, then a user can enter statistical amounts along with monetary amounts on a journal. If N, then a user can't enter statistical amounts along with monetary amounts on a journal.
Label
Allow mixed statistical and monetary journals
Properties
- searchable
- sortable
- not readable
- priorPeriodNotificationFlag (boolean)
Indicates whether to notify a user when a journal is entered for a prior period. If Y, then a user is notified when a journal is entered for a prior period. If N, then a user isn't notified when a journal is entered for a prior period.
Label
Notify when prior period journal is entered
Properties
- searchable
- sortable
- not readable
- receivablesDocumentSequencingOptionFlag (boolean)
Indicates whether document sequencing is enforced for Receivables. If Y, then document sequencing is enforced for Receivables. If N, then and document sequencing isn't enforced for Receivables.
Label
Receivables Document Sequencing
Properties
- searchable
- sortable
- not readable
- requireBudgetJournalsFlag (boolean)
Indicates whether the journal is required for budgeting. Possible values include Y for the journal requires budgeting and N for the journal doesn't require budgeting.
Label
Enable Budgetary Control
Properties
- searchable
- sortable
- not readable
- not nullable
- sequencingModeCode (string)
The level of document sequencing for a ledger. A list of accepted values is defined in the lookup type GL_SEQUENCING_OPTIONS.
Label
Sequencing By
Properties
- searchable
- sortable
- shortName (string)
Name of ledger.
Label
Target Ledger Short Name
Properties
- searchable
- sortable
- not readable
- not nullable
- subledgerAccountingSequencingFlag (boolean)
Indicates whether subledger sequencing is required. If Y, then subledger sequencing is required. If N, then subledger sequencing isn't required.
Label
Sequencing Mode
Properties
- searchable
- sortable
- not readable
- subledgerBalancingByLedgerCurrencyFlag (boolean)
Indicates whether subledger balancing by ledger currency is enabled. If Y, then subledger balancing by ledger currency is enabled. If N, then subledger balancing by ledger currency isn't enabled.
Label
Balance Entries by Ledger Currency
Properties
- searchable
- sortable
- not readable
- subledgerCashBasisLedgerFlag (boolean)
Indicates whether subledger cash basis accounting is enabled. If Y, then subledger cash basis accounting is enabled. If N, then subledger cash basis accounting isn't enabled.
Label
Use cash basis accounting
Properties
- searchable
- sortable
- not readable
- suspenseAllowedFlag (boolean)
Indicates whether posting to a suspense account is enabled for the ledger. If Y, then suspense account posting is enabled. If N, then suspense account posting isn't enabled.
Label
Enable Suspense
Properties
- searchable
- sortable
- not nullable
- thresholdAmount (big-decimal)
Threshold amount to create an additional balancing journal line if the accounted debit and the accounted credit offset is more than a certain amount.
Label
Balancing Threshold Percent
Properties
- searchable
- sortable
- not readable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not readable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not readable
- not nullable
- trackRoundingImbalanceFlag (boolean)
Indicates whether rounding imbalances are tracked. Valid values are Y for rounding imbalances are tracked and N for rounding imbalances aren't tracked.
Label
Track Rounding Imbalances
Properties
- searchable
- sortable
- not readable
- not nullable
- translateEndOfDayFlag (boolean)
Indicates whether the end of day average balances are translated.
Label
Translate End of Day Balances
Properties
- searchable
- sortable
- not nullable
- translateQuarterToDateFlag (boolean)
Indicates whether quarter-to-date average balances are translated. If Y, then quarter-to-date average balances are translated. If N, then quarter-to-date average balances aren't translated.
Label
Translate Quarter to Date Balances
Properties
- searchable
- sortable
- not nullable
- translateYearToDateFlag (boolean)
Indicates whether year-to-date average balances are translated.
Label
Translate Year to Date Balances
Properties
- searchable
- sortable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not readable
- not nullable
- validateJournalReferenceDate (string)
Indicates whether to validate that the journal reference date is in an open or future enterable period. If Y, then the validation is enabled. If N, then the validation isn't enabled.
Label
Validate reference date
Properties
- searchable
- sortable
- not readable
Reference Object
- calendar (AccountingCalendar)
An accounting calendar contains the periods of an accounting year. For example, one company can have a fiscal calendar that starts in May and ends in June. Another company can use calendars based on the calendar year, January to December.
Business Object
AccountingCalendarFields
- periodSetName (string)
Name of the accounting calendar.
Label
Accounting Calendar
Properties
- searchable
- sortable
- not nullable
- periodSetName (string)
- chartOfAccount (KeyFlexfieldStructureInstance)
The key flexfield structure instance resource is used to query the list of key flexfield structure instances.
Business Object
KeyFlexfieldStructureInstanceFields
- structureInstanceNumber (int64)
The structure instance number of the structure instance.
Label
Structure Instance Number
Properties
- searchable
- sortable
- not nullable
- structureInstanceNumber (int64)
- cumulativeTranslationAccount (GeneralLedgerAccount)
Identifier of the cumulative translation adjustment account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- currency (Currency)
A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- dailyTranslationRate (CurrencyConversionRateType)
Rate type to be used for translation of average balances.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- implicitAccessSet (DataAccessSet)
Identifier of the implicit access set.
Business Object
DataAccessSetFields
- accessSetId (int64)
Unique identifier of the data access set.
Label
Access Set ID
Properties
- searchable
- sortable
- not nullable
- accessSetId (int64)
- intercompanyGainLossAccount (GeneralLedgerAccount)
Identifier of the intercompany gain or loss account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- ledgerCategory (ERPLookupCode)
A ledger category represents the classification codes that designates a ledger as Primary, Secondary, Reporting Currency, or Ledger Set.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- ledgerConfiguration (LedgerConfiguration)
The ledger configuration defines the high-level input values for a primary ledger, such as ledger name and configuration status.
Business Object
LedgerConfigurationFields
- configurationId (int64)
The unique identifier of the ledger configuration that contains the setup information of a ledger. This attribute is a part of the composite key of the Ledger Configuration Details view object.
Label
Configuration ID
Properties
- searchable
- sortable
- not nullable
- configurationId (int64)
- netIncomeAccount (GeneralLedgerAccount)
Identifier of the net income account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- periodAverageRate (CurrencyConversionRateType)
Default period average rate type defined for a balance level ledger used for actual translation of balance sheet accounts.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- periodEndRate (CurrencyConversionRateType)
Default period end rate type defined for a balance level ledger used for actual translation of balance sheet accounts.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- reserveEncumbranceCodeCombination (GeneralLedgerAccount)
A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- retainedEarningsAccount (GeneralLedgerAccount)
Identifier of the retained earnings account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- roundingAccount (GeneralLedgerAccount)
Identifier of the rounding account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- subledgerAccountingMethod (SubledgerAccountingMethod)
Subledger accounting method.
Business Object
SubledgerAccountingMethodFields
- accountingMethodCode (string)
The short name of the accounting method used to record the financial impact of subledger transactions.
Label
Short Name
Properties
- searchable
- sortable
- not nullable
- accountingMethodTypeCode (string)
Indicates whether the accounting method is user defined or predefined by the subledger application.
Label
Accounting Method Type
Properties
- searchable
- sortable
- not nullable
- accountingMethodCode (string)
- subledgerEnteredCurrencyBalancingSuspenseAccount (GeneralLedgerAccount)
Suspense account used for balancing subledger journal entries by entered currency.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- subledgerLedgerCurrencyBalancingSuspenseAccount (GeneralLedgerAccount)
Identifier of the suspense account combination used for balancing subledger journal entries by ledger currency.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- allowIntercompanyPostFlag (boolean)