The Deal Performance Actuals
In ScopeTechnical: DEAL_ACTUALS_ITEM_LOC | ID: OR-CST-DEAL_ACTUALS_ITEM_LOC-DEAL_ACTUALS_ITEM_LOCATION
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- DEAL_ACTUALS_ITEM_LOC
Field Definitions(5)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | ITEMRPK | DAI_IDRPK | DEAL_IDR | DEAL_DETAIL_IDR | REPORTING_DATER | LOCATION | LOC_TYPE | ORDER_NO | BILL_TO_LOC | ACTUAL_INCOME | BILL_TO_LOC_TYPE | ACTUAL_TURNOVER_UNITS | ACTUAL_TURNOVER_REVENUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 1 | S | 1 | 1 | 1.0000 | S | 1.0000 | 1.0000 |
| default | Deal Actuals Item Loc-002 | 1000000003 | 1000000003 | 1000000003 | 2026-01-03 | 3 | D | 4 | 3 | 12.5000 | D | 12.5000 | 12.5000 |
| default | Deal Actuals Item Loc-003 | 1000000005 | 1000000005 | 1000000005 | 2026-01-05 | 5 | D | 6 | 5 | 14.0000 | D | 14.0000 | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- DAI_IDRPK
- 1
- DEAL_IDR
- 1
- DEAL_DETAIL_IDR
- 1
- REPORTING_DATER
- 2026-01-01
- LOCATION
- 1
- LOC_TYPE
- S
- ORDER_NO
- 1
- BILL_TO_LOC
- 1
- ACTUAL_INCOME
- 1.0000
- BILL_TO_LOC_TYPE
- S
- ACTUAL_TURNOVER_UNITS
- 1.0000
- ACTUAL_TURNOVER_REVENUE
- 1.0000
default
- ITEMRPK
- Deal Actuals Item Loc-002
- DAI_IDRPK
- 1000000003
- DEAL_IDR
- 1000000003
- DEAL_DETAIL_IDR
- 1000000003
- REPORTING_DATER
- 2026-01-03
- LOCATION
- 3
- LOC_TYPE
- D
- ORDER_NO
- 4
- BILL_TO_LOC
- 3
- ACTUAL_INCOME
- 12.5000
- BILL_TO_LOC_TYPE
- D
- ACTUAL_TURNOVER_UNITS
- 12.5000
- ACTUAL_TURNOVER_REVENUE
- 12.5000
default
- ITEMRPK
- Deal Actuals Item Loc-003
- DAI_IDRPK
- 1000000005
- DEAL_IDR
- 1000000005
- DEAL_DETAIL_IDR
- 1000000005
- REPORTING_DATER
- 2026-01-05
- LOCATION
- 5
- LOC_TYPE
- D
- ORDER_NO
- 6
- BILL_TO_LOC
- 5
- ACTUAL_INCOME
- 14.0000
- BILL_TO_LOC_TYPE
- D
- ACTUAL_TURNOVER_UNITS
- 14.0000
- ACTUAL_TURNOVER_REVENUE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 22