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