Pend Merchandising Hierarchy
In ScopeTechnical: PEND_MERCH_HIER | ID: OR-FND-PEND_MERCH_HIER-PEND_MERCHANDISING_HIERARCHY
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PEND_MERCH_HIER
Field Definitions(21)
Rules & Considerations(31)
validation
constraint
Sample Load Data(4)
| _scenario | BUYERRPK | MERCHRPK | DOMAINRPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | S | 1 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | S | 1 | 1 | SA | 1 | 1.0000 | 1.0000 | S | S | 1 | 1 |
Example values from field definitions
- BUYERRPK
- 1
- MERCHRPK
- 1
- DOMAINRPK
- 1
- HIER_TYPER
- S
- ACTION_TYPER
- S
- MERCH_HIER_IDR
- 1
- EFFECTIVE_DATER
- 2026-01-01
- MERCH_HIER_NAMER
- SAMPLE
- BUD_INT
- 1.0000
- BUD_MKUP
- 1.0000
- OTB_CALC_TYPE
- S
- PURCHASE_TYPE
- 1
- MAX_AVG_COUNTER
- 1
- MARKUP_CALC_TYPE
- SA
- PROFIT_CALC_TYPE
- 1
- TOTAL_MARKET_AMT
- 1.0000
- AVG_TOLERANCE_PCT
- 1.0000
- DEPT_VAT_INCL_IND
- S
- CLASS_VAT_INCL_IND
- S
- MERCH_HIER_PARENT_ID
- 1
- MERCH_HIER_GRANDPARENT_ID
- 1
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 31