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