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 | Description |
|---|---|---|
| AssetPurityProductId | int | Unique identifier for the purity product record |
| AssetPurityId | int | Associated asset purity record ID |
| PurityDateTime | datetime | Date/time of purity check |
| Shelf | int | Shelf number where product is located |
| Position | int | Position on the shelf |
| IsCompliant | bit | Compliance flag |
| IsForeign | bit | Foreign product flag |
Planogram Fields
| Column Name | Data Type | Description |
|---|---|---|
| PlanogramId | int | Planogram identifier |
| PlanogramName | varchar | Planogram name |
| ExternalPlanogramCode | varchar | External system planogram code |