Stake SKU Loc

In Scope

Technical: STAKE_SKU_LOC | ID: OR-MFCS-STAKE_SKU_LOC

Stores a row for each SKU/location combination for a stock count.

See how this object fits into Item Management

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
STAKE_SKU_LOC

Field Definitions(23)

Rules & Considerations(42)

Sample Load Data(4)

default

DEPTR
1001
ITEMR
Stake SKU Loc-001
CLASSR
1101
LOCATIONR
1
LOC_TYPER
Stake SKU Loc-001
SUBCLASSR
1111
CREATE_IDR
USERENV
PROCESSEDR
Stake SKU Loc-001
CYCLE_COUNTRPK
1
PACK_COMP_QTYR
11.0000
LAST_UPDATE_IDR
USERENV
CREATE_DATETIMER
2026-01-01
LAST_UPDATE_DATETIMER
2026-01-01
DISTRIBUTE_QTY
11.0000
IN_TRANSIT_AMT
11.0000
XFORM_ITEM_TYPE
S
DEPOSIT_ITEM_TYPE
E
PHYSICAL_COUNT_QTY
11.0000
SNAPSHOT_UNIT_COST
11.0000
SNAPSHOT_ON_HAND_QTY
11.0000
SNAPSHOT_SHIPPED_QTY
11.0000
SNAPSHOT_UNIT_RETAIL
11.0000
SNAPSHOT_IN_TRANSIT_QTY
11.0000
Stake SKU Loc | undefined | Oracle Retail