Salesforce Tables
The Salesforce integration includes the following tables
Tables
SalesForceAccounts
Represents an individual account, which is an organization or person involved with your business (such as customers, competitors, and partners).
| Name | Type | Description |
|---|---|---|
| AccountNumber | string | Account number assigned to this account. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedById | string | The ID of the user who created the account. |
| CreatedDate | datetime2 | The date and time when the account was created. |
| Description | string | Text description of the account. |
| Fax | string | Fax number for the account. |
| ID | string | Unique identifier for the account. |
| Industry | string | An industry associated with this account. For example, Biotechnology. |
| IsPriorityRecord | boolean | Shows whether the user has marked the account as important (True) or not (False). |
| LastActivityDate | datetime2 | Value is one of the following, whichever is the most recent: Due date of the most recent event logged against the record or Due date of the most recently closed task associated with the record |
| LastModifiedById | string | The ID of the user who last modified the account. |
| LastModifiedDate | datetime2 | The date and time when the account was last updated. |
| LastReferencedDate | datetime2 | The timestamp when the current user last accessed this record indirectly, for example, through a list view or related record. |
| Name | string | Name of the account. |
| OwnerId | string | The ID of the user who currently owns this account. |
| OwnerName | string | The name of the user who currently owns this account. |
| Ownership | string | Ownership type for the account, for example Private, Public, or Subsidiary. |
| Phone | string | Phone number for this account. |
| Type | string | Type of account, for example, Customer, Competitor, or Partner. |
SalesForceAssets
Represents an item of commercial value, such as a product sold by your company or a competitor, that a customer has purchased.
| Name | Type | Description |
|---|---|---|
| AccountId | string | ID of the Account associated with this asset. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedById | string | The ID of the user who created this asset. |
| CreatedDate | datetime2 | The date and time when the asset was created. |
| Description | string | Description of the asset. |
| ID | string | Unique identifier for the asset. |
| InstallDate | datetime2 | Date when the asset was installed. |
| IsCompetitorProduct | boolean | Indicates whether this Asset represents a product sold by a competitor (true) or not (false). |
| LastModifiedById | string | The ID of the user who last modified the asset. |
| LastModifiedDate | datetime2 | The date and time when the account was last updated. |
| Name | string | Name of the asset |
| Price | decimal | Price paid for this asset. |
| PurchaseDate | datetime2 | Date on which this asset was purchased. |
| Quantity | integer | Quantity purchased or installed. |
| SerialNumber | string | Serial number for this asset. |
| Status | string | Customizable picklist of values. The default picklist includes the following values: Purchased, Shipped, Installed, Registered, Obsolete |
SalesForceContacts
Represents a contact, which is a person associated with an account.
| Name | Type | Description |
|---|---|---|
| AccountId | string | ID of the account that’s the parent of this contact. |
| AssistantName | string | The assistant’s name. |
| AssistantPhone | string | The assistant’s phone number. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| Birthdate | datetime2 | The contact’s birthdate. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ContactSource | string | If Automatic Contact Creation is enabled, this field indicates whether the contact was created automatically. A possible value is: Auto Create |
| CreatedById | string | The ID of the user who created the contact. |
| CreatedDate | datetime2 | The date and time when the contact was created. |
| Department | string | The contact’s department. |
| DepartmentGroup | string | If Automatic Contact Enhancements or Buyer Relationship Map is enabled, this field contains the business unit, function, or department that the contact belongs to in the organization. Possible values are: chiefExecutive, customerSuccess, finance, humanResources, legal, marketing, other, sales, support, tech. |
| Description | string | A description of the contact. |
| string | The contact’s email address. | |
| Fax | string | The contact’s fax number. |
| FirstName | string | The contact’s first name. |
| HomePhone | string | The contact’s home phone number. |
| ID | string | Unique identifier for the contract. |
| IsDeleted | boolean | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| LastModifiedById | string | The ID of the user who last modified the contact. |
| LastModifiedDate | datetime2 | The date and time when the contact was last updated. |
| LastName | string | Last name of the contact. |
| LeadSource | string | The source of the lead that was converted to this contact. |
| MobilePhone | string | Contact’s mobile phone number. |
| Name | string | Concatenation of FirstName, MiddleName, LastName, and Suffix. |
| Phone | string | Phone number for the contact. |
| Title | string | Title of the contact, such as CEO or Vice President. |
| TitleType | string | If Automatic Contact Enhancements or Buyer Relationship Map is enabled, this field contains the hierarchical position that the contact holds in the organization. In the UI, this field is shown as Seniority Level. Possible values are: ceo, directorOrManager, executive, individual contributor, vp |
SalesForceContracts
Represents a contract (a business agreement) associated with an Account.
| Name | Type | Description |
|---|---|---|
| AccountId | string | ID of the Account associated with this contract. |
| ActivatedById | string | ID of the User who activated this contract. |
| ActivatedDate | datetime2 | Date and time when this contract was activated. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| CompanySignedDate | datetime2 | The date your organization signed the contract. |
| CompanySignedId | string | ID of the user who signed the contract. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ContractNumber | string | Number of the contract. |
| ContractTerm | integer | Number of months that the contract is valid. |
| CreatedById | string | The ID of the user who created the contract. |
| CreatedDate | datetime2 | The date and time when the contract was created. |
| CustomerSignedDate | datetime2 | The date when the customer signed the contract. |
| CustomerSignedId | string | ID of the Contact who signed this contract. |
| CustomerSignedTitle | string | Title of the customer who signed the contract. |
| Description | string | Description of the contract. |
| EndDate | datetime2 | Calculated end date of the contract. |
| ID | string | Unique identifier for the contract. |
| IsDeleted | boolean | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| LastApprovedDate | datetime2 | Last date the contract was approved. |
| LastModifiedById | string | The ID of the user who last modified the contract. |
| LastModifiedDate | datetime2 | The date and time when the contract was last updated. |
| OwnerExpirationNotice | string | Number of days ahead of the contract end date. |
| OwnerId | string | ID of the user who owns the contract. |
| SpecialTerms | string | Special terms that apply to the contract. |
| StartDate | datetime2 | Start date for this contract. |
| Status | string | The picklist of values that indicate order status. Each value is within one of two status categories defined in StatusCode. For example, the status picklist may contain: Ready to Ship, Shipped, Received as values within the Activated StatusCode. |
| StatusCode | string | The status category for the contract. A contract can be Draft, InApproval, or Activated. |
SalesForceGroups
A set of User records. Groups are sets of users. They can contain individual users, other groups, the users in a particular role or territory, or the users in a particular role or territory plus all the users below that role or territory in the hierarchy.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedByID | string | The ID of the user who created the contract. |
| CreatedDate | datetime2 | The date and time when the contract was created. |
| DeveloperName | string | The name of the object in the API. |
| DoesIncludeBosses | boolean | Indicates whether records shared with users in this group are also shared with users higher in the role hierarchy (true) or not (false). |
| DoesSendEmailToMembers | boolean | Indicates whether the email is sent (true) or not sent (false) to the group members. |
| string | Email address for a group of type Case | |
| ID | string | Unique identifier for the group. |
| LastModifiedByID | string | The ID of the user who last modified the group. |
| LastModifiedDate | datetime2 | The date and time when the group was last updated. |
| Name | string | Name of the group. |
| Owner | string | Name of the Owner. |
| OwnerID | string | ID of the user who owns the group. |
| RelatedID | string | Represents the ID of the associated groups. For groups of type “Role,” the ID of the associated UserRole. |
| Type | string | Type of the group. One of the following values: AllCustomerPortal, ChannelProgramGroup, CollaborationGroup, Manager, ManagerAndSubordinatesInternal, Organization, Participant, PRMOrganization, Queue, Regular, Role, RoleAndSubordinates, RoleAndSubordinatesInternal, Territory, TerritoryAndSubordinates. |
SalesForceLead
Represents a prospect or lead.
| Name | Type | Description |
|---|---|---|
| AnnualRevenue | decimal | Annual revenue for the lead’s company. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| City | string | City for the lead’s address. |
| Company | string | The lead’s company. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| Country | string | The lead’s country. |
| CreatedById | string | The ID of the user who created the lead. |
| CreatedDate | datetime2 | The date and time when the lead was created. |
| Description | string | The lead’s description. |
| string | The lead’s email address. | |
| Fax | string | If bounce management is activated and an email sent to the lead bounced, the date and time of the bounce. |
| FirstName | string | The lead’s first name. |
| ID | string | Unique identifier for the lead. |
| Industry | string | Industry in which the lead works. |
| IsDeleted | boolean | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| IsUnreadByOwner | boolean | If true, lead has been assigned, but not yet viewed. |
| LastModifiedById | string | The ID of the user who last modified the lead. |
| LastModifiedDate | datetime2 | The date and time when the lead was last updated. |
| LastName | string | Last name of the lead. |
| LeadSource | string | The origin or source of the lead. |
| MasterRecordId | string | If this record was deleted as the result of a merge, this field contains the ID of the record that was kept. If this record was deleted for any other reason, or hasn’t been deleted, the value is null. |
| MobilePhone | string | The lead’s mobile phone number. |
| Name | string | Concatenation of FirstName, MiddleName, LastName, and Suffix |
| NumberOfEmployees | integer | Number of employees at the lead’s company. |
| OwnerId | string | ID of the lead’s owner. |
| Phone | string | The lead’s phone number. |
| PostalCode | string | Postal code for the address of the lead. |
| Salutation | string | Salutation for the lead. |
| State | string | State for the address of the lead. |
| Status | string | The ISO state code for the lead’s address. |
| Street | string | Street number and name for the address of the lead. |
| Title | string | Title for the lead, such as CFO or CEO. |
| Website | string | Website for the lead. |
SalesForceLoginHistory
Represents the login history for all successful and failed login attempts for organizations and enabled portals.
| Name | Type | Description |
|---|---|---|
| Application | string | The application used to access the organization |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ID | string | Unique identifier for the login history. |
| LoginTime | datetime2 | Time zone is based on GMT. |
| SalesForceUserConfigID | integer | The ID of the configuration within Compyl. |
| SalesForceUserID | string | The ID of the user associated with this login history. |
| Status | string | Displays the status of the attempted login. Status is either success or a reason for failure |
| UserID | string | The ID of the user associated with this login history. |
SalesForceOpportunities
Represents an opportunity, which is a sale or pending deal.
| Name | Type | Description |
|---|---|---|
| AccountId | string | ID of the account associated with this opportunity. |
| Amount | float | Estimated total sale amount. For opportunities with products, the amount is the sum of the related products. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| CloseDate | datetime2 | Date when the opportunity is expected to close. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedById | string | The ID of the user who created the opportunity. |
| CreatedDate | datetime2 | The date and time when the opportunity was created. |
| Description | string | Text description of the opportunity. |
| Fiscal | string | If fiscal years are not enabled, the name of the fiscal quarter or period in which the opportunity CloseDate falls. |
| FiscalQuarter | integer | Represents the fiscal quarter. Valid values are 1, 2, 3, or 4. |
| FiscalYear | integer | Represents the fiscal year, for example`, 2006. |
| ForecastCategory | string | Represents the forecast classification of the opportunity. The value is automatically determined by the ForecastCategoryName field but can be manually overridden. Used for tracking and predicting sales revenue. Possible values are: BestCase, Closed, Forecast, MostLikely, Omitted, Pipeline. |
| ForecastCategoryName | string | Represents the name of the forecast category for the opportunity. Possible values are: Best Case, Closed, Commit, Most Likely, Omitted, Pipeline. |
| HasOpenActivity | boolean | Indicates whether an opportunity has an open event or task (true) or not (false). |
| HasOpportunityLineItem | boolean | Field that indicates whether the opportunity has associated line items. A value of true means that Opportunity line items have been created for the opportunity. |
| HasOverdueTask | boolean | Indicates whether an opportunity has an overdue task (true) or not (false). |
| ID | string | Unique identifier for the opportunity. |
| IsClosed | boolean | Directly controlled by StageName. You can query and filter on this field, but you can’t directly set it in a create, upsert, or update request. It can only be set via StageName. |
| IsDeleted | boolean | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| IsWon | boolean | Directly controlled by StageName. You can query and filter on this field, but you can’t directly set the value. It can only be set via StageName. |
| LastModifiedById | string | The ID of the user who last modified the opportunity. |
| LastModifiedDate | datetime2 | The date and time when the opportunity was last updated. |
| LeadSource | string | Source of this opportunity, such as Advertisement or Trade Show. |
| Name | string | Required. A name for this opportunity. |
| NextStep | string | Description of next task in closing opportunity. |
| OwnerId | string | ID of the User who has been assigned to work this opportunity |
| Probability | float | Percentage of estimated confidence in closing the opportunity. |
| StageName | string | Current stage of this record. The StageName field controls several other fields on an opportunity |
| Type | string | Type of opportunity. For example, Existing Business or New Business. |
SalesForceOpportunityContacts
Represents the role that a Contact plays on an Opportunity.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ContactId | string | ID of an associated Contact. |
| CreatedById | string | The ID of the user who created the opportunity contact. |
| CreatedDate | datetime2 | The date and time when the opportunity contact was created. |
| ID | string | Unique identifier for the opportunity contact. |
| IsDeleted | boolean | Indicates whether the record has been moved to the Recycle Bin (true) or not (false). |
| IsPrimary | boolean | Indicates whether the associated Contact plays the primary role on the Opportunity (true) or not (false). |
| LastModifiedById | string | The ID of the user who last modified the opportunity contact. |
| LastModifiedDate | datetime2 | The date and time when the opportunity contact was last updated. |
| OpportunityId | string | ID of an associated Opportunity. |
| Role | string | Name of the role played by the associated Contact on the Opportunity, such as Business User or Decision Maker. |
SalesForceOrders
Represents an order associated with a contract or an account.
| Name | Type | Description |
|---|---|---|
| AdjustedMerchandizeTotalTax | float | The adjusted total merchandise tax for the order. |
| AdjustedShippingTotalTax | float | The adjusted total shipping tax for the order. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ConfirmationStatus | string | The status indicating whether the order has been confirmed. |
| CreatedBy | string | The ID of the user who created the order. |
| CreationDate | datetime2 | The date and time when the order was created. |
| Currency | string | The currency used for the order. |
| CustomerLocale | string | The locale of the customer who placed the order. |
| ExportStatus | string | The status indicating whether the order has been exported. |
| ID | string | Unique identifier for the order. |
| InvoiceNo | string | The invoice number associated with the order. |
| LastModified | datetime2 | The date and time when the order was last modified. |
| MerchandizeTotalTax | float | The total merchandise tax before any adjustments. |
| OrderTotal | float | The total cost of the order, including taxes and shipping. |
| PaymentStatus | string | The status of the payment for the order. |
| PlaceDate | datetime2 | The date and time when the order was placed. |
| ProductSubTotal | integer | The subtotal cost of products in the order before taxes and discounts. |
| ProductTotal | integer | The total cost of products in the order, after any applicable adjustments. |
| RemoteHost | string | The host or IP address from which the order was placed. |
| ShippingStatus | string | The status of the shipping process for the order. |
| ShippingTotal | float | The total cost of shipping for the order. |
| ShippingTotalTax | float | The total tax applied to shipping costs. |
| SiteId | string | The identifier of the site where the order was placed. |
| Status | string | The overall status of the order (e.g., completed, canceled, pending). |
| Taxation | string | The type or method of taxation applied to the order. |
| TaxTotal | float | Roll up of all tax on the order. Includes delivery taxes, price adjustment taxes, and product taxes. |
SalesForcePermissionSetAssignments
Represents a user’s assignment to a permission set or permission set group. This object is available in API version 22.0 and later.
| Name | Type | Description |
|---|---|---|
| AssigneeID | string | The ID of the user that is assigned the permission set indicated in PermissionSetId or the permission set group indicated in PermissionSetGroupId. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ExpirationDate | datetime2 | The date that the assignment of the permission set or permission set group expires for the specified user. |
| ID | string | Unique identifier for the permission set assignment. |
| IsActive | boolean | Indicates whether the assignment is active (true) or not (false) |
| PermissionSetGroupID | string | The ID of the permission set group assigned to the user specified in AssigneeId. |
| PermissionSetID | string | The ID of the permission set assigned to the user specified in AssigneeId. |
SalesForcePermissionSets
Represents a set of permissions that’s used to grant more access to one or more users without changing their profile or reassigning profiles.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedByID | string | The ID of the user who created the permission set. |
| CreatedDate | datetime2 | The date and time when the permission set was created. |
| Description | string | A description of the permission set. |
| HasActivationRequired | boolean | Indicates whether the permission set requires an associated active session (true) or not (false). |
| ID | string | Unique identifier for the permission set. |
| IsCustom | boolean | If true, the permission set is custom (created by an admin); if false, the permission set is standard and related to a specific permission set license. |
| Label | string | The permission set label |
| LastModifiedByID | string | The ID of the user who last modified the permission set. |
| LastModifiedDate | datetime2 | The date and time when the permission set was last updated. |
| Name | string | The unique name of the object in the API. This name can contain only underscores and alphanumeric characters, and must be unique in your organization. |
| Type | string | The type of the permission set. |
SalesForceProducts
This object has several fields that are used only for quantity and revenue schedules (for example, annuities).
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedById | string | The ID of the user who created the product. |
| CreatedDate | datetime2 | The date and time when the product was created. |
| Description | string | A text description of this record. |
| DisplayUrl | string | URL leading to a specific version of a record in the linked external data source. |
| Family | string | Name of the product family associated with this record. |
| ID | string | Unique identifier for the product. |
| IsActive | boolean | Indicates whether this record is active (true) or not (false). |
| IsArchived | boolean | Describes whether the product is archived. |
| IsDeleted | boolean | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| LastModifiedById | string | The ID of the user who last modified the product. |
| LastModifiedDate | datetime2 | The date and time when the product was last updated. |
| ProductCode | string | Default product code for this record. |
SalesForceProfiles
Represents a profile, which defines a set of permissions to perform different operations.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedByID | string | The ID of the user who created the profile. |
| CreatedDate | datetime2 | The date and time when the profile was created. |
| Description | string | Description of the profile. |
| ID | string | Unique identifier for the profile. |
| LastModifiedByID | string | The ID of the user who last modified the profile. |
| LastModifiedDate | datetime2 | The date and time when the profile was last updated. |
| Name | string | The name of the profile. |
| UserType | string | The category of user license. Valid values includes: Standard, PowerPartner, CspLitePortal, CustomerSuccess, PowerCustomerSuccess, CsnOnly, Guest. |
SalesForceSetupAuditTrails
Represents changes you or other admins made in your org’s Setup area for at least the last 180 days.
| Name | Type | Description |
|---|---|---|
| Action | string | The category of the change made in Setup. For example, a value of PermSetCreate indicates that an administrator created a permission set. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedByID | string | The ID of the user who created the setup audit trail. |
| CreatedDate | datetime2 | The date and time when the setup audit trail was created. |
| Display | string | The full description of changes made in Setup. For example, if the Action field has a value of PermSetCreate, the Display field has a value like “Created permission set MAD: with user license Salesforce.” |
| ID | string | Unique identifier for the setup audit trail. |
| Section | string | The section in the Setup menu where the action occurred. For example, Manage Users or Company Profile. |
SalesForceUserDeviceApplications
Represents information on applications installed on a device that is accessing Salesforce.
| Name | Type | Description |
|---|---|---|
| ApplicationType | string | The type of application used to log in to Salesforce. |
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| ID | string | Unique identifier for the user device application. |
| Name | string | This field is system-generated and cannot be changed. |
| Status | string | The activity status of the device application. Valid values are: Approved, Pending Approval, Revoked. |
| UserDeviceID | string | The unique identifier used to identify a device when tracking events. |
| UserID | string | The ID of the user. |
SalesForceUserDeviceHistorys
Represents tracking information on the UserDevice sObject.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| DataType | string | The type of data that has changed. Possible values include Address, AnyType, AutoNumber, Base64, BitVector, Boolean, Content, Currency, DataCategoryGroupReference, DateOnly, DateTime, Division, Double, DynamicEnum, Email, EncryptedBase64, EncryptedText, EntityId, EnumOrId, ExternalId, Fax, File, HtmlMultiLineText, HtmlStringPlusClob, InetAddress, Json, Location, MultiEnum, MultiLineText, Namespace, Percent, PersonName, Phone, Raw, RecordType, SfdcEncryptedText, SimpleNamespace, StringPlusClob, Switchable_PersonName, Text, TimeOnly, Url, and YearQuarter. |
| Field | string | The field that has changed. Possible values include BrowserType (Browser), DeviceNativeUid (Device Native ID), DeviceType (Device Type), HashedBrowserFingerPrint (Hashed Browser Fingerprint), IsVerified (Is Device Verified), LastLoginHistory (Login History), Name, PlatformType (Platform or OS Type), PlatformVersion (Platform or OS Version), RawBrowserFingerPrint (Raw Browser Fingerprint Data), Status (Device Status), User, UserLastSeen (Last time user was seen), UserProvidedDeviceIdentifier (User provided device identifier), created (Created), feedEvent (Feed event), individualMerged (Individual Merged), locked (Record locked), ownerAccepted (Owner Accepted), ownerAssignment (Owner Assignment), and unlocked (Record unlocked). |
| ID | string | Unique identifier for the user device history. |
| NewValue | string | The value after a change has occurred. |
| OldValue | string | The value before a change has occurred. |
| UserDeviceID | string | The ID of the UserDevice object. |
SalesForceUserDevices
Represents information unique to a device.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| BrowserType | string | The browser used for login. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| DeviceNativeUID | string | A unique string used to identify a mobile device. |
| DeviceType | string | The device used to log in to Salesforce, with picklist options including Desktop, Tablet, iPad, iPhone, Phone, and Unknown. |
| ID | string | Unique identifier for the user device. |
| IsVerified | bit | Reserved for future use. |
| LastLoginHistoryID | string | The most recent LoginHistory associated with the device. |
| Name | string | Name of the user device. |
| PlatformType | string | The operating system of the device, with picklist options including iOS, Android, OSX, Linux, Phone, Windows, AppleApp, Blackberry, and Other. |
| PlatformVersion | string | The version of the operating system running on the device. |
| SalesForceUserConfigID | integer | The ID of the configuration within Compyl. |
| SalesForceUserID | string | The ID of the user. |
| Status | string | The activity status of the device, with picklist options including Approved, Pending Approval, and Revoked. |
| UserID | string | The ID of the user. |
| UserLastSeen | datetime2 | The date and time of the user’s last access. |
| UserProvidedDeviceIdentifier | string | An identifier for the user’s device such as the International Mobile Equipment Identity (IMEI) number or the device serial number. |
SalesForceUsers
Represents a user in your organization.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime2 | The date and time data was synced to our database. |
| CompanyName | string | The name of the user’s company. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| CreatedByID | string | The ID of the user who created the user. |
| CreatedDate | datetime2 | The date and time when the user was created. |
| Fax | string | The user’s fax number. |
| ID | string | Unique identifier for the user. |
| IsActive | bit | Indicates whether the user has access to log in (true) or not (false). |
| LastModifiedByID | string | The ID of the user who last modified the user. |
| LastModifiedDate | datetime2 | The date and time when the user was last updated. |
| Manager | string | User lookup field used to select the user's manager. |
| ManagerID | string | The Id of the user who manages this user. |
| Name | string | Concatenation of FirstName and LastName. |
| Phone | string | The user’s phone number. |
| ProfileID | string | ID of the user’s Profile. |
| SalesForceProfileConfigID | integer | The ID of the configuration within Compyl. |
| Username | string | Contains the name that a user enters to log in to the API or the user interface. The value for this field is in the form of an email address |
| UserRole | string | Name of the user’s UserRole |
Updated over 1 year ago