Allocation Session Item Location
In ScopeTechnical: ALC_SESSION_ITEM_LOC | ID: OR-ALLOC-ALC_SESSION_ITEM_LOC-ACTUAL_LANDED_COST_SESSION_ITEM_LOCATION
Table stores Item and Location session information for an Allocation. On Load this table will be loaded from Alc_item_source and Alc_item_loc tables.
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_SESSION_ITEM_LOC
Field Definitions(5)
Rules & Considerations(58)
Sample Load Data(4)
| _scenario | FACET_SESSION_IDR | ITEM_LOC_SESSION_IDRPK | COST | WH_ID | ITEM_ID | SOM_QTY | ALLOC_ID | DIFF1_ID | DIFF2_ID | DIFF3_ID | GROUP_ID | LOC_TYPE | NEED_QTY | ON_ALLOC | ON_ORDER | ORDER_NO | RLOH_QTY | ALLOC_OUT | ITEM_DESC | ITEM_TYPE | RUSH_FLAG | CREATED_BY | DIFF1_DESC | DIFF2_DESC | DIFF3_DESC | FREEZE_IND | GROUP_DESC | GROUP_TYPE | IN_TRANSIT | UPDATED_BY | ITEM_LOC_ID | LOCATION_ID | ON_HAND_QTY | SOURCE_TYPE | UPDATE_DATE | CREATED_DATE | FILTERED_IND | LOC_GROUP_ID | RELEASE_DATE | ALLOCATED_QTY | BACKORDER_QTY | IN_STORE_DATE | LOCATION_DESC | PACK_COMP_QTY | CALCULATED_QTY | GROSS_NEED_QTY | PARENT_ITEM_ID | QBE_FILTER_IND | NEXT_1_WEEK_QTY | NEXT_2_WEEK_QTY | NEXT_3_WEEK_QTY | CREATED_ORDER_NO | OBJECT_VERSION_ID | RESULT_FILTER_IND | FUTURE_ON_HAND_QTY | FUTURE_UNIT_RETAIL | CREATED_SUPPLIER_ID | PARENT_ITEM_LOC_SESSION_ID | QUANTITY_LIMITS_FILTER_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1 | SAMPLE | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | 1 | 1.0000 | SAMPLE | 1 | 1 | 1.0000 | 1 | 2026-01-01 | 2026-01-01 | S | 1 | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | S | 1 | 1 | 1 | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | SAMPLE | 1 | S |
| default | ALT-ALC_SESSIO-002 | 1000000003 | 12.5000 | 1000000003 | ALT-ALC_SESSIO-002 | 12.5000 | 1000000003 | ALT-ALC_SE | ALT-ALC_SE | ALT-ALC_SE | ALT-ALC_SESSIO-002 | A | 12.5000 | 12.5000 | 12.5000 | Alc Session Item Loc-002-ALT | 0.0000 | 12.5000 | Alc Session Item Loc-002-ALT | STYLE | A | Alc Session Item Loc-002-ALT | Alc Session Item Loc-002-ALT | Alc Session Item Loc-002-ALT | Alc Session Item Loc-002-ALT | N | Alc Session Item Loc-002-ALT | 3 | 12.5000 | 2026-01-02-ALT | 1000000003 | 1000000003 | 12.5000 | 3 | 2026-01-03 | 2026-01-03 | N | 1000000003 | 2026-01-03 | 12.5000 | 12.5000 | 2026-01-03 | Alc Session Item Loc-002-ALT | 12.5000 | 12.5000 | 0.0000 | ALT-ALC_SESSIO-002 | N | 3 | 3 | 3 | Alc Session Item Loc-002-ALT | ALT-ALC_SESSIO-002 | N | 12.5000 | 12.5000 | ALT-ALC_SESSIO-002 | 1000000003 | N |
| default | EDGE-ALC_SESSIO-003 | 1000000005 | 14.0000 | 1000000005 | EDGE-ALC_SESSIO-003 | 14.0000 | 1000000005 | EDGE-ALC_S | EDGE-ALC_S | EDGE-ALC_S | EDGE-ALC_SESSIO-003 | A | 14.0000 | 14.0000 | 14.0000 | Alc Session Item Loc-003-EDGE | 0.0000 | 14.0000 | Alc Session Item Loc-003-EDGE | STYLE | A | Alc Session Item Loc-003-EDGE | Alc Session Item Loc-003-EDGE | Alc Session Item Loc-003-EDGE | Alc Session Item Loc-003-EDGE | Y | Alc Session Item Loc-003-EDGE | 5 | 14.0000 | 2026-01-03-EDGE | 1000000005 | 1000000005 | 14.0000 | 5 | 2026-01-05 | 2026-01-05 | N | 1000000005 | 2026-01-05 | 14.0000 | 14.0000 | 2026-01-05 | Alc Session Item Loc-003-EDGE | 14.0000 | 14.0000 | 0.0000 | EDGE-ALC_SESSIO-003 | N | 5 | 5 | 5 | Alc Session Item Loc-003-EDGE | EDGE-ALC_SESSIO-003 | N | 14.0000 | 14.0000 | EDGE-ALC_SESSIO-003 | 1000000005 | N |
Example values from field definitions
- FACET_SESSION_IDR
- SAMPLE
- ITEM_LOC_SESSION_IDRPK
- 1
- COST
- 1.0000
- WH_ID
- 1
- ITEM_ID
- SAMPLE
- SOM_QTY
- 1.0000
- ALLOC_ID
- 1
- DIFF1_ID
- SAMPLE
- DIFF2_ID
- SAMPLE
- DIFF3_ID
- SAMPLE
- GROUP_ID
- SAMPLE
- 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
- CREATED_BY
- SAMPLE
- DIFF1_DESC
- SAMPLE
- DIFF2_DESC
- SAMPLE
- DIFF3_DESC
- SAMPLE
- FREEZE_IND
- S
- GROUP_DESC
- SAMPLE
- GROUP_TYPE
- 1
- IN_TRANSIT
- 1.0000
- UPDATED_BY
- SAMPLE
- ITEM_LOC_ID
- 1
- LOCATION_ID
- 1
- ON_HAND_QTY
- 1.0000
- SOURCE_TYPE
- 1
- UPDATE_DATE
- 2026-01-01
- CREATED_DATE
- 2026-01-01
- FILTERED_IND
- S
- LOC_GROUP_ID
- 1
- RELEASE_DATE
- 2026-01-01
- ALLOCATED_QTY
- 1.0000
- BACKORDER_QTY
- 1.0000
- IN_STORE_DATE
- 2026-01-01
- LOCATION_DESC
- SAMPLE
- PACK_COMP_QTY
- 1.0000
- CALCULATED_QTY
- 1.0000
- GROSS_NEED_QTY
- 1.0000
- PARENT_ITEM_ID
- SAMPLE
- QBE_FILTER_IND
- S
- NEXT_1_WEEK_QTY
- 1
- NEXT_2_WEEK_QTY
- 1
- NEXT_3_WEEK_QTY
- 1
- CREATED_ORDER_NO
- SAMPLE
- OBJECT_VERSION_ID
- SAMPLE
- RESULT_FILTER_IND
- S
- FUTURE_ON_HAND_QTY
- 1.0000
- FUTURE_UNIT_RETAIL
- 1.0000
- CREATED_SUPPLIER_ID
- SAMPLE
- PARENT_ITEM_LOC_SESSION_ID
- 1
- QUANTITY_LIMITS_FILTER_IND
- S
default
- FACET_SESSION_IDR
- ALT-ALC_SESSIO-002
- ITEM_LOC_SESSION_IDRPK
- 1000000003
- COST
- 12.5000
- WH_ID
- 1000000003
- ITEM_ID
- ALT-ALC_SESSIO-002
- SOM_QTY
- 12.5000
- ALLOC_ID
- 1000000003
- DIFF1_ID
- ALT-ALC_SE
- DIFF2_ID
- ALT-ALC_SE
- DIFF3_ID
- ALT-ALC_SE
- GROUP_ID
- ALT-ALC_SESSIO-002
- LOC_TYPE
- A
- NEED_QTY
- 12.5000
- ON_ALLOC
- 12.5000
- ON_ORDER
- 12.5000
- ORDER_NO
- Alc Session Item Loc-002-ALT
- RLOH_QTY
- 0.0000
- ALLOC_OUT
- 12.5000
- ITEM_DESC
- Alc Session Item Loc-002-ALT
- ITEM_TYPE
- STYLE
- RUSH_FLAG
- A
- CREATED_BY
- Alc Session Item Loc-002-ALT
- DIFF1_DESC
- Alc Session Item Loc-002-ALT
- DIFF2_DESC
- Alc Session Item Loc-002-ALT
- DIFF3_DESC
- Alc Session Item Loc-002-ALT
- FREEZE_IND
- N
- GROUP_DESC
- Alc Session Item Loc-002-ALT
- GROUP_TYPE
- 3
- IN_TRANSIT
- 12.5000
- UPDATED_BY
- 2026-01-02-ALT
- ITEM_LOC_ID
- 1000000003
- LOCATION_ID
- 1000000003
- ON_HAND_QTY
- 12.5000
- SOURCE_TYPE
- 3
- UPDATE_DATE
- 2026-01-03
- CREATED_DATE
- 2026-01-03
- FILTERED_IND
- N
- LOC_GROUP_ID
- 1000000003
- RELEASE_DATE
- 2026-01-03
- ALLOCATED_QTY
- 12.5000
- BACKORDER_QTY
- 12.5000
- IN_STORE_DATE
- 2026-01-03
- LOCATION_DESC
- Alc Session Item Loc-002-ALT
- PACK_COMP_QTY
- 12.5000
- CALCULATED_QTY
- 12.5000
- GROSS_NEED_QTY
- 0.0000
- PARENT_ITEM_ID
- ALT-ALC_SESSIO-002
- QBE_FILTER_IND
- N
- NEXT_1_WEEK_QTY
- 3
- NEXT_2_WEEK_QTY
- 3
- NEXT_3_WEEK_QTY
- 3
- CREATED_ORDER_NO
- Alc Session Item Loc-002-ALT
- OBJECT_VERSION_ID
- ALT-ALC_SESSIO-002
- RESULT_FILTER_IND
- N
- FUTURE_ON_HAND_QTY
- 12.5000
- FUTURE_UNIT_RETAIL
- 12.5000
- CREATED_SUPPLIER_ID
- ALT-ALC_SESSIO-002
- PARENT_ITEM_LOC_SESSION_ID
- 1000000003
- QUANTITY_LIMITS_FILTER_IND
- N
default
- FACET_SESSION_IDR
- EDGE-ALC_SESSIO-003
- ITEM_LOC_SESSION_IDRPK
- 1000000005
- COST
- 14.0000
- WH_ID
- 1000000005
- ITEM_ID
- EDGE-ALC_SESSIO-003
- SOM_QTY
- 14.0000
- ALLOC_ID
- 1000000005
- DIFF1_ID
- EDGE-ALC_S
- DIFF2_ID
- EDGE-ALC_S
- DIFF3_ID
- EDGE-ALC_S
- GROUP_ID
- EDGE-ALC_SESSIO-003
- LOC_TYPE
- A
- NEED_QTY
- 14.0000
- ON_ALLOC
- 14.0000
- ON_ORDER
- 14.0000
- ORDER_NO
- Alc Session Item Loc-003-EDGE
- RLOH_QTY
- 0.0000
- ALLOC_OUT
- 14.0000
- ITEM_DESC
- Alc Session Item Loc-003-EDGE
- ITEM_TYPE
- STYLE
- RUSH_FLAG
- A
- CREATED_BY
- Alc Session Item Loc-003-EDGE
- DIFF1_DESC
- Alc Session Item Loc-003-EDGE
- DIFF2_DESC
- Alc Session Item Loc-003-EDGE
- DIFF3_DESC
- Alc Session Item Loc-003-EDGE
- FREEZE_IND
- Y
- GROUP_DESC
- Alc Session Item Loc-003-EDGE
- GROUP_TYPE
- 5
- IN_TRANSIT
- 14.0000
- UPDATED_BY
- 2026-01-03-EDGE
- ITEM_LOC_ID
- 1000000005
- LOCATION_ID
- 1000000005
- ON_HAND_QTY
- 14.0000
- SOURCE_TYPE
- 5
- UPDATE_DATE
- 2026-01-05
- CREATED_DATE
- 2026-01-05
- FILTERED_IND
- N
- LOC_GROUP_ID
- 1000000005
- RELEASE_DATE
- 2026-01-05
- ALLOCATED_QTY
- 14.0000
- BACKORDER_QTY
- 14.0000
- IN_STORE_DATE
- 2026-01-05
- LOCATION_DESC
- Alc Session Item Loc-003-EDGE
- PACK_COMP_QTY
- 14.0000
- CALCULATED_QTY
- 14.0000
- GROSS_NEED_QTY
- 0.0000
- PARENT_ITEM_ID
- EDGE-ALC_SESSIO-003
- QBE_FILTER_IND
- N
- NEXT_1_WEEK_QTY
- 5
- NEXT_2_WEEK_QTY
- 5
- NEXT_3_WEEK_QTY
- 5
- CREATED_ORDER_NO
- Alc Session Item Loc-003-EDGE
- OBJECT_VERSION_ID
- EDGE-ALC_SESSIO-003
- RESULT_FILTER_IND
- N
- FUTURE_ON_HAND_QTY
- 14.0000
- FUTURE_UNIT_RETAIL
- 14.0000
- CREATED_SUPPLIER_ID
- EDGE-ALC_SESSIO-003
- PARENT_ITEM_LOC_SESSION_ID
- 1000000005
- QUANTITY_LIMITS_FILTER_IND
- N
Rule Validation Summary
- Source Rule Count
- 80
- Governed Rule Count
- 58