Allocation Ideal Weeks Of Supply

In Scope

Technical: ALC_IDEAL_WEEKS_OF_SUPPLY | ID: OR-ALLOC-ALC_IDEAL_WEEKS_OF_SUPPLY-ACTUAL_LANDED_COST_IDEAL_WEEKS_OF_SUPPLY

Stores a unique ideal weeks-of-supply value for each location. this data is expected to be populated from an external system.

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_IDEAL_WEEKS_OF_SUPPLY

Field Definitions(5)

Rules & Considerations(12)

constraint

validation

Sample Load Data(4)

_scenario	LOCATION_IDR	IDEAL_WEEKS_OF_SUPPLY_IDRPK	DEPT	CLASS	ITEM_ID	DIFF1_ID	SUBCLASS	IWOS_WEEKS
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000
default	ALT-ALC_IDEAL-002	1000000003	Alc Ideal Weeks Of Supply-002-ALT	Alc Ideal Weeks Of Supply-002-ALT	ALT-ALC_IDEAL-002	ALT-ALC_IDEAL-002	Alc Ideal Weeks Of Supply-002-ALT	12.5000
default	EDGE-ALC_IDEAL-003	1000000005	Alc Ideal Weeks Of Supply-003-EDGE	Alc Ideal Weeks Of Supply-003-EDGE	EDGE-ALC_IDEAL-003	EDGE-ALC_IDEAL-003	Alc Ideal Weeks Of Supply-003-EDGE	14.0000

Example values from field definitions

LOCATION_IDR: SAMPLE
IDEAL_WEEKS_OF_SUPPLY_IDRPK: 1
DEPT: SAMPLE
CLASS: SAMPLE
ITEM_ID: SAMPLE
DIFF1_ID: SAMPLE
SUBCLASS: SAMPLE
IWOS_WEEKS: 1.0000

default

LOCATION_IDR: ALT-ALC_IDEAL-002
IDEAL_WEEKS_OF_SUPPLY_IDRPK: 1000000003
DEPT: Alc Ideal Weeks Of Supply-002-ALT
CLASS: Alc Ideal Weeks Of Supply-002-ALT
ITEM_ID: ALT-ALC_IDEAL-002
DIFF1_ID: ALT-ALC_IDEAL-002
SUBCLASS: Alc Ideal Weeks Of Supply-002-ALT
IWOS_WEEKS: 12.5000

default

LOCATION_IDR: EDGE-ALC_IDEAL-003
IDEAL_WEEKS_OF_SUPPLY_IDRPK: 1000000005
DEPT: Alc Ideal Weeks Of Supply-003-EDGE
CLASS: Alc Ideal Weeks Of Supply-003-EDGE
ITEM_ID: EDGE-ALC_IDEAL-003
DIFF1_ID: EDGE-ALC_IDEAL-003
SUBCLASS: Alc Ideal Weeks Of Supply-003-EDGE
IWOS_WEEKS: 14.0000

Rule Validation Summary

Source Rule Count: 18
Governed Rule Count: 12