TDV Adapter for Microsoft Dynamics CRM

Build 22.0.8462

SemiAnnualFiscalCalendar

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the semiannual fiscal calendar.

BusinessUnitId_Id String True

Unique identifier of the business unit with which the calendar is associated.

BusinessUnitId_LogicalName String True

BusinessUnitId_Name String True

CreatedBy_Id String True

Unique identifier of the user who created the semiannual fiscal calendar.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

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

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the SemiAnnualFiscalCalendar.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

EffectiveOn Datetime False

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

ExchangeRate Double True

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

firsthalf Double False

Sales quota for the first half of the fiscal year.

firsthalf_base Double True

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

FiscalPeriodType Integer True

Type of fiscal period used in the sales quota.

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

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

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

SalesPersonId_Id String False

Unique identifier of the associated salesperson.

SalesPersonId_LogicalName String False

SalesPersonId_Name String False

secondhalf Double False

Sales quota for the second half of the fiscal year.

secondhalf_base Double True

Base currency equivalent of the sales quota for the second half of the fiscal year.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the semiannual fiscal calendar.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UserFiscalCalendarId String False

Unique identifier for the user who created the semiannual 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