Table 5367 CRM Account Statistics

Base Application, Microsoft.Integration.D365Sales

50 fields

IdNameTypeVersions
1AccountStatisticsIdGuid17-29
2CreatedOnDateTime17-29
3CreatedByGuid17-29
4ModifiedOnDateTime17-29
5ModifiedByGuid17-29
6CreatedOnBehalfByGuid17-29
7ModifiedOnBehalfByGuid17-29
8CreatedByNameText[200]17-29
9CreatedOnBehalfByNameText[200]17-29
10ModifiedByNameText[200]17-29
11ModifiedOnBehalfByNameText[200]17-29
12OrganizationIdGuid17-29
13OrganizationIdNameText[160]17-29
14statecodeOption17-29
15statuscodeOption17-29
16VersionNumberBigInteger17-29
17ImportSequenceNumberInteger17-29
18OverriddenCreatedOnDate17-29
19TimeZoneRuleVersionNumberInteger17-29
20UTCConversionTimeZoneCodeInteger17-29
21NameText[160]17-29
22Customer NoText[20]17-29
23Balance (LCY)Decimal17-29
24TransactionCurrencyIdGuid17-29
25TransactionCurrencyIdNameText[100]17-29
26ExchangeRateDecimal17-29
27Balance (Base)Decimal17-29
28Outstanding Orders (LCY)Decimal17-29
29Outstanding Orders (Base)Decimal17-29
30Shipped Not Invoiced (LCY)Decimal17-29
31Shipped Not Invoiced (Base)Decimal17-29
32Outstanding Invoices (LCY)Decimal17-29
33Outstanding Invoices (Base)Decimal17-29
34Outstanding Serv Orders (LCY)Decimal17-29
35Outstanding Serv Orders (Base)Decimal17-29
36Serv Shipped Not Invd (LCY)Decimal17-29
37Serv Shipped Not Invd (Base)Decimal17-29
38Outstd Serv Invoices (LCY)Decimal17-29
39Outstd Serv Invoices (Base)Decimal17-29
40Total (LCY)Decimal17-29
41Total (Base)Decimal17-29
42Credit Limit (LCY)Decimal17-29
43Credit Limit (Base)Decimal17-29
44Overdue Amounts (LCY)Decimal17-29
45Overdue Amounts (Base)Decimal17-29
46Overdue Amounts As Of DateDate17-29
47Total Sales (LCY)Decimal17-29
48Total Sales (Base)Decimal17-29
49Invd Prepayment Amount (LCY)Decimal17-29
50Invd Prepayment Amount (Base)Decimal17-29