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 | Nullable | Description |
|---|---|---|---|
| AssetId | int | NOT NULL | Unique identifier for the asset |
| AssetSerialNumber | nvarchar(50) | NOT NULL | Serial number of the asset |
| ExternalAssetCode | nvarchar(250) | NULL | External system asset code |
| ParentAssetSerialNumber | nvarchar(50) | NULL | Serial number of the parent asset |
| SubscriptionModelName | nvarchar(100) | NULL | Name of the subscription model |
| ManufacturingDate | datetime | NULL | Date the asset was manufactured |
| AssetNotes | nvarchar(1000) | NOT NULL | Notes about the asset (free-form text field) |
| TagNumber | nvarchar(50) | NOT NULL | Tag number assigned to the asset |
| AssetCategory | varchar(500) | NULL | Category of the asset |
| DisplacementThreshold | int | NOT NULL | Threshold for displacement detection |
| DateDelivered | datetime | NULL | Date the asset was delivered |
| CoolerDeliveryDate | datetime | NULL | Cooler-specific delivery date |
| IsImageProcessingNotRequired | bit | NOT NULL | Flag indicating if image processing is not required |
| Installation | datetime | NULL | Installation details |
| IsDeleted | tinyint | NOT NULL | Soft delete flag |
| PointOfSale | varchar(500) | NULL | Point of sale location type |
| InStoreLocation | varchar(500) | NULL | In-store location type |
| Latitude | decimal(13,6) | NOT NULL | Geographic latitude coordinate |
| Longitude | decimal(13,6) | NOT NULL | Geographic longitude coordinate |
| InstallationStatus | varchar(500) | NULL | Current installation status |
| AssetTypeId | int | NOT NULL | Asset type identifier |
| AssetType | nvarchar(50) | NOT NULL | Name of the asset type |
| PlanogramId | int | NOT NULL | Planogram identifier |
| PlanogramName | nvarchar(500) | NOT NULL | Name of the planogram |
| ExternalPlanogramCode | nvarchar(250) | NULL | External system planogram code |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |
| LocationId | int | NOT NULL | Unique identifier for the location |
| Name | nvarchar(200) | NULL | Location name |
| Code | nvarchar(100) | NULL | Location code |
| ExternalLocationCode | nvarchar(250) | NULL | External system location code |
| Street | nvarchar(150) | NULL | Street address |
| Street2 | nvarchar(150) | NULL | Street address line 2 |
| Street3 | nvarchar(150) | NULL | Street address line 3 |
| City | nvarchar(50) | NULL | City name |
| PostalCode | nvarchar(50) | NULL | Postal/ZIP code |
| MarketId | int | NOT NULL | Market identifier |
| MarketName | nvarchar(150) | NOT NULL | Market name |
| ClassificationId | int | NOT NULL | Location classification identifier |
| ClassificationName | nvarchar(200) | NOT NULL | Location classification name |
| ChannelId | int | NOT NULL | Channel/location type identifier |
| Channel | nvarchar(255) | NOT NULL | Channel/location type name |
| DistributorId | int | NULL | Distributor identifier |
| DistributorName | nvarchar(100) | NULL | Distributor name |
| InstallerUser | varchar(50) | NULL | Username of the installer |
| Tags | varchar | NULL | Comma-separated list of asset tags |