Location Classification Schema
- File Name:
locationclassification.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains reference data for location classifications (e.g., Premium, Standard, Key Account), used to categorize and segment outlets.
Fields
📋 Includes Common Fields: Client Information, Audit Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ClassificationId | int | NOT NULL | Unique identifier for the location classification |
| ClassificationName | nvarchar(200) | NOT NULL | Name of the classification |
| Code | nvarchar(20) | NULL | Classification code |
| ExternalLocationClassificationCode | nvarchar(250) | NULL | External system classification code |
| CreatedOn | datetime | NOT NULL | Record creation timestamp |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| CreatedByUser | varchar(50) | NOT NULL | Username of creator |
| ModifiedByUser | varchar(50) | NOT NULL | Username of last modifier |
| 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 |