Visit DMO

Object API Name: ssot__Visit__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• VisitorRecordId has a FOREIGNKEY relationship with the Work Resource DMO Id field.
• VisitorRecordId has a FOREIGNKEY relationship with the User DMO Id field.
• PlaceRecordId has a FOREIGNKEY relationship with the Retail Store DMO Id field.
• PlaceRecordId has a FOREIGNKEY relationship with the Location DMO Id field.
• PlaceRecordId has a FOREIGNKEY relationship with the Address DMO Id field.
• DurationUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• RelatedVisitId has a FOREIGNKEY relationship with the Visit DMO Id field.
• OwnerId has a FOREIGNKEY relationship with the User DMO Id field.
• OwnerId has a FOREIGNKEY relationship with the User Group DMO Id field.
• SourceContextRecordId has a FOREIGNKEY relationship with the Application DMO Id field.

• AccountId
• ActualVisitEndTime
• ActualVisitLatitude
• ActualVisitLongitude
• ActualVisitStartTime
• BusinessUnitId
• cdp_sys_record_currency
• CompletionDate
• CreatedDate
• DataSourceId
• DataSourceObjectId
• DistributionIssueCount
• DurationNumber
• DurationUOMId
• HasDistributionIssues
• HasOutOfStockIssue
• Id
• InternalOrganizationId
• IsAllDayVisit
• KQ_AccountId
• KQ_DurationUOMId
• KQ_Id
• KQ_OwnerId
• KQ_PlaceRecordId
• KQ_RelatedVisitId
• KQ_VisitorRecordId
• Name
• OutOfStockIssueCount
• OutOfStockRateFocusArea
• OwnerId
• OwnerObject
• PerfectStoreIndexScoreNumber
• PerfectStoreQuotientNumber
• PlaceRecordId
• PlaceRecordObject
• PlannedVisitDate
• PlannedVisitEndTime
• PlannedVisitStartTime
• Priority
• ProductDistributionRate
• ProductDistributionRateFocusArea
• Purpose
• RelatedVisitId
• SourceContextObject
• SourceContextRecordId
• Status
• StatusReasonText
• VisitNoteText
• VisitorRecordId
• VisitorRecordObject
• VisitTypeRecordId
• VisitTypeRecordObject

• Field API Name: ssot__AccountId__c
• Data Type: TEXT
• Description: The ID of the account that’s associated with a visit.

• Field API Name: ssot__ActualVisitEndTime__c
• Data Type: DATETIME
• Description: The actual date time of visit end.

• Field API Name: ssot__ActualVisitLatitude__c
• Data Type: DOUBLE
• Description: The actual visit geo location latitude.

• Field API Name: ssot__ActualVisitLongitude__c
• Data Type: DOUBLE
• Description: The actual visit geo location longitude.

• Field API Name: ssot__ActualVisitStartTime__c
• Data Type: DATETIME
• Description: The actual date time of visit start.

• Field API Name: ssot__BusinessUnitId__c
• Data Type: TEXT
• Description: The logical Internal Organization to which promotion offer record belongs.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__CompletionDate__c
• Data Type: DATEONLY
• Description: The completion date of visit.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DistributionIssueCount__c
• Data Type: DOUBLE
• Description: The count of distribution issues identified during visit.

• Field API Name: ssot__DurationNumber__c
• Data Type: DOUBLE
• Description: The duration of visit.

• Field API Name: ssot__DurationUOMId__c
• Data Type: TEXT
• Description: The unit of measure for duration of visit.

• Field API Name: ssot__HasDistributionIssues__c
• Data Type: BOOLEAN
• Description: Whether this service process was marked as a favorite for the org.

• Field API Name: ssot__HasOutOfStockIssue__c
• Data Type: BOOLEAN
• Description: Whether for particular visit to store/location/address has product out of stock issues or not.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this Visit record. Maximum size is 36 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__IsAllDayVisit__c
• Data Type: BOOLEAN
• Description: Represent if visit is all day event or not.

• Field API Name: KQ_AccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountId

• Field API Name: KQ_DurationUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DurationUOMId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_OwnerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OwnerId

• Field API Name: KQ_PlaceRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PlaceRecordId

• Field API Name: KQ_RelatedVisitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RelatedVisitId

• Field API Name: KQ_VisitorRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for VisitorRecordId

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The primary name or label for this Visit record. Maximum size is 255 characters.

• Field API Name: ssot__OutOfStockIssueCount__c
• Data Type: DOUBLE
• Description: The count of out of stock issues.

• Field API Name: ssot__OutOfStockRateFocusArea__c
• Data Type: TEXT
• Description: The focus area of out of stock rate of all surveyed products for given visit.

• Field API Name: ssot__OwnerId__c
• Data Type: TEXT
• Description: The Visit’s owner.

• Field API Name: ssot__OwnerObject__c
• Data Type: TEXT
• Description: Indicates the Owner object name. For example, User, UserGroup.

• Field API Name: ssot__PerfectStoreIndexScoreNumber__c
• Data Type: DOUBLE
• Description: The perfect store index score value for given visit.

• Field API Name: ssot__PerfectStoreQuotientNumber__c
• Data Type: DOUBLE
• Description: The perfect store quotient score value for given visit.

• Field API Name: ssot__PlaceRecordId__c
• Data Type: TEXT
• Description: The reference record of Place at which Visit is performed.

• Field API Name: ssot__PlaceRecordObject__c
• Data Type: TEXT
• Description: The domain object name of the place record belong to.

• Field API Name: ssot__PlannedVisitDate__c
• Data Type: DATETIME
• Description: The planned date for visit.

• Field API Name: ssot__PlannedVisitEndTime__c
• Data Type: DATETIME
• Description: Date and time when the visit is expected to end.

• Field API Name: ssot__PlannedVisitStartTime__c
• Data Type: DATETIME
• Description: Date and time when the visit is expected to start.

• Field API Name: ssot__Priority__c
• Data Type: TEXT
• Description: Represent the priority of visit. Valid values are: - High - Low - Medium.

• Field API Name: ssot__ProductDistributionRate__c
• Data Type: DOUBLE
• Description: The distribution rate of all survey products for given visit.

• Field API Name: ssot__ProductDistributionRateFocusArea__c
• Data Type: TEXT
• Description: The focus of distribution rate of all survey products for given visit. For example, Market Penetration, Sales Peformance.

• Field API Name: ssot__Purpose__c
• Data Type: TEXT
• Description: The purpose of the visit.

• Field API Name: ssot__RelatedVisitId__c
• Data Type: TEXT
• Description: The parent/related visit associated with.

• Field API Name: ssot__SourceContextObject__c
• Data Type: TEXT
• Description: The object name of the source context record id.

• Field API Name: ssot__SourceContextRecordId__c
• Data Type: TEXT
• Description: The source context of the visit. For example, Claim, Case.

• Field API Name: ssot__Status__c
• Data Type: TEXT
• Description: The status of the visit. Valid values are: - Abondoned - Completed - InProgress - Planned.

• Field API Name: ssot__StatusReasonText__c
• Data Type: TEXT
• Description: The reason/remarks for the status of the visit.

• Field API Name: ssot__VisitNoteText__c
• Data Type: TEXT
• Description: Notes to be captured by sales rep during visit execution. For example, Store manager mentioned high demand for Product B but insufficient stock; Customer feedback on Product C packaging improvement.

• Field API Name: ssot__VisitorRecordId__c
• Data Type: TEXT
• Description: The reference record of the visitor object who is performing the visit.

• Field API Name: ssot__VisitorRecordObject__c
• Data Type: TEXT
• Description: The domain object name of the visitor record who is performing the visit.

• Field API Name: ssot__VisitTypeRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__VisitTypeRecordObject__c
• Data Type: TEXT
• Description: Alphanumeric string representing the visit type record object.