Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | SystemUserId (SystemUserId) | GUID | ExternalName: systemuserid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
| 2 | OrganizationId (OrganizationId) | GUID | ExternalName: organizationid ExternalType: Uniqueidentifier ExternalAccess: Read
|
|
| 3 | BusinessUnitId (BusinessUnitId) | GUID | ExternalName: businessunitid ExternalType: Lookup
|
|
| 4 | ParentSystemUserId (ParentSystemUserId) | GUID | ExternalName: parentsystemuserid ExternalType: Lookup
|
|
| 5 | FirstName (FirstName) | Text64 | ExternalName: firstname ExternalType: String
|
|
| 6 | Salutation (Salutation) | Text20 | ExternalName: salutation ExternalType: String
|
|
| 7 | MiddleName (MiddleName) | Text50 | ExternalName: middlename ExternalType: String
|
|
| 8 | LastName (LastName) | Text64 | ExternalName: lastname ExternalType: String
|
|
| 9 | PersonalEMailAddress (PersonalEMailAddress) | Text100 [E-Mail] | ExternalName: personalemailaddress ExternalType: String
|
|
| 10 | FullName (FullName) | Text200 | ExternalName: fullname ExternalType: String ExternalAccess: Read
|
|
| 11 | NickName (NickName) | Text50 | ExternalName: nickname ExternalType: String
|
|
| 12 | Title (Title) | Text128 | ExternalName: title ExternalType: String
|
|
| 13 | InternalEMailAddress (InternalEMailAddress) | Text100 [E-Mail] | ExternalName: internalemailaddress ExternalType: String
|
|
| 14 | JobTitle (JobTitle) | Text100 | ExternalName: jobtitle ExternalType: String
|
|
| 15 | MobileAlertEMail (MobileAlertEMail) | Text100 [E-Mail] | ExternalName: mobilealertemail ExternalType: String
|
|
| 16 | PreferredEmailCode (PreferredEmailCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: preferredemailcode ExternalType: Picklist
|
|
| 17 | HomePhone (HomePhone) | Text50 | ExternalName: homephone ExternalType: String
|
|
| 18 | MobilePhone (MobilePhone) | Text64 | ExternalName: mobilephone ExternalType: String
|
|
| 19 | PreferredPhoneCode (PreferredPhoneCode) | Option | [MainPhone,OtherPhone,HomePhone,MobilePhone] OptionOrdinalValues: [1;2;3;4] InitValue: MainPhone ExternalName: preferredphonecode ExternalType: Picklist
|
|
| 20 | PreferredAddressCode (PreferredAddressCode) | Option | [MailingAddress,OtherAddress] OptionOrdinalValues: [1;2] InitValue: MailingAddress ExternalName: preferredaddresscode ExternalType: Picklist
|
|
| 21 | PhotoUrl (PhotoUrl) | Text200 [URL] | ExternalName: photourl ExternalType: String
|
|
| 22 | DomainName (DomainName) | Text250 | ExternalName: domainname ExternalType: String
|
|
| 23 | PassportLo (PassportLo) | Integer | MaxValue: 1000000000 ExternalName: passportlo ExternalType: Integer
|
|
| 24 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
| 25 | PassportHi (PassportHi) | Integer | MaxValue: 1000000000 ExternalName: passporthi ExternalType: Integer
|
|
| 26 | DisabledReason (DisabledReason) | Text250 | ExternalName: disabledreason ExternalType: String ExternalAccess: Read
|
|
| 27 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
| 28 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
| 29 | EmployeeId (EmployeeId) | Text100 | ExternalName: employeeid ExternalType: String
|
|
| 30 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
| 31 | IsDisabled (IsDisabled) | Boolean | ExternalName: isdisabled ExternalType: Boolean ExternalAccess: Read
|
|
| 32 | GovernmentId (GovernmentId) | Text100 | ExternalName: governmentid ExternalType: String
|
|
| 33 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
| 34 | ParentSystemUserIdName (ParentSystemUserIdName) | Text200 | ExternalName: parentsystemuseridname ExternalType: String ExternalAccess: Read
|
FlowField |
| 35 | Address1_AddressId (Address1_AddressId) | GUID | ExternalName: address1_addressid ExternalType: Uniqueidentifier
|
|
| 36 | Address1_AddressTypeCode (Address1_AddressTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_addresstypecode ExternalType: Picklist
|
|
| 37 | Address1_Name (Address1_Name) | Text100 | ExternalName: address1_name ExternalType: String
|
|
| 38 | Address1_Line1 (Address1_Line1) | Text250 | ExternalName: address1_line1 ExternalType: String
|
|
| 39 | Address1_Line2 (Address1_Line2) | Text250 | ExternalName: address1_line2 ExternalType: String
|
|
| 40 | Address1_Line3 (Address1_Line3) | Text250 | ExternalName: address1_line3 ExternalType: String
|
|
| 41 | Address1_City (Address1_City) | Text128 | ExternalName: address1_city ExternalType: String
|
|
| 42 | Address1_StateOrProvince (Address1_StateOrProvince) | Text128 | ExternalName: address1_stateorprovince ExternalType: String
|
|
| 43 | Address1_County (Address1_County) | Text128 | ExternalName: address1_county ExternalType: String
|
|
| 44 | Address1_Country (Address1_Country) | Text128 | ExternalName: address1_country ExternalType: String
|
|
| 45 | Address1_PostOfficeBox (Address1_PostOfficeBox) | Text40 | ExternalName: address1_postofficebox ExternalType: String
|
|
| 46 | Address1_PostalCode (Address1_PostalCode) | Text40 | ExternalName: address1_postalcode ExternalType: String
|
|
| 47 | Address1_UTCOffset (Address1_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address1_utcoffset ExternalType: Integer
|
|
| 48 | Address1_UPSZone (Address1_UPSZone) | Text4 | ExternalName: address1_upszone ExternalType: String
|
|
| 49 | Address1_Latitude (Address1_Latitude) | Decimal | ExternalName: address1_latitude ExternalType: Double
|
|
| 50 | Address1_Telephone1 (Address1_Telephone1) | Text64 | ExternalName: address1_telephone1 ExternalType: String
|
|
| 51 | Address1_Longitude (Address1_Longitude) | Decimal | ExternalName: address1_longitude ExternalType: Double
|
|
| 52 | Address1_ShippingMethodCode (Address1_ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_shippingmethodcode ExternalType: Picklist
|
|
| 53 | Address1_Telephone2 (Address1_Telephone2) | Text50 | ExternalName: address1_telephone2 ExternalType: String
|
|
| 54 | Address1_Telephone3 (Address1_Telephone3) | Text50 | ExternalName: address1_telephone3 ExternalType: String
|
|
| 55 | Address1_Fax (Address1_Fax) | Text64 | ExternalName: address1_fax ExternalType: String
|
|
| 56 | Address2_AddressId (Address2_AddressId) | GUID | ExternalName: address2_addressid ExternalType: Uniqueidentifier
|
|
| 57 | Address2_AddressTypeCode (Address2_AddressTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_addresstypecode ExternalType: Picklist
|
|
| 58 | Address2_Name (Address2_Name) | Text100 | ExternalName: address2_name ExternalType: String
|
|
| 59 | Address2_Line1 (Address2_Line1) | Text250 | ExternalName: address2_line1 ExternalType: String
|
|
| 60 | Address2_Line2 (Address2_Line2) | Text250 | ExternalName: address2_line2 ExternalType: String
|
|
| 61 | Address2_Line3 (Address2_Line3) | Text250 | ExternalName: address2_line3 ExternalType: String
|
|
| 62 | Address2_City (Address2_City) | Text128 | ExternalName: address2_city ExternalType: String
|
|
| 63 | Address2_StateOrProvince (Address2_StateOrProvince) | Text128 | ExternalName: address2_stateorprovince ExternalType: String
|
|
| 64 | Address2_County (Address2_County) | Text128 | ExternalName: address2_county ExternalType: String
|
|
| 65 | Address2_Country (Address2_Country) | Text128 | ExternalName: address2_country ExternalType: String
|
|
| 66 | Address2_PostOfficeBox (Address2_PostOfficeBox) | Text40 | ExternalName: address2_postofficebox ExternalType: String
|
|
| 67 | Address2_PostalCode (Address2_PostalCode) | Text40 | ExternalName: address2_postalcode ExternalType: String
|
|
| 68 | Address2_UTCOffset (Address2_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address2_utcoffset ExternalType: Integer
|
|
| 69 | Address2_UPSZone (Address2_UPSZone) | Text4 | ExternalName: address2_upszone ExternalType: String
|
|
| 70 | Address2_Latitude (Address2_Latitude) | Decimal | ExternalName: address2_latitude ExternalType: Double
|
|
| 71 | Address2_Telephone1 (Address2_Telephone1) | Text50 | ExternalName: address2_telephone1 ExternalType: String
|
|
| 72 | Address2_Longitude (Address2_Longitude) | Decimal | ExternalName: address2_longitude ExternalType: Double
|
|
| 73 | Address2_ShippingMethodCode (Address2_ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_shippingmethodcode ExternalType: Picklist
|
|
| 74 | Address2_Telephone2 (Address2_Telephone2) | Text50 | ExternalName: address2_telephone2 ExternalType: String
|
|
| 75 | Address2_Telephone3 (Address2_Telephone3) | Text50 | ExternalName: address2_telephone3 ExternalType: String
|
|
| 76 | Address2_Fax (Address2_Fax) | Text50 | ExternalName: address2_fax ExternalType: String
|
|
| 77 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
| 78 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
| 79 | BusinessUnitIdName (BusinessUnitIdName) | Text160 | ExternalName: businessunitidname ExternalType: String ExternalAccess: Read
|
FlowField |
| 80 | Skills (Skills) | Text100 | ExternalName: skills ExternalType: String
|
|
| 81 | DisplayInServiceViews (DisplayInServiceViews) | Boolean | ExternalName: displayinserviceviews ExternalType: Boolean
|
|
| 82 | SetupUser (SetupUser) | Boolean | ExternalName: setupuser ExternalType: Boolean
|
|
| 83 | WindowsLiveID (WindowsLiveID) | Text250 [E-Mail] | ExternalName: windowsliveid ExternalType: String
|
|
| 84 | IncomingEmailDeliveryMethod (IncomingEmailDeliveryMethod) | Option | [None,MicrosoftDynamicsCRMforOutlook,Server-SideSynchronizationorEmailRouter,ForwardMailbox] OptionOrdinalValues: [0;1;2;3] InitValue: MicrosoftDynamicsCRMforOutlook ExternalName: incomingemaildeliverymethod ExternalType: Picklist
|
|
| 85 | OutgoingEmailDeliveryMethod (OutgoingEmailDeliveryMethod) | Option | [None,MicrosoftDynamicsCRMforOutlook,Server-SideSynchronizationorEmailRouter] OptionOrdinalValues: [0;1;2] InitValue: MicrosoftDynamicsCRMforOutlook ExternalName: outgoingemaildeliverymethod ExternalType: Picklist
|
|
| 86 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
| 87 | AccessMode (AccessMode) | Option | [Read-Write,Administrative,Read,SupportUser,Non-interactive] OptionOrdinalValues: [0;1;2;3;4] InitValue: Read-Write ExternalName: accessmode ExternalType: Picklist
|
|
| 88 | InviteStatusCode (InviteStatusCode) | Option | [InvitationNotSent,Invited,InvitationNearExpired,InvitationExpired,InvitationAccepted,InvitationRejected,InvitationRevoked] OptionOrdinalValues: [0;1;2;3;4;5;6] InitValue: InvitationNotSent ExternalName: invitestatuscode ExternalType: Picklist
|
|
| 89 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
| 90 | UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
| 91 | TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
| 92 | YomiFullName (YomiFullName) | Text200 | ExternalName: yomifullname ExternalType: String ExternalAccess: Read
|
|
| 93 | YomiLastName (YomiLastName) | Text64 | ExternalName: yomilastname ExternalType: String
|
|
| 94 | YomiMiddleName (YomiMiddleName) | Text50 | ExternalName: yomimiddlename ExternalType: String
|
|
| 95 | YomiFirstName (YomiFirstName) | Text64 | ExternalName: yomifirstname ExternalType: String
|
|
| 96 | IsIntegrationUser (IsIntegrationUser) | Boolean | ExternalName: isintegrationuser ExternalType: Boolean
|
|
| 97 | DefaultFiltersPopulated (DefaultFiltersPopulated) | Boolean | ExternalName: defaultfilterspopulated ExternalType: Boolean ExternalAccess: Read
|
|
| 98 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
| 99 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
| 100 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
| 101 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
| 102 | EmailRouterAccessApproval (EmailRouterAccessApproval) | Option | [Empty,Approved,PendingApproval,Rejected] OptionOrdinalValues: [0;1;2;3] InitValue: Empty ExternalName: emailrouteraccessapproval ExternalType: Picklist ExternalAccess: Modify
|
|
| 103 | TransactionCurrencyId (TransactionCurrencyId) | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
| 104 | TransactionCurrencyIdName (TransactionCurrencyIdName) | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
| 105 | ExchangeRate (ExchangeRate) | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
| 106 | CALType (CALType) | Option | [Professional,Administrative,Basic,DeviceProfessional,DeviceBasic,Essential,DeviceEssential,Enterprise,DeviceEnterprise] OptionOrdinalValues: [0;1;2;3;4;5;6;7;8] InitValue: Professional ExternalName: caltype ExternalType: Picklist
|
|
| 107 | IsLicensed (IsLicensed) | Boolean | ExternalName: islicensed ExternalType: Boolean
|
|
| 108 | IsSyncWithDirectory (IsSyncWithDirectory) | Boolean | ExternalName: issyncwithdirectory ExternalType: Boolean
|
|
| 109 | YammerEmailAddress (YammerEmailAddress) | Text200 [E-Mail] | ExternalName: yammeremailaddress ExternalType: String
|
|
| 110 | YammerUserId (YammerUserId) | Text128 | ExternalName: yammeruserid ExternalType: String
|
|
| 111 | UserLicenseType (UserLicenseType) | Integer | ExternalName: userlicensetype ExternalType: Integer
|
|
| 112 | EntityImageId (EntityImageId) | GUID | ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read
|
|
| 113 | Address2_Composite (Address2_Composite) | BLOB [Memo] | ExternalName: address2_composite ExternalType: Memo ExternalAccess: Read
|
|
| 114 | Address1_Composite (Address1_Composite) | BLOB [Memo] | ExternalName: address1_composite ExternalType: Memo ExternalAccess: Read
|
|
| 115 | ProcessId (ProcessId) | GUID | ExternalName: processid ExternalType: Uniqueidentifier
|
|
| 116 | StageId (StageId) | GUID | ExternalName: stageid ExternalType: Uniqueidentifier
|
|
| 117 | IsEmailAddressApprovedByO365Ad (IsEmailAddressApprovedByO365Ad) | Boolean | ExternalName: isemailaddressapprovedbyo365admin ExternalType: Boolean ExternalAccess: Read
|
|
| 118 | TraversedPath (TraversedPath) | Text250 | ExternalName: traversedpath ExternalType: String
|
|
| 119 | SharePointEmailAddress (SharePointEmailAddress) | Text250 | ExternalName: sharepointemailaddress ExternalType: String
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | SystemUserId (SystemUserId) | Clustered: Yes | |
| 1 | FullName (FullName) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| BusinessUnitId (BusinessUnitId) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
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 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Account Statistics | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Businessunit | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Contact | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Contract | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Customeraddress | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Discount | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Discounttype | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Incident | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Incidentresolution | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Invoice | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Invoicedetail | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM NAV Connection | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Opportunity | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Organization | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Post | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Pricelevel | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Product | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Productpricelevel | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Quote | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Quotedetail | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Salesorder | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Salesorderdetail | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Systemuser | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Team | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Transactioncurrency | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Uom | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |
| CRM Uomschedule | ModifiedOnBehalfBy (ModifiedOnBehalfBy) |
|
1..n |