Stake SKU Location
In ScopeTechnical: STAKE_SKU_LOC | ID: OR-ITM-STAKE_SKU_LOC-STAKE_SKU_LOCATION
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STAKE_SKU_LOC
Field Definitions(23)
Rules & Considerations(35)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTR | ITEMR | CLASSR | LOCATIONR | LOC_TYPER | SUBCLASSR | CREATE_IDR | PROCESSEDR | CYCLE_COUNTRPK | PACK_COMP_QTYR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | DISTRIBUTE_QTY | IN_TRANSIT_AMT | XFORM_ITEM_TYPE | DEPOSIT_ITEM_TYPE | PHYSICAL_COUNT_QTY | SNAPSHOT_UNIT_COST | SNAPSHOT_ON_HAND_QTY | SNAPSHOT_SHIPPED_QTY | SNAPSHOT_UNIT_RETAIL | SNAPSHOT_IN_TRANSIT_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | S | 1 | SAMPLE | S | 1 | 1.0000 | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | S | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
Example values from field definitions
- DEPTR
- 1
- ITEMR
- SAMPLE
- CLASSR
- 1
- LOCATIONR
- 1
- LOC_TYPER
- S
- SUBCLASSR
- 1
- CREATE_IDR
- SAMPLE
- PROCESSEDR
- S
- CYCLE_COUNTRPK
- 1
- PACK_COMP_QTYR
- 1.0000
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- DISTRIBUTE_QTY
- 1.0000
- IN_TRANSIT_AMT
- 1.0000
- XFORM_ITEM_TYPE
- S
- DEPOSIT_ITEM_TYPE
- S
- PHYSICAL_COUNT_QTY
- 1.0000
- SNAPSHOT_UNIT_COST
- 1.0000
- SNAPSHOT_ON_HAND_QTY
- 1.0000
- SNAPSHOT_SHIPPED_QTY
- 1.0000
- SNAPSHOT_UNIT_RETAIL
- 1.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 1.0000
Rule Validation Summary
- Source Rule Count
- 49
- Governed Rule Count
- 35