TDV Adapter for Microsoft Dynamics CRM

Build 22.0.8462

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.

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