Deal Item Loc Explode
In ScopeTechnical: DEAL_ITEM_LOC_EXPLODE | ID: OR-MFCS-DEAL_ITEM_LOC_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
Target Structure
- Load Approach
- Table
- Target Objects
- DEAL_ITEM_LOC_EXPLODE
Field Definitions(49)
Rules & Considerations(120)
Sample Load Data(4)
| _scenario | ITEMRPK | DEAL_IDR | LOCATIONR | LOC_TYPER | SUPPLIERR | ACTIVE_DATER | DEAL_DETAIL_IDR | ORIGIN_COUNTRY_IDR | CLOSE_DATE | DEAL_CLASS | PARTNER_ID | SETUP_AREA | SETUP_DEPT | 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_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Deal Item Loc Explode-001 | 1000000001 | 1 | Deal Item Loc Explode-001 | 1 | 2026-01-01 | 1000000001 | STD-DEAL_ITEM-001 | 2026-01-01 | M | STD-DEAL_ITEM-001 | 101 | 1001 | 11 | 1101 | S1 | Deal Item Loc Explode-001 | Deal Item Loc Explode-001 | Deal Item Loc Explode-001 | Deal Item Loc Explode-001 | 201 | 11.0000 | M | PO | 301 | 0101 | 0002 | 1 | 1111 | 2026-01-01 | 1 | 11.0000 | Deal Item Loc Explode-001 | company | percent | 11.0000 | 11.0000 | Deal Item Loc Explode-001 | Deal Item Loc Explode-001 | Deal Item Loc Explode-001 | free | 11.0000 | Y | off | 11.0000 | 11.0000 | Deal Item Loc Explode-001 | 1 | 11.0000 |
default
- ITEMRPK
- Deal Item Loc Explode-001
- DEAL_IDR
- 1000000001
- LOCATIONR
- 1
- LOC_TYPER
- Deal Item Loc Explode-001
- SUPPLIERR
- 1
- ACTIVE_DATER
- 2026-01-01
- DEAL_DETAIL_IDR
- 1000000001
- ORIGIN_COUNTRY_IDR
- STD-DEAL_ITEM-001
- CLOSE_DATE
- 2026-01-01
- DEAL_CLASS
- M
- PARTNER_ID
- STD-DEAL_ITEM-001
- SETUP_AREA
- 101
- SETUP_DEPT
- 1001
- SETUP_CHAIN
- 11
- SETUP_CLASS
- 1101
- PARTNER_TYPE
- S1
- SETUP_DIFF_1
- Deal Item Loc Explode-001
- SETUP_DIFF_2
- Deal Item Loc Explode-001
- SETUP_DIFF_3
- Deal Item Loc Explode-001
- SETUP_DIFF_4
- Deal Item Loc Explode-001
- SETUP_REGION
- 201
- CONTRIB_VALUE
- 11.0000
- COST_APPL_IND
- M
- DEAL_HEAD_TYPE
- PO
- SETUP_DISTRICT
- 301
- SETUP_DIVISION
- 0101
- SETUP_GROUP_NO
- 0002
- SETUP_LOCATION
- 1
- SETUP_SUBCLASS
- 1111
- CREATE_DATETIME
- 2026-01-01
- SETUP_ORG_LEVEL
- 1
- GET_FREE_DISCOUNT
- 11.0000
- SETUP_ITEM_PARENT
- Deal Item Loc Explode-001
- SETUP_MERCH_LEVEL
- company
- VEND_CONTRIB_TYPE
- percent
- QTY_THRESH_BUY_QTY
- 11.0000
- QTY_THRESH_GET_QTY
- 11.0000
- PRICE_COST_APPL_IND
- Deal Item Loc Explode-001
- QTY_THRESH_BUY_ITEM
- Deal Item Loc Explode-001
- QTY_THRESH_GET_ITEM
- Deal Item Loc Explode-001
- QTY_THRESH_GET_TYPE
- free
- QTY_THRESH_GET_VALUE
- 11.0000
- QTY_THRESH_RECUR_IND
- Y
- THRESHOLD_VALUE_TYPE
- off
- QTY_THRESH_BUY_TARGET
- 11.0000
- QTY_THRESH_BUY_AVG_LOC
- 11.0000
- SETUP_ITEM_GRANDPARENT
- Deal Item Loc Explode-001
- DEAL_DETAIL_APPLICATION_ORDER
- 1
- QTY_THRESH_FREE_ITEM_UNIT_COST
- 11.0000