Table "CRM Contract"
ID 5357
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | CRM Contract |
| Description | Agreement to provide customer service during a specified amount of time or number of cases. |
| ExternalName | contract |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| ContractId | Guid | |
| OwningBusinessUnit | Guid | |
| ContractServiceLevelCode | Option | |
| ServiceAddress | Guid | |
| BillToAddress | Guid | |
| OwningUser | Guid | |
| ContactId | Guid | |
| AccountId | Guid | |
| BillingAccountId | Guid | |
| ContractNumber | Text[100] | |
| BillingContactId | Guid | |
| ActiveOn | Date | |
| ExpiresOn | Date | |
| CancelOn | Date | |
| Title | Text[100] | |
| ContractLanguage | Blob | |
| BillingStartOn | Date | |
| EffectivityCalendar | Text[168] | |
| BillingEndOn | Date | |
| BillingFrequencyCode | Option | |
| CreatedBy | Guid | |
| CreatedOn | DateTime | |
| ModifiedBy | Guid | |
| AllotmentTypeCode | Option | |
| UseDiscountAsPercentage | Boolean | |
| ModifiedOn | DateTime | |
| TotalPrice | Decimal | |
| VersionNumber | BigInteger | |
| TotalDiscount | Decimal | |
| StateCode | Option | |
| NetPrice | Decimal | |
| StatusCode | Option | |
| OriginatingContract | Guid | |
| Duration | Integer | |
| ContactIdName | Text[160] | |
| AccountIdName | Text[160] | |
| BillingContactIdName | Text[160] | |
| BillingAccountIdName | Text[160] | |
| OriginatingContractName | Text[100] | |
| BillToAddressName | Text[200] | |
| ServiceAddressName | Text[200] | |
| ContractTemplateAbbreviation | Text[20] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| CustomerId | Guid | |
| CustomerIdType | Option | |
| BillingCustomerId | Guid | |
| BillingCustomerIdType | Option | |
| OwnerId | Guid | |
| OwnerIdType | Option | |
| TimeZoneRuleVersionNumber | Integer | |
| OverriddenCreatedOn | Date | |
| ImportSequenceNumber | Integer | |
| UTCConversionTimeZoneCode | Integer | |
| TransactionCurrencyId | Guid | |
| ExchangeRate | Decimal | |
| TotalDiscount_Base | Decimal | |
| NetPrice_Base | Decimal | |
| TransactionCurrencyIdName | Text[100] | |
| TotalPrice_Base | Decimal | |
| CreatedOnBehalfBy | Guid | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| OwningTeam | Guid | |
| EntityImageId | Guid | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |