Diff Ratio Head

In Scope

Technical: DIFF_RATIO_HEAD | ID: OR-MFCS-DIFF_RATIO_HEAD

This table will hold all the dept/class/subclass parameters that are used to build size ratios.

See how this object fits into Item Management

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

Field Definitions(19)

Rules & Considerations(26)

Sample Load Data(4)

_scenario	DEPTRPK	CLASSR	SUBCLASSR	DESCRIPTIONR	DIFF_GROUP_1R	DIFF_RATIO_IDRPK	SYSTEM_GEN_INDR	END_DATE	START_DATE	UPDATE_IND	WEEKS_BACK	PERIOD_TYPE	DIFF_GROUP_2	DIFF_GROUP_3	REVIEW_WEEKS	PROM_SALES_IND	CLEAR_SALES_IND	LAST_REVIEW_DATE	REGULAR_SALES_IND
default	1001	1101	1111	Diff Ratio Head-001	Diff Ratio Head-001	100001	Diff Ratio Head-001	2026-01-01	2026-01-01	2026-01-01	001	Date-to	Diff Ratio Head-001	Diff Ratio Head-001	001	Diff Ratio Head-001	Diff Ratio Head-001	2026-01-01	Diff Ratio Head-001

default

DEPTRPK: 1001
CLASSR: 1101
SUBCLASSR: 1111
DESCRIPTIONR: Diff Ratio Head-001
DIFF_GROUP_1R: Diff Ratio Head-001
DIFF_RATIO_IDRPK: 100001
SYSTEM_GEN_INDR: Diff Ratio Head-001
END_DATE: 2026-01-01
START_DATE: 2026-01-01
UPDATE_IND: 2026-01-01
WEEKS_BACK: 001
PERIOD_TYPE: Date-to
DIFF_GROUP_2: Diff Ratio Head-001
DIFF_GROUP_3: Diff Ratio Head-001
REVIEW_WEEKS: 001
PROM_SALES_IND: Diff Ratio Head-001
CLEAR_SALES_IND: Diff Ratio Head-001
LAST_REVIEW_DATE: 2026-01-01
REGULAR_SALES_IND: Diff Ratio Head-001