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

Keys

# Fields
0 AccountStatisticsId Clustered: Yes
1 Name

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
CRM Account AccountStatiticsId 1..n