Retail Core data model tables

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • Tables configured within the Retail Operations application enable you to determine the data model, tasks, and product offerings for your Retail Operations workflows.

    Retail Organization table

    The Retail organization [sn_retail_organization] table stores information about your retail organizations.

    This has a one-to-one relationship with the Service Organization [sn_customer_service_organization] table.

    Service Organization [sn_customer_service_organization] has an attribute of Retail Organization.

    Retail-specific attributes should be maintained in this table.

    Field Description
    Ownership The ownership type of this retail organization. Options are:
    • Company owned
    • Franchise
    Brand The associated brand of this retail organization.
    Service Organization The associated service organization.
    Retail Subtype The retail subtype. Options are:
    • Store
    • Region
    • Division
    • Area
    • District
    Flagship Indicates whether this is considered a flagship retail organization location.

    Retail case table

    The Retail case [sn_retail_case] table stores information about your retail case types and provides the basis for retail case creation.

    This table extends the Customer Service Management case table. All functionality utilized through the Customer Service Management case remains intact.

    This table can be extended to further expand the flow and logic for retail use cases.

    Field Description
    Number Numerical code indicating the case number for this request.
    Requested by Internal user associated with this request.
    Requesting Retail Organization Retail organization this request is being created for.
    Supporting Retail Organization Retail organization responsible for fulfilling this request.
    Short description A short description of this request's purpose.
    Description A detailed description of this request's purpose.
    Opened Date and time at which this request was opened.
    Priority Sequence in which this case must be resolved, based on impact and urgency.
    Assignment Group The associated assignment group responsible for working on this request.
    Assigned to Person primarily responsible for working on this request.