Market Schema
- File Name:
market.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains reference data for markets (regions, territories, geographic divisions) including hierarchical relationships and ordering parameters.
Fields
📋 Includes Common Fields: Client Information
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| MarketId | int | NOT NULL | Unique identifier for the market |
| MarketName | nvarchar(150) | NOT NULL | Name of the market |
| ParentMarketId | int | NOT NULL | Parent market identifier (for hierarchies) |
| ParentMarket | nvarchar(150) | NOT NULL | Name of the parent market |
| ChildCount | int | NULL | Number of child markets |
| MoQ | int | NOT NULL | Minimum order quantity |
| MoV | int | NOT NULL | Minimum order value |
| ExternalMarketCode | nvarchar(250) | NULL | External system market code |
| MarketLevel | int | NULL | Level in the market hierarchy |
| IsDeleted | tinyint | NOT NULL | Soft delete flag |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |