ADO.NET Provider for Salesforce

Build 25.0.9434

FiscalYearSettings

Stores fiscal year configurations, defining the start date and structure for financial reporting.

Columns

Name Type References Description
Id [KEY] String Unique identifier of the fiscal year settings record.
PeriodId String

Period.Id

ID of the period associated with this fiscal year configuration.
StartDate Date Start date of the fiscal year.
EndDate Date End date of the fiscal year.
Name String Name assigned to the fiscal year, such as 'FY2025'.
IsStandardYear Bool Indicates whether the fiscal year follows the standard calendar year (true) or a custom configuration (false).
YearType String Type of fiscal year, such as 'Standard' or 'Custom'.
QuarterLabelScheme String Labeling scheme used for fiscal quarters, such as numeric or alphabetic.
PeriodLabelScheme String Labeling scheme used for fiscal periods.
WeekLabelScheme String Labeling scheme used for fiscal weeks.
QuarterPrefix String Prefix used when naming fiscal quarters.
PeriodPrefix String Prefix used when naming fiscal periods.
WeekStartDay Int Numeric representation of the day that weeks begin on, such as 1 for Sunday or 2 for Monday.
Description String Additional description or notes for the fiscal year settings.
SOQL String Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn String Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope String Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.
SystemModstamp Datetime Timestamp indicating the last system update to this record.

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