| AssetPurityId | int | NOT NULL | Unique identifier for the purity record |
| SmartDeviceId | int | NOT NULL | ID of the Smart Device that captured the image |
| AssetId | int | NOT NULL | ID of the asset |
| EmptyFacings | tinyint | NOT NULL | Number of empty facings |
| TotalStock | tinyint | NOT NULL | Total actual products in cooler |
| ForeignProduct | tinyint | NOT NULL | Non-client products count |
| TotalFacings | tinyint | NOT NULL | Total number of facings |
| OurStock | tinyint | NOT NULL | Client brand stock on the cooler |
| CompliantFacings | tinyint | NOT NULL | Products matching planogram shelf position |
| PurityPercentage | tinyint | NOT NULL | Purity percentage of asset vs planogram |
| StockPercentage | tinyint | NOT NULL | Percentage of stock in the asset |
| PlanogramCompliance | tinyint | NOT NULL | Percentage of products matching planogram position |
| StatusId | int | NOT NULL | Status of the cooler (2 = Provisioned) |
| ImageStatus | varchar(500) | NULL | Image status (e.g., "New", "Provisioned") |
| PurityDateTime | datetime | NOT NULL | Date/time when image was taken |
| GatewayId | int | NOT NULL | Hub ID |
| ClientId | int | NOT NULL | Client identifier |
| PlanogramId | int | NOT NULL | Planogram identifier |
| Shelves | tinyint | NOT NULL | Total number of shelves in cooler |
| DoorOpenUtc | datetime | NULL | Door open time in UTC |
| LocationId | int | NOT NULL | Location identifier |
| RejectReason | int | NULL | Reason code if image was rejected |
| RejectReasonValue | varchar(500) | NULL | Rejection reason (e.g., "No Planogram", "Corrupted Image") |
| PurityDateOnly | date | NULL | Date portion of PurityDateTime |
| SceneTypeId | int | NOT NULL | Scene type identifier |
| SceneType | varchar(500) | NULL | Scene type (e.g., "POS", "Product Analysis") |
| OOSPercentage | numeric(5,2) | NULL | Out of stock percentage |
| CaseSuggested | decimal(19,2) | NULL | Suggested order quantity in cases |
| ValueSuggested | decimal(19,2) | NULL | Suggested order value |
| ForeignProductPercentage | numeric(5,2) | NOT NULL | Percentage of foreign products |
| EmptyProductPercentage | numeric(5,2) | NOT NULL | Percentage of empty facings |
| ImageReceivedFrom | tinyint | NOT NULL | Source of image (1 = default) |
| BeforeAfterImage | tinyint | NOT NULL | Indicates before/after image type |
| CompliantShelvesProductType | tinyint | NULL | Compliant shelves by product type |
| CompliantShelvesPackageType | tinyint | NULL | Compliant shelves by package type |
| OurProductFillLevel | numeric(10,2) | NULL | Our product fill level |
| InStoreAndPlanogramOurProductCount | tinyint | NULL | Our products both in-store and in planogram |
| OurProductCount | tinyint | NULL | Total our product count |
| TotalProductFillLevel | numeric(10,2) | NULL | Total product fill level |
| TotalProductCountInImage | tinyint | NULL | Total products detected in image |
| PogOwnProductCount | tinyint | NULL | Own products in planogram |
| AssortmentDepthCompliance | numeric(10,2) | NULL | Assortment depth compliance percentage |
| ShareOfShelf | numeric(10,2) | NULL | Client product share of shelf percentage |
| TargetPortfolioOutOfStock | numeric(10,2) | NULL | Target portfolio out of stock percentage |
| Occupancy | numeric(10,2) | NULL | Asset occupancy percentage |
| ShelfAvailability | numeric(10,2) | NULL | Shelf availability percentage for client products |
| OnShelfAvailability | numeric(10,2) | NULL | On shelf availability metric |
| TargetPortfolioCompliance | numeric(10,2) | NULL | Target portfolio compliance percentage |
| PlanogramFacings | int | NULL | Product items displayed shelf-wise as per the approved customer planogram |
| ReplenishModelId | int | NULL | Replenish Model identifier |