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. |