Diagrams


Table

CRM Systemuser

DynamicsDocs.comCRM Systemuser«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«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 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«Table 5343»CRM OpportunityOpportunityId [PK]PriceLevelIdOpportunityRatingCode; [Hot,Warm,Cold]PriorityCode; [DefaultValue]ContactIdAccountIdNameStepIdDescriptionEstimatedValueStepNameSalesStageCode; [DefaultValue]ParticipatesInWorkflowPricingErrorCode; [None,DetailError,Mi...EstimatedCloseDateCloseProbabilityActualValueActualCloseDateOwningUserOwningBusinessUnitCreatedOnCreatedByModifiedOnModifiedByVersionNumberStateCode; [Open,Won,Lost]StatusCode; [,InProgress,OnHold,Won,Ca...IsRevenueSystemCalculatedContactIdNameAccountIdNamePriceLevelIdName...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5347»CRM ProductpricelevelPriceLevelIdProductPriceLevelId [PK]UoMIdUoMScheduleIdDiscountTypeIdProductIdPercentageAmountCreatedOnQuantitySellingCode; [NoControl,Whole,...RoundingPolicyCode; [,None,Up,Down,ToN...ModifiedOnPricingMethodCode; [CurrencyAmount,Per...RoundingOptionCode; [,Endsin,Multipleo...RoundingOptionAmountVersionNumberCreatedByModifiedByDiscountTypeIdNameProductIdNamePriceLevelIdNameUoMIdNameUoMScheduleIdNameCreatedByNameModifiedByNameOrganizationIdExchangeRateTransactionCurrencyIdOverriddenCreatedOnImportSequenceNumberAmount_Base...«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5349»CRM IncidentIncidentId [PK]OwningBusinessUnitContractIdOwningUserActualServiceUnitsCaseOriginCode; [,Phone,Email,Web,Face...BilledServiceUnitsCaseTypeCode; [,Question,Problem,Reque...ProductSerialNumberTitleProductIdContractServiceLevelCode; [,Gold,Silve...AccountIdDescriptionContactIdIsDecrementingCreatedOnTicketNumberPriorityCode; [High,Normal,Low]CustomerSatisfactionCode; [,VerySatisf...IncidentStageCode; [DefaultValue]ModifiedOnCreatedByFollowupByModifiedByVersionNumberStateCode; [Active,Resolved,Canceled]SeverityCode; [DefaultValue]StatusCode; [,ProblemSolved,Informatio...ResponsibleContactIdAccountIdName...«Table 5350»CRM IncidentresolutionModifiedOnActualStartCreatedByActualDurationMinutesIsWorkflowCreatedScheduledEndCategoryIsBilledActivityId [PK]StateCode; [Open,Completed,Canceled]DescriptionStatusCode; [,Open,Closed,Canceled]OwnerIdTimeSpentSubjectCreatedOnModifiedByScheduledStartScheduledDurationMinutesVersionNumberActualEndOwningBusinessUnitIncidentIdSubcategoryOwningUserCreatedByNameIncidentIdNameModifiedByNameOwnerIdType; [,systemuser,team]ImportSequenceNumberTimeZoneRuleVersionNumber...«Table 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5352»CRM QuotedetailQuoteDetailId [PK]QuoteIdSalesRepIdLineItemNumberUoMIdProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionShipTo_NameIsPriceOverriddenTaxShipTo_Line1CreatedOnShipTo_Line2CreatedByModifiedByShipTo_Line3ShipTo_CityModifiedOnShipTo_StateOrProvinceShipTo_CountryShipTo_PostalCodeWillCall...«Table 5353»CRM SalesorderSalesOrderId [PK]OpportunityIdQuoteIdPriorityCode; [DefaultValue]SubmitStatusOwningUserSubmitDateOwningBusinessUnitSubmitStatusDescriptionPriceLevelIdLastBackofficeSubmitAccountIdContactIdOrderNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountRequestDeliveryByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOn...«Table 5354»CRM SalesorderdetailSalesOrderDetailId [PK]SalesOrderIdSalesRepIdIsProductOverriddenIsCopiedQuantityShippedLineItemNumberQuantityBackorderedUoMIdQuantityCancelledProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionIsPriceOverriddenShipTo_NameTaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5355»CRM InvoiceInvoiceId [PK]OpportunityIdPriorityCode; [DefaultValue]SalesOrderIdOwningUserOwningBusinessUnitLastBackofficeSubmitPriceLevelIdAccountIdContactIdInvoiceNumberNameDescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountCreatedByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...CreatedOnModifiedByModifiedOnStateCode; [Active,Closed<deprecated>,...StatusCode; [,New,PartiallyShipped,Bil...ShipTo_NameVersionNumber...«Table 5356»CRM InvoicedetailInvoiceDetailId [PK]SalesRepIdIsProductOverriddenLineItemNumberIsCopiedInvoiceIdQuantityBackorderedUoMIdProductIdActualDeliveryOnQuantityManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountQuantityCancelledShippingTrackingNumberExtendedAmountDescriptionIsPriceOverriddenShipTo_NamePricingErrorCode; [None,DetailError,Mi...TaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5357»CRM ContractContractId [PK]OwningBusinessUnitContractServiceLevelCode; [Gold,Silver...ServiceAddressBillToAddressOwningUserContactIdAccountIdBillingAccountIdContractNumberBillingContactIdActiveOnExpiresOnCancelOnTitleContractLanguageBillingStartOnEffectivityCalendarBillingEndOnBillingFrequencyCode; [Monthly,Bimonth...CreatedByCreatedOnModifiedByAllotmentTypeCode; [,NumberofCases,Tim...UseDiscountAsPercentageModifiedOnTotalPriceVersionNumberTotalDiscountStateCode; [Draft,Invoiced,Active,OnHo...NetPrice...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5360»CRM CustomeraddressParentIdCustomerAddressId [PK]AddressNumberAddressTypeCode; [,BillTo,ShipTo,Prima...NamePrimaryContactNameLine1Line2Line3CityStateOrProvinceCountyCountryPostOfficeBoxPostalCodeUTCOffsetFreightTermsCode; [,FOB,NoCharge]UPSZoneLatitudeTelephone1LongitudeShippingMethodCode; [,Airborne,DHL,Fed...Telephone2Telephone3FaxVersionNumberCreatedByCreatedOnModifiedByModifiedOnCreatedByName...«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5362»CRM UomscheduleUoMScheduleId [PK]OrganizationIdNameDescriptionCreatedOnCreatedByModifiedOnModifiedByVersionNumberCreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberBaseUoMNameOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameStateCode; [Active,Inactive]StatusCode; [,Active,Inactive]«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5365»CRM DiscountDiscountId [PK]DiscountTypeIdLowQuantityHighQuantityPercentageAmountStatusCode; []CreatedOnCreatedByModifiedByModifiedOnDiscountTypeIdNameIsAmountTypeCreatedByNameModifiedByNameVersionNumberOrganizationIdOverriddenCreatedOnTransactionCurrencyIdExchangeRateImportSequenceNumberAmount_BaseTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«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 5368»CRM NAV ConnectionNAVConnectionId [PK]CreatedOnCreatedByModifiedOnModifiedByCreatedOnBehalfByModifiedOnBehalfByCreatedByNameCreatedOnBehalfByNameModifiedByNameModifiedOnBehalfByNameOrganizationIdOrganizationIdNamestatecode; [,Active,Inactive]statuscode; [,Active,Inactive]VersionNumberImportSequenceNumberOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeNameDynamics NAV URL<BusinessUnitId><TransactionCurrencyId><RegardingObjectId><RegardingObjectOwnerId><SalesRepId><SalesRepId><SalesRepId><AdministratorId><DefaultPriceLevelId><OwningBusinessUnit><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><AccountStatiticsId><AccountId><CustomerId><ParentAccountId><RegardingObjectId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><ParentId><DefaultPriceLevelId><OwningBusinessUnit><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><ContactId><CustomerId><ParentContactId><RegardingObjectId><ContactId><ResponsibleContactId><CustomerId><PrimaryContactId><ContactId><CustomerId><ContactId><CustomerId><ContactId><CustomerId><ContactId><BillingContactId><CustomerId><BillingCustomerId><ParentId><PriceLevelId><OwningBusinessUnit><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><RegardingObjectId><OpportunityId><OpportunityId><OpportunityId><OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwningBusinessU><RegardingObjectId><RegardingObjectId><OrganizationId><BaseCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><OrganizationId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><UoMId><UoMScheduleId><DiscountTypeId><ProductId><DefaultUoMScheduleId><OrganizationId><DefaultUoMId><ParentProductId><ProductId><ProductId><ProductId><ProductId><OwningBusinessUnit><ContractId><OwnerId><OwningTeam><ExistingCase><MasterId><ParentCaseId><IncidentId><OwnerId><OwningTeam><OwningBusinessUnit><OwningBusinessUnit><OwnerId><OwningTeam><QuoteId><QuoteId><UoMId><OwnerId><OwningBusinessUnit><OwnerId><OwningTeam><SalesOrderId><SalesOrderId><UoMId><OwnerId><OwningBusinessUnit><OwnerId><OwningTeam><InvoiceId><UoMId><OwnerId><OwningBusinessUnit><ServiceAddress><BillToAddress><OriginatingContract><OwnerId><OwningTeam><BusinessUnitId><OwnerId><OwningBusinessUnit><BaseUoM><UoMScheduleId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><ParentBusinessUnitId><DiscountTypeId>

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

Fields

# Name Type
1 SystemUserId GUID
2 OrganizationId GUID
3 BusinessUnitId GUID
4 ParentSystemUserId GUID
5 FirstName Text64
6 Salutation Text20
7 MiddleName Text50
8 LastName Text64
9 PersonalEMailAddress Text100 [E-Mail]
10 FullName Text200
11 NickName Text50
12 Title Text128
13 InternalEMailAddress Text100 [E-Mail]
14 JobTitle Text100
15 MobileAlertEMail Text100 [E-Mail]
16 PreferredEmailCode Option
17 HomePhone Text50
18 MobilePhone Text64
19 PreferredPhoneCode Option
20 PreferredAddressCode Option
21 PhotoUrl Text200 [URL]
22 DomainName Text250
23 PassportLo Integer
24 CreatedOn DateTime
25 PassportHi Integer
26 DisabledReason Text250
27 ModifiedOn DateTime
28 CreatedBy GUID
29 EmployeeId Text100
30 ModifiedBy GUID
31 IsDisabled Boolean
32 GovernmentId Text100
33 VersionNumber BigInteger
34 ParentSystemUserIdName Text200 FlowField
35 Address1_AddressId GUID
36 Address1_AddressTypeCode Option
37 Address1_Name Text100
38 Address1_Line1 Text250
39 Address1_Line2 Text250
40 Address1_Line3 Text250
41 Address1_City Text128
42 Address1_StateOrProvince Text128
43 Address1_County Text128
44 Address1_Country Text128
45 Address1_PostOfficeBox Text40
46 Address1_PostalCode Text40
47 Address1_UTCOffset Integer
48 Address1_UPSZone Text4
49 Address1_Latitude Decimal
50 Address1_Telephone1 Text64
51 Address1_Longitude Decimal
52 Address1_ShippingMethodCode Option
53 Address1_Telephone2 Text50
54 Address1_Telephone3 Text50
55 Address1_Fax Text64
56 Address2_AddressId GUID
57 Address2_AddressTypeCode Option
58 Address2_Name Text100
59 Address2_Line1 Text250
60 Address2_Line2 Text250
61 Address2_Line3 Text250
62 Address2_City Text128
63 Address2_StateOrProvince Text128
64 Address2_County Text128
65 Address2_Country Text128
66 Address2_PostOfficeBox Text40
67 Address2_PostalCode Text40
68 Address2_UTCOffset Integer
69 Address2_UPSZone Text4
70 Address2_Latitude Decimal
71 Address2_Telephone1 Text50
72 Address2_Longitude Decimal
73 Address2_ShippingMethodCode Option
74 Address2_Telephone2 Text50
75 Address2_Telephone3 Text50
76 Address2_Fax Text50
77 CreatedByName Text200 FlowField
78 ModifiedByName Text200 FlowField
79 BusinessUnitIdName Text160 FlowField
80 Skills Text100
81 DisplayInServiceViews Boolean
82 SetupUser Boolean
83 WindowsLiveID Text250 [E-Mail]
84 IncomingEmailDeliveryMethod Option
85 OutgoingEmailDeliveryMethod Option
86 ImportSequenceNumber Integer
87 AccessMode Option
88 InviteStatusCode Option
89 OverriddenCreatedOn Date
90 UTCConversionTimeZoneCode Integer
91 TimeZoneRuleVersionNumber Integer
92 YomiFullName Text200
93 YomiLastName Text64
94 YomiMiddleName Text50
95 YomiFirstName Text64
96 IsIntegrationUser Boolean
97 DefaultFiltersPopulated Boolean
98 CreatedOnBehalfBy GUID
99 ModifiedOnBehalfBy GUID
100 ModifiedOnBehalfByName Text200 FlowField
101 CreatedOnBehalfByName Text200 FlowField
102 EmailRouterAccessApproval Option
103 TransactionCurrencyId GUID
104 TransactionCurrencyIdName Text100 FlowField
105 ExchangeRate Decimal
106 CALType Option
107 IsLicensed Boolean
108 IsSyncWithDirectory Boolean
109 YammerEmailAddress Text200 [E-Mail]
110 YammerUserId Text128
111 UserLicenseType Integer
112 EntityImageId GUID
113 Address2_Composite BLOB [Memo]
114 Address1_Composite BLOB [Memo]
115 ProcessId GUID
116 StageId GUID
117 IsEmailAddressApprovedByO365Ad Boolean
118 TraversedPath Text250
119 SharePointEmailAddress Text250

Keys

# Fields
0 SystemUserId Clustered: Yes
1 FullName

Table Relations To Other Tables

Field Related Table Related Field
BusinessUnitId CRM Businessunit BusinessUnitId 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 ModifiedOnBehalfBy 1..n
CRM Account Statistics ModifiedOnBehalfBy 1..n
CRM Businessunit ModifiedOnBehalfBy 1..n
CRM Contact ModifiedOnBehalfBy 1..n
CRM Contract ModifiedOnBehalfBy 1..n
CRM Customeraddress ModifiedOnBehalfBy 1..n
CRM Discount ModifiedOnBehalfBy 1..n
CRM Discounttype ModifiedOnBehalfBy 1..n
CRM Incident ModifiedOnBehalfBy 1..n
CRM Incidentresolution ModifiedOnBehalfBy 1..n
CRM Invoice ModifiedOnBehalfBy 1..n
CRM Invoicedetail ModifiedOnBehalfBy 1..n
CRM NAV Connection ModifiedOnBehalfBy 1..n
CRM Opportunity ModifiedOnBehalfBy 1..n
CRM Organization ModifiedOnBehalfBy 1..n
CRM Post ModifiedOnBehalfBy 1..n
CRM Pricelevel ModifiedOnBehalfBy 1..n
CRM Product ModifiedOnBehalfBy 1..n
CRM Productpricelevel ModifiedOnBehalfBy 1..n
CRM Quote ModifiedOnBehalfBy 1..n
CRM Quotedetail ModifiedOnBehalfBy 1..n
CRM Salesorder ModifiedOnBehalfBy 1..n
CRM Salesorderdetail ModifiedOnBehalfBy 1..n
CRM Systemuser ModifiedOnBehalfBy 1..n
CRM Team ModifiedOnBehalfBy 1..n
CRM Transactioncurrency ModifiedOnBehalfBy 1..n
CRM Uom ModifiedOnBehalfBy 1..n
CRM Uomschedule ModifiedOnBehalfBy 1..n