Stage Data For Allocation Item Sources

In Scope

Technical: ALC_SVC_ITEM_SOURCE | ID: OR-ALLOC-ALC_SVC_ITEM_SOURCE-ACTUAL_LANDED_COST_SERVICE_ITEM_SOURCE

Stores stage data for allocation item sources.

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_SOURCE

Field Definitions(5)

Rules & Considerations(32)

Sample Load Data(4)

_scenario	WH_ID	ACTION	PALLET	ROW_ID	ITEM_ID	SOM_QTY	TSR_IND	ALLOC_ID	DIFF1_ID	DIFF2_ID	ORDER_NO	PACK_IND	AVAIL_QTY	CASE_SIZE	ERROR_MSG	ITEM_TYPE	DIFF1_DESC	INNER_SIZE	PACK_ROUND	ON_HAND_QTY	SOURCE_TYPE	RELEASE_DATE	WORKSPACE_ID	BACKORDER_QTY	CALC_MULTIPLE	DEFAULT_LEVEL	MIN_AVAIL_QTY	ITEM_SOURCE_ID	PROCESS$STATUS	HOLD_BACK_VALUE	THRESHOLD_PERCENT	FUTURE_ON_HAND_QTY	HOLD_BACK_PCT_FLAG
Example values from field definitions	SAMPLE	SAMPLE	1.0000	1	SAMPLE	1.0000	S	1	SAMPLE	SAMPLE	SAMPLE	SA	1.0000	1.0000	SAMPLE	SAMPLE	SAMPLE	1.0000	1.000	1.0000	S	2026-01-01	1	1.0000	SA	S	1.0000	1	SAMPLE	1.0000	1.00	1.0000	S
default	ALT-ALC_SVC-002	Alc Svc It	12.5000	100003	ALT-ALC_SVC-002	12.5000	N	1000000003	ALT-ALC_SVC-002	ALT-ALC_SVC-002	Alc Svc Item Source-002-ALT	Al	12.5000	12.5000	Alc Svc Item Source-002-ALT	Alc Svc It	Alc Svc Item Source-002-ALT	12.5000	12.500	12.5000	A	2026-01-03	1000000003	12.5000	Al	A	12.5000	1000000003	PENDING-AL	12.5000	12.50	12.5000	A
default	EDGE-ALC_SVC-003	Alc Svc It	14.0000	100005	EDGE-ALC_SVC-003	14.0000	N	1000000005	EDGE-ALC_SVC-003	EDGE-ALC_SVC-003	Alc Svc Item Source-003-EDGE	Al	14.0000	14.0000	Alc Svc Item Source-003-EDGE	Alc Svc It	Alc Svc Item Source-003-EDGE	14.0000	14.000	14.0000	A	2026-01-05	1000000005	14.0000	Al	A	14.0000	1000000005	ACTIVE-EDG	14.0000	14.00	14.0000	A

Example values from field definitions

default

WH_ID: ALT-ALC_SVC-002
ACTION: Alc Svc It
PALLET: 12.5000
ROW_ID: 100003
ITEM_ID: ALT-ALC_SVC-002
SOM_QTY: 12.5000
TSR_IND: N
ALLOC_ID: 1000000003
DIFF1_ID: ALT-ALC_SVC-002
DIFF2_ID: ALT-ALC_SVC-002
ORDER_NO: Alc Svc Item Source-002-ALT
PACK_IND: Al
AVAIL_QTY: 12.5000
CASE_SIZE: 12.5000
ERROR_MSG: Alc Svc Item Source-002-ALT
ITEM_TYPE: Alc Svc It
DIFF1_DESC: Alc Svc Item Source-002-ALT
INNER_SIZE: 12.5000
PACK_ROUND: 12.500
ON_HAND_QTY: 12.5000
SOURCE_TYPE: A
RELEASE_DATE: 2026-01-03
WORKSPACE_ID: 1000000003
BACKORDER_QTY: 12.5000
CALC_MULTIPLE: Al
DEFAULT_LEVEL: A
MIN_AVAIL_QTY: 12.5000
ITEM_SOURCE_ID: 1000000003
PROCESS$STATUS: PENDING-AL
HOLD_BACK_VALUE: 12.5000
THRESHOLD_PERCENT: 12.50
FUTURE_ON_HAND_QTY: 12.5000
HOLD_BACK_PCT_FLAG: A

default

WH_ID: EDGE-ALC_SVC-003
ACTION: Alc Svc It
PALLET: 14.0000
ROW_ID: 100005
ITEM_ID: EDGE-ALC_SVC-003
SOM_QTY: 14.0000
TSR_IND: N
ALLOC_ID: 1000000005
DIFF1_ID: EDGE-ALC_SVC-003
DIFF2_ID: EDGE-ALC_SVC-003
ORDER_NO: Alc Svc Item Source-003-EDGE
PACK_IND: Al
AVAIL_QTY: 14.0000
CASE_SIZE: 14.0000
ERROR_MSG: Alc Svc Item Source-003-EDGE
ITEM_TYPE: Alc Svc It
DIFF1_DESC: Alc Svc Item Source-003-EDGE
INNER_SIZE: 14.0000
PACK_ROUND: 14.000
ON_HAND_QTY: 14.0000
SOURCE_TYPE: A
RELEASE_DATE: 2026-01-05
WORKSPACE_ID: 1000000005
BACKORDER_QTY: 14.0000
CALC_MULTIPLE: Al
DEFAULT_LEVEL: A
MIN_AVAIL_QTY: 14.0000
ITEM_SOURCE_ID: 1000000005
PROCESS$STATUS: ACTIVE-EDG
HOLD_BACK_VALUE: 14.0000
THRESHOLD_PERCENT: 14.00
FUTURE_ON_HAND_QTY: 14.0000
HOLD_BACK_PCT_FLAG: A

Rule Validation Summary

Source Rule Count: 40
Governed Rule Count: 32