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	Description
LocationProductId	int	Unique identifier for the location product
ProductId	int	Product identifier
Product	varchar	Product name
SKU	varchar	Stock keeping unit
ExternalProductCode	varchar	External system product code
ProductName	varchar	Name of the product at this location
Price	decimal(18,2)	Product price at this location
ProductCategoryId	int	Product category identifier
ProductCategory	varchar	Product category name
ProductCategoryColor	varchar	Color code for product category
IsDeleted	bit	Soft delete flag
ClientName	varchar	Name of the client
ClientCode	varchar	Code of the client
LocationId	int	Location identifier
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
ChannelId	int	Channel/location type identifier
Channel	varchar	Channel/location type name
StateId	int	State/province identifier
State	varchar	State/province name
CountryId	int	Country identifier
Country	varchar	Country name
CreatedOn	datetime	Record creation timestamp
CreatedBy	varchar	Username of creator
ModifiedOn	datetime	Record modification timestamp
ModifiedBy	varchar	Username of last modifier