Subclass Sales History

In Scope

Technical: SUBCLASS_SALES_HIST | ID: OR-FIN-SUBCLASS_SALES_HIST-SUBCLASS_SALES_HISTORY

Stores one row for each subclass/location/week/sales type combination. Sales history, forecast and plan information about each combination is held.

See how this object fits into Finance

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

Field Definitions(5)

Rules & Considerations(24)

constraint

validation

Sample Load Data(4)

_scenario	DEPTRPK	CLASSRPK	STORERPK	EOW_DATERPK	SUBCLASSRPK	GP	SALES	VALUE	WEEK_454	YEAR_454	MONTH_454	PLAN_SALES	SALES_TYPE
Example values from field definitions	1	1	1	2026-01-01	1	1.0000	1.0000	1.0000	1	1	1	1.0000	S
default	1003	1103	1003	2026-01-03	1113	12.5000	12.5000	12.5000	3	3	3	12.5000	R
default	1005	1105	1005	2026-01-05	1115	14.0000	14.0000	14.0000	5	5	5	14.0000	R

Example values from field definitions

DEPTRPK: 1
CLASSRPK: 1
STORERPK: 1
EOW_DATERPK: 2026-01-01
SUBCLASSRPK: 1
GP: 1.0000
SALES: 1.0000
VALUE: 1.0000
WEEK_454: 1
YEAR_454: 1
MONTH_454: 1
PLAN_SALES: 1.0000
SALES_TYPE: S

default

DEPTRPK: 1003
CLASSRPK: 1103
STORERPK: 1003
EOW_DATERPK: 2026-01-03
SUBCLASSRPK: 1113
GP: 12.5000
SALES: 12.5000
VALUE: 12.5000
WEEK_454: 3
YEAR_454: 3
MONTH_454: 3
PLAN_SALES: 12.5000
SALES_TYPE: R

default

DEPTRPK: 1005
CLASSRPK: 1105
STORERPK: 1005
EOW_DATERPK: 2026-01-05
SUBCLASSRPK: 1115
GP: 14.0000
SALES: 14.0000
VALUE: 14.0000
WEEK_454: 5
YEAR_454: 5
MONTH_454: 5
PLAN_SALES: 14.0000
SALES_TYPE: R

Rule Validation Summary

Source Rule Count: 35
Governed Rule Count: 24