AI Data Catalog / CustAssignToSellerView
supervisor_account

CustAssignToSellerView

AI-ready relationship view that maps customers to one or more assigned sales representatives.
assignment salesforce customers territory
Purpose

This view defines the relationship between customers and sales representatives (visitors). It supports collaborative selling scenarios where multiple visitors can simultaneously serve the same customer.

Business Rules
  • Each row represents one customer-to-visitor assignment.
  • A customer may be assigned to multiple visitors simultaneously.
  • A visitor may manage multiple customers.
  • This view represents an active many-to-many relationship.
  • The view stores assignment relationships only and does not include descriptive information.
Relationships

This view serves as a core mapping layer between customers and sales representatives and is used as a reference dimension in multiple operational and analytical views.

Related View Join Key Description
SellerVisitPathCustomersView SellerID, CustID Aligns assigned customers with planned visit routes to validate whether assigned customers are included in daily visit planning.
CustomerVisitLogsView SellerID, CustID Evaluates actual visit execution against assigned customer ownership to measure salesperson activity effectiveness.
OrderFinancialSummaryView SellerID, CustID Links customer-salesperson assignment to financial performance, revenue generation and receivable analysis.
OrderCollectionAnalyticsView CustID Analyzes customer payment behavior based on assigned salesperson and helps evaluate collection performance per sales territory.
CustomerPotentialAnalyticsView CustID Connects customer assignment with behavioral scoring, segmentation and AI-based customer potential estimation.
OrderReturnSummaryView CustID, SellerID Analyzes return patterns per assigned salesperson and customer relationship, helping detect product or service issues at territory level.
DeliveryOperationAnalyticsView SellerID Associates assigned sales representatives with logistics execution and delivery performance metrics.
OrderFinancialSummaryView SellerID, CustID Provides enhanced financial aggregation aligned with customer assignment for AI-driven revenue and performance modeling.
Primary Join Keys
  • SellerID → Salesperson / Visitor dimension
  • CustID → Customer dimension
  • Composite (SellerID + CustID) → Assignment relationship
Fields
Field Type Description
SellerID int Unique identifier of the assigned visitor / salesperson.
CustID int Unique identifier of the assigned customer.
Usage
  • Sales territory analysis
  • Customer coverage reporting
  • Collaborative sales management
  • AI-driven assignment recommendations
  • Customer ownership analysis
  • Visitor workload balancing
Example Query
SELECT
    a.SellerID,
    v.VisitorName,
    a.CustID,
    c.CustTitle
FROM CustAssignToSeller a
INNER JOIN tblVisitorDesc v
    ON a.SellerID = v.VisitorID
INNER JOIN tblCustomers c
    ON a.CustID = c.CustID;
Important Notes
warning
Assignment Logic Note

This view supports concurrent assignments. The same customer can be associated with multiple visitors at the same time. Reports and AI models must consider this many-to-many structure to avoid duplicate counting.