Table 5347 "CRM Productpricelevel"

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

Properties

Property	Value
Caption	CRM Productpricelevel
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	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
2	ProductPriceLevelId	Guid	Product Price List caption
3	UoMId	Guid	Unit caption	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
4	UoMScheduleId	Guid	Unit Schedule ID caption	TableRelation Table 5362 “CRM Uomschedule” (“CRM Uomschedule”.UoMScheduleId)
5	DiscountTypeId	Guid	Discount List caption	TableRelation Table 5366 “CRM Discounttype” (“CRM Discounttype”.DiscountTypeId)
6	ProductId	Guid	Product caption	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
7	Percentage Δ BC28	Decimal	—
8	Amount Δ BC28	Decimal	—
9	CreatedOn	DateTime	Created On caption
10	QuantitySellingCode	Option	Quantity Selling Option caption	OptionCaption: No Control,Whole,Whole and Fractional
11	RoundingPolicyCode	Option	Rounding Policy caption	OptionCaption: ,None,Up,Down,To Nearest
12	ModifiedOn	DateTime	Modified On caption
13	PricingMethodCode	Option	Pricing Method caption	OptionCaption: Currency Amount,Percent of List,Percent Markup - Current Cost,Percent Margin - Current Cost,Percent Markup - Standard Cost,Percent Margin - Standard Cost
14	RoundingOptionCode	Option	Rounding Option caption	OptionCaption: ,Ends in,Multiple of
15	RoundingOptionAmount Δ BC28	Decimal	Rounding Amount caption
16	VersionNumber	BigInteger	Version Number caption
17	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
18	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
19	DiscountTypeIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Discounttype”.Name where(DiscountTypeId = field(DiscountTypeId)))
20	ProductIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Product”.Name where(ProductId = field(ProductId)))
21	PriceLevelIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
22	UoMIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Uom”.Name where(UoMId = field(UoMId)))
23	UoMScheduleIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Uomschedule”.Name where(UoMScheduleId = field(UoMScheduleId)))
24	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
25	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
26	OrganizationId	Guid	Organization caption
27	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
28	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
29	OverriddenCreatedOn	Date	Record Created On caption
30	ImportSequenceNumber	Integer	Import Sequence Number caption
31	Amount_Base Δ BC28	Decimal	Amount (Base) caption
32	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
33	RoundingOptionAmount_Base Δ BC28	Decimal	Rounding Amount (Base) caption
34	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
35	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
36	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
37	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
38	ProcessId	Guid	Process caption
39	StageId	Guid	Process Stage caption
40	ProductNumber	Text[100]	Product ID caption
41	TraversedPath	Text[250]	Traversed Path caption

Keys

Key1: ProductPriceLevelId (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”
PriceLevelIdName: CalcFormula Table 5346 “CRM Pricelevel”
PriceLevelId: TableRelation Table 5346 “CRM Pricelevel”
ProductIdName: CalcFormula Table 5348 “CRM Product”
ProductId: TableRelation Table 5348 “CRM Product”
UoMIdName: CalcFormula Table 5361 “CRM Uom”
UoMId: TableRelation Table 5361 “CRM Uom”
UoMScheduleIdName: CalcFormula Table 5362 “CRM Uomschedule”
UoMScheduleId: TableRelation Table 5362 “CRM Uomschedule”
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 Productpricelevel"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.