Deal Component Promotion
In ScopeTechnical: DEAL_COMP_PROM | ID: OR-CST-DEAL_COMP_PROM-DEAL_COMPONENT_PROMOTION
This table will contain records that are associated to multiple Vendor Funded Promotion Components for a single Vendor Funded Deal Component.
See how this object fits into Cost
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
- DEAL_COMP_PROM
Field Definitions(12)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | DEAL_IDRPK | PROMOTION_IDR | PROMO_SOURCER | PROMO_COMP_IDR | DEAL_DETAIL_IDR | CREATE_ID | CONTRIB_VALUE | LAST_UPDATE_ID | CREATE_DATETIME | CONSIGNMENT_RATE | VEND_CONTRIB_TYPE | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SA | 1 | 1 | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 | 1.0000 | SAMPLE | 2026-01-01 |
Example values from field definitions
- DEAL_IDRPK
- 1
- PROMOTION_IDR
- 1
- PROMO_SOURCER
- SA
- PROMO_COMP_IDR
- 1
- DEAL_DETAIL_IDR
- 1
- CREATE_ID
- SAMPLE
- CONTRIB_VALUE
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CONSIGNMENT_RATE
- 1.0000
- VEND_CONTRIB_TYPE
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 16