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(5)
Rules & Considerations(41)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONRPK | LOC_TYPERPK | CYCLE_COUNTRPK | DEPT | CLASS | SUBCLASS | CREATE_ID | PROCESSED | PACK_COMP_QTY | DISTRIBUTE_QTY | IN_TRANSIT_AMT | LAST_UPDATE_ID | CREATE_DATETIME | XFORM_ITEM_TYPE | DEPOSIT_ITEM_TYPE | PHYSICAL_COUNT_QTY | SNAPSHOT_UNIT_COST | LAST_UPDATE_DATETIME | SNAPSHOT_ON_HAND_QTY | SNAPSHOT_SHIPPED_QTY | SNAPSHOT_UNIT_RETAIL | SNAPSHOT_IN_TRANSIT_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 1 | 1 | 1 | 1 | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 | S | S | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
| default | Stake SKU Loc-002-ALT | 3 | S | 3 | 1003 | 1103 | 1113 | CLIENT_INFO | S | 12.5000 | 12.5000 | 12.5000 | CLIENT_INFO | 2026-01-03 | S | E | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | Stake SKU Loc-003-EDGE | 5 | S | 5 | 1005 | 1105 | 1115 | SESSION_USER | S | 14.0000 | 14.0000 | 14.0000 | SESSION_USER | 2026-01-05 | S | E | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONRPK
- 1
- LOC_TYPERPK
- S
- CYCLE_COUNTRPK
- 1
- DEPT
- 1
- CLASS
- 1
- SUBCLASS
- 1
- CREATE_ID
- SAMPLE
- PROCESSED
- S
- PACK_COMP_QTY
- 1.0000
- DISTRIBUTE_QTY
- 1.0000
- IN_TRANSIT_AMT
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- XFORM_ITEM_TYPE
- S
- DEPOSIT_ITEM_TYPE
- S
- PHYSICAL_COUNT_QTY
- 1.0000
- SNAPSHOT_UNIT_COST
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- SNAPSHOT_ON_HAND_QTY
- 1.0000
- SNAPSHOT_SHIPPED_QTY
- 1.0000
- SNAPSHOT_UNIT_RETAIL
- 1.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 1.0000
default
- ITEMRPK
- Stake SKU Loc-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPERPK
- S
- CYCLE_COUNTRPK
- 3
- DEPT
- 1003
- CLASS
- 1103
- SUBCLASS
- 1113
- CREATE_ID
- CLIENT_INFO
- PROCESSED
- S
- PACK_COMP_QTY
- 12.5000
- DISTRIBUTE_QTY
- 12.5000
- IN_TRANSIT_AMT
- 12.5000
- LAST_UPDATE_ID
- CLIENT_INFO
- CREATE_DATETIME
- 2026-01-03
- XFORM_ITEM_TYPE
- S
- DEPOSIT_ITEM_TYPE
- E
- PHYSICAL_COUNT_QTY
- 12.5000
- SNAPSHOT_UNIT_COST
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- SNAPSHOT_ON_HAND_QTY
- 12.5000
- SNAPSHOT_SHIPPED_QTY
- 12.5000
- SNAPSHOT_UNIT_RETAIL
- 12.5000
- SNAPSHOT_IN_TRANSIT_QTY
- 12.5000
default
- ITEMRPK
- Stake SKU Loc-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPERPK
- S
- CYCLE_COUNTRPK
- 5
- DEPT
- 1005
- CLASS
- 1105
- SUBCLASS
- 1115
- CREATE_ID
- SESSION_USER
- PROCESSED
- S
- PACK_COMP_QTY
- 14.0000
- DISTRIBUTE_QTY
- 14.0000
- IN_TRANSIT_AMT
- 14.0000
- LAST_UPDATE_ID
- SESSION_USER
- CREATE_DATETIME
- 2026-01-05
- XFORM_ITEM_TYPE
- S
- DEPOSIT_ITEM_TYPE
- E
- PHYSICAL_COUNT_QTY
- 14.0000
- SNAPSHOT_UNIT_COST
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- SNAPSHOT_ON_HAND_QTY
- 14.0000
- SNAPSHOT_SHIPPED_QTY
- 14.0000
- SNAPSHOT_UNIT_RETAIL
- 14.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 55
- Governed Rule Count
- 41