Alc Item Parent Loc

In Scope

Technical: ALC_ITEM_PARENT_LOC | ID: OR-RACS-ALC_ITEM_PARENT_LOC

Recalculation Table, This table stores information at Style/Color or Fashion Pack Group level when Recalculation is the action.

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

Target Structure

Load Approach
Table
Target Objects
ALC_ITEM_PARENT_LOC

Field Definitions(30)

Rules & Considerations(72)

Sample Load Data(4)

default

WH_IDR
STD-ALC_ITEM-001
ALLOC_IDR
1000000001
ITEM_NODER
Alc Item Parent Loc-001
LOCATION_IDR
STD-ALC_ITEM-001
SOURCE_TYPER
1
RELEASE_DATER
2026-01-01
ITEM_PARENT_LOC_IDRPK
1000000001
COST
11.0000
SOM_QTY
11.0000
LOC_TYPE
Alc Item Parent Loc-001
NEED_QTY
11.0000
ON_ALLOC
11.0000
ON_ORDER
11.0000
ORDER_NO
Alc Item Parent Loc-001
RLOH_QTY
11.0000
ALLOC_OUT
11.0000
ITEM_DESC
Alc Item Parent Loc-001
ITEM_TYPE
Alc Item Parent Loc-001
RUSH_FLAG
Alc Item Parent Loc-001
FREEZE_IND
Alc Item Parent Loc-001
IN_TRANSIT
11.0000
ALLOCATED_QTY
11.0000
BACKORDER_QTY
11.0000
IN_STORE_DATE
2026-01-01
STOCK_ON_HAND
11.0000
CALCULATED_QTY
11.0000
GROSS_NEED_QTY
11.0000
PARENT_ITEM_ID
STD-ALC_ITEM-001
TOTAL_ON_HAND_QTY
11.0000
FUTURE_UNIT_RETAIL
11.0000
Alc Item Parent Loc | undefined | Oracle Retail