Location Product Schema
- File Name:
locationproduct.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains location-specific product information including pricing and naming variations at the outlet level.
Fields
📋 Includes Common Fields: Client Information, Location Information, Audit Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| LocationProductId | int | NOT NULL | Unique identifier for the location product |
| ProductId | int | NOT NULL | Product identifier |
| Product | nvarchar(100) | NULL | Product name |
| SKU | varchar(50) | NULL | Stock keeping unit |
| ExternalProductCode | nvarchar(100) | NULL | External system product code |
| ProductName | nvarchar(100) | NOT NULL | Name of the product at this location |
| Price | numeric(18,2) | NOT NULL | Product price at this location |
| ProductCategoryId | int | NOT NULL | Product category identifier |
| ProductCategory | varchar(255) | NULL | Product category name |
| ProductCategoryColor | varchar(20) | NULL | Color code for product category |
| IsDeleted | tinyint | NOT NULL | Soft delete flag |
| ClientName | nvarchar(50) | NULL | Name of the client |
| ClientCode | varchar(10) | NULL | Code of the client |
| LocationId | int | NOT NULL | Location identifier |
| 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 | NULL | Market identifier |
| MarketName | nvarchar(150) | NULL | Market name |
| ChannelId | int | NULL | Channel/location type identifier |
| Channel | nvarchar(255) | NULL | Channel/location type name |
| StateId | int | NULL | State/province identifier |
| State | nvarchar(50) | NULL | State/province name |
| CountryId | int | NULL | Country identifier |
| Country | varchar(50) | NULL | Country name |
| CreatedOn | datetime | NOT NULL | Record creation timestamp |
| CreatedBy | varchar(50) | NULL | Username of creator |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| ModifiedBy | varchar(50) | NULL | Username of last modifier |