Asset Schema
- File Name:
asset.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains master data for all assets (coolers, refrigerators, vending machines, etc.) including their configuration, location, planogram assignments, and installation details.
Fields
📋 Includes Common Fields: Client Information, Location Information, Asset Information
| Column Name | Data Type | Description |
|---|---|---|
| AssetId | int | Unique identifier for the asset |
| AssetSerialNumber | varchar | Serial number of the asset |
| ExternalAssetCode | varchar | External system asset code |
| ParentAssetSerialNumber | varchar | Serial number of the parent asset |
| SubscriptionModelName | varchar | Name of the subscription model |
| ManufacturingDate | datetime | Date the asset was manufactured |
| AssetNotes | text | Notes about the asset (free-form text field) |
| TagNumber | varchar | Tag number assigned to the asset |
| AssetCategory | varchar | Category of the asset |
| DisplacementThreshold | decimal(18,2) | Threshold for displacement detection |
| DateDelivered | datetime | Date the asset was delivered |
| CoolerDeliveryDate | datetime | Cooler-specific delivery date |
| IsImageProcessingNotRequired | bit | Flag indicating if image processing is not required |
| Installation | varchar | Installation details |
| IsDeleted | bit | Soft delete flag |
| PointOfSale | varchar | Point of sale location type |
| InStoreLocation | varchar | In-store location type |
| Latitude | decimal(18,2) | Geographic latitude coordinate |
| Longitude | decimal(18,2) | Geographic longitude coordinate |
| InstallationStatus | varchar | Current installation status |
| AssetTypeId | int | Asset type identifier |
| AssetType | varchar | Name of the asset type |
| PlanogramId | int | Planogram identifier |
| PlanogramName | varchar | Name of the planogram |
| ExternalPlanogramCode | varchar | External system planogram code |
| ClientName | varchar | Name of the client |
| ClientCode | varchar | Code of the client |
| LocationId | int | Unique identifier for the location |
| Name | varchar | Location name |
| Code | varchar | Location code |
| ExternalLocationCode | varchar | External system location code |
| Street | varchar | Street address |
| Street2 | varchar | Street address line 2 |
| Street3 | varchar | Street address line 3 |
| City | varchar | City name |
| PostalCode | varchar | Postal/ZIP code |
| MarketId | int | Market identifier |
| MarketName | varchar | Market name |
| ClassificationId | int | Location classification identifier |
| ClassificationName | varchar | Location classification name |
| ChannelId | int | Channel/location type identifier |
| Channel | varchar | Channel/location type name |
| DistributorId | int | Distributor identifier |
| DistributorName | varchar | Distributor name |
| InstallerUser | varchar | Username of the installer |
| Tags | varchar | Comma-separated list of asset tags |