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