Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Line item in a contract that specifies the type of service a customer is entitled to.
Messages
The following table lists the messages for the Contract Line (ContractDetail) table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: True |
POST /contractdetailsSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /contractdetails(contractdetailid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
RetrieveEvent: True |
GET /contractdetails(contractdetailid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /contractdetailsSee Query data |
Query data |
SetStateEvent: True |
PATCH /contractdetails(contractdetailid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /contractdetails(contractdetailid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /contractdetails(contractdetailid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
Properties
The following table lists selected properties for the Contract Line (ContractDetail) table.
| Property | Value |
|---|---|
| DisplayName | Contract Line |
| DisplayCollectionName | Contract Lines |
| SchemaName | ContractDetail |
| CollectionSchemaName | ContractDetails |
| EntitySetName | contractdetails |
| LogicalName | contractdetail |
| LogicalCollectionName | contractdetails |
| PrimaryIdAttribute | contractdetailid |
| PrimaryNameAttribute | title |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActiveOn
- ContractDetailId
- ContractId
- CustomerId
- CustomerIdType
- Discount
- DiscountPercentage
- EffectivityCalendar
- ExpiresOn
- ImportSequenceNumber
- InitialQuantity
- LineItemOrder
- OverriddenCreatedOn
- Price
- ProductId
- ProductSerialNumber
- ServiceAddress
- ServiceContractUnitsCode
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- Title
- TotalAllotments
- UoMId
- UoMScheduleId
- UTCConversionTimeZoneCode
ActiveOn
| Property | Value |
|---|---|
| Description | Enter the date when the contract line becomes active. |
| DisplayName | Start Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | activeon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ContractDetailId
| Property | Value |
|---|---|
| Description | Unique identifier of the contract line. |
| DisplayName | Contract Line |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | contractdetailid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ContractId
| Property | Value |
|---|---|
| Description | Unique identifier of the contract associated with the contract line. |
| DisplayName | Contract |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | contractid |
| RequiredLevel | SystemRequired |
| Type | Lookup |
| Targets | contract |
CustomerId
| Property | Value |
|---|---|
| Description | Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. |
| DisplayName | Customer |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customerid |
| RequiredLevel | SystemRequired |
| Type | Customer |
| Targets | account, contact |
CustomerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | Customer Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridtype |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
Discount
| Property | Value |
|---|---|
| Description | Type the discount amount for the contract line to deduct any negotiated or other savings from the net amount due. |
| DisplayName | Discount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
DiscountPercentage
| Property | Value |
|---|---|
| Description | Type the discount rate that should be applied to the Total Price, for use in calculating the net amount due for the contract line. |
| DisplayName | Discount (%) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discountpercentage |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100 |
| MinValue | 0 |
| Precision | 5 |
| SourceTypeMask | 0 |
EffectivityCalendar
| Property | Value |
|---|---|
| Description | Days of the week and times for which the contract line item is effective. |
| DisplayName | Support Calendar |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | effectivitycalendar |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 168 |
ExpiresOn
| Property | Value |
|---|---|
| Description | Enter the date when the contract line expires. The date is automatically filled with the contract date, but you can change it if required. |
| DisplayName | End Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | expireson |
| RequiredLevel | SystemRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
InitialQuantity
| Property | Value |
|---|---|
| Description | Type the number of units of the specified product or service that are eligible for support on the contract line. |
| DisplayName | Quantity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | initialquantity |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
LineItemOrder
| Property | Value |
|---|---|
| Description | Type the line item number for the contract line to easily identify the contract line and make sure it's listed in the correct order in the parent contract. |
| DisplayName | Line Item Order |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lineitemorder |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
Price
| Property | Value |
|---|---|
| Description | Type the total service charge for the contract line before any discounts are credited. |
| DisplayName | Total Price |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | price |
| RequiredLevel | SystemRequired |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
ProductId
| Property | Value |
|---|---|
| Description | Choose the product that is eligible for services on the contract line. |
| DisplayName | Product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | product |
ProductSerialNumber
| Property | Value |
|---|---|
| Description | Type the serial number for the product that is eligible for services on the contract line. |
| DisplayName | Serial Number |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productserialnumber |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
ServiceAddress
| Property | Value |
|---|---|
| Description | Choose the address for the customer account or contact where the services are provided. |
| DisplayName | Location |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | serviceaddress |
| RequiredLevel | None |
| Type | Lookup |
| Targets | customeraddress |
ServiceContractUnitsCode
| Property | Value |
|---|---|
| Description | Select the unit type allotted in the contract line, such as cases or minutes, to determine the level of support. |
| DisplayName | Service Contract Units |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | servicecontractunitscode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | contractdetail_servicecontractunitscode |
ServiceContractUnitsCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the contract line is existing, renewed, canceled, or expired. You can't edit a contract line after it is saved, regardless of the status. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | 0 |
| GlobalChoiceName | contractdetail_statecode |
StateCode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Existing DefaultStatus: 1 InvariantName: Existing |
| 1 | Label: Renewed DefaultStatus: 2 InvariantName: Renewed |
| 2 | Label: Canceled DefaultStatus: 3 InvariantName: Canceled |
| 3 | Label: Expired DefaultStatus: 4 InvariantName: Expired |
StatusCode
| Property | Value |
|---|---|
| Description | Select the contract line's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | -1 |
| GlobalChoiceName | contractdetail_statuscode |
StatusCode Choices/Options
| Value | Details |
|---|---|
| 1 | Label: New State:0 TransitionData: None |
| 2 | Label: Renewed State:1 TransitionData: None |
| 3 | Label: Canceled State:2 TransitionData: None |
| 4 | Label: Expired State:3 TransitionData: None |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Title
| Property | Value |
|---|---|
| Description | Type a title or name that describes the contract line. |
| DisplayName | Title |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | title |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
TotalAllotments
| Property | Value |
|---|---|
| Description | Type the total number of minutes or cases allowed for the contract line. |
| DisplayName | Total Allotments |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totalallotments |
| RequiredLevel | SystemRequired |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
UoMId
| Property | Value |
|---|---|
| Description | Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. |
| DisplayName | Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | uomid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | uom |
UoMScheduleId
| Property | Value |
|---|---|
| Description | Unique identifier of the unit group associated with the contract line. |
| DisplayName | Unit Schedule |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | uomscheduleid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | uomschedule |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- AccountId
- AllotmentsOverage
- AllotmentsRemaining
- AllotmentsUsed
- ContactId
- ContractStateCode
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CustomerIdName
- CustomerIdYomiName
- Discount_Base
- ExchangeRate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- Net
- Net_Base
- OwnerId
- OwnerIdName
- OwnerIdType
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- Price_Base
- Rate
- Rate_Base
- TransactionCurrencyId
- VersionNumber
AccountId
| Property | Value |
|---|---|
| Description | Unique identifier of the account with which the contract is associated. |
| DisplayName | Account |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | accountid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | account |
AllotmentsOverage
| Property | Value |
|---|---|
| Description | Shows the number of minutes over the Total Allotments field that have been spent on resolved cases related to the contract line. |
| DisplayName | Allotments Overage |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | allotmentsoverage |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
AllotmentsRemaining
| Property | Value |
|---|---|
| Description | Shows the number of cases or minutes remaining, based on the resolved cases logged to the contract line. |
| DisplayName | Allotments Remaining |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | allotmentsremaining |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
AllotmentsUsed
| Property | Value |
|---|---|
| Description | Shows the number of cases or minutes used in the resolved cases on the contract line. |
| DisplayName | Allotments Used |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | allotmentsused |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
ContactId
| Property | Value |
|---|---|
| Description | Unique identifier for the contact associated with the contract line. |
| DisplayName | Contact |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | contactid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | contact |
ContractStateCode
| Property | Value |
|---|---|
| Description | Status of the contract. |
| DisplayName | Contract State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | contractstatecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | contractdetail_contractstatecode |
ContractStateCode Choices/Options
| Value | Label |
|---|
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CustomerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridname |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 160 |
CustomerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridyominame |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 450 |
Discount_Base
| Property | Value |
|---|---|
| Description | Value of the Discount in base currency. |
| DisplayName | Discount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100000000000 |
| MinValue | 1E-12 |
| Precision | 12 |
| SourceTypeMask | 0 |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
Net
| Property | Value |
|---|---|
| Description | Shows the total charge to the customer for the contract line, calculated as the Total Price minus any discounts. |
| DisplayName | Net |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | net |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
Net_Base
| Property | Value |
|---|---|
| Description | Value of the Net in base currency. |
| DisplayName | Net (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | net_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | ApplicationRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets |
Price_Base
| Property | Value |
|---|---|
| Description | Value of the Total Price in base currency. |
| DisplayName | Total Price (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | price_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
Rate
| Property | Value |
|---|---|
| Description | Shows the cost per case or minute, calculated by dividing the Total Price value by the total number of cases or minutes allocated to the contract line. |
| DisplayName | Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | rate |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 100000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
Rate_Base
| Property | Value |
|---|---|
| Description | Value of the Rate in base currency. |
| DisplayName | Rate (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | rate_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | transactioncurrency |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- contract_detail_unit_of_measure_schedule
- contract_line_items
- contractlineitem_customer_accounts
- contractlineitem_customer_contacts
- customer_address_contract_line_items
- lk_contractdetail_createdonbehalfby
- lk_contractdetail_modifiedonbehalfby
- lk_contractdetailbase_createdby
- lk_contractdetailbase_modifiedby
- product_contract_line_items
- team_contractdetail
- transactioncurrency_contractdetail
- unit_of_measurement_contract_line_items
- user_contractdetail
contract_detail_unit_of_measure_schedule
One-To-Many Relationship: uomschedule contract_detail_unit_of_measure_schedule
| Property | Value |
|---|---|
| ReferencedEntity | uomschedule |
| ReferencedAttribute | uomscheduleid |
| ReferencingAttribute | uomscheduleid |
| ReferencingEntityNavigationPropertyName | uomscheduleid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
contract_line_items
One-To-Many Relationship: contract contract_line_items
| Property | Value |
|---|---|
| ReferencedEntity | contract |
| ReferencedAttribute | contractid |
| ReferencingAttribute | contractid |
| ReferencingEntityNavigationPropertyName | contractid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
contractlineitem_customer_accounts
One-To-Many Relationship: account contractlineitem_customer_accounts
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | customerid |
| ReferencingEntityNavigationPropertyName | customerid_account |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
contractlineitem_customer_contacts
One-To-Many Relationship: contact contractlineitem_customer_contacts
| Property | Value |
|---|---|
| ReferencedEntity | contact |
| ReferencedAttribute | contactid |
| ReferencingAttribute | customerid |
| ReferencingEntityNavigationPropertyName | customerid_contact |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: CascadeMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
customer_address_contract_line_items
One-To-Many Relationship: customeraddress customer_address_contract_line_items
| Property | Value |
|---|---|
| ReferencedEntity | customeraddress |
| ReferencedAttribute | customeraddressid |
| ReferencingAttribute | serviceaddress |
| ReferencingEntityNavigationPropertyName | serviceaddress |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_contractdetail_createdonbehalfby
One-To-Many Relationship: systemuser lk_contractdetail_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_contractdetail_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_contractdetail_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_contractdetailbase_createdby
One-To-Many Relationship: systemuser lk_contractdetailbase_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_contractdetailbase_modifiedby
One-To-Many Relationship: systemuser lk_contractdetailbase_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
product_contract_line_items
One-To-Many Relationship: product product_contract_line_items
| Property | Value |
|---|---|
| ReferencedEntity | product |
| ReferencedAttribute | productid |
| ReferencingAttribute | productid |
| ReferencingEntityNavigationPropertyName | productid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
team_contractdetail
One-To-Many Relationship: team team_contractdetail
| Property | Value |
|---|---|
| ReferencedEntity | team |
| ReferencedAttribute | teamid |
| ReferencingAttribute | owningteam |
| ReferencingEntityNavigationPropertyName | owningteam |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
transactioncurrency_contractdetail
One-To-Many Relationship: transactioncurrency transactioncurrency_contractdetail
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
unit_of_measurement_contract_line_items
One-To-Many Relationship: uom unit_of_measurement_contract_line_items
| Property | Value |
|---|---|
| ReferencedEntity | uom |
| ReferencedAttribute | uomid |
| ReferencingAttribute | uomid |
| ReferencingEntityNavigationPropertyName | uomid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
user_contractdetail
One-To-Many Relationship: systemuser user_contractdetail
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | owninguser |
| ReferencingEntityNavigationPropertyName | owninguser |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- contract_detail_cases
- ContractDetail_Annotation
- ContractDetail_AsyncOperations
- ContractDetail_BulkDeleteFailures
- contractdetail_MailboxTrackingFolders
- contractdetail_principalobjectattributeaccess
- ContractDetail_ProcessSessions
- ContractDetail_SyncErrors
contract_detail_cases
Many-To-One Relationship: incident contract_detail_cases
| Property | Value |
|---|---|
| ReferencingEntity | incident |
| ReferencingAttribute | contractdetailid |
| ReferencedEntityNavigationPropertyName | contract_detail_cases |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMIncident.RetrieveByObjectViewId: 00000000-0000-0000-00aa-000010003501 |
ContractDetail_Annotation
Many-To-One Relationship: annotation ContractDetail_Annotation
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | ContractDetail_Annotation |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ContractDetail_AsyncOperations
Many-To-One Relationship: asyncoperation ContractDetail_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | ContractDetail_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ContractDetail_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure ContractDetail_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | ContractDetail_BulkDeleteFailures |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
contractdetail_MailboxTrackingFolders
Many-To-One Relationship: mailboxtrackingfolder contractdetail_MailboxTrackingFolders
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | contractdetail_MailboxTrackingFolders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
contractdetail_principalobjectattributeaccess
Many-To-One Relationship: principalobjectattributeaccess contractdetail_principalobjectattributeaccess
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | contractdetail_principalobjectattributeaccess |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ContractDetail_ProcessSessions
Many-To-One Relationship: processsession ContractDetail_ProcessSessions
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | ContractDetail_ProcessSessions |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
ContractDetail_SyncErrors
Many-To-One Relationship: syncerror ContractDetail_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | ContractDetail_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference