Channel Schema
- File Name:
channel_dump_01.01.parquet - Type: Full
- Schema Version: 01.01
- Last Updated: 2026-02-26
Description
Contains reference data for sales channels (also known as location types), such as On-Premise, Off-Premise, Convenience Store, Supermarket, etc. This export represents the LocationType table, with fields aliased to use "Channel" terminology for clarity in the data warehouse context.
Fields
📋 Includes Common Fields: Client Information
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ChannelId | int | NOT NULL | Unique identifier for the channel (aliased from LocationTypeId) |
| Channel | nvarchar(255) | NOT NULL | Name of the channel (aliased from LocationType.Name) |
| Code | nvarchar(20) | NULL | Channel code for internal use |
| ExternalLocationTypeCode | nvarchar(250) | NULL | External system location type code for integration |
| IsDeleted | tinyint | NOT NULL | Soft delete flag - indicates if channel is marked as deleted |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |