Cost Event Retail Change
In ScopeTechnical: COST_EVENT_RETAIL_CHANGE | ID: OR-PRC-COST_EVENT_RETAIL_CHANGE-COST_EVENT_RETAIL_CHANGE
This tables holds the items and associated templates for which the unit retail is changed.
See how this object fits into Pricing & Promotions
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
- COST_EVENT_RETAIL_CHANGE
Field Definitions(5)
Rules & Considerations(17)
validation
constraint
Sample Load Data(4)
| _scenario | LOCR | ITEMR | LOC_TYPER | UNIT_RETAILR | COST_EVENT_PROCESS_IDRPK | END_DATE | TEMPL_ID | MARGIN_PCT | START_DATE |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1.0000 | 1 | 2026-01-01 | 1 | 1.0000 | 2026-01-01 |
| default | 3 | Cost Event Retail Change- | C | 12.5000 | 1000000003 | 2026-01-03 | 1000000003 | 12.5000 | 2026-01-03 |
| default | 5 | Cost Event Retail Change- | C | 14.0000 | 1000000005 | 2026-01-05 | 1000000005 | 14.0000 | 2026-01-05 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- LOC_TYPER
- S
- UNIT_RETAILR
- 1.0000
- COST_EVENT_PROCESS_IDRPK
- 1
- END_DATE
- 2026-01-01
- TEMPL_ID
- 1
- MARGIN_PCT
- 1.0000
- START_DATE
- 2026-01-01
default
- LOCR
- 3
- ITEMR
- Cost Event Retail Change-
- LOC_TYPER
- C
- UNIT_RETAILR
- 12.5000
- COST_EVENT_PROCESS_IDRPK
- 1000000003
- END_DATE
- 2026-01-03
- TEMPL_ID
- 1000000003
- MARGIN_PCT
- 12.5000
- START_DATE
- 2026-01-03
default
- LOCR
- 5
- ITEMR
- Cost Event Retail Change-
- LOC_TYPER
- C
- UNIT_RETAILR
- 14.0000
- COST_EVENT_PROCESS_IDRPK
- 1000000005
- END_DATE
- 2026-01-05
- TEMPL_ID
- 1000000005
- MARGIN_PCT
- 14.0000
- START_DATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 17