Table 5365 "CRM Discount"

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

Properties

Property	Value
Caption	CRM Discount
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	DiscountId	Guid	Discount caption
2	DiscountTypeId	Guid	Discount Type caption	TableRelation Table 5366 “CRM Discounttype” (“CRM Discounttype”.DiscountTypeId)
3	LowQuantity Δ BC28	Decimal	Begin Quantity caption
4	HighQuantity Δ BC28	Decimal	End Quantity caption
5	Percentage Δ BC28	Decimal	—
6	Amount Δ BC28	Decimal	—
7	StatusCode	Option	Status Reason caption	OptionCaption:
8	CreatedOn	DateTime	Created On caption
9	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
10	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
11	ModifiedOn	DateTime	Modified On caption
12	DiscountTypeIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Discounttype”.Name where(DiscountTypeId = field(DiscountTypeId)))
13	IsAmountType	Boolean	Amount Type caption
14	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
15	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
16	VersionNumber	BigInteger	Version Number caption
17	OrganizationId	Guid	Organization caption
18	OverriddenCreatedOn	Date	Record Created On caption
19	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
20	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
21	ImportSequenceNumber	Integer	Import Sequence Number caption
22	Amount_Base Δ BC28	Decimal	Amount (Base) caption
23	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
24	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
25	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
26	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
27	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))

Keys

Key1: DiscountId (clustered)

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”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
DiscountTypeIdName: CalcFormula Table 5366 “CRM Discounttype”
DiscountTypeId: TableRelation Table 5366 “CRM Discounttype”

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 Discount"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 3 connected objects and pages