Pend Merchandising Hierarchy

In Scope

Technical: 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(5)

Rules & Considerations(34)

validation

constraint

Sample Load Data(4)

_scenario	HIER_TYPER	MERCH_HIER_IDR	EFFECTIVE_DATER	BUYER	MERCH	DOMAIN	BUD_INT	BUD_MKUP	ACTION_TYPE	OTB_CALC_TYPE	PURCHASE_TYPE	MAX_AVG_COUNTER	MERCH_HIER_NAME	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	S	1	2026-01-01	1	1	1	1.0000	1.0000	S	S	1	1	SAMPLE	SA	1	1.0000	1.0000	S	S	1	1
default	P	100003	2026-01-03	3	3	3	12.5000	12.5000	P	C	0	3	Pend Merch Hier Secondary	C	1	12.5000	12.5000	P	P	100003	100003
default	P	100005	2026-01-05	5	5	5	14.0000	14.0000	P	C	0	5	Pend Merch Hier Core	C	1	14.0000	14.0000	P	P	100005	100005

Example values from field definitions

HIER_TYPER: S
MERCH_HIER_IDR: 1
EFFECTIVE_DATER: 2026-01-01
BUYER: 1
MERCH: 1
DOMAIN: 1
BUD_INT: 1.0000
BUD_MKUP: 1.0000
ACTION_TYPE: S
OTB_CALC_TYPE: S
PURCHASE_TYPE: 1
MAX_AVG_COUNTER: 1
MERCH_HIER_NAME: SAMPLE
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

default

HIER_TYPER: P
MERCH_HIER_IDR: 100003
EFFECTIVE_DATER: 2026-01-03
BUYER: 3
MERCH: 3
DOMAIN: 3
BUD_INT: 12.5000
BUD_MKUP: 12.5000
ACTION_TYPE: P
OTB_CALC_TYPE: C
PURCHASE_TYPE: 0
MAX_AVG_COUNTER: 3
MERCH_HIER_NAME: Pend Merch Hier Secondary
MARKUP_CALC_TYPE: C
PROFIT_CALC_TYPE: 1
TOTAL_MARKET_AMT: 12.5000
AVG_TOLERANCE_PCT: 12.5000
DEPT_VAT_INCL_IND: P
CLASS_VAT_INCL_IND: P
MERCH_HIER_PARENT_ID: 100003
MERCH_HIER_GRANDPARENT_ID: 100003