Alc Svc Item Parent Loc

In Scope

Technical: ALC_SVC_ITEM_PARENT_LOC | ID: OR-RACS-ALC_SVC_ITEM_PARENT_LOC

Stores stage data for allocation parent item locations.

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_SVC_ITEM_PARENT_LOC

Field Definitions(35)

Rules & Considerations(73)

Sample Load Data(4)

default

COST
11.0000
WH_ID
STD-ALC_SVC-001
ACTION
Alc Svc Item Parent Loc-001
ROW_ID
100001
SOM_QTY
11.0000
ALLOC_ID
1000000001
LOC_TYPE
Alc Svc Item Parent Loc-001
NEED_QTY
11.0000
ON_ALLOC
11.0000
ON_ORDER
11.0000
ORDER_NO
Alc Svc Item Parent Loc-001
RLOH_QTY
11.0000
ALLOC_OUT
11.0000
ERROR_MSG
Alc Svc Item Parent Loc-001
ITEM_DESC
Alc Svc Item Parent Loc-001
ITEM_NODE
Alc Svc Item Parent Loc-001
ITEM_TYPE
Alc Svc Item Parent Loc-001
RUSH_FLAG
Alc Svc Item Parent Loc-001
FREEZE_IND
Alc Svc Item Parent Loc-001
IN_TRANSIT
11.0000
LOCATION_ID
STD-ALC_SVC-001
SOURCE_TYPE
1
RELEASE_DATE
2026-01-01
WORKSPACE_ID
1000000001
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_SVC-001
PROCESS$STATUS
ACTIVE
TOTAL_ON_HAND_QTY
11.0000
FUTURE_UNIT_RETAIL
11.0000
ITEM_PARENT_LOC_ID
1000000001
Alc Svc Item Parent Loc | undefined | Oracle Retail