Deals Applicable To An Item/Supplier/Country/Location Combination

In Scope

Technical: DEAL_ITEM_LOC_EXPLODE | ID: OR-CST-DEAL_ITEM_LOC_EXPLODE-DEAL_ITEM_LOCATION_EXPLODE

This tables contains the deals applicable to an item/supplier/country/location combination. Deals defined at the Merch, Org and Supplier Hierarchy are exploded.

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_ITEM_LOC_EXPLODE

Field Definitions(5)

Rules & Considerations(55)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	LOCATIONR	LOC_TYPER	SUPPLIERR	ORIGIN_COUNTRY_IDR	DEAL_ID	CLOSE_DATE	DEAL_CLASS	PARTNER_ID	SETUP_AREA	SETUP_DEPT	ACTIVE_DATE	SETUP_CHAIN	SETUP_CLASS	PARTNER_TYPE	SETUP_DIFF_1	SETUP_DIFF_2	SETUP_DIFF_3	SETUP_DIFF_4	SETUP_REGION	CONTRIB_VALUE	COST_APPL_IND	DEAL_DETAIL_ID	DEAL_HEAD_TYPE	SETUP_DISTRICT	SETUP_DIVISION	SETUP_GROUP_NO	SETUP_LOCATION	SETUP_SUBCLASS	CREATE_DATETIME	SETUP_ORG_LEVEL	GET_FREE_DISCOUNT	SETUP_ITEM_PARENT	SETUP_MERCH_LEVEL	VEND_CONTRIB_TYPE	QTY_THRESH_BUY_QTY	QTY_THRESH_GET_QTY	PRICE_COST_APPL_IND	QTY_THRESH_BUY_ITEM	QTY_THRESH_GET_ITEM	QTY_THRESH_GET_TYPE	QTY_THRESH_GET_VALUE	QTY_THRESH_RECUR_IND	THRESHOLD_VALUE_TYPE	QTY_THRESH_BUY_TARGET	QTY_THRESH_BUY_AVG_LOC	SETUP_ITEM_GRANDPARENT	DEAL_DETAIL_APPLICATION_ORDER	QTY_THRESH_FREE_ITEM_UNIT_COST
Example values from field definitions	SAMPLE	1	S	1	SAM	1	2026-01-01	SAMPLE	SAMPLE	1	1	2026-01-01	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1.0000	SAMPLE	1	SAMPLE	1	1	1	1	1	2026-01-01	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	1.0000	1.0000	S	SAMPLE	SAMPLE	SAMPLE	1.0000	S	SAMPLE	1.0000	1.0000	SAMPLE	1	1.0000
default	Deal Item Loc Explode-002	3	D	3	ALT	1000000003	2026-01-03	CU	ALT-DEAL_I	103	1003	2026-01-03	13	1103	S2	Deal Item	Deal Item	Deal Item	Deal Item	203	12.5000	N	1000000003	A	303	103	4	3	1113	2026-01-03	2	12.5000	Deal Item Loc Explode-002	1	amount	12.5000	12.5000	D	Deal Item Loc Explode-002	Deal Item Loc Explode-002	percen	12.5000	Y	M	12.5000	12.5000	Deal Item Loc Explode-002	3	12.5000
default	Deal Item Loc Explode-003	5	D	5	EDG	1000000005	2026-01-05	CS	EDGE-DEAL_	105	1005	2026-01-05	15	1105	S3	Deal Item	Deal Item	Deal Item	Deal Item	205	14.0000	NN	1000000005	P	305	105	6	5	1115	2026-01-05	3	14.0000	Deal Item Loc Explode-003	2	requir	14.0000	14.0000	D	Deal Item Loc Explode-003	Deal Item Loc Explode-003	amount	14.0000	Y	Q	14.0000	14.0000	Deal Item Loc Explode-003	5	14.0000

Example values from field definitions

ITEMRPK: SAMPLE
LOCATIONR: 1
LOC_TYPER: S
SUPPLIERR: 1
ORIGIN_COUNTRY_IDR: SAM
DEAL_ID: 1
CLOSE_DATE: 2026-01-01
DEAL_CLASS: SAMPLE
PARTNER_ID: SAMPLE
SETUP_AREA: 1
SETUP_DEPT: 1
ACTIVE_DATE: 2026-01-01
SETUP_CHAIN: 1
SETUP_CLASS: 1
PARTNER_TYPE: SAMPLE
SETUP_DIFF_1: SAMPLE
SETUP_DIFF_2: SAMPLE
SETUP_DIFF_3: SAMPLE
SETUP_DIFF_4: SAMPLE
SETUP_REGION: 1
CONTRIB_VALUE: 1.0000
COST_APPL_IND: SAMPLE
DEAL_DETAIL_ID: 1
DEAL_HEAD_TYPE: SAMPLE
SETUP_DISTRICT: 1
SETUP_DIVISION: 1
SETUP_GROUP_NO: 1
SETUP_LOCATION: 1
SETUP_SUBCLASS: 1
CREATE_DATETIME: 2026-01-01
SETUP_ORG_LEVEL: SAMPLE
GET_FREE_DISCOUNT: 1.0000
SETUP_ITEM_PARENT: SAMPLE
SETUP_MERCH_LEVEL: SAMPLE
VEND_CONTRIB_TYPE: SAMPLE
QTY_THRESH_BUY_QTY: 1.0000
QTY_THRESH_GET_QTY: 1.0000
PRICE_COST_APPL_IND: S
QTY_THRESH_BUY_ITEM: SAMPLE
QTY_THRESH_GET_ITEM: SAMPLE
QTY_THRESH_GET_TYPE: SAMPLE
QTY_THRESH_GET_VALUE: 1.0000
QTY_THRESH_RECUR_IND: S
THRESHOLD_VALUE_TYPE: SAMPLE
QTY_THRESH_BUY_TARGET: 1.0000
QTY_THRESH_BUY_AVG_LOC: 1.0000
SETUP_ITEM_GRANDPARENT: SAMPLE
DEAL_DETAIL_APPLICATION_ORDER: 1
QTY_THRESH_FREE_ITEM_UNIT_COST: 1.0000

default

ITEMRPK: Deal Item Loc Explode-002
LOCATIONR: 3
LOC_TYPER: D
SUPPLIERR: 3
ORIGIN_COUNTRY_IDR: ALT
DEAL_ID: 1000000003
CLOSE_DATE: 2026-01-03
DEAL_CLASS: CU
PARTNER_ID: ALT-DEAL_I
SETUP_AREA: 103
SETUP_DEPT: 1003
ACTIVE_DATE: 2026-01-03
SETUP_CHAIN: 13
SETUP_CLASS: 1103
PARTNER_TYPE: S2
SETUP_DIFF_1: Deal Item
SETUP_DIFF_2: Deal Item
SETUP_DIFF_3: Deal Item
SETUP_DIFF_4: Deal Item
SETUP_REGION: 203
CONTRIB_VALUE: 12.5000
COST_APPL_IND: N
DEAL_DETAIL_ID: 1000000003
DEAL_HEAD_TYPE: A
SETUP_DISTRICT: 303
SETUP_DIVISION: 103
SETUP_GROUP_NO: 4
SETUP_LOCATION: 3
SETUP_SUBCLASS: 1113
CREATE_DATETIME: 2026-01-03
SETUP_ORG_LEVEL: 2
GET_FREE_DISCOUNT: 12.5000
SETUP_ITEM_PARENT: Deal Item Loc Explode-002
SETUP_MERCH_LEVEL: 1
VEND_CONTRIB_TYPE: amount
QTY_THRESH_BUY_QTY: 12.5000
QTY_THRESH_GET_QTY: 12.5000
PRICE_COST_APPL_IND: D
QTY_THRESH_BUY_ITEM: Deal Item Loc Explode-002
QTY_THRESH_GET_ITEM: Deal Item Loc Explode-002
QTY_THRESH_GET_TYPE: percen
QTY_THRESH_GET_VALUE: 12.5000
QTY_THRESH_RECUR_IND: Y
THRESHOLD_VALUE_TYPE: M
QTY_THRESH_BUY_TARGET: 12.5000
QTY_THRESH_BUY_AVG_LOC: 12.5000
SETUP_ITEM_GRANDPARENT: Deal Item Loc Explode-002
DEAL_DETAIL_APPLICATION_ORDER: 3
QTY_THRESH_FREE_ITEM_UNIT_COST: 12.5000