Deal Head

In Scope

Technical: DEAL_HEAD | ID: OR-MFCS-DEAL_HEAD

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

Target Structure

Load Approach: Table
Target Objects: DEAL_HEAD

Field Definitions(59)

Rules & Considerations(167)

Sample Load Data(4)

_scenario	TYPER	STATUSR	DEAL_IDRPK	ORDER_NOPK	SUPPLIERPK	CREATE_IDR	REBATE_INDR	ACTIVE_DATER	BILLING_TYPER	PARTNER_TYPERPK	SECURITY_INDR	CURRENCY_CODERPK	LAST_UPDATE_IDR	CREATE_DATETIMER	INCLUDE_VAT_INDR	STOCK_LEDGER_INDR	GROWTH_REBATE_INDR	THRESHOLD_LIMIT_UOMPK	LAST_UPDATE_DATETIMER	RECALC_APPROVED_ORDERSR	CLOSE_ID	COMMENTS	REJECT_ID	CLOSE_DATE	EXT_REF_NO	PARTNER_ID	VAT_REGION	APPROVAL_ID	REJECT_DATE	APPROVAL_DATE	COMPARISON_DATE	BBD_ADD_REP_DAYS	BILL_BACK_METHOD	BILL_BACK_PERIOD	DEAL_APPL_TIMING	REBATE_CALC_TYPE	TURNOVER_TO_DATE	LAST_INVOICE_DATE	BILLING_PARTNER_ID	BILLING_SUPPLIER_ID	GROWTH_RATE_TO_DATE	BBD_ADD_PERIOD_SCOPE	BILLING_PARTNER_TYPE	DEAL_REPORTING_LEVEL	THRESHOLD_LIMIT_TYPE	TRACK_PACK_LEVEL_IND	EST_NEXT_INVOICE_DATE	REBATE_PURCH_SALES_IND	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
default	PO	W	1000000001	2	1	MIG_USER	Y	2026-01-01	off	S	Deal Head-001	STD-DEAL_HEAD-001	MIG_USER	2026-01-01	Y	Y	Y	Deal Head-001	2026-01-01	Y	STD-DEAL_HEAD-001	Deal Head-001	STD-DEAL_HEAD-001	2026-01-01	Deal Head-001	STD-DEAL_HEAD-001	0201	STD-DEAL_HEAD-001	2026-01-01	2026-01-01	2026-01-01	001	note	W	M	L	11.0000	2026-01-01	STD-DEAL_HEAD-001	1000000001	11.0000	Deal Head-001	S1	Quarter	M	Deal Head-001	2026-01-01	P	Y	N	Pro	2026-01-01	NO	Deal Head-001	2026-01-01	Deal Head-001	Purchase	Sales	11.0000

default

TYPER: PO
STATUSR: W
DEAL_IDRPK: 1000000001
ORDER_NOPK: 2
SUPPLIERPK: 1
CREATE_IDR: MIG_USER
REBATE_INDR: Y
ACTIVE_DATER: 2026-01-01
BILLING_TYPER: off
PARTNER_TYPERPK: S
SECURITY_INDR: Deal Head-001
CURRENCY_CODERPK: STD-DEAL_HEAD-001
LAST_UPDATE_IDR: MIG_USER
CREATE_DATETIMER: 2026-01-01
INCLUDE_VAT_INDR: Y
STOCK_LEDGER_INDR: Y
GROWTH_REBATE_INDR: Y
THRESHOLD_LIMIT_UOMPK: Deal Head-001
LAST_UPDATE_DATETIMER: 2026-01-01
RECALC_APPROVED_ORDERSR: Y
CLOSE_ID: STD-DEAL_HEAD-001
COMMENTS: Deal Head-001
REJECT_ID: STD-DEAL_HEAD-001
CLOSE_DATE: 2026-01-01
EXT_REF_NO: Deal Head-001
PARTNER_ID: STD-DEAL_HEAD-001
VAT_REGION: 0201
APPROVAL_ID: STD-DEAL_HEAD-001
REJECT_DATE: 2026-01-01
APPROVAL_DATE: 2026-01-01
COMPARISON_DATE: 2026-01-01
BBD_ADD_REP_DAYS: 001
BILL_BACK_METHOD: note
BILL_BACK_PERIOD: W
DEAL_APPL_TIMING: M
REBATE_CALC_TYPE: L
TURNOVER_TO_DATE: 11.0000
LAST_INVOICE_DATE: 2026-01-01
BILLING_PARTNER_ID: STD-DEAL_HEAD-001
BILLING_SUPPLIER_ID: 1000000001
GROWTH_RATE_TO_DATE: 11.0000
BBD_ADD_PERIOD_SCOPE: Deal Head-001
BILLING_PARTNER_TYPE: S1
DEAL_REPORTING_LEVEL: Quarter
THRESHOLD_LIMIT_TYPE: M
TRACK_PACK_LEVEL_IND: Deal Head-001
EST_NEXT_INVOICE_DATE: 2026-01-01
REBATE_PURCH_SALES_IND: P
USE_MFG_SUG_RETAIL_IND: Y
USE_SUPP_UNIT_COST_IND: N
DEAL_INCOME_CALCULATION: Pro
HISTORICAL_COMP_END_DATE: 2026-01-01
INVOICE_PROCESSING_LOGIC: NO
RETROACTIVE_ELIGIBLE_IND: Deal Head-001
HISTORICAL_COMP_START_DATE: 2026-01-01
RECALC_INVENTORY_VALUE_IND: Deal Head-001
INCLUDE_FRANCHISE_PURCH_IND: Purchase
INCLUDE_FRANCHISE_SALES_IND: Sales
ACTUAL_MONIES_EARNED_TO_DATE: 11.0000

All objects