JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

FixedMonthlyFiscalCalendar

This is a table representing the FixedMonthlyFiscalCalendar entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the fixed monthly fiscal calendar.

BusinessUnitId_Id String True

Business unit responsible for the quota associated with this calendar.

BusinessUnitId_LogicalName String True

BusinessUnitId_Name String True

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 quota for the fixed monthly fiscal calendar was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the FixedMonthlyFiscalCalendar.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

EffectiveOn Datetime False

Date and time when the fixed monthly fiscal calendar sales quota takes effect.

ExchangeRate Double True

Exchange rate for the currency associated with the fixed monthly fiscal calendar with respect to the base currency.

FiscalPeriodType Integer True

Type of fiscal period used in the fixed monthly fiscal calendar sales quota.

ModifiedBy_Id String True

Unique identifier of the user who last modified the fixed monthly fiscal calendar.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the fixed monthly fiscal calendar was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the FixedMonthlyFiscalCalendar.

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 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 fixed monthly fiscal calendar.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UserFiscalCalendarId String False

Unique identifier of the user of the fiscal calendar.

UTCConversionTimeZoneCode Integer False

Time zone code that was in use when the record was created.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462