Deal Actuals Forecast
In ScopeTechnical: DEAL_ACTUALS_FORECAST | ID: OR-MFCS-DEAL_ACTUALS_FORECAST
Stores all the deal performance forecasts. There is one row per deal component reporting period.
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_ACTUALS_FORECAST
Field Definitions(13)
Rules & Considerations(42)
Sample Load Data(4)
| _scenario | DEAL_IDRPK | BUDGET_INCOMER | DEAL_DETAIL_IDR | REPORTING_DATER | BUDGET_TURNOVERR | BASELINE_TURNOVERR | ACTUAL_FORECAST_INDR | ACTUAL_FORECAST_INCOMER | ACTUAL_FORECAST_TURNOVERR | ACTUAL_FORECAST_TREND_INCOMER | ACTUAL_FORECAST_TREND_TURNOVERR | ACTUAL_INCOME | INVC_PROCESSED_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 11.0000 | 1000000001 | 2026-01-01 | 11.0000 | 11.0000 | Deal Actuals Forecast-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | N |
default
- DEAL_IDRPK
- 1000000001
- BUDGET_INCOMER
- 11.0000
- DEAL_DETAIL_IDR
- 1000000001
- REPORTING_DATER
- 2026-01-01
- BUDGET_TURNOVERR
- 11.0000
- BASELINE_TURNOVERR
- 11.0000
- ACTUAL_FORECAST_INDR
- Deal Actuals Forecast-001
- ACTUAL_FORECAST_INCOMER
- 11.0000
- ACTUAL_FORECAST_TURNOVERR
- 11.0000
- ACTUAL_FORECAST_TREND_INCOMER
- 11.0000
- ACTUAL_FORECAST_TREND_TURNOVERR
- 11.0000
- ACTUAL_INCOME
- 11.0000
- INVC_PROCESSED_IND
- N