Retail organization data model tables

  • Release version: Australia
  • Updated March 12, 2026
  • 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.

    The Retail organization [sn_retail_organization] table has a one-to-one relationship with the Organization Core [sn_customer_service_organization] table.

    Organization Core [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.
    Organization Core The associated organization core.
    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.

    The Retail case [sn_retail_case] table extends the Customer Service Management case table. All functionality used through the Customer Service Management case remains intact.

    The Retail case [sn_retail_case] table can be extended to 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.