Table 5346 "CRM Pricelevel"

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

Properties

Property	Value
Caption	CRM Pricelevel
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	PriceLevelId	Guid	Price List caption
2	OrganizationId	Guid	Organization caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
3	Name Δ BC28	Text[100]	Specifies the name of the record.
4	Description	BLOB	—
5	ShippingMethodCode	Option	Shipping Method caption	OptionCaption: Default Value
6	BeginDate	Date	Start Date caption
7	PaymentMethodCode	Option	Payment Method caption	OptionCaption: Default Value
8	FreightTermsCode	Option	Freight Terms caption	OptionCaption: Default Value
9	EndDate	Date	End Date caption
10	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
11	CreatedOn	DateTime	Created On caption
12	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
13	ModifiedOn	DateTime	Modified On caption
14	StateCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: Active,Inactive
15	VersionNumber	BigInteger	Version Number caption
16	StatusCode Δ BC28	Option	Specifies information related to the Dynamics 365 Sales connection.	OptionCaption: ,Active,Inactive
17	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
18	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
19	OrganizationIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId)))
20	ImportSequenceNumber	Integer	Import Sequence Number caption
21	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
22	OverriddenCreatedOn	Date	Record Created On caption
23	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
24	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
25	TransactionCurrencyIdName Δ BC24 Δ BC28	Text[100]	Specifies the currency that amounts are shown in.	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
26	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
27	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
28	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
29	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
30	ExchangeRate Δ BC28	Decimal	Specifies the currency exchange rate.
31	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

Key1: PriceLevelId (clustered)
Key2: Name

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”
OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
OrganizationId: TableRelation Table 5363 “CRM Organization”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

24 fields in 16 objects relate to this table (TableRelation or CalcFormula).

Table 5341 “CRM Account”: DefaultPriceLevelIdName, DefaultPriceLevelId
Table 5342 “CRM Contact”: DefaultPriceLevelIdName, DefaultPriceLevelId
Table 5343 “CRM Opportunity”: PriceLevelIdName, PriceLevelId
Table 5347 “CRM Productpricelevel”: PriceLevelIdName, PriceLevelId
Table 5348 “CRM Product”: PriceLevelIdName, PriceLevelId
Table 5351 “CRM Quote”: PriceLevelIdName, PriceLevelId
Table 5353 “CRM Salesorder”: PriceLevelIdName, PriceLevelId
Table 5355 “CRM Invoice”: PriceLevelIdName, PriceLevelId
Table 6400 “FS Work Order”: PriceList
Table 6402 “FS Work Order Product”: PriceList
Table 6406 “FS Work Order Service”: PriceList
Table 6409 “FS Work Order Type”: PriceList
Table 6617 “FS Work Order”: PriceList
Table 6619 “FS Work Order Product”: PriceList
Table 6620 “FS Work Order Service”: PriceList
Table 6622 “FS Work Order Type”: PriceList

Pages and codeunits on this table

Page 5346 “CRM Pricelevel List” (source table)

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