Pend Merch Hier
In ScopeTechnical: PEND_MERCH_HIER | ID: OR-MFCS-PEND_MERCH_HIER
This table will hold all the addition/changes to the hierarchy structure for division, group, department, class and subclass level, so that a retailer can plan additions for the new division,…
See how this object fits into Foundation Data
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
- PEND_MERCH_HIER
Field Definitions(21)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | BUYERPK | MERCHPK | DOMAINPK | HIER_TYPER | ACTION_TYPER | MERCH_HIER_IDR | EFFECTIVE_DATER | MERCH_HIER_NAMER | BUD_INT | BUD_MKUP | OTB_CALC_TYPE | PURCHASE_TYPE | MAX_AVG_COUNTER | MARKUP_CALC_TYPE | PROFIT_CALC_TYPE | TOTAL_MARKET_AMT | AVG_TOLERANCE_PCT | DEPT_VAT_INCL_IND | CLASS_VAT_INCL_IND | MERCH_HIER_PARENT_ID | MERCH_HIER_GRANDPARENT_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 0001 | 0001 | 01 | Pend Merch Hier-001 | Pend Merch Hier-001 | 100001 | 2026-01-01 | Pend Merch Hier Primary | 11.0000 | 11.0000 | C | 0 | 00001 | C | 1 | 11.0000 | 11.0000 | Pend Merch Hier-001 | Pend Merch Hier-001 | 100001 | 100001 |
default
- BUYERPK
- 0001
- MERCHPK
- 0001
- DOMAINPK
- 01
- HIER_TYPER
- Pend Merch Hier-001
- ACTION_TYPER
- Pend Merch Hier-001
- MERCH_HIER_IDR
- 100001
- EFFECTIVE_DATER
- 2026-01-01
- MERCH_HIER_NAMER
- Pend Merch Hier Primary
- BUD_INT
- 11.0000
- BUD_MKUP
- 11.0000
- OTB_CALC_TYPE
- C
- PURCHASE_TYPE
- 0
- MAX_AVG_COUNTER
- 00001
- MARKUP_CALC_TYPE
- C
- PROFIT_CALC_TYPE
- 1
- TOTAL_MARKET_AMT
- 11.0000
- AVG_TOLERANCE_PCT
- 11.0000
- DEPT_VAT_INCL_IND
- Pend Merch Hier-001
- CLASS_VAT_INCL_IND
- Pend Merch Hier-001
- MERCH_HIER_PARENT_ID
- 100001
- MERCH_HIER_GRANDPARENT_ID
- 100001