Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

LedgersLOV

Offers a lookup of defined ledgers, including primary, secondary, or reporting ledgers, enabling multi-ledger financial tracking.

Columns

Name Type Description
AccountedPeriodType String The period type used for accounting in the ledger, specifying the frequency of periods (for example, monthly, quarterly).
ChartOfAccountsId Long Unique identifier for the chart of accounts associated with the ledger, defining the structure of account numbers and classifications.
Description String A descriptive text providing more details about the ledger and its usage in the financial system.
EnableBudgetaryControlFlag Bool Flag indicating whether budgetary control is enabled for the ledger to monitor expenditures within the defined budgets.
LedgerCategoryCode String Code that identifies the category of the ledger, such as Primary, Sub, or Reporting ledger.
LedgerId [KEY] Long Unique identifier for the ledger used for financial transactions and accounting.
Name String The name of the ledger, typically used to identify and distinguish between ledgers.
LedgerTypeCode String Code that specifies the type of ledger, such as General, Tax, or Currency ledger.
PeriodSetName String The name of the period set associated with the ledger, defining the accounting periods for transactions.
SequencingModeCode String Code that defines how document sequencing is handled in the ledger, such as manual or automatic.
ApDocumentSequencingOptionFlag Bool Flag indicating whether automatic document sequencing is enabled for Accounts Payable (AP) transactions.
ArDocumentSequencingOptionFlag Bool Flag indicating whether automatic document sequencing is enabled for Accounts Receivable (AR) transactions.
EnfSequenceDateCorrelationCode String Code used to correlate sequence dates in the ledger to ensure proper document sequencing.
CurrencyCode String The code representing the currency used in the ledger for recording transactions.
BindAccessSetId Long Unique identifier for the access set used to control access to the ledger's data and operations.
BindDefaultPeriodName String The default period name for the ledger, which is used for accounting and financial reporting purposes.
Finder String Search term or identifier used to locate specific ledger records in the system.
SearchTerm String A general search term associated with the ledger, used to filter or identify specific records related to the ledger.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454