CRM Contract

Diagrams

Table

CRM Contract

Fields |
Keys |
Relations To |
Relations From

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	ContractId (ContractId)	GUID	ExternalName: contractid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the contract.
2	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the contract. TableRelation: "CRM Businessunit".BusinessUnitId
3	ContractServiceLevelCode (ContractServiceLevelCode)	Option	[Gold,Silver,Bronze] OptionOrdinalValues: [1;2;3] InitValue: Gold ExternalName: contractservicelevelcode ExternalType: Picklist Description: Select the level of service that should be provided for the contract based on your company's definition of bronze, silver, or gold.
4	ServiceAddress (ServiceAddress)	GUID	ExternalName: serviceaddress ExternalType: Lookup Description: Choose the address for the customer account or contact where the services are provided. TableRelation: "CRM Customeraddress".CustomerAddressId
5	BillToAddress (BillToAddress)	GUID	ExternalName: billtoaddress ExternalType: Lookup Description: Choose which address to send the invoice to. TableRelation: "CRM Customeraddress".CustomerAddressId
6	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the contract. TableRelation: "CRM Systemuser".SystemUserId
7	ContactId (ContactId)	GUID	ExternalName: contactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact specified for the contract. TableRelation: "CRM Contact".ContactId
8	AccountId (AccountId)	GUID	ExternalName: accountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account with which the contract is associated. TableRelation: "CRM Account".AccountId
9	BillingAccountId (BillingAccountId)	GUID	ExternalName: billingaccountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account to which the contract is to be billed. TableRelation: "CRM Account".AccountId
10	ContractNumber (ContractNumber)	Text100	ExternalName: contractnumber ExternalType: String ExternalAccess: Insert Description: Shows the number for the contract for customer reference and searching capabilities. You cannot modify this number.
11	BillingContactId (BillingContactId)	GUID	ExternalName: billingcontactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact to whom the contract is to be billed. TableRelation: "CRM Contact".ContactId
12	ActiveOn (ActiveOn)	Date	ExternalName: activeon ExternalType: DateTime Description: Enter the date when the contract becomes active.
13	ExpiresOn (ExpiresOn)	Date	ExternalName: expireson ExternalType: DateTime Description: Enter the date when the contract expires.
14	CancelOn (CancelOn)	Date	ExternalName: cancelon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the contract was canceled.
15	Title (Title)	Text100	ExternalName: title ExternalType: String Description: Type a title or name for the contract that indicates the purpose of the contract.
16	ContractLanguage (ContractLanguage)	BLOB [Memo]	ExternalName: contractlanguage ExternalType: Memo Description: Type additional information about the contract, such as the products or services provided to the customer.
17	BillingStartOn (BillingStartOn)	Date	ExternalName: billingstarton ExternalType: DateTime Description: Enter the start date for the contract's billing period to indicate the period for which the customer must pay for a service. This defaults to the same date that is selected in the Contract Start Date field.
18	EffectivityCalendar (EffectivityCalendar)	Text168	ExternalName: effectivitycalendar ExternalType: String Description: Days of the week and times during which customer service support is available for the duration of the contract.
19	BillingEndOn (BillingEndOn)	Date	ExternalName: billingendon ExternalType: DateTime Description: Enter the end date for the contract's billing period to indicate the period for which the customer must pay for a service.
20	BillingFrequencyCode (BillingFrequencyCode)	Option	[Monthly,Bimonthly,Quarterly,Semiannually,Annually] OptionOrdinalValues: [1;2;3;4;5] InitValue: Monthly ExternalName: billingfrequencycode ExternalType: Picklist Description: Select the billing schedule of the contract to indicate how often the customer should be invoiced.
21	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
22	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
23	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
24	AllotmentTypeCode (AllotmentTypeCode)	Option	[ ,NumberofCases,Time,CoverageDates] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: allotmenttypecode ExternalType: Picklist Description: Type of allotment that the contract supports.
25	UseDiscountAsPercentage (UseDiscountAsPercentage)	Boolean	ExternalName: usediscountaspercentage ExternalType: Boolean ExternalAccess: Insert Description: Select whether the discounts entered on contract lines for this contract should be entered as a percentage or a fixed dollar value.
26	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
27	TotalPrice (TotalPrice)	Decimal	ExternalName: totalprice ExternalType: Money ExternalAccess: Read Description: Shows the total service charge for the contract, before any discounts are credited. This is calculated as the sum of values in the Total Price field for each existing contract line related to the contract.
28	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the contract.
29	TotalDiscount (TotalDiscount)	Decimal	ExternalName: totaldiscount ExternalType: Money ExternalAccess: Read Description: Shows the total discount applied to the contract's service charges, calculated as the sum of values in the Discount fields for each existing contract line related to the contract.
30	StateCode (StateCode)	Option	[Draft,Invoiced,Active,OnHold,Canceled,Expired] OptionOrdinalValues: [0;1;2;3;4;5] InitValue: Draft ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Shows whether the contract is in draft, invoiced, active, on hold, canceled, or expired. You can edit only the contracts that are in draft status.
31	NetPrice (NetPrice)	Decimal	ExternalName: netprice ExternalType: Money ExternalAccess: Read Description: Shows the total charge to the customer for the service contract, calculated as the sum of values in the Net field for each existing contract line related to the contract.
32	StatusCode (StatusCode)	Option	[ ,Draft,Invoiced,Active,OnHold,Canceled,Expired] OptionOrdinalValues: [-1;1;2;3;4;5;6] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Select the contract's status.
33	OriginatingContract (OriginatingContract)	GUID	ExternalName: originatingcontract ExternalType: Lookup ExternalAccess: Insert Description: Choose the original contract that this contract was created from. This information is used to track renewal history. TableRelation: "CRM Contract".ContractId
34	Duration (Duration)	Integer	ExternalName: duration ExternalType: Integer ExternalAccess: Read Description: Shows for the duration of the contract, in days, based on the contract start and end dates.
35	ContactIdName (ContactIdName)	Text160	ExternalName: contactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ContactId)))	FlowField
36	AccountIdName (AccountIdName)	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
37	BillingContactIdName (BillingContactIdName)	Text160	ExternalName: billingcontactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(BillingContactId)))	FlowField
38	BillingAccountIdName (BillingAccountIdName)	Text160	ExternalName: billingaccountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(BillingAccountId)))	FlowField
39	OriginatingContractName (OriginatingContractName)	Text100	ExternalName: originatingcontractname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contract".Title WHERE (ContractId=FIELD(OriginatingContract)))	FlowField
40	BillToAddressName (BillToAddressName)	Text200	ExternalName: billtoaddressname ExternalType: String ExternalAccess: Read Description: Name of the address that is to be billed for the contract. CalcFormula: Lookup("CRM Customeraddress".Name WHERE (CustomerAddressId=FIELD(BillToAddress)))	FlowField
41	ServiceAddressName (ServiceAddressName)	Text200	ExternalName: serviceaddressname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Customeraddress".Name WHERE (CustomerAddressId=FIELD(ServiceAddress)))	FlowField
42	ContractTemplateAbbreviation (ContractTemplateAbbreviation)	Text20	ExternalName: contracttemplateabbreviation ExternalType: String ExternalAccess: Read Description: Shows the abbreviation of the contract template selected when the contract is created.
43	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
44	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
45	CustomerId (CustomerId)	GUID	ExternalName: customerid ExternalType: Customer Description: Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;
46	CustomerIdType (CustomerIdType)	Option	[ ,account,contact] ExternalName: customeridtype ExternalType: EntityName
47	BillingCustomerId (BillingCustomerId)	GUID	ExternalName: billingcustomerid ExternalType: Customer Description: Select the customer account or contact to which the contract should be billed to provide a quick link to address and other customer details. TableRelation: IF (BillingCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (BillingCustomerIdType=CONST(contact)) "CRM Contact".ContactId;
48	BillingCustomerIdType (BillingCustomerIdType)	Option	[ ,account,contact] ExternalName: billingcustomeridtype ExternalType: EntityName
49	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
50	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
51	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
52	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
53	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
54	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
55	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup ExternalAccess: Insert Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
56	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read 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.
57	TotalDiscount_Base (TotalDiscount_Base)	Decimal	ExternalName: totaldiscount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Discount field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
58	NetPrice_Base (NetPrice_Base)	Decimal	ExternalName: netprice_base ExternalType: Money ExternalAccess: Read Description: Shows the Net Price field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
59	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
60	TotalPrice_Base (TotalPrice_Base)	Decimal	ExternalName: totalprice_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Price field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
61	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
62	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
63	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
64	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
65	OwningTeam (OwningTeam)	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the contract. TableRelation: "CRM Team".TeamId
66	EntityImageId (EntityImageId)	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.

Keys

#	Fields
0	ContractId (ContractId)		Clustered: Yes
1	Title (Title)

Table Relations To Other Tables

Field	Related Table	Related Field
BillingCustomerId (BillingCustomerId)	CRM Account	AccountId (AccountId)	TableRelation: IF (BillingCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (BillingCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OwningBusinessUnit (OwningBusinessUnit)	CRM Businessunit	BusinessUnitId (BusinessUnitId)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
BillingCustomerId (BillingCustomerId)	CRM Contact	ContactId (ContactId)	TableRelation: IF (BillingCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (BillingCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OriginatingContract (OriginatingContract)	CRM Contract	ContractId (ContractId)	TableRelation: "CRM Contract".ContractId	1..n
BillToAddress (BillToAddress)	CRM Customeraddress	CustomerAddressId (CustomerAddressId)	TableRelation: "CRM Customeraddress".CustomerAddressId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam (OwningTeam)	CRM Team	TeamId (TeamId)	TableRelation: "CRM Team".TeamId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Contract	OriginatingContract (OriginatingContract)	TableRelation: "CRM Contract".ContractId	1..n
CRM Incident	ContractId (ContractId)	TableRelation: "CRM Contract".ContractId	1..n
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n