Table 5352 "CRM Quotedetail"

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

Properties

Property	Value
Caption	CRM Quotedetail
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	QuoteDetailId	Guid	Quote Product caption
2	QuoteId	Guid	Quote caption	TableRelation Table 5351 “CRM Quote” (“CRM Quote”.QuoteId)
3	SalesRepId	Guid	Salesperson caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	LineItemNumber	Integer	Line Item Number caption
5	UoMId	Guid	Unit caption	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
6	ProductId	Guid	Existing Product caption	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
7	RequestDeliveryBy	Date	Requested Delivery Date caption
8	Quantity Δ BC28	Decimal	—
9	PricingErrorCode	Option	Pricing Error caption	OptionCaption: None,Detail Error,Missing Price Level,Inactive Price Level,Missing Quantity,Missing Unit Price,Missing Product,Invalid Product,Missing Pricing Code,Invalid Pricing Code,Missing UOM,Product Not In Price Level,Missing Price Level Amount,Missing Price Level Percentage,Missing Price,Missing Current Cost…
10	ManualDiscountAmount Δ BC28	Decimal	Manual Discount caption
11	ProductDescription	Text[250]	Write-In Product caption
12	VolumeDiscountAmount Δ BC28	Decimal	Volume Discount caption
13	PricePerUnit Δ BC28	Decimal	Price Per Unit caption
14	BaseAmount Δ BC28	Decimal	Amount caption
15	ExtendedAmount Δ BC28	Decimal	Extended Amount caption
16	Description	BLOB	—
17	ShipTo_Name	Text[200]	Ship To Name caption
18	IsPriceOverridden	Boolean	Price Overridden caption
19	Tax Δ BC28	Decimal	—
20	ShipTo_Line1	Text[250]	Ship To Street 1 caption
21	CreatedOn	DateTime	Created On caption
22	ShipTo_Line2	Text[250]	Ship To Street 2 caption
23	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
24	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
25	ShipTo_Line3	Text[250]	Ship To Street 3 caption
26	ShipTo_City	Text[80]	Ship To City caption
27	ModifiedOn	DateTime	Modified On caption
28	ShipTo_StateOrProvince	Text[50]	Ship To State/Province caption
29	ShipTo_Country	Text[80]	Ship To Country/Region caption
30	ShipTo_PostalCode	Text[20]	Ship To ZIP/Postal Code caption
31	WillCall	Boolean	Ship To caption
32	IsProductOverridden	Boolean	Select Product caption
33	ShipTo_Telephone	Text[50]	Ship To Phone caption
34	ShipTo_Fax	Text[50]	Ship To Fax caption
35	ShipTo_FreightTermsCode	Option	Freight Terms caption	OptionCaption: ,FOB,No Charge
36	ProductIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Product”.Name where(ProductId = field(ProductId)))
37	UoMIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Uom”.Name where(UoMId = field(UoMId)))
38	SalesRepIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(SalesRepId)))
39	QuoteStateCode	Option	Quote Status caption	OptionCaption:
40	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
41	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
42	OwningUser	Guid	Owning User caption
43	ShipTo_AddressId	Guid	Ship To Address ID caption
44	ShipTo_ContactName	Text[150]	Ship To Contact Name caption
45	OwningBusinessUnit	Guid	Owning Business Unit caption
46	VersionNumber	BigInteger	Version Number caption
47	ImportSequenceNumber	Integer	Import Sequence Number caption
48	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
49	OverriddenCreatedOn	Date	Record Created On caption
50	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
51	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
52	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
53	Tax_Base Δ BC28	Decimal	Tax (Base) caption
54	ExtendedAmount_Base Δ BC28	Decimal	Extended Amount (Base) caption
55	PricePerUnit_Base Δ BC28	Decimal	Price Per Unit (Base) caption
56	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
57	BaseAmount_Base Δ BC28	Decimal	Amount (Base) caption
58	ManualDiscountAmount_Base Δ BC28	Decimal	Manual Discount (Base) caption
59	VolumeDiscountAmount_Base Δ BC28	Decimal	Volume Discount (Base) caption
60	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)
61	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
62	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
63	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
64	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
65	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
66	SequenceNumber	Integer	Sequence Number caption
67	PropertyConfigurationStatus	Option	Property Configuration caption	OptionCaption: Edit,Rectify,NotConfigured
68	ProductAssociationId	Guid	Bundle Item Association caption
69	ParentBundleId	Guid	Parent Bundle caption
70	ProductTypeCode	Option	Product type caption	OptionCaption: Product,Bundle,Required Bundle Product,Optional Bundle Product

Keys

Key1: QuoteDetailId (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”
SalesRepIdName: 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)
SalesRepId: TableRelation Table 5340 “CRM Systemuser”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
ProductIdName: CalcFormula Table 5348 “CRM Product”
ProductId: TableRelation Table 5348 “CRM Product”
QuoteId: TableRelation Table 5351 “CRM Quote”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
UoMIdName: CalcFormula Table 5361 “CRM Uom”
UoMId: TableRelation Table 5361 “CRM Uom”

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