Size Profile Information Used

In Scope

Technical: ALC_SIZE_PROFILE | ID: OR-ALLOC-ALC_SIZE_PROFILE-ACTUAL_LANDED_COST_SIZE_PROFILE

Stores all size profile information used within allocation. this data is used to spread the aggregate need to the sku level within the calculation process.

See how this object fits into Allocations

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

Field Definitions(5)

Rules & Considerations(31)

constraint

validation

Sample Load Data(4)

_scenario	LOCR	SIZE_PROFILE_IDRPK	QTY	DEPT	CLASS	SIZE1	SIZE2	SIZE3	SIZE4	STYLE	SUBCLASS	CREATED_BY	SIZE_GROUP1	SIZE_GROUP2	GID_PROFILE_ID	SIZE_PROFILE_LEVEL	OBJECT_VERSION_NUMBER	CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY	LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN
Example values from field definitions	SAMPLE	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	1	SAMPLE	SAMPLE
default	Alc Size Profile-002-ALT	1000000003	12.5000	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	Alc Size Profile-002-ALT	1000000003	3	3	2026-01-02-ALT	2026-01-02-ALT
default	Alc Size Profile-003-EDGE	1000000005	14.0000	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	Alc Size Profile-003-EDGE	1000000005	5	5	2026-01-03-EDGE	2026-01-03-EDGE

Example values from field definitions

LOCR: SAMPLE
SIZE_PROFILE_IDRPK: 1
QTY: 1.0000
DEPT: SAMPLE
CLASS: SAMPLE
SIZE1: SAMPLE
SIZE2: SAMPLE
SIZE3: SAMPLE
SIZE4: SAMPLE
STYLE: SAMPLE
SUBCLASS: SAMPLE
CREATED_BY: SAMPLE
SIZE_GROUP1: SAMPLE
SIZE_GROUP2: SAMPLE
GID_PROFILE_ID: 1
SIZE_PROFILE_LEVEL: 1
OBJECT_VERSION_NUMBER: 1
CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN: SAMPLE

default

LOCR: Alc Size Profile-002-ALT
SIZE_PROFILE_IDRPK: 1000000003
QTY: 12.5000
DEPT: Alc Size Profile-002-ALT
CLASS: Alc Size Profile-002-ALT
SIZE1: Alc Size Profile-002-ALT
SIZE2: Alc Size Profile-002-ALT
SIZE3: Alc Size Profile-002-ALT
SIZE4: Alc Size Profile-002-ALT
STYLE: Alc Size Profile-002-ALT
SUBCLASS: Alc Size Profile-002-ALT
CREATED_BY: Alc Size Profile-002-ALT
SIZE_GROUP1: Alc Size Profile-002-ALT
SIZE_GROUP2: Alc Size Profile-002-ALT
GID_PROFILE_ID: 1000000003
SIZE_PROFILE_LEVEL: 3
OBJECT_VERSION_NUMBER: 3
CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY: 2026-01-02-ALT
LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN: 2026-01-02-ALT