BC Observatoryunofficial, made by waldo
tableIntegration & APIsofficial - Microsoftderived - from the source, no model text

Table 5355 "CRM Invoice"

Base Application · Microsoft.Integration.D365Sales

Open in Claude5355.mdSource on GitHub

Across versions

  1. BC23present
  2. BC2410 fields changed
  3. BC25unchanged
  4. BC262 fields removed
  5. BC27unchanged
  6. BC2819 fields changed
  7. BC29-30unchanged

Neighbourhood 11 connected objects and pages

Table 5340 "CRM Systemuser" (relates to, 10 links)CRM SystemuserTable 5341 "CRM Account" (relates to, 3 links)CRM AccountTable 5342 "CRM Contact" (relates to, 3 links)CRM ContactTable 5343 "CRM Opportunity" (relates to, 2 links)CRM OpportunityTable 5345 "CRM Transactioncurrency" (relates to, 2 links)CRM TransactioncurrencyTable 5346 "CRM Pricelevel" (relates to, 2 links)CRM PricelevelTable 5353 "CRM Salesorder" (relates to, 2 links)CRM SalesorderTable 5359 "CRM Team" (relates to, 2 links)CRM TeamTable 5364 "CRM Businessunit" (relates to)CRM BusinessunitTable 5393 "CDS Company" (relates to)CDS CompanyTable 5356 "CRM Invoicedetail" (referenced by)CRM Invoicedetail

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Properties

Property Value
Caption CRM Invoice
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 InvoiceId Guid Invoice caption
2 OpportunityId Guid Opportunity caption TableRelation Table 5343 “CRM Opportunity” (“CRM Opportunity”.OpportunityId)
3 PriorityCode Option Priority caption OptionCaption: Default Value
4 SalesOrderId Guid Order caption TableRelation Table 5353 “CRM Salesorder” (“CRM Salesorder”.SalesOrderId)
5 OwningUser Guid Owning User caption TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6 OwningBusinessUnit Guid Owning Business Unit caption TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
7 LastBackofficeSubmit Date Last Submitted to Back Office caption
8 PriceLevelId Guid Price List caption TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
9 AccountId Guid Account caption TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
10 ContactId Guid Contact caption TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
11 InvoiceNumber Text[100] Invoice ID caption
12 Name Text[2048] —
13 Description BLOB —
14 DiscountAmount Δ BC28 Decimal Invoice Discount Amount caption
15 FreightAmount Δ BC28 Decimal Freight Amount caption
16 TotalAmount Δ BC28 Decimal Total Amount caption
17 TotalLineItemAmount Δ BC28 Decimal Total Detail Amount caption
18 TotalLineItemDiscountAmount Δ BC28 Decimal Total Line Item Discount Amount caption
19 TotalAmountLessFreight Δ BC28 Decimal Total Pre-Freight Amount caption
20 TotalDiscountAmount Δ BC28 Decimal Total Discount Amount caption
21 CreatedBy Guid Created By caption TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
22 TotalTax Δ BC28 Decimal Total Tax caption
25 CreatedOn DateTime Created On caption
26 ModifiedBy Guid Modified By caption TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
27 ModifiedOn DateTime Modified On caption
28 StateCode Option Status caption OptionCaption: Active,Closed (deprecated),Paid,Canceled
29 StatusCode Option Status Reason caption OptionCaption: ,New,Partially Shipped,Billed,Booked (applies to services),Installed (applies to services),Canceled (deprecated),Paid in Full (deprecated),Complete,Partial,Canceled
30 ShipTo_Name Text[200] Ship To Name caption
31 VersionNumber BigInteger Version Number caption
32 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…
33 ShipTo_Line1 Text[250] Ship To Street 1 caption
34 ShipTo_Line2 Text[250] Ship To Street 2 caption
35 ShipTo_Line3 Text[250] Ship To Street 3 caption
36 ShipTo_City Text[80] Ship To City caption
37 ShipTo_StateOrProvince Text[50] Ship To State/Province caption
38 ShipTo_Country Text[80] Ship To Country/Region caption
39 ShipTo_PostalCode Text[20] Ship To ZIP/Postal Code caption
40 WillCall Boolean Ship To caption
41 ShipTo_Telephone Text[50] Ship To Phone caption
42 BillTo_Name Text[200] Bill To Name caption
43 ShipTo_FreightTermsCode Option Ship To Freight Terms caption OptionCaption: Default Value
44 ShipTo_Fax Text[50] Ship To Fax caption
45 BillTo_Line1 Text[250] Bill To Street 1 caption
46 BillTo_Line2 Text[250] Bill To Street 2 caption
47 BillTo_Line3 Text[250] Bill To Street 3 caption
48 BillTo_City Text[80] Bill To City caption
49 BillTo_StateOrProvince Text[50] Bill To State/Province caption
50 BillTo_Country Text[80] Bill To Country/Region caption
51 BillTo_PostalCode Text[20] Bill To ZIP/Postal Code caption
52 BillTo_Telephone Text[50] Bill To Phone caption
53 BillTo_Fax Text[50] Bill To Fax caption
54 DiscountPercentage Δ BC28 Decimal Invoice Discount (%) caption
55 ContactIdName Δ BC24 Text[160] — FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
56 AccountIdName Δ BC24 Text[160] — FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
57 OpportunityIdName Δ BC24 Text[2048] — FlowField: lookup(“CRM Opportunity”.Name where(OpportunityId = field(OpportunityId)))
58 SalesOrderIdName Δ BC24 Text[2048] — FlowField: lookup(“CRM Salesorder”.Name where(SalesOrderId = field(SalesOrderId)))
59 PriceLevelIdName Δ BC24 Text[100] — FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
60 CreatedByName Δ BC24 Text[200] — FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
61 ModifiedByName Δ BC24 Text[200] — FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
62 CustomerId Guid Customer caption TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
63 CustomerIdType Option Customer Type caption OptionCaption: ,account,contact
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 — OptionCaption: ,systemuser,team
66 IsPriceLocked Boolean Prices Locked caption
67 DateDelivered Date Date Delivered caption
68 DueDate Date Due Date caption
69 TimeZoneRuleVersionNumber Integer Time Zone Rule Version Number caption
70 ImportSequenceNumber Integer Import Sequence Number caption
71 OverriddenCreatedOn Date Record Created On caption
72 ExchangeRate Δ BC28 Decimal Exchange Rate caption
73 UTCConversionTimeZoneCode Integer UTC Conversion Time Zone Code caption
74 TransactionCurrencyId Guid Currency caption TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
75 TransactionCurrencyIdName Δ BC24 Δ BC28 Text[100] — FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
76 TotalLineItemAmount_Base Δ BC28 Decimal Total Detail Amount (Base) caption
77 TotalLineItemDiscountAmount_Ba Δ BC28 Decimal Total Line Item Discount Amount (Base) caption
78 TotalTax_Base Δ BC28 Decimal Total Tax (Base) caption
79 TotalAmountLessFreight_Base Δ BC28 Decimal Total Pre-Freight Amount (Base) caption
80 DiscountAmount_Base Δ BC28 Decimal Invoice Discount Amount (Base) caption
81 TotalAmount_Base Δ BC28 Decimal Total Amount (Base) caption
82 FreightAmount_Base Δ BC28 Decimal Freight Amount (Base) caption
83 TotalDiscountAmount_Base Δ BC28 Decimal Total Discount Amount (Base) caption
84 CreatedOnBehalfBy Guid Created By (Delegate) caption TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
85 CreatedOnBehalfByName Δ BC24 Text[200] — FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
86 ModifiedOnBehalfBy Guid Modified By (Delegate) caption TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
87 ModifiedOnBehalfByName Δ BC24 Text[200] — FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
88 OwningTeam Guid Owning Team caption TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
89 BillTo_Composite BLOB Bill To Address caption
90 ShipTo_Composite BLOB Ship To Address caption
91 ProcessId Guid Process caption
92 StageId Guid Process Stage caption
93 EntityImageId Guid Entity Image Id caption
94 TraversedPath Text[250] Traversed Path caption
95 CompanyId Guid Company Id caption TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
96 PaymentTermsCodeEnum Enum “CDS Payment Terms Code” Payment Terms caption enum Enum 5334 “CDS Payment Terms Code”
97 ShippingMethodCodeEnum Enum “CDS Shipping Agent Code” Shipping Method caption enum Enum 5336 “CDS Shipping Agent Code”

Keys

  • Key1: InvoiceId (clustered)
  • Key2: Name

Relations

Referenced by

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

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

Evidence 1 sources