Retail organization data model tables
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. |
Parent Topic:Retail organization data model