DynamicsDocs.com

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	GUID	ExternalName: contractid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the contract.
2	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	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	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	GUID	ExternalName: billtoaddress ExternalType: Lookup Description: Choose which address to send the invoice to. TableRelation: "CRM Customeraddress".CustomerAddressId
6	OwningUser	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the contract. TableRelation: "CRM Systemuser".SystemUserId
7	ContactId	GUID	ExternalName: contactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact specified for the contract. TableRelation: "CRM Contact".ContactId
8	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	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	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	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	Date	ExternalName: activeon ExternalType: DateTime Description: Enter the date when the contract becomes active.
13	ExpiresOn	Date	ExternalName: expireson ExternalType: DateTime Description: Enter the date when the contract expires.
14	CancelOn	Date	ExternalName: cancelon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the contract was canceled.
15	Title	Text100	ExternalName: title ExternalType: String Description: Type a title or name for the contract that indicates the purpose of the contract.
16	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	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	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	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	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	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
22	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	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
24	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	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	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	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	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the contract.
29	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	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	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	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	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	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	Text160	ExternalName: contactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ContactId)))	FlowField
36	AccountIdName	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
37	BillingContactIdName	Text160	ExternalName: billingcontactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(BillingContactId)))	FlowField
38	BillingAccountIdName	Text160	ExternalName: billingaccountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(BillingAccountId)))	FlowField
39	OriginatingContractName	Text100	ExternalName: originatingcontractname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contract".Title WHERE (ContractId=FIELD(OriginatingContract)))	FlowField
40	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	Text200	ExternalName: serviceaddressname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Customeraddress".Name WHERE (CustomerAddressId=FIELD(ServiceAddress)))	FlowField
42	ContractTemplateAbbreviation	Text20	ExternalName: contracttemplateabbreviation ExternalType: String ExternalAccess: Read Description: Shows the abbreviation of the contract template selected when the contract is created.
43	CreatedByName	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
44	ModifiedByName	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
45	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	Option	[ ,account,contact] ExternalName: customeridtype ExternalType: EntityName
47	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	Option	[ ,account,contact] ExternalName: billingcustomeridtype ExternalType: EntityName
49	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	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
51	TimeZoneRuleVersionNumber	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
52	OverriddenCreatedOn	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
53	ImportSequenceNumber	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
54	UTCConversionTimeZoneCode	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
55	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	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	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	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	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
60	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	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
62	CreatedOnBehalfByName	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
63	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	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
65	OwningTeam	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the contract. TableRelation: "CRM Team".TeamId
66	EntityImageId	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.

Keys

#	Fields
0	ContractId		Clustered: Yes
1	Title

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table	From Field
CRM Contract	OriginatingContract	TableRelation: "CRM Contract".ContractId	1..n
CRM Incident	ContractId	TableRelation: "CRM Contract".ContractId	1..n
CRM Post	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