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 | Description |
|---|---|---|
| PlanogramId | int | Unique identifier for the planogram |
| PlanogramName | varchar | Name of the planogram |
| ExternalPlanogramCode | varchar | External system planogram code |
| Shelves | int | Number of shelves |
| Facings | int | Total number of facings |
| FacingsDistinct | int | Number of distinct facings |
| FacingDetails | text | Detailed facing information (JSON structure) |
| StartDate | datetime | Planogram start date |
| IsCategory | bit | Category planogram flag |
| IsActive | bit | Active status flag |
| IsDeleted | bit | Soft delete flag |
| IsUseStockPercentage | bit | Flag to use stock percentage |
| AssetTypeId | int | Asset type identifier |
| AssetType | varchar | Asset type name |
| CabinetHeight | decimal(18,2) | Height of the cabinet |
| CabinetWidth | decimal(18,2) | Width of the cabinet |
| IsChestCooler | bit | Chest cooler flag |
| ReplenishModel | varchar | Replenishment model name |
| ClientName | varchar | Name of the client |
| CreatedOn | datetime | Record creation timestamp |
| ModifiedOn | datetime | Record modification timestamp |
| CreatedBy | varchar | Username of creator |
| ModifiedBy | varchar | Username of last modifier |