Deal Comp Prom
In ScopeTechnical: DEAL_COMP_PROM | ID: OR-MFCS-DEAL_COMP_PROM
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
Target Structure
- Load Approach
- Table
- Target Objects
- DEAL_COMP_PROM
Field Definitions(12)
Rules & Considerations(37)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 1000000001 | MP | 1000000001 | 1000000001 | USERENV | 11.0000 | USERENV | 2026-01-01 | 11.0000 | percent | 2026-01-01 |
default
- DEAL_IDRPK
- 1000000001
- PROMOTION_IDR
- 1000000001
- PROMO_SOURCER
- MP
- PROMO_COMP_IDR
- 1000000001
- DEAL_DETAIL_IDR
- 1000000001
- CREATE_ID
- USERENV
- CONTRIB_VALUE
- 11.0000
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-01
- CONSIGNMENT_RATE
- 11.0000
- VEND_CONTRIB_TYPE
- percent
- LAST_UPDATE_DATETIME
- 2026-01-01