Deal Header
In ScopeTechnical: DEAL_HEAD | ID: OR-CST-DEAL_HEAD-DEAL_HEADER
This table will hold deal header information for each deal, including such information as supplier or manufacturer, 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_HEAD
Field Definitions(5)
Rules & Considerations(78)
validation
constraint
Sample Load Data(4)
| _scenario | TYPER | DEAL_IDRPK | PARTNER_TYPER | STATUS | CLOSE_ID | COMMENTS | ORDER_NO | SUPPLIER | CREATE_ID | REJECT_ID | CLOSE_DATE | EXT_REF_NO | PARTNER_ID | REBATE_IND | VAT_REGION | ACTIVE_DATE | APPROVAL_ID | REJECT_DATE | BILLING_TYPE | SECURITY_IND | APPROVAL_DATE | CURRENCY_CODE | LAST_UPDATE_ID | COMPARISON_DATE | CREATE_DATETIME | INCLUDE_VAT_IND | BBD_ADD_REP_DAYS | BILL_BACK_METHOD | BILL_BACK_PERIOD | DEAL_APPL_TIMING | REBATE_CALC_TYPE | STOCK_LEDGER_IND | TURNOVER_TO_DATE | GROWTH_REBATE_IND | LAST_INVOICE_DATE | BILLING_PARTNER_ID | BILLING_SUPPLIER_ID | GROWTH_RATE_TO_DATE | THRESHOLD_LIMIT_UOM | BBD_ADD_PERIOD_SCOPE | BILLING_PARTNER_TYPE | DEAL_REPORTING_LEVEL | LAST_UPDATE_DATETIME | THRESHOLD_LIMIT_TYPE | TRACK_PACK_LEVEL_IND | EST_NEXT_INVOICE_DATE | REBATE_PURCH_SALES_IND | RECALC_APPROVED_ORDERS | USE_MFG_SUG_RETAIL_IND | USE_SUPP_UNIT_COST_IND | DEAL_INCOME_CALCULATION | HISTORICAL_COMP_END_DATE | INVOICE_PROCESSING_LOGIC | RETROACTIVE_ELIGIBLE_IND | HISTORICAL_COMP_START_DATE | RECALC_INVENTORY_VALUE_IND | INCLUDE_FRANCHISE_PURCH_IND | INCLUDE_FRANCHISE_SALES_IND | ACTUAL_MONIES_EARNED_TO_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | S | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | S | 2026-01-01 | SAM | SAMPLE | SAMPLE | 2026-01-01 | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | S | 2026-01-01 | SAMPLE | 1 | 1.0000 | SAMP | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | S | 2026-01-01 | SAMPLE | S | S | S | SAMPLE | 2026-01-01 | SAMPLE | S | 2026-01-01 | S | S | S | 1.0000 |
| default | A | 1000000003 | SS | S | ALT-DEAL_HEAD-002 | Deal Head-002-ALT | 4 | 3 | MDM_USER | ALT-DEAL_HEAD-002 | 2026-01-03 | Deal Head-002-ALT | ALT-DEAL_H | Y | 203 | 2026-01-03 | ALT-DEAL_HEAD-002 | 2026-01-03 | OI | D | 2026-01-03 | ALT | MDM_USER | 2026-0 | 2026-01-03 | Y | 3 | note | M | O | L | Y | 12.5000 | Y | 2026-01-03 | ALT-DEAL_H | 1000000003 | 12.5000 | Deal | Deal H | S2 | W | 2026-01-03 | Q | D | 2026-01-03 | P | Y | N | Y | Pro | 2026-01-03 | AA | D | 2026-01-03 | D | Y | Y | 12.5000 |
| default | P | 1000000005 | S1 | A | EDGE-DEAL_HEAD-003 | Deal Head-003-EDGE | 6 | 5 | BATCH_USER | EDGE-DEAL_HEAD-003 | 2026-01-05 | Deal Head-003-EDGE | EDGE-DEAL_ | Y | 205 | 2026-01-05 | EDGE-DEAL_HEAD-003 | 2026-01-05 | off | D | 2026-01-05 | EDG | BATCH_USER | 2026-0 | 2026-01-05 | Y | 5 | note | Q | R | L | Y | 14.0000 | Y | 2026-01-05 | EDGE-DEAL_ | 1000000005 | 14.0000 | Deal | Deal H | S3 | M | 2026-01-05 | A | D | 2026-01-05 | P | Y | Y | N | Pro | 2026-01-05 | MA | D | 2026-01-05 | D | a | S | 14.0000 |
Example values from field definitions
- TYPER
- SAMPLE
- DEAL_IDRPK
- 1
- PARTNER_TYPER
- SAMPLE
- STATUS
- SAMPLE
- CLOSE_ID
- SAMPLE
- COMMENTS
- SAMPLE
- ORDER_NO
- 1
- SUPPLIER
- 1
- CREATE_ID
- SAMPLE
- REJECT_ID
- SAMPLE
- CLOSE_DATE
- 2026-01-01
- EXT_REF_NO
- SAMPLE
- PARTNER_ID
- SAMPLE
- REBATE_IND
- S
- VAT_REGION
- 1
- ACTIVE_DATE
- 2026-01-01
- APPROVAL_ID
- SAMPLE
- REJECT_DATE
- 2026-01-01
- BILLING_TYPE
- SAMPLE
- SECURITY_IND
- S
- APPROVAL_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- LAST_UPDATE_ID
- SAMPLE
- COMPARISON_DATE
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- INCLUDE_VAT_IND
- S
- BBD_ADD_REP_DAYS
- 1
- BILL_BACK_METHOD
- SAMPLE
- BILL_BACK_PERIOD
- SAMPLE
- DEAL_APPL_TIMING
- SAMPLE
- REBATE_CALC_TYPE
- SAMPLE
- STOCK_LEDGER_IND
- S
- TURNOVER_TO_DATE
- 1.0000
- GROWTH_REBATE_IND
- S
- LAST_INVOICE_DATE
- 2026-01-01
- BILLING_PARTNER_ID
- SAMPLE
- BILLING_SUPPLIER_ID
- 1
- GROWTH_RATE_TO_DATE
- 1.0000
- THRESHOLD_LIMIT_UOM
- SAMP
- BBD_ADD_PERIOD_SCOPE
- SAMPLE
- BILLING_PARTNER_TYPE
- SAMPLE
- DEAL_REPORTING_LEVEL
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- THRESHOLD_LIMIT_TYPE
- SAMPLE
- TRACK_PACK_LEVEL_IND
- S
- EST_NEXT_INVOICE_DATE
- 2026-01-01
- REBATE_PURCH_SALES_IND
- SAMPLE
- RECALC_APPROVED_ORDERS
- S
- USE_MFG_SUG_RETAIL_IND
- S
- USE_SUPP_UNIT_COST_IND
- S
- DEAL_INCOME_CALCULATION
- SAMPLE
- HISTORICAL_COMP_END_DATE
- 2026-01-01
- INVOICE_PROCESSING_LOGIC
- SAMPLE
- RETROACTIVE_ELIGIBLE_IND
- S
- HISTORICAL_COMP_START_DATE
- 2026-01-01
- RECALC_INVENTORY_VALUE_IND
- S
- INCLUDE_FRANCHISE_PURCH_IND
- S
- INCLUDE_FRANCHISE_SALES_IND
- S
- ACTUAL_MONIES_EARNED_TO_DATE
- 1.0000
default
- TYPER
- A
- DEAL_IDRPK
- 1000000003
- PARTNER_TYPER
- SS
- STATUS
- S
- CLOSE_ID
- ALT-DEAL_HEAD-002
- COMMENTS
- Deal Head-002-ALT
- ORDER_NO
- 4
- SUPPLIER
- 3
- CREATE_ID
- MDM_USER
- REJECT_ID
- ALT-DEAL_HEAD-002
- CLOSE_DATE
- 2026-01-03
- EXT_REF_NO
- Deal Head-002-ALT
- PARTNER_ID
- ALT-DEAL_H
- REBATE_IND
- Y
- VAT_REGION
- 203
- ACTIVE_DATE
- 2026-01-03
- APPROVAL_ID
- ALT-DEAL_HEAD-002
- REJECT_DATE
- 2026-01-03
- BILLING_TYPE
- OI
- SECURITY_IND
- D
- APPROVAL_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- LAST_UPDATE_ID
- MDM_USER
- COMPARISON_DATE
- 2026-0
- CREATE_DATETIME
- 2026-01-03
- INCLUDE_VAT_IND
- Y
- BBD_ADD_REP_DAYS
- 3
- BILL_BACK_METHOD
- note
- BILL_BACK_PERIOD
- M
- DEAL_APPL_TIMING
- O
- REBATE_CALC_TYPE
- L
- STOCK_LEDGER_IND
- Y
- TURNOVER_TO_DATE
- 12.5000
- GROWTH_REBATE_IND
- Y
- LAST_INVOICE_DATE
- 2026-01-03
- BILLING_PARTNER_ID
- ALT-DEAL_H
- BILLING_SUPPLIER_ID
- 1000000003
- GROWTH_RATE_TO_DATE
- 12.5000
- THRESHOLD_LIMIT_UOM
- Deal
- BBD_ADD_PERIOD_SCOPE
- Deal H
- BILLING_PARTNER_TYPE
- S2
- DEAL_REPORTING_LEVEL
- W
- LAST_UPDATE_DATETIME
- 2026-01-03
- THRESHOLD_LIMIT_TYPE
- Q
- TRACK_PACK_LEVEL_IND
- D
- EST_NEXT_INVOICE_DATE
- 2026-01-03
- REBATE_PURCH_SALES_IND
- P
- RECALC_APPROVED_ORDERS
- Y
- USE_MFG_SUG_RETAIL_IND
- N
- USE_SUPP_UNIT_COST_IND
- Y
- DEAL_INCOME_CALCULATION
- Pro
- HISTORICAL_COMP_END_DATE
- 2026-01-03
- INVOICE_PROCESSING_LOGIC
- AA
- RETROACTIVE_ELIGIBLE_IND
- D
- HISTORICAL_COMP_START_DATE
- 2026-01-03
- RECALC_INVENTORY_VALUE_IND
- D
- INCLUDE_FRANCHISE_PURCH_IND
- Y
- INCLUDE_FRANCHISE_SALES_IND
- Y
- ACTUAL_MONIES_EARNED_TO_DATE
- 12.5000
default
- TYPER
- P
- DEAL_IDRPK
- 1000000005
- PARTNER_TYPER
- S1
- STATUS
- A
- CLOSE_ID
- EDGE-DEAL_HEAD-003
- COMMENTS
- Deal Head-003-EDGE
- ORDER_NO
- 6
- SUPPLIER
- 5
- CREATE_ID
- BATCH_USER
- REJECT_ID
- EDGE-DEAL_HEAD-003
- CLOSE_DATE
- 2026-01-05
- EXT_REF_NO
- Deal Head-003-EDGE
- PARTNER_ID
- EDGE-DEAL_
- REBATE_IND
- Y
- VAT_REGION
- 205
- ACTIVE_DATE
- 2026-01-05
- APPROVAL_ID
- EDGE-DEAL_HEAD-003
- REJECT_DATE
- 2026-01-05
- BILLING_TYPE
- off
- SECURITY_IND
- D
- APPROVAL_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- LAST_UPDATE_ID
- BATCH_USER
- COMPARISON_DATE
- 2026-0
- CREATE_DATETIME
- 2026-01-05
- INCLUDE_VAT_IND
- Y
- BBD_ADD_REP_DAYS
- 5
- BILL_BACK_METHOD
- note
- BILL_BACK_PERIOD
- Q
- DEAL_APPL_TIMING
- R
- REBATE_CALC_TYPE
- L
- STOCK_LEDGER_IND
- Y
- TURNOVER_TO_DATE
- 14.0000
- GROWTH_REBATE_IND
- Y
- LAST_INVOICE_DATE
- 2026-01-05
- BILLING_PARTNER_ID
- EDGE-DEAL_
- BILLING_SUPPLIER_ID
- 1000000005
- GROWTH_RATE_TO_DATE
- 14.0000
- THRESHOLD_LIMIT_UOM
- Deal
- BBD_ADD_PERIOD_SCOPE
- Deal H
- BILLING_PARTNER_TYPE
- S3
- DEAL_REPORTING_LEVEL
- M
- LAST_UPDATE_DATETIME
- 2026-01-05
- THRESHOLD_LIMIT_TYPE
- A
- TRACK_PACK_LEVEL_IND
- D
- EST_NEXT_INVOICE_DATE
- 2026-01-05
- REBATE_PURCH_SALES_IND
- P
- RECALC_APPROVED_ORDERS
- Y
- USE_MFG_SUG_RETAIL_IND
- Y
- USE_SUPP_UNIT_COST_IND
- N
- DEAL_INCOME_CALCULATION
- Pro
- HISTORICAL_COMP_END_DATE
- 2026-01-05
- INVOICE_PROCESSING_LOGIC
- MA
- RETROACTIVE_ELIGIBLE_IND
- D
- HISTORICAL_COMP_START_DATE
- 2026-01-05
- RECALC_INVENTORY_VALUE_IND
- D
- INCLUDE_FRANCHISE_PURCH_IND
- a
- INCLUDE_FRANCHISE_SALES_IND
- S
- ACTUAL_MONIES_EARNED_TO_DATE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 136
- Governed Rule Count
- 78