JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

ContractTemplate

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the contract template.

Abbreviation String False

Abbreviation of the contract template name.

AllotmentTypeCode String False

Criteria for the contracts based on the template, such as number of cases, time, or coverage dates.

BillingFrequencyCode String False

How often the customer or account is to be billed in contracts that are based on the template.

ComponentState String True

For internal use only.

ContractServiceLevelCode String False

Unique identifier of the level of service specified in contracts that are based on the template.

ContractTemplateId String False

Unique identifier of the contract template.

ContractTemplateIdUnique String True

For internal use only.

CreatedBy_Id String True

Unique identifier of the user who created the contract template.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the contract template was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the contracttemplate.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the contract template.

EffectivityCalendar String False

Days of the week and times for which contracts based on the template are effective.

ImportSequenceNumber Integer False

Unique identifier of the data import or data migration that created this record.

IsManaged Boolean True

Indicates whether the solution component is part of a managed solution.

ModifiedBy_Id String True

Unique identifier of the user who last modified the contract template.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the contract template was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the contract template.

OrganizationId_Id String True

Unique identifier of the organization associated with the contract template.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OverwriteTime Datetime True

For internal use only.

SolutionId String True

Unique identifier of the associated solution.

UseDiscountAsPercentage Boolean False

Specifies whether the discount is a percentage or a monetary amount in contracts based on the template.

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