ODBC Driver for SAP Concur

Build 24.0.9062

FiscalPeriod

Retrieve a list of all fiscal periods

Columns

Name Type Description
Id [KEY] String The budget service's key for this object.
Name String The name of this fiscal period. Must be unique for this entity.
StartDate Date The start date for this fiscal period. Must be within the parent fiscal year.
EndDate Date The end date for this fiscal period. Must be within the parent fiscal year.
Status String The status of this fiscal period. Supported values: OPEN, CLOSED, REMOVED
CurrentPeriod Boolean True if this the current fiscal period based on the current date and time, False otherwise.
PeriodType String The type of fiscal period. Supported values: MONTHLY
FiscalYearId [KEY] String The key of the parent fiscal year for this fiscal period.
SpendDate Date If the current date is after this fiscal period's start date, this field shows the current date.

Pseudo-Columns

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

Name Type Description
IncludeRemoved Boolean If true, the service will return all Fiscal Years, including those that were previously removed. If not supplied, this field defaults to false.

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