Table 5357 CRM Contract in 17

Jonas Paprotka, Base Application 17.5.22499.32099, checked 2026-09-20

App: Base Application

Versions1718 19 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 66

Id	Name	Type	Obsolete
1	ContractId	Guid	-
2	OwningBusinessUnit	Guid	-
3	ContractServiceLevelCode	Option	-
4	ServiceAddress	Guid	-
5	BillToAddress	Guid	-
6	OwningUser	Guid	-
7	ContactId	Guid	-
8	AccountId	Guid	-
9	BillingAccountId	Guid	-
10	ContractNumber	Text[100]	-
11	BillingContactId	Guid	-
12	ActiveOn	Date	-
13	ExpiresOn	Date	-
14	CancelOn	Date	-
15	Title	Text[100]	-
16	ContractLanguage	Blob	-
17	BillingStartOn	Date	-
18	EffectivityCalendar	Text[168]	-
19	BillingEndOn	Date	-
20	BillingFrequencyCode	Option	-
21	CreatedBy	Guid	-
22	CreatedOn	DateTime	-
23	ModifiedBy	Guid	-
24	AllotmentTypeCode	Option	-
25	UseDiscountAsPercentage	Boolean	-
26	ModifiedOn	DateTime	-
27	TotalPrice	Decimal	-
28	VersionNumber	BigInteger	-
29	TotalDiscount	Decimal	-
30	StateCode	Option	-
31	NetPrice	Decimal	-
32	StatusCode	Option	-
33	OriginatingContract	Guid	-
34	Duration	Integer	-
35	ContactIdName	Text[160]	-
36	AccountIdName	Text[160]	-
37	BillingContactIdName	Text[160]	-
38	BillingAccountIdName	Text[160]	-
39	OriginatingContractName	Text[100]	-
40	BillToAddressName	Text[200]	-
41	ServiceAddressName	Text[200]	-
42	ContractTemplateAbbreviation	Text[20]	-
43	CreatedByName	Text[200]	-
44	ModifiedByName	Text[200]	-
45	CustomerId	Guid	-
46	CustomerIdType	Option	-
47	BillingCustomerId	Guid	-
48	BillingCustomerIdType	Option	-
49	OwnerId	Guid	-
50	OwnerIdType	Option	-
51	TimeZoneRuleVersionNumber	Integer	-
52	OverriddenCreatedOn	Date	-
53	ImportSequenceNumber	Integer	-
54	UTCConversionTimeZoneCode	Integer	-
55	TransactionCurrencyId	Guid	-
56	ExchangeRate	Decimal	-
57	TotalDiscount_Base	Decimal	-
58	NetPrice_Base	Decimal	-
59	TransactionCurrencyIdName	Text[100]	-
60	TotalPrice_Base	Decimal	-
61	CreatedOnBehalfBy	Guid	-
62	CreatedOnBehalfByName	Text[200]	-
63	ModifiedOnBehalfBy	Guid	-
64	ModifiedOnBehalfByName	Text[200]	-
65	OwningTeam	Guid	-
66	EntityImageId	Guid	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	ContractId	-
Key2	Title	-