One Row For Every Channel Operated
In ScopeTechnical: CHANNELS | ID: OR-FND-CHANNELS-CHANNELS
Stores one row for every channel operated within the company. This table will only be used in a multi-channel environment.
See how this object fits into Foundation Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- CHANNELS
Field Definitions(5)
Rules & Considerations(12)
validation
constraint
Sample Load Data(4)
| _scenario | BANNER_IDR | CREATE_IDR | CHANNEL_IDRPK | CHANNEL_NAMER | CHANNEL_TYPER | CREATE_DATETIME |
|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 |
| default | 100003 | C LIENT_INFO | 100003 | Channels Secondary | Channe | 2026-01-03 |
| default | 100005 | USE RENV | 100005 | Channels Core | Channe | 2026-01-05 |
Example values from field definitions
- BANNER_IDR
- 1
- CREATE_IDR
- SAMPLE
- CHANNEL_IDRPK
- 1
- CHANNEL_NAMER
- SAMPLE
- CHANNEL_TYPER
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
default
- BANNER_IDR
- 100003
- CREATE_IDR
- C LIENT_INFO
- CHANNEL_IDRPK
- 100003
- CHANNEL_NAMER
- Channels Secondary
- CHANNEL_TYPER
- Channe
- CREATE_DATETIME
- 2026-01-03
default
- BANNER_IDR
- 100005
- CREATE_IDR
- USE RENV
- CHANNEL_IDRPK
- 100005
- CHANNEL_NAMER
- Channels Core
- CHANNEL_TYPER
- Channe
- CREATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 12