ContractDetail (Contract Line) Entity Metadata

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the contract detail (contract line) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early binding class for this entity is ContractDetail.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the contract detail (contract line) entity.

Entity metadata property Value

OTC

1011

EntityLogicalName

contractdetail

DisplayName

Contract Line

DisplayCollectionName

Contract Lines

IsCustomizable

True

OwnershipType

None

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

False

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

True

IsChildEntity

True

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

False

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

contractdetailid

PrimaryNameAttribute

title

ReportViewName

FilteredContractDetail

Description

Line item in a contract that specifies the type of service a customer is entitled to.

Privilege Metadata

There is no entity privilege metadata for the contract detail (contract line) entity.

Attribute Metadata

The following table shows the attribute metadata for the contract detail (contract line) entity.

LogicalName SchemaName Type RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsCustomizable IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion Description

accountid

AccountId

Lookup

None

False

True

False

False

False

False

True

True

True

False

False

False

False

False

Account

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

activeon

ActiveOn

DateTime

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Start Date

Date and time when the contract line becomes active.

allotmentsoverage

AllotmentsOverage

Integer

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Allotments Overage

Number of overage allotments for the contract line.

allotmentsremaining

AllotmentsRemaining

Integer

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Allotments Remaining

Number of allotments remaining for the contract line.

allotmentsused

AllotmentsUsed

Integer

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Allotments Used

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

contactid

ContactId

Lookup

None

False

True

False

False

False

False

True

True

True

False

False

False

False

False

Contact

Unique identifier for the contact associated with the contract line.

contractdetailid

ContractDetailId

Uniqueidentifier

SystemRequired

True

True

False

False

False

False

True

False

True

True

False

True

False

True

Contract Line

Unique identifier of the contract line.

contractid

ContractId

Lookup

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Contract

Unique identifier of the contract associated with the contract line.

contractstatecode

ContractStateCode

Picklist

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

False

False

False

Contract State

Status of the contract.

createdby

CreatedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By

Unique identifier of the user who created the contract line.

createdon

CreatedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created On

Date and time when the contract line was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By (Delegate)

Unique identifier of the delegate user who created the contractdetail.

customerid

CustomerId

Customer

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Customer

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

discount

Discount

Money

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Discount

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

discount_base

Discount_Base

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Discount (Base)

Base currency equivalent of the discount for the contract line.

discountpercentage

DiscountPercentage

Decimal

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Discount (%)

Discount for the contract line. Specified as a percentage.

effectivitycalendar

EffectivityCalendar

String

None

True

True

True

False

False

False

False

False

True

False

False

False

False

False

Support Calendar

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

exchangerate

ExchangeRate

Decimal

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Exchange Rate

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

expireson

ExpiresOn

DateTime

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

True

False

True

End Date

Date when the contract line item expires.

importsequencenumber

ImportSequenceNumber

Integer

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Import Sequence Number

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

initialquantity

InitialQuantity

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Quantity

Initial quantity of units allocated in the contract line item.

lineitemorder

LineItemOrder

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Line Item Order

Position of item in the list of contract line items.

modifiedby

ModifiedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By

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

modifiedon

ModifiedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified On

Date and time when the contract line was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By (Delegate)

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

net

Net

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Net

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

net_base

Net_Base

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Net (Base)

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

overriddencreatedon

OverriddenCreatedOn

DateTime

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Record Created On

Date and time that the record was migrated.

ownerid

OwnerId

Owner

ApplicationRequired

False

True

False

False

False

False

True

True

True

False

False

False

False

False

Owner

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

owningbusinessunit

OwningBusinessUnit

Uniqueidentifier

ApplicationRequired

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Owning Business Unit

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

owninguser

OwningUser

Uniqueidentifier

ApplicationRequired

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Owning User

Unique identifier of the user who owns the contract line.

price

Price

Money

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Total Price

Price of the contract line.

price_base

Price_Base

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Total Price (Base)

Base currency equivalent of the price of the contract line.

productid

ProductId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Product

Unique identifier of the product associated with the contract line.

productserialnumber

ProductSerialNumber

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Serial Number

Serial number of the product referenced in the contract line.

rate

Rate

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Rate

Billing rate for the contract line.

rate_base

Rate_Base

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Rate (Base)

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

serviceaddress

ServiceAddress

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Location

Address at which service is to be provided.

servicecontractunitscode

ServiceContractUnitsCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Service Contract Units

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

statecode

StateCode

State

SystemRequired

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Status

Status of the contract line item.

statuscode

StatusCode

Status

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Status Reason

Reason for the status of the contract line item.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

Time Zone Rule Version Number

For internal use only.

title

Title

String

ApplicationRequired

True

True

True

False

False

False

True

True

True

False

True

True

False

True

Title

Title of the contract line.

totalallotments

TotalAllotments

Integer

SystemRequired

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Total Allotments

Total allotments for the contract line.

transactioncurrencyid

TransactionCurrencyId

Lookup

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Currency

Unique identifier of the currency associated with the contract detail.

uomid

UoMId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Unit

Unique identifier of the unit associated with the contract line.

uomscheduleid

UoMScheduleId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

False

False

False

Unit Schedule

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

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

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

versionnumber

VersionNumber

BigInt

None

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Version Number

Version number of the contract template.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship for the contract detail (contract line) entity.

Relationship schema name Referencing Entity

ContractDetail_Annotation

annotation

ContractDetail_AsyncOperations

asyncoperation

ContractDetail_BulkDeleteFailures

bulkdeletefailure

contract_detail_cases

incident

contractdetail_principalobjectattributeaccess

principalobjectattributeaccess

ContractDetail_ProcessSessions

processsession

userentityinstancedata_contractdetail

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the contract detail (contract line) entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship for the contract detail (contract line) entity.

Relationship schema name Referenced entity

contractlineitem_customer_accounts

account

contractlineitem_customer_contacts

contact

contract_line_items

contract

customer_address_contract_line_items

customeraddress

product_contract_line_items

product

lk_contractdetail_modifiedonbehalfby

systemuser

lk_contractdetailbase_createdby

systemuser

lk_contractdetail_createdonbehalfby

systemuser

lk_contractdetailbase_modifiedby

systemuser

transactioncurrency_contractdetail

transactioncurrency

unit_of_measurement_contract_line_items

uom

contract_detail_unit_of_measure_schedule

uomschedule

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

ContractDetail (Contract Line) Entity Messages and Methods
ContractDetail (Contract Line) Entity OptionSet Attribute Metadata
ContractDetail (Contract Line) Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.