Store dimension (mandatory)
Overview:
- Can be a physical store or an online shop.
- The primary key is the
store_id
.
Fields list
Field name | Type | Kind | Definition | Value example |
---|---|---|---|---|
store_id | String | Mandatory | The store identifier. | 457 |
name | String | Mandatory | The store name, as it is displayed in Splio solutions. | Superstore Paris |
type | String | Mandatory | Value web|store | store |
is_closed | Boolean | Mandatory | A flag indicating whether the store is closed or not | 1 |
closed_date | Date | Optional | The date the store was closed | 2022-11-15 |
city | String | Optional | The city of the store's location | Paris |
country | String | Optional | The country of the store's location | France |
coordinates | String | Optional | The coordinates for the store, in decimal degrees (DD) | 48.871152, 2.335402 |
url | String | Optional | The URL for the store's information page (on the e-commerce website or Google Mybusiness) | |
{custom attribute} | Any type | Optional | Any store-related attribute of interest to making it available in Splio solutions. | |
inserted_at | Datetime | Mandatory | The datetime of the record creation in the source information system | 2022-02-29T18:34:26+01:00 |
updated_at | Datetime | Mandatory | The datetime of the record last update in the source information system | 2022-08-15T06:34:26+01:00 |
Updated 2 months ago