SSIS Components for Oracle Fusion Cloud Financials

Build 25.0.9434

AccountingPeriodStatusLOV

Tracks the current status of each accounting period (for example, open, closed) within a calendar, preventing unauthorized postings.

Columns

Name Type Description
PeriodNameId [KEY] String The unique identifier for the period name in the AccountingPeriodStatusLOV table, representing a specific accounting period name.
ApplicationId [KEY] Long The unique identifier for the application in the AccountingPeriodStatusLOV table, linking the period to a specific application context.
LedgerId [KEY] Long The unique identifier for the ledger in the AccountingPeriodStatusLOV table, representing the financial ledger associated with the accounting period.
ClosingStatus String The status of the closing process for the accounting period, indicating whether the period has been closed or is still open.
EndDate Date The date when the accounting period ends, marking the last day of financial transactions for that period.
StartDate Date The date when the accounting period starts, marking the first day of financial transactions for that period.
EffectivePeriodNumber Long The effective period number within the accounting system, used for identifying the period in a chronological order of execution.
PeriodYear Long The year of the accounting period, used for grouping and reporting financial data by year.
PeriodNumber Long The unique number assigned to the accounting period within a given year, typically used for financial reporting purposes.
AdjustmentPeriodFlag Bool A flag indicating whether the period is an adjustment period, which can be used to make changes to prior accounting periods.
BindAccountingDate Date The date used for binding accounting entries, often related to when financial transactions are recorded or processed in the system.
BindAdjFlag String A flag that indicates whether adjustments are allowed or have been made for the accounting period being processed.
BindApplicationId Long The application identifier linked to the accounting period, used to associate the period with a specific financial application or system.
BindEffectivePeriodNum Long The effective period number used for binding the period to specific transaction entries in the accounting system.
BindLedgerId Long The ledger identifier associated with the accounting period, ensuring the correct ledger is used during the period's financial operations.
BuIdVar Long The unique identifier for the business unit, linking the accounting period to a specific organizational unit for reporting and financial analysis.
Finder String A search term or identifier used to locate specific accounting periods or related data within the system's query functions.
LedgerIdVar Long The variable ledger identifier, representing the ledger in use during specific financial processes for the accounting period.
SearchTerm String A term used to search for relevant accounting period data, typically used in queries or lookup operations in the financial system.
SearchTerms String A set of search terms or keywords used to filter and locate accounting period records in the system's search functionality.

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