Planogram Schema
- File Name:
planogram.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains planogram master data including product facing configurations, shelf layouts, and replenishment models for assets.
Fields
📋 Includes Common Fields: Client Information, Audit Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PlanogramId | int | NOT NULL | Unique identifier for the planogram |
| PlanogramName | nvarchar(500) | NOT NULL | Name of the planogram |
| ExternalPlanogramCode | nvarchar(250) | NULL | External system planogram code |
| Shelves | tinyint | NOT NULL | Number of shelves |
| Facings | tinyint | NOT NULL | Total number of facings |
| FacingsDistinct | tinyint | NOT NULL | Number of distinct facings |
| FacingDetails | varchar(max) | NOT NULL | Detailed facing information (JSON structure) |
| StartDate | datetime | NULL | Planogram start date |
| IsCategory | bit | NOT NULL | Category planogram flag |
| IsActive | bit | NOT NULL | Active status flag |
| IsDeleted | tinyint | NOT NULL | Soft delete flag |
| IsUseStockPercentage | bit | NOT NULL | Flag to use stock percentage |
| AssetTypeId | int | NOT NULL | Asset type identifier |
| AssetType | nvarchar(50) | NOT NULL | Asset type name |
| CabinetHeight | decimal(9,3) | NOT NULL | Height of the cabinet |
| CabinetWidth | decimal(9,3) | NOT NULL | Width of the cabinet |
| IsChestCooler | bit | NULL | Chest cooler flag |
| ReplenishModel | varchar(500) | NULL | Replenishment model name |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| CreatedOn | datetime | NOT NULL | Record creation timestamp |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| CreatedBy | varchar(50) | NOT NULL | Username of creator |
| ModifiedBy | varchar(50) | NOT NULL | Username of last modifier |