Alc Svc Item Loc
In ScopeTechnical: ALC_SVC_ITEM_LOC | ID: OR-RACS-ALC_SVC_ITEM_LOC
Stores stage data for allocation 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_LOC
Field Definitions(45)
Rules & Considerations(95)
Sample Load Data(4)
| _scenario | COST | WH_ID | ACTION | ROW_ID | ITEM_ID | SOM_QTY | ALLOC_ID | DIFF1_ID | DIFF2_ID | DIFF3_ID | LOC_TYPE | NEED_QTY | ON_ALLOC | ON_ORDER | ORDER_NO | RLOH_QTY | ALLOC_OUT | ERROR_MSG | ITEM_DESC | ITEM_TYPE | RUSH_FLAG | DIFF1_DESC | DIFF2_DESC | DIFF3_DESC | FREEZE_IND | IN_TRANSIT | ITEM_LOC_ID | LOCATION_ID | SOURCE_TYPE | RELEASE_DATE | WORKSPACE_ID | ALLOCATED_QTY | BACKORDER_QTY | IN_STORE_DATE | LOCATION_DESC | STOCK_ON_HAND | CALCULATED_QTY | GROSS_NEED_QTY | PARENT_ITEM_ID | PROCESS$STATUS | PARENT_DIFF1_ID | CREATED_ORDER_NO | TOTAL_ON_HAND_QTY | FUTURE_UNIT_RETAIL | CREATED_SUPPLIER_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | STD-ALC_SVC-001 | Alc Svc Item Loc-001 | 100001 | STD-ALC_SVC-001 | 11.0000 | 1000000001 | STD-ALC_SVC-001 | STD-ALC_SVC-001 | STD-ALC_SVC-001 | Alc Svc Item Loc-001 | 11.0000 | 11.0000 | 11.0000 | Alc Svc Item Loc-001 | 0 | 11.0000 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | Alc Svc Item Loc-001 | 11.0000 | 1000000001 | STD-ALC_SVC-001 | 1 | 2026-01-01 | 1000000001 | 11.0000 | 11.0000 | 2026-01-01 | Alc Svc Item Loc-001 | 11.0000 | 11.0000 | 0 | STD-ALC_SVC-001 | ACTIVE | STD-ALC_SVC-001 | Alc Svc Item Loc-001 | 11.0000 | 11.0000 | STD-ALC_SVC-001 |
default
- COST
- 11.0000
- WH_ID
- STD-ALC_SVC-001
- ACTION
- Alc Svc Item Loc-001
- ROW_ID
- 100001
- ITEM_ID
- STD-ALC_SVC-001
- SOM_QTY
- 11.0000
- ALLOC_ID
- 1000000001
- DIFF1_ID
- STD-ALC_SVC-001
- DIFF2_ID
- STD-ALC_SVC-001
- DIFF3_ID
- STD-ALC_SVC-001
- LOC_TYPE
- Alc Svc Item Loc-001
- NEED_QTY
- 11.0000
- ON_ALLOC
- 11.0000
- ON_ORDER
- 11.0000
- ORDER_NO
- Alc Svc Item Loc-001
- RLOH_QTY
- 0
- ALLOC_OUT
- 11.0000
- ERROR_MSG
- Alc Svc Item Loc-001
- ITEM_DESC
- Alc Svc Item Loc-001
- ITEM_TYPE
- Alc Svc Item Loc-001
- RUSH_FLAG
- Alc Svc Item Loc-001
- DIFF1_DESC
- Alc Svc Item Loc-001
- DIFF2_DESC
- Alc Svc Item Loc-001
- DIFF3_DESC
- Alc Svc Item Loc-001
- FREEZE_IND
- Alc Svc Item Loc-001
- IN_TRANSIT
- 11.0000
- ITEM_LOC_ID
- 1000000001
- 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
- LOCATION_DESC
- Alc Svc Item Loc-001
- STOCK_ON_HAND
- 11.0000
- CALCULATED_QTY
- 11.0000
- GROSS_NEED_QTY
- 0
- PARENT_ITEM_ID
- STD-ALC_SVC-001
- PROCESS$STATUS
- ACTIVE
- PARENT_DIFF1_ID
- STD-ALC_SVC-001
- CREATED_ORDER_NO
- Alc Svc Item Loc-001
- TOTAL_ON_HAND_QTY
- 11.0000
- FUTURE_UNIT_RETAIL
- 11.0000
- CREATED_SUPPLIER_ID
- STD-ALC_SVC-001