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 | Description |
|---|---|---|
| ChannelId | int | Unique identifier for the channel (aliased from LocationTypeId) |
| Channel | varchar | Name of the channel (aliased from LocationType.Name) |
| Code | varchar | Channel code for internal use |
| ExternalLocationTypeCode | varchar | External system location type code for integration |
| IsDeleted | bit | Soft delete flag - indicates if channel is marked as deleted |
| ClientName | varchar | Name of the client |
| ClientCode | varchar | Code of the client |