Allocation Item Parent Location
In ScopeTechnical: ALC_ITEM_PARENT_LOC | ID: OR-ALLOC-ALC_ITEM_PARENT_LOC-ACTUAL_LANDED_COST_ITEM_PARENT_LOCATION
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ALC_ITEM_PARENT_LOC
Field Definitions(5)
Rules & Considerations(36)
constraint
validation
Sample Load Data(4)
| _scenario | WH_IDR | ALLOC_IDR | ITEM_NODER | LOCATION_IDR | ITEM_PARENT_LOC_IDRPK | COST | SOM_QTY | LOC_TYPE | NEED_QTY | ON_ALLOC | ON_ORDER | ORDER_NO | RLOH_QTY | ALLOC_OUT | ITEM_DESC | ITEM_TYPE | RUSH_FLAG | FREEZE_IND | IN_TRANSIT | SOURCE_TYPE | RELEASE_DATE | ALLOCATED_QTY | BACKORDER_QTY | IN_STORE_DATE | STOCK_ON_HAND | CALCULATED_QTY | GROSS_NEED_QTY | PARENT_ITEM_ID | TOTAL_ON_HAND_QTY | FUTURE_UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAMPLE | S | S | 1.0000 | 1 | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 |
| default | ALT-ALC_ITEM-002 | 1000000003 | Alc Item Parent Loc-002-ALT | ALT-ALC_ITEM-002 | 1000000003 | 12.5000 | 12.5000 | A | 12.5000 | 12.5000 | 12.5000 | Alc Item Parent Loc-002-ALT | 12.5000 | 12.5000 | Alc Item Parent Loc-002-ALT | Alc Item P | A | A | 12.5000 | 2 | 2026-01-03 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | ALT-ALC_ITEM-002 | 12.5000 | 12.5000 |
| default | EDGE-ALC_ITEM-003 | 1000000005 | Alc Item Parent Loc-003-EDGE | EDGE-ALC_ITEM-003 | 1000000005 | 14.0000 | 14.0000 | A | 14.0000 | 14.0000 | 14.0000 | Alc Item Parent Loc-003-EDGE | 14.0000 | 14.0000 | Alc Item Parent Loc-003-EDGE | Alc Item P | A | A | 14.0000 | 3 | 2026-01-05 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | EDGE-ALC_ITEM-003 | 14.0000 | 14.0000 |
Example values from field definitions
- WH_IDR
- SAMPLE
- ALLOC_IDR
- 1
- ITEM_NODER
- SAMPLE
- LOCATION_IDR
- SAMPLE
- ITEM_PARENT_LOC_IDRPK
- 1
- COST
- 1.0000
- SOM_QTY
- 1.0000
- LOC_TYPE
- S
- NEED_QTY
- 1.0000
- ON_ALLOC
- 1.0000
- ON_ORDER
- 1.0000
- ORDER_NO
- SAMPLE
- RLOH_QTY
- 1.0000
- ALLOC_OUT
- 1.0000
- ITEM_DESC
- SAMPLE
- ITEM_TYPE
- SAMPLE
- RUSH_FLAG
- S
- FREEZE_IND
- S
- IN_TRANSIT
- 1.0000
- SOURCE_TYPE
- 1
- RELEASE_DATE
- 2026-01-01
- ALLOCATED_QTY
- 1.0000
- BACKORDER_QTY
- 1.0000
- IN_STORE_DATE
- 2026-01-01
- STOCK_ON_HAND
- 1.0000
- CALCULATED_QTY
- 1.0000
- GROSS_NEED_QTY
- 1.0000
- PARENT_ITEM_ID
- SAMPLE
- TOTAL_ON_HAND_QTY
- 1.0000
- FUTURE_UNIT_RETAIL
- 1.0000
default
- WH_IDR
- ALT-ALC_ITEM-002
- ALLOC_IDR
- 1000000003
- ITEM_NODER
- Alc Item Parent Loc-002-ALT
- LOCATION_IDR
- ALT-ALC_ITEM-002
- ITEM_PARENT_LOC_IDRPK
- 1000000003
- COST
- 12.5000
- SOM_QTY
- 12.5000
- LOC_TYPE
- A
- NEED_QTY
- 12.5000
- ON_ALLOC
- 12.5000
- ON_ORDER
- 12.5000
- ORDER_NO
- Alc Item Parent Loc-002-ALT
- RLOH_QTY
- 12.5000
- ALLOC_OUT
- 12.5000
- ITEM_DESC
- Alc Item Parent Loc-002-ALT
- ITEM_TYPE
- Alc Item P
- RUSH_FLAG
- A
- FREEZE_IND
- A
- IN_TRANSIT
- 12.5000
- SOURCE_TYPE
- 2
- RELEASE_DATE
- 2026-01-03
- ALLOCATED_QTY
- 12.5000
- BACKORDER_QTY
- 12.5000
- IN_STORE_DATE
- 2026-01-03
- STOCK_ON_HAND
- 12.5000
- CALCULATED_QTY
- 12.5000
- GROSS_NEED_QTY
- 12.5000
- PARENT_ITEM_ID
- ALT-ALC_ITEM-002
- TOTAL_ON_HAND_QTY
- 12.5000
- FUTURE_UNIT_RETAIL
- 12.5000
default
- WH_IDR
- EDGE-ALC_ITEM-003
- ALLOC_IDR
- 1000000005
- ITEM_NODER
- Alc Item Parent Loc-003-EDGE
- LOCATION_IDR
- EDGE-ALC_ITEM-003
- ITEM_PARENT_LOC_IDRPK
- 1000000005
- COST
- 14.0000
- SOM_QTY
- 14.0000
- LOC_TYPE
- A
- NEED_QTY
- 14.0000
- ON_ALLOC
- 14.0000
- ON_ORDER
- 14.0000
- ORDER_NO
- Alc Item Parent Loc-003-EDGE
- RLOH_QTY
- 14.0000
- ALLOC_OUT
- 14.0000
- ITEM_DESC
- Alc Item Parent Loc-003-EDGE
- ITEM_TYPE
- Alc Item P
- RUSH_FLAG
- A
- FREEZE_IND
- A
- IN_TRANSIT
- 14.0000
- SOURCE_TYPE
- 3
- RELEASE_DATE
- 2026-01-05
- ALLOCATED_QTY
- 14.0000
- BACKORDER_QTY
- 14.0000
- IN_STORE_DATE
- 2026-01-05
- STOCK_ON_HAND
- 14.0000
- CALCULATED_QTY
- 14.0000
- GROSS_NEED_QTY
- 14.0000
- PARENT_ITEM_ID
- EDGE-ALC_ITEM-003
- TOTAL_ON_HAND_QTY
- 14.0000
- FUTURE_UNIT_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 36