Deal Detail
In ScopeTechnical: DEAL_DETAIL | ID: OR-CST-DEAL_DETAIL-DEAL_DETAIL
This table will hold deal component information for each deal. Deal component information will share the same supplier and start and end dates.
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_DETAIL
Field Definitions(5)
Rules & Considerations(60)
Sample Load Data(4)
| _scenario | DEAL_IDRPK | DEAL_COMP_TYPER | DEAL_DETAIL_IDRPK | COMMENTS | CREATE_ID | DEAL_CLASS | CONTRIB_VALUE | COST_APPL_IND | LAST_UPDATE_ID | CREATE_DATETIME | CALC_TO_ZERO_IND | COLLECT_END_DATE | CONSIGNMENT_RATE | TURNOVER_TO_DATE | APPLICATION_ORDER | GET_FREE_DISCOUNT | TRAN_DISCOUNT_IND | VEND_CONTRIB_TYPE | COLLECT_START_DATE | QTY_THRESH_BUY_QTY | QTY_THRESH_GET_QTY | GROWTH_RATE_TO_DATE | PRICE_COST_APPL_IND | QTY_THRESH_BUY_ITEM | QTY_THRESH_GET_ITEM | QTY_THRESH_GET_TYPE | LAST_UPDATE_DATETIME | QTY_THRESH_GET_VALUE | QTY_THRESH_RECUR_IND | THRESHOLD_VALUE_TYPE | TOTAL_FORECAST_UNITS | CURRENT_COMP_END_DATE | QTY_THRESH_BUY_TARGET | TOTAL_BUDGET_TURNOVER | QTY_THRESH_BUY_AVG_LOC | TOTAL_ACTUAL_FIXED_IND | TOTAL_BUDGET_FIXED_IND | TOTAL_FORECAST_REVENUE | CURRENT_COMP_START_DATE | ACTUAL_MONIES_EARNED_TO_DATE | TOTAL_BASELINE_GROWTH_BUDGET | TOTAL_BASELINE_GROWTH_ACT_FOR | QTY_THRESH_FREE_ITEM_UNIT_COST | TOTAL_ACTUAL_FORECAST_TURNOVER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | 2026-01-01 | S | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1.0000 | S | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1.0000 | S | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | S | S | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
| default | 1000000003 | Deal D | 1000000003 | Deal Detail-002-ALT | C LIENT_INFO | CU | 12.5000 | N | MDM_USER | 2026-01-03 | Y | 2026-01-03 | 12.5000 | 12.5000 | 3 | 12.5000 | D | amount | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | D | Deal Detail-002-ALT | Deal Detail-002-ALT | percen | 2026-01-03 | 12.5000 | Y | M | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | D | D | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | 1000000005 | Deal D | 1000000005 | Deal Detail-003-EDGE | USE RENV | CS | 14.0000 | NN | BATCH_USER | 2026-01-05 | Y | 2026-01-05 | 14.0000 | 14.0000 | 5 | 14.0000 | D | requir | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | D | Deal Detail-003-EDGE | Deal Detail-003-EDGE | amount | 2026-01-05 | 14.0000 | Y | Q | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | D | D | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- DEAL_IDRPK
- 1
- DEAL_COMP_TYPER
- SAMPLE
- DEAL_DETAIL_IDRPK
- 1
- COMMENTS
- SAMPLE
- CREATE_ID
- SAMPLE
- DEAL_CLASS
- SAMPLE
- CONTRIB_VALUE
- 1.0000
- COST_APPL_IND
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CALC_TO_ZERO_IND
- S
- COLLECT_END_DATE
- 2026-01-01
- CONSIGNMENT_RATE
- 1.0000
- TURNOVER_TO_DATE
- 1.0000
- APPLICATION_ORDER
- 1
- GET_FREE_DISCOUNT
- 1.0000
- TRAN_DISCOUNT_IND
- S
- VEND_CONTRIB_TYPE
- SAMPLE
- COLLECT_START_DATE
- 2026-01-01
- QTY_THRESH_BUY_QTY
- 1.0000
- QTY_THRESH_GET_QTY
- 1.0000
- GROWTH_RATE_TO_DATE
- 1.0000
- PRICE_COST_APPL_IND
- S
- QTY_THRESH_BUY_ITEM
- SAMPLE
- QTY_THRESH_GET_ITEM
- SAMPLE
- QTY_THRESH_GET_TYPE
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- QTY_THRESH_GET_VALUE
- 1.0000
- QTY_THRESH_RECUR_IND
- S
- THRESHOLD_VALUE_TYPE
- SAMPLE
- TOTAL_FORECAST_UNITS
- 1.0000
- CURRENT_COMP_END_DATE
- 2026-01-01
- QTY_THRESH_BUY_TARGET
- 1.0000
- TOTAL_BUDGET_TURNOVER
- 1.0000
- QTY_THRESH_BUY_AVG_LOC
- 1.0000
- TOTAL_ACTUAL_FIXED_IND
- S
- TOTAL_BUDGET_FIXED_IND
- S
- TOTAL_FORECAST_REVENUE
- 1.0000
- CURRENT_COMP_START_DATE
- 2026-01-01
- ACTUAL_MONIES_EARNED_TO_DATE
- 1.0000
- TOTAL_BASELINE_GROWTH_BUDGET
- 1.0000
- TOTAL_BASELINE_GROWTH_ACT_FOR
- 1.0000
- QTY_THRESH_FREE_ITEM_UNIT_COST
- 1.0000
- TOTAL_ACTUAL_FORECAST_TURNOVER
- 1.0000
default
- DEAL_IDRPK
- 1000000003
- DEAL_COMP_TYPER
- Deal D
- DEAL_DETAIL_IDRPK
- 1000000003
- COMMENTS
- Deal Detail-002-ALT
- CREATE_ID
- C LIENT_INFO
- DEAL_CLASS
- CU
- CONTRIB_VALUE
- 12.5000
- COST_APPL_IND
- N
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- CALC_TO_ZERO_IND
- Y
- COLLECT_END_DATE
- 2026-01-03
- CONSIGNMENT_RATE
- 12.5000
- TURNOVER_TO_DATE
- 12.5000
- APPLICATION_ORDER
- 3
- GET_FREE_DISCOUNT
- 12.5000
- TRAN_DISCOUNT_IND
- D
- VEND_CONTRIB_TYPE
- amount
- COLLECT_START_DATE
- 2026-01-03
- QTY_THRESH_BUY_QTY
- 12.5000
- QTY_THRESH_GET_QTY
- 12.5000
- GROWTH_RATE_TO_DATE
- 12.5000
- PRICE_COST_APPL_IND
- D
- QTY_THRESH_BUY_ITEM
- Deal Detail-002-ALT
- QTY_THRESH_GET_ITEM
- Deal Detail-002-ALT
- QTY_THRESH_GET_TYPE
- percen
- LAST_UPDATE_DATETIME
- 2026-01-03
- QTY_THRESH_GET_VALUE
- 12.5000
- QTY_THRESH_RECUR_IND
- Y
- THRESHOLD_VALUE_TYPE
- M
- TOTAL_FORECAST_UNITS
- 12.5000
- CURRENT_COMP_END_DATE
- 2026-01-03
- QTY_THRESH_BUY_TARGET
- 12.5000
- TOTAL_BUDGET_TURNOVER
- 12.5000
- QTY_THRESH_BUY_AVG_LOC
- 12.5000
- TOTAL_ACTUAL_FIXED_IND
- D
- TOTAL_BUDGET_FIXED_IND
- D
- TOTAL_FORECAST_REVENUE
- 12.5000
- CURRENT_COMP_START_DATE
- 2026-01-03
- ACTUAL_MONIES_EARNED_TO_DATE
- 12.5000
- TOTAL_BASELINE_GROWTH_BUDGET
- 12.5000
- TOTAL_BASELINE_GROWTH_ACT_FOR
- 12.5000
- QTY_THRESH_FREE_ITEM_UNIT_COST
- 12.5000
- TOTAL_ACTUAL_FORECAST_TURNOVER
- 12.5000
default
- DEAL_IDRPK
- 1000000005
- DEAL_COMP_TYPER
- Deal D
- DEAL_DETAIL_IDRPK
- 1000000005
- COMMENTS
- Deal Detail-003-EDGE
- CREATE_ID
- USE RENV
- DEAL_CLASS
- CS
- CONTRIB_VALUE
- 14.0000
- COST_APPL_IND
- NN
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- CALC_TO_ZERO_IND
- Y
- COLLECT_END_DATE
- 2026-01-05
- CONSIGNMENT_RATE
- 14.0000
- TURNOVER_TO_DATE
- 14.0000
- APPLICATION_ORDER
- 5
- GET_FREE_DISCOUNT
- 14.0000
- TRAN_DISCOUNT_IND
- D
- VEND_CONTRIB_TYPE
- requir
- COLLECT_START_DATE
- 2026-01-05
- QTY_THRESH_BUY_QTY
- 14.0000
- QTY_THRESH_GET_QTY
- 14.0000
- GROWTH_RATE_TO_DATE
- 14.0000
- PRICE_COST_APPL_IND
- D
- QTY_THRESH_BUY_ITEM
- Deal Detail-003-EDGE
- QTY_THRESH_GET_ITEM
- Deal Detail-003-EDGE
- QTY_THRESH_GET_TYPE
- amount
- LAST_UPDATE_DATETIME
- 2026-01-05
- QTY_THRESH_GET_VALUE
- 14.0000
- QTY_THRESH_RECUR_IND
- Y
- THRESHOLD_VALUE_TYPE
- Q
- TOTAL_FORECAST_UNITS
- 14.0000
- CURRENT_COMP_END_DATE
- 2026-01-05
- QTY_THRESH_BUY_TARGET
- 14.0000
- TOTAL_BUDGET_TURNOVER
- 14.0000
- QTY_THRESH_BUY_AVG_LOC
- 14.0000
- TOTAL_ACTUAL_FIXED_IND
- D
- TOTAL_BUDGET_FIXED_IND
- D
- TOTAL_FORECAST_REVENUE
- 14.0000
- CURRENT_COMP_START_DATE
- 2026-01-05
- ACTUAL_MONIES_EARNED_TO_DATE
- 14.0000
- TOTAL_BASELINE_GROWTH_BUDGET
- 14.0000
- TOTAL_BASELINE_GROWTH_ACT_FOR
- 14.0000
- QTY_THRESH_FREE_ITEM_UNIT_COST
- 14.0000
- TOTAL_ACTUAL_FORECAST_TURNOVER
- 14.0000
Rule Validation Summary
- Source Rule Count
- 84
- Governed Rule Count
- 60