Table 5356 "CRM Invoicedetail"

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

Properties

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

Keys

Key1: InvoiceDetailId (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”
InvoiceId: TableRelation Table 5355 “CRM Invoice”
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 Invoicedetail"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.