Deal Item Location Explode (GTT)

Out of Scope

Technical: DEAL_ITEM_LOC_EXPLODE_GTT | ID: OR-CST-DEAL_ITEM_LOC_EXPLODE_GTT-DEAL_ITEM_LOC_EXPLODE_GTT

this table is used during the processing of cost engine.

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: gtt

Target Structure

Load Approach: Table
Target Objects: DEAL_ITEM_LOC_EXPLODE_GTT

Field Definitions(5)

Rules & Considerations(57)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	LOCATIONR	SUPPLIERR	ORIGIN_COUNTRY_IDR	DEAL_ID	EXCL_IND	LOC_TYPE	CLOSE_DATE	DEAL_CLASS	PARTNER_ID	RETAIN_IND	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	1	SAM	1	S	S	2026-01-01	SAMPLE	SAMPLE	S	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 Gtt	3	3	ALT	1000000003	D	D	2026-01-03	cu	ALT-DEAL_I	D	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 Gtt	1	amount	12.5000	12.5000	D	Deal Item Loc Explode Gtt	Deal Item Loc Explode Gtt	percen	12.5000	y	m	12.5000	12.5000	Deal Item Loc Explode Gtt	3	12.5000
default	Deal Item Loc Explode Gtt	5	5	EDG	1000000005	D	D	2026-01-05	cs	EDGE-DEAL_	D	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 Gtt	2	requir	14.0000	14.0000	D	Deal Item Loc Explode Gtt	Deal Item Loc Explode Gtt	amount	14.0000	y	q	14.0000	14.0000	Deal Item Loc Explode Gtt	5	14.0000

Example values from field definitions

ITEMRPK: SAMPLE
LOCATIONR: 1
SUPPLIERR: 1
ORIGIN_COUNTRY_IDR: SAM
DEAL_ID: 1
EXCL_IND: S
LOC_TYPE: S
CLOSE_DATE: 2026-01-01
DEAL_CLASS: SAMPLE
PARTNER_ID: SAMPLE
RETAIN_IND: S
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 Gtt
LOCATIONR: 3
SUPPLIERR: 3
ORIGIN_COUNTRY_IDR: ALT
DEAL_ID: 1000000003
EXCL_IND: D
LOC_TYPE: D
CLOSE_DATE: 2026-01-03
DEAL_CLASS: cu
PARTNER_ID: ALT-DEAL_I
RETAIN_IND: D
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 Gtt
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 Gtt
QTY_THRESH_GET_ITEM: Deal Item Loc Explode Gtt
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 Gtt
DEAL_DETAIL_APPLICATION_ORDER: 3
QTY_THRESH_FREE_ITEM_UNIT_COST: 12.5000