QuarterlyFiscalCalendar
This is a table representing the QuarterlyFiscalCalendar entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the quarterly fiscal calendar. |
| BusinessUnitId_Id | String | True | |
| BusinessUnitId_LogicalName | String | True | |
| BusinessUnitId_Name | String | True | |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the quarterly fiscal calendar. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the quota for the quarterly fiscal calendar was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the QuarterlyFiscalCalendar. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| EffectiveOn | Datetime | False |
Date and time when the quarterly fiscal calendar sales quota takes effect. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the quarterly fiscal calendar with respect to the base currency. |
| FiscalPeriodType | Integer | True |
Type of fiscal period used in the sales quota. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the quarterly fiscal calendar. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the quarterly fiscal calendar was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the QuarterlyFiscalCalendar. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| quarter1 | Double | False |
Sales quota for the first quarter in the fiscal year. |
| quarter1_base | Double | True |
Base currency equivalent of the sales quota for the first quarter in the fiscal year. |
| quarter2 | Double | False |
Sales quota for the second quarter in the fiscal year. |
| quarter2_base | Double | True |
Base currency equivalent of the sales quota for the second quarter in the fiscal year |
| quarter3 | Double | False |
Sales quota for the third quarter in the fiscal year. |
| quarter3_base | Double | True |
Base currency equivalent of the sales quota for the third quarter in the fiscal year. |
| quarter4 | Double | False |
Sales quota for the fourth quarter in the fiscal year. |
| quarter4_base | Double | True |
Base currency equivalent of the sales quota for the fourth quarter in the fiscal year. |
| SalesPersonId_Id | String | False |
Unique identifier of the associated salesperson. |
| SalesPersonId_LogicalName | String | False | |
| SalesPersonId_Name | String | False | |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | False |
Unique identifier of the currency associated with the quarterly fiscal calendar. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UserFiscalCalendarId | String | False |
Unique identifier of the quarterly fiscal calendar. |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |