JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

ContractDetail

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the contract line.

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 line becomes active.

AllotmentsOverage Integer True

Number of overage allotments for the contract line.

AllotmentsRemaining Integer True

Number of allotments remaining for the contract line.

AllotmentsUsed Integer True

Number of allotments that have been used for the contract line.

ContactId_Id String True

Unique identifier for the contact associated with the contract line.

ContactId_LogicalName String True

ContactId_Name String True

ContractDetailId String False

Unique identifier of the contract line.

ContractId_Id String False

Unique identifier of the contract associated with the contract line.

ContractId_LogicalName String False

ContractId_Name String False

ContractStateCode String True

Status of the contract.

CreatedBy_Id String True

Unique identifier of the user who created the contract line.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the contract line was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the contractdetail.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

Unique identifier for the account or contact associated with the contract line.

CustomerId_LogicalName String False

CustomerId_Name String False

Discount Double False

Discount for the contract line. Specified as a monetary amount.

Discount_Base Double True

Base currency equivalent of the discount for the contract line.

DiscountPercentage Double False

Discount for the contract line. Specified as a percentage.

EffectivityCalendar String False

Days of the week and times for which the contract line item is effective.

ExchangeRate Double True

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

ExpiresOn Datetime False

Date when the contract line item expires.

ImportSequenceNumber Integer False

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

InitialQuantity Integer False

Initial quantity of units allocated in the contract line item.

LineItemOrder Integer False

Position of item in the list of contract line items.

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the contract line was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Net Double True

Net price for the contract line. Net price is the total price minus any applicable discount.

Net_Base Double True

Base currency equivalent of the net price for the contract line.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String True

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

OwnerId_LogicalName String True

OwnerId_Name String True

OwningBusinessUnit String True

Unique identifier of the business unit that owns the contract line.

OwningUser String True

Unique identifier of the user who owns the contract line.

Price Double False

Price of the contract line.

Price_Base Double True

Base currency equivalent of the price of the contract line.

ProductId_Id String False

Unique identifier of the product associated with the contract line.

ProductId_LogicalName String False

ProductId_Name String False

ProductSerialNumber String False

Serial number of the product referenced in the contract line.

Rate Double True

Billing rate for the contract line.

Rate_Base Double True

Base currency equivalent of the billing rate for the contract line.

ServiceAddress_Id String False

Address at which service is to be provided.

ServiceAddress_LogicalName String False

ServiceAddress_Name String False

ServiceContractUnitsCode String False

Unique identifier of the product units specified on the contract line.

StateCode String True

Status of the contract line item.

StatusCode String False

Reason for the status of the contract line item.

TimeZoneRuleVersionNumber Integer False

For internal use only.

Title String False

Title of the contract line.

TotalAllotments Integer False

Total allotments for the contract line.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the contract detail.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

UoMId_Id String False

Unique identifier of the unit associated with the contract line.

UoMId_LogicalName String False

UoMId_Name String False

UoMScheduleId_Id String False

Unique identifier of the unit group associated with the contract line.

UoMScheduleId_LogicalName String False

UoMScheduleId_Name String False

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