Table 5348 "CRM Product"

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

Properties

Property	Value
Caption	CRM Product
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	ProductId	Guid	Product caption
2	DefaultUoMScheduleId	Guid	Unit Group caption	TableRelation Table 5362 “CRM Uomschedule” (“CRM Uomschedule”.UoMScheduleId)
3	OrganizationId	Guid	Organization caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
4	Name Δ BC28	Text[100]	Specifies the name of the record.
5	DefaultUoMId	Guid	Default Unit caption	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
6	PriceLevelId	Guid	Default Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
7	Description	BLOB	—
8	ProductTypeCode	Option	Product Type caption	OptionCaption: Sales Inventory,Miscellaneous Charges,Services,Flat Fees
9	ProductUrl	Text[250]	URL caption
10	Price Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
11	IsKit	Boolean	Is Kit caption
12	ProductNumber Δ BC28	Text[100]	Specifies information related to the Dynamics 365 Sales connection.
13	Size	Text[200]	—
14	CurrentCost Δ BC28	Decimal	Specifies the item’s unit cost.
15	StockVolume Δ BC28	Decimal	Stock Volume caption
16	StandardCost Δ BC28	Decimal	Specifies information related to the Dynamics 365 Sales connection.
17	StockWeight Δ BC28	Decimal	Stock Weight caption
18	QuantityDecimal	Integer	Decimals Supported caption
19	QuantityOnHand Δ BC28	Decimal	Quantity On Hand caption
20	IsStockItem	Boolean	Stock Item caption
21	SupplierName	Text[100]	Supplier Name caption
22	VendorName	Text[100]	Vendor caption
23	VendorPartNumber	Text[100]	Vendor Name caption
24	CreatedOn	DateTime	Created On caption
25	ModifiedOn	DateTime	Modified On caption
26	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
27	StateCode	Option	Status caption	OptionCaption: Active,Retired,Draft,Under Revision
28	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
29	StatusCode	Option	Status Reason caption	OptionCaption: ,Active,Retired,Draft,Under Revision
30	VersionNumber	BigInteger	Version Number caption
31	DefaultUoMIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Uom”.Name where(UoMId = field(DefaultUoMId)))
32	DefaultUoMScheduleIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Uomschedule”.Name where(UoMScheduleId = field(DefaultUoMScheduleId)))
33	PriceLevelIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
34	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
35	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
36	OrganizationIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId)))
37	OverriddenCreatedOn	Date	Record Created On caption
38	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
39	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
40	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
41	ImportSequenceNumber	Integer	Import Sequence Number caption
42	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
43	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
44	CurrentCost_Base Δ BC28	Decimal	Current Cost (Base) caption
45	Price_Base Δ BC28	Decimal	List Price (Base) caption
46	StandardCost_Base Δ BC28	Decimal	Standard Cost (Base) caption
47	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
48	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
49	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
50	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
51	EntityImageId	Guid	Entity Image Id caption
52	ProcessId	Guid	Process caption
53	StageId	Guid	Process Stage caption
54	ParentProductId	Guid	Parent caption	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
55	ParentProductIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Product”.Name where(ProductId = field(ParentProductId)))
56	ProductStructure	Option	Product Structure caption	OptionCaption: Product,Product Family,Product Bundle
57	VendorID	Text[100]	Vendor ID caption
58	TraversedPath	Text[250]	Traversed Path caption
59	ValidFromDate	Date	Valid From caption
60	ValidToDate	Date	Valid To caption
61	HierarchyPath	Text[250]	Hierarchy Path caption
62	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

Key1: ProductId (clustered)
Key2: Name
Key3: ProductNumber

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”
ParentProductIdName: CalcFormula Table 5348 “CRM Product”
ParentProductId: TableRelation Table 5348 “CRM Product”
DefaultUoMIdName: CalcFormula Table 5361 “CRM Uom”
DefaultUoMId: TableRelation Table 5361 “CRM Uom”
DefaultUoMScheduleIdName: CalcFormula Table 5362 “CRM Uomschedule”
DefaultUoMScheduleId: TableRelation Table 5362 “CRM Uomschedule”
OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
OrganizationId: TableRelation Table 5363 “CRM Organization”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

19 fields in 13 objects relate to this table (TableRelation or CalcFormula).

Table 5347 “CRM Productpricelevel”: ProductIdName, ProductId
Table 5348 “CRM Product”: ParentProductIdName, ParentProductId
Table 5349 “CRM Incident”: ProductIdName, ProductId
Table 5352 “CRM Quotedetail”: ProductIdName, ProductId
Table 5354 “CRM Salesorderdetail”: ProductIdName, ProductId
Table 5356 “CRM Invoicedetail”: ProductIdName, ProductId
Table 5385 “CRM Annotation”: ObjectId
Table 6402 “FS Work Order Product”: Product
Table 6406 “FS Work Order Service”: Service
Table 6420 “FS Customer Asset”: Product
Table 6613 “FS Customer Asset”: Product
Table 6619 “FS Work Order Product”: Product
Table 6620 “FS Work Order Service”: Service

Pages and codeunits on this table

Page 5348 “CRM Product List” (source table)

Extended by

Table extension 6617 “FS CRM Product”

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

Across versions

Neighbourhood 21 connected objects and pages