Deal Actuals Item Loc
In ScopeTechnical: DEAL_ACTUALS_ITEM_LOC | ID: OR-MFCS-DEAL_ACTUALS_ITEM_LOC
Stores all the deal performance actuals. There is one row per deal component item location 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_ITEM_LOC
Field Definitions(13)
Rules & Considerations(38)
Sample Load Data(4)
| _scenario | ITEMRPK | DAI_IDRPK | DEAL_IDR | LOCATIONR | LOC_TYPER | DEAL_DETAIL_IDR | REPORTING_DATER | ORDER_NO | BILL_TO_LOC | ACTUAL_INCOME | BILL_TO_LOC_TYPE | ACTUAL_TURNOVER_UNITS | ACTUAL_TURNOVER_REVENUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Deal Actuals Item Loc-001 | 1000000001 | 1000000001 | 1 | Deal Actuals Item Loc-001 | 1000000001 | 2026-01-01 | 2 | 1 | 11.0000 | Deal Actuals Item Loc-001 | 11.0000 | 11.0000 |
default
- ITEMRPK
- Deal Actuals Item Loc-001
- DAI_IDRPK
- 1000000001
- DEAL_IDR
- 1000000001
- LOCATIONR
- 1
- LOC_TYPER
- Deal Actuals Item Loc-001
- DEAL_DETAIL_IDR
- 1000000001
- REPORTING_DATER
- 2026-01-01
- ORDER_NO
- 2
- BILL_TO_LOC
- 1
- ACTUAL_INCOME
- 11.0000
- BILL_TO_LOC_TYPE
- Deal Actuals Item Loc-001
- ACTUAL_TURNOVER_UNITS
- 11.0000
- ACTUAL_TURNOVER_REVENUE
- 11.0000