Table 5367 "CRM Account Statistics"

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

Properties

Property	Value
Caption	CRM Account Statistics
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	AccountStatisticsId	Guid	Account Statistics caption
2	CreatedOn	DateTime	Created On caption
3	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ModifiedOn	DateTime	Modified On caption
5	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
8	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
9	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
10	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
11	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
12	OrganizationId	Guid	Organization Id caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
13	OrganizationIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId)))
14	statecode	Option	Status caption	OptionCaption: ,Active,Inactive
15	statuscode	Option	Status Reason caption	OptionCaption: ,Active,Inactive
16	VersionNumber	BigInteger	—
17	ImportSequenceNumber	Integer	Import Sequence Number caption
18	OverriddenCreatedOn	Date	Record Created On caption
19	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
20	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
21	Name	Text[160]	Account Name caption
22	Customer No	Text[20]	Customer No. caption
23	Balance (LCY) Δ BC28	Decimal	—
24	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
25	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
26	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
27	Balance (Base) Δ BC28	Decimal	Balance (LCY) (Base) caption
28	Outstanding Orders (LCY) Δ BC28	Decimal	—
29	Outstanding Orders (Base) Δ BC28	Decimal	Outstanding Orders (LCY) (Base) caption
30	Shipped Not Invoiced (LCY) Δ BC28	Decimal	Shipped Not Invd. (LCY) caption
31	Shipped Not Invoiced (Base) Δ BC28	Decimal	Shipped Not Invd. (LCY) (Base) caption
32	Outstanding Invoices (LCY) Δ BC28	Decimal	—
33	Outstanding Invoices (Base) Δ BC28	Decimal	Outstanding Invoices (LCY) (Base) caption
34	Outstanding Serv Orders (LCY) Δ BC28	Decimal	Outstanding Serv. Orders (LCY) caption
35	Outstanding Serv Orders (Base) Δ BC28	Decimal	Outstanding Serv. Orders (LCY) (Base) caption
36	Serv Shipped Not Invd (LCY) Δ BC28	Decimal	Serv. Shipped Not Invd. (LCY) caption
37	Serv Shipped Not Invd (Base) Δ BC28	Decimal	Serv. Shipped Not Invd. (LCY) (Base) caption
38	Outstd Serv Invoices (LCY) Δ BC28	Decimal	Outstanding Serv. Invoices (LCY) caption
39	Outstd Serv Invoices (Base) Δ BC28	Decimal	Outstanding Serv. Invoices (LCY) (Base) caption
40	Total (LCY) Δ BC28	Decimal	—
41	Total (Base) Δ BC28	Decimal	Total (LCY) (Base) caption
42	Credit Limit (LCY) Δ BC28	Decimal	—
43	Credit Limit (Base) Δ BC28	Decimal	Credit Limit (LCY) (Base) caption
44	Overdue Amounts (LCY) Δ BC28	Decimal	—
45	Overdue Amounts (Base) Δ BC28	Decimal	Overdue Amounts (LCY) (Base) caption
46	Overdue Amounts As Of Date	Date	Overdue Amounts as of caption
47	Total Sales (LCY) Δ BC28	Decimal	—
48	Total Sales (Base) Δ BC28	Decimal	Total Sales (LCY) (Base) caption
49	Invd Prepayment Amount (LCY) Δ BC28	Decimal	Invoiced Prepayment Amount (LCY) caption
50	Invd Prepayment Amount (Base) Δ BC28	Decimal	Invoiced Prepayment Amount (LCY) (Base) caption

Keys

Key1: AccountStatisticsId (clustered)
Key2: Name

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”
OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
OrganizationId: TableRelation Table 5363 “CRM Organization”

Referenced by

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

Table 5341 “CRM Account”: AccountStatiticsId

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