Table 5357 "CRM Contract"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Contract
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	ContractId	Guid	Contract caption
2	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
3	ContractServiceLevelCode	Option	Service Level caption	OptionCaption: Gold,Silver,Bronze
4	ServiceAddress	Guid	Contract Address caption	TableRelation Table 5360 “CRM Customeraddress” (“CRM Customeraddress”.CustomerAddressId)
5	BillToAddress	Guid	Bill To Address caption	TableRelation Table 5360 “CRM Customeraddress” (“CRM Customeraddress”.CustomerAddressId)
6	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
8	AccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
9	BillingAccountId	Guid	Billing Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
10	ContractNumber	Text[100]	Contract ID caption
11	BillingContactId	Guid	Billing Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
12	ActiveOn	Date	Contract Start Date caption
13	ExpiresOn	Date	Contract End Date caption
14	CancelOn	Date	Cancellation Date caption
15	Title	Text[100]	Contract Name caption
16	ContractLanguage	BLOB	Description caption
17	BillingStartOn	Date	Billing Start Date caption
18	EffectivityCalendar	Text[168]	Support Calendar caption
19	BillingEndOn	Date	Billing End Date caption
20	BillingFrequencyCode	Option	Billing Frequency caption	OptionCaption: Monthly,Bimonthly,Quarterly,Semiannually,Annually
21	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
22	CreatedOn	DateTime	Created On caption
23	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
24	AllotmentTypeCode	Option	Allotment Type caption	OptionCaption: ,Number of Cases,Time,Coverage Dates
25	UseDiscountAsPercentage	Boolean	Discount caption
26	ModifiedOn	DateTime	Modified On caption
27	TotalPrice Δ BC28	Decimal	Total Price caption
28	VersionNumber	BigInteger	Version Number caption
29	TotalDiscount Δ BC28	Decimal	Total Discount caption
30	StateCode	Option	Status caption	OptionCaption: Draft,Invoiced,Active,On Hold,Canceled,Expired
31	NetPrice Δ BC28	Decimal	Net Price caption
32	StatusCode	Option	Status Reason caption	OptionCaption: ,Draft,Invoiced,Active,On Hold,Canceled,Expired
33	OriginatingContract	Guid	Originating Contract caption	TableRelation Table 5357 “CRM Contract” (“CRM Contract”.ContractId)
34	Duration	Integer	—
35	ContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
36	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
37	BillingContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(BillingContactId)))
38	BillingAccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(BillingAccountId)))
39	OriginatingContractName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Contract”.Title where(ContractId = field(OriginatingContract)))
40	BillToAddressName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Customeraddress”.Name where(CustomerAddressId = field(BillToAddress)))
41	ServiceAddressName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Customeraddress”.Name where(CustomerAddressId = field(ServiceAddress)))
42	ContractTemplateAbbreviation	Text[20]	Template Abbreviation caption
43	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
44	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
45	CustomerId	Guid	Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
46	CustomerIdType	Option	Customer Type caption	OptionCaption: ,account,contact
47	BillingCustomerId	Guid	Bill To Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (BillingCustomerIdType = const(account)) “CRM Account”.AccountId else if (BillingCustomerIdType = const(contact)) “CRM Contact”.ContactId)
48	BillingCustomerIdType	Option	Bill To Customer Type caption	OptionCaption: ,account,contact
49	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
50	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
51	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
52	OverriddenCreatedOn	Date	Record Created On caption
53	ImportSequenceNumber	Integer	Import Sequence Number caption
54	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
55	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
56	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
57	TotalDiscount_Base Δ BC28	Decimal	Total Discount (Base) caption
58	NetPrice_Base Δ BC28	Decimal	Net Price (Base) caption
59	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
60	TotalPrice_Base Δ BC28	Decimal	Total Price (Base) caption
61	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
62	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
63	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
64	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
65	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
66	EntityImageId	Guid	Entity Image Id caption

Keys

Key1: ContractId (clustered)
Key2: Title

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
AccountIdName: CalcFormula Table 5341 “CRM Account”
BillingAccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
BillingAccountId: TableRelation Table 5341 “CRM Account”
BillingCustomerId: TableRelation Table 5341 “CRM Account” (conditional)
CustomerId: TableRelation Table 5341 “CRM Account” (conditional)
BillingContactIdName: CalcFormula Table 5342 “CRM Contact”
ContactIdName: CalcFormula Table 5342 “CRM Contact”
BillingContactId: TableRelation Table 5342 “CRM Contact”
BillingCustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
ContactId: TableRelation Table 5342 “CRM Contact”
CustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
OriginatingContractName: CalcFormula Table 5357 “CRM Contract”
OriginatingContract: TableRelation Table 5357 “CRM Contract”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
BillToAddressName: CalcFormula Table 5360 “CRM Customeraddress”
ServiceAddressName: CalcFormula Table 5360 “CRM Customeraddress”
BillToAddress: TableRelation Table 5360 “CRM Customeraddress”
ServiceAddress: TableRelation Table 5360 “CRM Customeraddress”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”

Referenced by

4 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5349 “CRM Incident”: ContractIdName, ContractId
Table 5357 “CRM Contract”: OriginatingContractName, OriginatingContract

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Contract"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 8 connected objects and pages