RMS Oi Cum Markon Percent Variance

In Scope

Technical: RMS_OI_CUM_MARKON_PCT_VARIANCE | ID: OR-FND-RMS_OI_CUM_MARKON_PCT_VARIANCE-RMS_OI_CUM_MARKON_PERCENT_VARIANCE

Stores the information about subclass/location combinations having a cumulative markon variance that falls outside of a defined tolerance for the Cumulative markon% Variance Report.

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

Field Definitions(5)

Rules & Considerations(25)

Sample Load Data(4)

_scenario	LOC	DEPT	CLASS	EOM_DATE	LOC_NAME	LOC_TYPE	SUBCLASS	DEPT_NAME	CLASS_NAME	SESSION_ID	CLS_STK_COST	CURRENCY_CODE	HTD_GAFS_COST	SUBCLASS_NAME	CLS_STK_RETAIL	HTD_GAFS_RETAIL	POSTED_MARKON_PCT	BUDGETED_MARKON_PCT	VARIANCE_MARKON_PCT	CALCULATED_MARKON_PCT	CLS_STK_COST_PRIM_CUR	HTD_GAFS_COST_PRIM_CUR	CLS_STK_RETAIL_PRIM_CUR	HTD_GAFS_RETAIL_PRIM_CUR	LOC_EOM_DATE_SUBCLASS_CNT	SUBCLASS_EOM_DATE_LOC_CNT
Example values from field definitions	1	1	1	2026-01-01	SAMPLE	S	1	SAMPLE	SAMPLE	1	1.0000	SAM	1.0000	SAMPLE	1.0000	1.0000	1.0000000000	1.0000000000	1.0000000000	1.0000000000	1.0000	1.0000	1.0000	1.0000	1	1
default	3	1003	1103	2026-01-03	RMS Oi Cum Markon Pct Variance Secondary	R	1113	Footwear	Womenswear	1000000003	12.5000	ALT	12.5000	Fashion Range	12.5000	12.5000	12.5000000000	12.5000000000	12.5000000000	12.5000000000	12.5000	12.5000	12.5000	12.5000	3	3
default	5	1005	1105	2026-01-05	RMS Oi Cum Markon Pct Variance Core	R	1115	Beauty	Kidswear	1000000005	14.0000	EDG	14.0000	Value Range	14.0000	14.0000	14.0000000000	14.0000000000	14.0000000000	14.0000000000	14.0000	14.0000	14.0000	14.0000	5	5

Example values from field definitions

LOC: 1
DEPT: 1
CLASS: 1
EOM_DATE: 2026-01-01
LOC_NAME: SAMPLE
LOC_TYPE: S
SUBCLASS: 1
DEPT_NAME: SAMPLE
CLASS_NAME: SAMPLE
SESSION_ID: 1
CLS_STK_COST: 1.0000
CURRENCY_CODE: SAM
HTD_GAFS_COST: 1.0000
SUBCLASS_NAME: SAMPLE
CLS_STK_RETAIL: 1.0000
HTD_GAFS_RETAIL: 1.0000
POSTED_MARKON_PCT: 1.0000000000
BUDGETED_MARKON_PCT: 1.0000000000
VARIANCE_MARKON_PCT: 1.0000000000
CALCULATED_MARKON_PCT: 1.0000000000
CLS_STK_COST_PRIM_CUR: 1.0000
HTD_GAFS_COST_PRIM_CUR: 1.0000
CLS_STK_RETAIL_PRIM_CUR: 1.0000
HTD_GAFS_RETAIL_PRIM_CUR: 1.0000
LOC_EOM_DATE_SUBCLASS_CNT: 1
SUBCLASS_EOM_DATE_LOC_CNT: 1

default

LOC: 3
DEPT: 1003
CLASS: 1103
EOM_DATE: 2026-01-03
LOC_NAME: RMS Oi Cum Markon Pct Variance Secondary
LOC_TYPE: R
SUBCLASS: 1113
DEPT_NAME: Footwear
CLASS_NAME: Womenswear
SESSION_ID: 1000000003
CLS_STK_COST: 12.5000
CURRENCY_CODE: ALT
HTD_GAFS_COST: 12.5000
SUBCLASS_NAME: Fashion Range
CLS_STK_RETAIL: 12.5000
HTD_GAFS_RETAIL: 12.5000
POSTED_MARKON_PCT: 12.5000000000
BUDGETED_MARKON_PCT: 12.5000000000
VARIANCE_MARKON_PCT: 12.5000000000
CALCULATED_MARKON_PCT: 12.5000000000
CLS_STK_COST_PRIM_CUR: 12.5000
HTD_GAFS_COST_PRIM_CUR: 12.5000
CLS_STK_RETAIL_PRIM_CUR: 12.5000
HTD_GAFS_RETAIL_PRIM_CUR: 12.5000
LOC_EOM_DATE_SUBCLASS_CNT: 3
SUBCLASS_EOM_DATE_LOC_CNT: 3

default

LOC: 5
DEPT: 1005
CLASS: 1105
EOM_DATE: 2026-01-05
LOC_NAME: RMS Oi Cum Markon Pct Variance Core
LOC_TYPE: R
SUBCLASS: 1115
DEPT_NAME: Beauty
CLASS_NAME: Kidswear
SESSION_ID: 1000000005
CLS_STK_COST: 14.0000
CURRENCY_CODE: EDG
HTD_GAFS_COST: 14.0000
SUBCLASS_NAME: Value Range
CLS_STK_RETAIL: 14.0000
HTD_GAFS_RETAIL: 14.0000
POSTED_MARKON_PCT: 14.0000000000
BUDGETED_MARKON_PCT: 14.0000000000
VARIANCE_MARKON_PCT: 14.0000000000
CALCULATED_MARKON_PCT: 14.0000000000
CLS_STK_COST_PRIM_CUR: 14.0000
HTD_GAFS_COST_PRIM_CUR: 14.0000
CLS_STK_RETAIL_PRIM_CUR: 14.0000
HTD_GAFS_RETAIL_PRIM_CUR: 14.0000
LOC_EOM_DATE_SUBCLASS_CNT: 5
SUBCLASS_EOM_DATE_LOC_CNT: 5

Rule Validation Summary

Source Rule Count: 28
Governed Rule Count: 25

All objects