Tableau Connector for Microsoft Dynamics CRM

Build 24.0.9060

AnnualFiscalCalendar

Create, update, delete, and query annual fiscal calendar entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the annual fiscal calendar.

annual Double False

Sales quota for the first period in the fiscal year.

annual_base Double True

Base currency equivalent of the sales quota for the first period in the fiscal year.

BusinessUnitId_Id String True

BusinessUnitId_LogicalName String True

BusinessUnitId_Name String True

CreatedBy_Id String True

Unique identifier of the user who created the quota for the annual fiscal calendar.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the quota for the annual fiscal calendar was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the annual fiscal calendar.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

EffectiveOn Datetime False

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

ExchangeRate Double True

Exchange rate for the currency associated with the annual 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 quota for the annual fiscal calendar.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the annual fiscal calendar was last modified.

ModifiedOnBehalfBy_Id String True

Unique identifier of the delegate user who last modified the annual fiscal calendar.

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

SalesPersonId_Id String False

Unique identifier of the salesperson associated with the sales quota.

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 annual fiscal calendar.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UserFiscalCalendarId String False

Unique identifier of the user associated with the annual fiscal calendar.

UTCConversionTimeZoneCode Integer False

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060