ODBC Driver for Oracle Fusion Cloud Financials

Build 23.0.8839

AccountingPeriodStatusLOV

AccountingPeriodStatusLOV

Columns

Name Type Description
PeriodNameId [KEY] String PeriodNameId of AccountingPeriodStatusLOV
ApplicationId [KEY] Long ApplicationId of AccountingPeriodStatusLOV
LedgerId [KEY] Long LedgerId of AccountingPeriodStatusLOV
ClosingStatus String ClosingStatus of AccountingPeriodStatusLOV
EndDate Date EndDate of AccountingPeriodStatusLOV
StartDate Date StartDate of AccountingPeriodStatusLOV
EffectivePeriodNumber Long EffectivePeriodNumber of AccountingPeriodStatusLOV
PeriodYear Long PeriodYear of AccountingPeriodStatusLOV
PeriodNumber Long PeriodNumber of AccountingPeriodStatusLOV
AdjustmentPeriodFlag Bool AdjustmentPeriodFlag of AccountingPeriodStatusLOV

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
BindAccountingDate Date BindAccountingDate
BindAdjFlag String BindAdjFlag
BindApplicationId Long BindApplicationId
BindEffectivePeriodNum Long BindEffectivePeriodNum
BindLedgerId Long BindLedgerId
BuIdVar Long BuIdVar
LedgerIdVar Long LedgerIdVar
SearchTerm String SearchTerm
SearchTerms String SearchTerms
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839