Table "CRM Account Statistics"
ID 5367
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | CRM Account Statistics |
| Description | An entity to store aggregate statistics from Dynamics NAV about an account. |
| ExternalName | nav_accountstatistics |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| AccountStatisticsId | Guid | |
| CreatedOn | DateTime | |
| CreatedBy | Guid | |
| ModifiedOn | DateTime | |
| ModifiedBy | Guid | |
| CreatedOnBehalfBy | Guid | |
| ModifiedOnBehalfBy | Guid | |
| CreatedByName | Text[200] | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedByName | Text[200] | |
| ModifiedOnBehalfByName | Text[200] | |
| OrganizationId | Guid | |
| OrganizationIdName | Text[160] | |
| statecode | Option | |
| statuscode | Option | |
| VersionNumber | BigInteger | |
| ImportSequenceNumber | Integer | |
| OverriddenCreatedOn | Date | |
| TimeZoneRuleVersionNumber | Integer | |
| UTCConversionTimeZoneCode | Integer | |
| Name | Text[160] | |
| "Customer No" | Text[20] | |
| "Balance (LCY)" | Decimal | |
| TransactionCurrencyId | Guid | |
| TransactionCurrencyIdName | Text[100] | |
| ExchangeRate | Decimal | |
| "Balance (Base)" | Decimal | |
| "Outstanding Orders (LCY)" | Decimal | |
| "Outstanding Orders (Base)" | Decimal | |
| "Shipped Not Invoiced (LCY)" | Decimal | |
| "Shipped Not Invoiced (Base)" | Decimal | |
| "Outstanding Invoices (LCY)" | Decimal | |
| "Outstanding Invoices (Base)" | Decimal | |
| "Outstanding Serv Orders (LCY)" | Decimal | |
| "Outstanding Serv Orders (Base)" | Decimal | |
| "Serv Shipped Not Invd (LCY)" | Decimal | |
| "Serv Shipped Not Invd (Base)" | Decimal | |
| "Outstd Serv Invoices (LCY)" | Decimal | |
| "Outstd Serv Invoices (Base)" | Decimal | |
| "Total (LCY)" | Decimal | |
| "Total (Base)" | Decimal | |
| "Credit Limit (LCY)" | Decimal | |
| "Credit Limit (Base)" | Decimal | |
| "Overdue Amounts (LCY)" | Decimal | |
| "Overdue Amounts (Base)" | Decimal | |
| "Overdue Amounts As Of Date" | Date | |
| "Total Sales (LCY)" | Decimal | |
| "Total Sales (Base)" | Decimal | |
| "Invd Prepayment Amount (LCY)" | Decimal | |
| "Invd Prepayment Amount (Base)" | Decimal | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |