Asset Purity Product
- File Name:
assetpurityproduct.parquet - Type: Incremental (Delta)
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains product-level details for each purity check, showing individual product positions, shelf placement, and compliance status. Each record represents a single product facing identified in a purity check.
Delta Filter
- Inherits from AssetPurity: Records are included based on the parent AssetPurity record's modification date
- First Run: Includes up to 1 month of historical data
- Gap Handling: If more than 1 month has passed since last export, limited to most recent month
Fields
📋 Includes Common Fields: Client Information, Location Information, Asset Information, Product Information, Smart Device Information, Audit Fields
Core AssetPurityProduct Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| AssetPurityProductId | int | NOT NULL | Unique identifier for the purity product record |
| AssetPurityId | int | NOT NULL | Associated asset purity record ID |
| PurityDateTime | datetime | NULL | Date/time of purity check |
| Shelf | tinyint | NOT NULL | Shelf number where product is located |
| Position | tinyint | NOT NULL | Position on the shelf |
| IsCompliant | bit | NOT NULL | Compliance flag |
| IsForeign | bit | NOT NULL | Foreign product flag |
Planogram Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PlanogramId | int | NOT NULL | Planogram identifier |
| PlanogramName | nvarchar(500) | NULL | Planogram name |
| ExternalPlanogramCode | nvarchar(250) | NULL | External system planogram code |