Allocation Item Location Service Staging

In Scope

Technical: ALC_SVC_ITEM_LOC | ID: OR-ALLOC-ALC_SVC_ITEM_LOC-ACTUAL_LANDED_COST_SERVICE_ITEM_LOCATION

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ALC_SVC_ITEM_LOC

Field Definitions(5)

Rules & Considerations(43)

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
Example values from field definitions	1.0000	SAMPLE	SAMPLE	1	SAMPLE	1.0000	1	SAMPLE	SAMPLE	SAMPLE	S	1.0000	1.0000	1.0000	SAMPLE	1.0000	1.0000	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	S	1.0000	1	SAMPLE	1	2026-01-01	1	1.0000	1.0000	2026-01-01	SAMPLE	1.0000	1.0000	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	1.0000	SAMPLE
default	12.5000	ALT-ALC_SVC-002	Alc Svc It	100003	ALT-ALC_SVC-002	12.5000	1000000003	ALT-ALC_SVC-002	ALT-ALC_SVC-002	ALT-ALC_SV	A	12.5000	12.5000	12.5000	Alc Svc Item Loc-002-ALT	0.0000	12.5000	Alc Svc Item Loc-002-ALT	Alc Svc Item Loc-002-ALT	Alc Svc It	A	Alc Svc Item Loc-002-ALT	Alc Svc Item Loc-002-ALT	Alc Svc Item Loc-002-ALT	A	12.5000	1000000003	ALT-ALC_SVC-002	3	2026-01-03	1000000003	12.5000	12.5000	2026-01-03	Alc Svc Item Loc-002-ALT	12.5000	12.5000	0.0000	ALT-ALC_SVC-002	PENDING-AL	ALT-ALC_SVC-002	Alc Svc Item Loc-002-ALT	12.5000	12.5000	ALT-ALC_SVC-002
default	14.0000	EDGE-ALC_SVC-003	Alc Svc It	100005	EDGE-ALC_SVC-003	14.0000	1000000005	EDGE-ALC_SVC-003	EDGE-ALC_SVC-003	EDGE-ALC_S	A	14.0000	14.0000	14.0000	Alc Svc Item Loc-003-EDGE	0.0000	14.0000	Alc Svc Item Loc-003-EDGE	Alc Svc Item Loc-003-EDGE	Alc Svc It	A	Alc Svc Item Loc-003-EDGE	Alc Svc Item Loc-003-EDGE	Alc Svc Item Loc-003-EDGE	A	14.0000	1000000005	EDGE-ALC_SVC-003	5	2026-01-05	1000000005	14.0000	14.0000	2026-01-05	Alc Svc Item Loc-003-EDGE	14.0000	14.0000	0.0000	EDGE-ALC_SVC-003	ACTIVE-EDG	EDGE-ALC_SVC-003	Alc Svc Item Loc-003-EDGE	14.0000	14.0000	EDGE-ALC_SVC-003

Example values from field definitions

COST: 1.0000
WH_ID: SAMPLE
ACTION: SAMPLE
ROW_ID: 1
ITEM_ID: SAMPLE
SOM_QTY: 1.0000
ALLOC_ID: 1
DIFF1_ID: SAMPLE
DIFF2_ID: SAMPLE
DIFF3_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
ERROR_MSG: SAMPLE
ITEM_DESC: SAMPLE
ITEM_TYPE: SAMPLE
RUSH_FLAG: S
DIFF1_DESC: SAMPLE
DIFF2_DESC: SAMPLE
DIFF3_DESC: SAMPLE
FREEZE_IND: S
IN_TRANSIT: 1.0000
ITEM_LOC_ID: 1
LOCATION_ID: SAMPLE
SOURCE_TYPE: 1
RELEASE_DATE: 2026-01-01
WORKSPACE_ID: 1
ALLOCATED_QTY: 1.0000
BACKORDER_QTY: 1.0000
IN_STORE_DATE: 2026-01-01
LOCATION_DESC: SAMPLE
STOCK_ON_HAND: 1.0000
CALCULATED_QTY: 1.0000
GROSS_NEED_QTY: 1.0000
PARENT_ITEM_ID: SAMPLE
PROCESS$STATUS: SAMPLE
PARENT_DIFF1_ID: SAMPLE
CREATED_ORDER_NO: SAMPLE
TOTAL_ON_HAND_QTY: 1.0000
FUTURE_UNIT_RETAIL: 1.0000
CREATED_SUPPLIER_ID: SAMPLE

default

COST: 12.5000
WH_ID: ALT-ALC_SVC-002
ACTION: Alc Svc It
ROW_ID: 100003
ITEM_ID: ALT-ALC_SVC-002
SOM_QTY: 12.5000
ALLOC_ID: 1000000003
DIFF1_ID: ALT-ALC_SVC-002
DIFF2_ID: ALT-ALC_SVC-002
DIFF3_ID: ALT-ALC_SV
LOC_TYPE: A
NEED_QTY: 12.5000
ON_ALLOC: 12.5000
ON_ORDER: 12.5000
ORDER_NO: Alc Svc Item Loc-002-ALT
RLOH_QTY: 0.0000
ALLOC_OUT: 12.5000
ERROR_MSG: Alc Svc Item Loc-002-ALT
ITEM_DESC: Alc Svc Item Loc-002-ALT
ITEM_TYPE: Alc Svc It
RUSH_FLAG: A
DIFF1_DESC: Alc Svc Item Loc-002-ALT
DIFF2_DESC: Alc Svc Item Loc-002-ALT
DIFF3_DESC: Alc Svc Item Loc-002-ALT
FREEZE_IND: A
IN_TRANSIT: 12.5000
ITEM_LOC_ID: 1000000003
LOCATION_ID: ALT-ALC_SVC-002
SOURCE_TYPE: 3
RELEASE_DATE: 2026-01-03
WORKSPACE_ID: 1000000003
ALLOCATED_QTY: 12.5000
BACKORDER_QTY: 12.5000
IN_STORE_DATE: 2026-01-03
LOCATION_DESC: Alc Svc Item Loc-002-ALT
STOCK_ON_HAND: 12.5000
CALCULATED_QTY: 12.5000
GROSS_NEED_QTY: 0.0000
PARENT_ITEM_ID: ALT-ALC_SVC-002
PROCESS$STATUS: PENDING-AL
PARENT_DIFF1_ID: ALT-ALC_SVC-002
CREATED_ORDER_NO: Alc Svc Item Loc-002-ALT
TOTAL_ON_HAND_QTY: 12.5000
FUTURE_UNIT_RETAIL: 12.5000
CREATED_SUPPLIER_ID: ALT-ALC_SVC-002

default

COST: 14.0000
WH_ID: EDGE-ALC_SVC-003
ACTION: Alc Svc It
ROW_ID: 100005
ITEM_ID: EDGE-ALC_SVC-003
SOM_QTY: 14.0000
ALLOC_ID: 1000000005
DIFF1_ID: EDGE-ALC_SVC-003
DIFF2_ID: EDGE-ALC_SVC-003
DIFF3_ID: EDGE-ALC_S
LOC_TYPE: A
NEED_QTY: 14.0000
ON_ALLOC: 14.0000
ON_ORDER: 14.0000
ORDER_NO: Alc Svc Item Loc-003-EDGE
RLOH_QTY: 0.0000
ALLOC_OUT: 14.0000
ERROR_MSG: Alc Svc Item Loc-003-EDGE
ITEM_DESC: Alc Svc Item Loc-003-EDGE
ITEM_TYPE: Alc Svc It
RUSH_FLAG: A
DIFF1_DESC: Alc Svc Item Loc-003-EDGE
DIFF2_DESC: Alc Svc Item Loc-003-EDGE
DIFF3_DESC: Alc Svc Item Loc-003-EDGE
FREEZE_IND: A
IN_TRANSIT: 14.0000
ITEM_LOC_ID: 1000000005
LOCATION_ID: EDGE-ALC_SVC-003
SOURCE_TYPE: 5
RELEASE_DATE: 2026-01-05
WORKSPACE_ID: 1000000005
ALLOCATED_QTY: 14.0000
BACKORDER_QTY: 14.0000
IN_STORE_DATE: 2026-01-05
LOCATION_DESC: Alc Svc Item Loc-003-EDGE
STOCK_ON_HAND: 14.0000
CALCULATED_QTY: 14.0000
GROSS_NEED_QTY: 0.0000
PARENT_ITEM_ID: EDGE-ALC_SVC-003
PROCESS$STATUS: ACTIVE-EDG
PARENT_DIFF1_ID: EDGE-ALC_SVC-003
CREATED_ORDER_NO: Alc Svc Item Loc-003-EDGE
TOTAL_ON_HAND_QTY: 14.0000
FUTURE_UNIT_RETAIL: 14.0000
CREATED_SUPPLIER_ID: EDGE-ALC_SVC-003

Rule Validation Summary

Source Rule Count: 53
Governed Rule Count: 43

All objects