UserFiscalCalendar
This is a table representing the UserFiscalCalendar entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the fiscal calendar. |
| BusinessUnitId | String | True |
Unique identifier of the business unit with which the user fiscal calendar is associated. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the fiscal calendar. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the fiscal calendar was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the userfiscalcalendar. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| EffectiveOn | Datetime | False |
Date and time when the fiscal calendar takes effect. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the user fiscal calendar with respect to the base currency. |
| FiscalPeriodType | Integer | True |
Type of fiscal period used in the fiscal calendar. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the fiscal calendar. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the fiscal calendar was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the userfiscalcalendar. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| Period1 | Double | False |
Sales quota for the first period in the fiscal year. |
| Period1_Base | Double | True |
Base currency equivalent of the sales quota for the first period in the fiscal year. |
| Period10 | Double | False |
Sales quota for the tenth period in the fiscal year. |
| Period10_Base | Double | True |
Base currency equivalent of the sales quota for the tenth period in the fiscal year. |
| Period11 | Double | False |
Sales quota for the eleventh period in the fiscal year. |
| Period11_Base | Double | True |
Base currency equivalent of the sales quota for the eleventh period in the fiscal year. |
| Period12 | Double | False |
Sales quota for the twelfth period in the fiscal year. |
| Period12_Base | Double | True |
Base currency equivalent of the sales quota for the twelfth period in the fiscal year. |
| Period13 | Double | False |
Sales quota for the thirteenth period in the fiscal year. |
| Period13_Base | Double | True |
Base currency equivalent of the sales quota for the thirteenth period in the fiscal year. |
| Period2 | Double | False |
Sales quota for the second period in the fiscal year. |
| Period2_Base | Double | True |
Base currency equivalent of the sales quota for the second period in the fiscal year. |
| Period3 | Double | False |
Sales quota for the third period in the fiscal year. |
| Period3_Base | Double | True |
Base currency equivalent of the sales quota for the third period in the fiscal year. |
| Period4 | Double | False |
Sales quota for the fourth period in the fiscal year. |
| Period4_Base | Double | True |
Base currency equivalent of the sales quota for the fourth period in the fiscal year. |
| Period5 | Double | False |
Sales quota for the fifth period in the fiscal year. |
| Period5_Base | Double | True |
Base currency equivalent of the sales quota for the fifth period in the fiscal year. |
| Period6 | Double | False |
Sales quota for the sixth period in the fiscal year. |
| Period6_Base | Double | True |
Base currency equivalent of the sales quota for the sixth period in the fiscal year. |
| Period7 | Double | False |
Sales quota for the seventh period in the fiscal year. |
| Period7_Base | Double | True |
Base currency equivalent of the sales quota for the seventh period in the fiscal year. |
| Period8 | Double | False |
Sales quota for the eighth period in the fiscal year. |
| Period8_Base | Double | True |
Base currency equivalent of the sales quota for the eighth period in the fiscal year. |
| Period9 | Double | False |
Sales quota for the ninth period in the fiscal year. |
| Period9_Base | Double | True |
Base currency equivalent of the sales quota for the ninth period in the fiscal year. |
| SalesPersonId_Id | String | False |
Unique identifier of the salesperson to whom the fiscal calendar is assigned. |
| 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 user fiscal calendar. |
| TransactionCurrencyId_LogicalName | String | False | |
| TransactionCurrencyId_Name | String | False | |
| UserFiscalCalendarId | String | False |
Unique identifier for the fiscal calendar. |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |