JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Contract

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the contract.

AccountId_Id String True

Unique identifier of the account with which the contract is associated.

AccountId_LogicalName String True

AccountId_Name String True

ActiveOn Datetime False

Date and time when the contract becomes active.

AllotmentTypeCode String False

Type of allotment that the contract supports.

BillingAccountId_Id String True

Unique identifier of the account to which the contract is to be billed.

BillingAccountId_LogicalName String True

BillingAccountId_Name String True

BillingContactId_Id String True

Unique identifier of the contact to whom the contract is to be billed.

BillingContactId_LogicalName String True

BillingContactId_Name String True

BillingCustomerId_Id String False

Unique identifier of the account or contact to which the contract is to be billed.

BillingCustomerId_LogicalName String False

BillingCustomerId_Name String False

BillingEndOn Datetime False

Date and time when the billing period ends.

BillingFrequencyCode String False

How often the customer or account is to be billed.

BillingStartOn Datetime False

Date and time when the billing period begins.

BillToAddress_Id String False

Address to bill for contract charges.

BillToAddress_LogicalName String False

BillToAddress_Name String False

CancelOn Datetime True

Date when the contract was canceled.

ContactId_Id String True

Unique identifier of the contact specified for the contract.

ContactId_LogicalName String True

ContactId_Name String True

ContractId String False

Unique identifier of the contract.

ContractLanguage String False

Description of the contract.

ContractNumber String False

System-generated contract identification number.

ContractServiceLevelCode String False

Response level or level of service specified for the contract.

ContractTemplateAbbreviation String True

Abbreviation of the contract template name.

ContractTemplateId_Id String False

Unique identifier of the template associated with the contract.

ContractTemplateId_LogicalName String False

ContractTemplateId_Name String False

CreatedBy_Id String True

Unique identifier of the user who created the contract.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the contract was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the contract.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

Unique identifier of the account or contact associated with the contract.

CustomerId_LogicalName String False

CustomerId_Name String False

Duration Integer True

Calculated duration of time that the contract spans.

EffectivityCalendar String False

Days of the week and times during which customer service support is available for the duration of the contract.

ExchangeRate Double True

Exchange rate for the currency associated with the contract with respect to the base currency.

ExpiresOn Datetime False

Date when the contract expires.

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 contract.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the contract was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

NetPrice Double True

Sum of all net values calculated on the contract lines.

NetPrice_Base Double True

Base currency equivalent of the sum of all net values calculated on the contract lines.

OriginatingContract_Id String False

Unique identifier of the original contract from which this current contract was derived.

OriginatingContract_LogicalName String False

OriginatingContract_Name String False

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

Unique identifier of the user or team who owns the contract.

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the contract.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the contract.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the contract.

OwningUser_LogicalName String True

OwningUser_Name String True

ServiceAddress_Id String False

Unique identifier of the address at which service is to be provided.

ServiceAddress_LogicalName String False

ServiceAddress_Name String False

StateCode String True

Status of the contract.

StatusCode String False

Reason for the status of the contract.

TimeZoneRuleVersionNumber Integer False

For internal use only.

Title String False

Title of the contract.

TotalDiscount Double True

Total of all discounts specified on the contract lines.

TotalDiscount_Base Double True

Base currency equivalent of the total of all discounts specified on the contract lines.

TotalPrice Double True

Total price of the contract.

TotalPrice_Base Double True

Base currency equivalent of the total price of the contract.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the contract.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UseDiscountAsPercentage Boolean False

Information about whether the discount is a percentage or a monetary amount.

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