Diagrams


Table

CRM Account Statistics

DynamicsDocs.comCRM Account Statistics«Table 5367»CRM Account StatisticsAccountStatisticsId [PK]CreatedOnCreatedByModifiedOnModifiedByCreatedOnBehalfByModifiedOnBehalfByCreatedByNameCreatedOnBehalfByNameModifiedByNameModifiedOnBehalfByNameOrganizationIdOrganizationIdNamestatecode; [,Active,Inactive]statuscode; [,Active,Inactive]VersionNumberImportSequenceNumberOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeNameCustomer NoBalance [LCY]TransactionCurrencyIdTransactionCurrencyIdNameExchangeRateBalance [Base]Outstanding Orders [LCY]Outstanding Orders [Base]Shipped Not Invoiced [LCY]Shipped Not Invoiced [Base]...«Table 5341»CRM AccountAccountId [PK]AccountCategoryCode; [,PreferredCustom...DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...CustomerTypeCode; [,Competitor,Consult...AccountRatingCode; [DefaultValue]IndustryCode; [,Accounting,Agriculture...TerritoryCode; [DefaultValue]AccountClassificationCode; [DefaultVal...BusinessTypeCode; [DefaultValue]OwningBusinessUnitTraversedPathOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]PrimaryContactIdParticipatesInWorkflowNameAccountNumberRevenueNumberOfEmployeesDescriptionSICOwnershipCode; [,Public,Private,Subsid...MarketCapSharesOutstandingTickerSymbolStockExchangeWebSiteURLFtpSiteURL...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OrganizationId><TransactionCurrencyId><AccountStatiticsId><ParentAccountId><MasterId><TransactionCurrencyId><TransactionCurrencyId><BaseCurrencyId><OrganizationId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 AccountStatisticsId (AccountStatisticsId) GUID
2 CreatedOn (CreatedOn) DateTime
3 CreatedBy (CreatedBy) GUID
4 ModifiedOn (ModifiedOn) DateTime
5 ModifiedBy (ModifiedBy) GUID
6 CreatedOnBehalfBy (CreatedOnBehalfBy) GUID
7 ModifiedOnBehalfBy (ModifiedOnBehalfBy) GUID
8 CreatedByName (CreatedByName) Text200 FlowField
9 CreatedOnBehalfByName (CreatedOnBehalfByName) Text200 FlowField
10 ModifiedByName (ModifiedByName) Text200 FlowField
11 ModifiedOnBehalfByName (ModifiedOnBehalfByName) Text200 FlowField
12 OrganizationId (OrganizationId) GUID
13 OrganizationIdName (OrganizationIdName) Text160 FlowField
14 statecode (statecode) Option
15 statuscode (statuscode) Option
16 VersionNumber (VersionNumber) BigInteger
17 ImportSequenceNumber (ImportSequenceNumber) Integer
18 OverriddenCreatedOn (OverriddenCreatedOn) Date
19 TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) Integer
20 UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) Integer
21 Name (Name) Text160
22 Customer No (Customer No) Text20
23 Balance (LCY) (Balance (LCY)) Decimal
24 TransactionCurrencyId (TransactionCurrencyId) GUID
25 TransactionCurrencyIdName (TransactionCurrencyIdName) Text100 FlowField
26 ExchangeRate (ExchangeRate) Decimal
27 Balance (Base) (Balance (Base)) Decimal
28 Outstanding Orders (LCY) (Outstanding Orders (LCY)) Decimal
29 Outstanding Orders (Base) (Outstanding Orders (Base)) Decimal
30 Shipped Not Invoiced (LCY) (Shipped Not Invoiced (LCY)) Decimal
31 Shipped Not Invoiced (Base) (Shipped Not Invoiced (Base)) Decimal
32 Outstanding Invoices (LCY) (Outstanding Invoices (LCY)) Decimal
33 Outstanding Invoices (Base) (Outstanding Invoices (Base)) Decimal
34 Outstanding Serv Orders (LCY) (Outstanding Serv Orders (LCY)) Decimal
35 Outstanding Serv Orders (Base) (Outstanding Serv Orders (Base)) Decimal
36 Serv Shipped Not Invd (LCY) (Serv Shipped Not Invd (LCY)) Decimal
37 Serv Shipped Not Invd (Base) (Serv Shipped Not Invd (Base)) Decimal
38 Outstd Serv Invoices (LCY) (Outstd Serv Invoices (LCY)) Decimal
39 Outstd Serv Invoices (Base) (Outstd Serv Invoices (Base)) Decimal
40 Total (LCY) (Total (LCY)) Decimal
41 Total (Base) (Total (Base)) Decimal
42 Credit Limit (LCY) (Credit Limit (LCY)) Decimal
43 Credit Limit (Base) (Credit Limit (Base)) Decimal
44 Overdue Amounts (LCY) (Overdue Amounts (LCY)) Decimal
45 Overdue Amounts (Base) (Overdue Amounts (Base)) Decimal
46 Overdue Amounts As Of Date (Overdue Amounts As Of Date) Date
47 Total Sales (LCY) (Total Sales (LCY)) Decimal
48 Total Sales (Base) (Total Sales (Base)) Decimal
49 Invd Prepayment Amount (LCY) (Invd Prepayment Amount (LCY)) Decimal
50 Invd Prepayment Amount (Base) (Invd Prepayment Amount (Base)) Decimal

Keys

# Fields
0 AccountStatisticsId (AccountStatisticsId) Clustered: Yes
1 Name (Name)

Table Relations To Other Tables

Field Related Table Related Field
OrganizationId (OrganizationId) CRM Organization OrganizationId (OrganizationId) 1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy) CRM Systemuser SystemUserId (SystemUserId) 1..n
TransactionCurrencyId (TransactionCurrencyId) CRM Transactioncurrency TransactionCurrencyId (TransactionCurrencyId) 1..n

Table Relations From Other Tables

From Table From Field
CRM Account AccountStatiticsId (AccountStatiticsId) 1..n