Fixed Deal Dates
In ScopeTechnical: FIXED_DEAL_DATES | ID: OR-CST-FIXED_DEAL_DATES-FIXED_DEAL_DATES
This table will hold a column for each date of the fixed deal that the amount should be collected from the supplier/partner.
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
- FIXED_DEAL_DATES
Field Definitions(5)
Rules & Considerations(12)
constraint
validation
Sample Load Data(4)
| _scenario | DEAL_NORPK | COLLECT_DATERPK | CURRENCY_CODER | EXTRACTED_INDR | FIXED_DEAL_AMTR |
|---|---|---|---|---|---|
| Example values from field definitions | 1 | 2026-01-01 | SAM | S | 1.0000 |
| default | 4 | 2026-01-03 | ALT | N | 12.5000 |
| default | 6 | 2026-01-05 | EDG | N | 14.0000 |
Example values from field definitions
- DEAL_NORPK
- 1
- COLLECT_DATERPK
- 2026-01-01
- CURRENCY_CODER
- SAM
- EXTRACTED_INDR
- S
- FIXED_DEAL_AMTR
- 1.0000
default
- DEAL_NORPK
- 4
- COLLECT_DATERPK
- 2026-01-03
- CURRENCY_CODER
- ALT
- EXTRACTED_INDR
- N
- FIXED_DEAL_AMTR
- 12.5000
default
- DEAL_NORPK
- 6
- COLLECT_DATERPK
- 2026-01-05
- CURRENCY_CODER
- EDG
- EXTRACTED_INDR
- N
- FIXED_DEAL_AMTR
- 14.0000
Rule Validation Summary
- Source Rule Count
- 20
- Governed Rule Count
- 12