Allocation Item Source

In Scope

Technical: ALC_ITEM_SOURCE | ID: OR-ALLOC-ALC_ITEM_SOURCE-ACTUAL_LANDED_COST_ITEM_SOURCE

Stores the item source information used to create the allocation. a unique record for each item/wh/purchase order/release date will be available on this table, this resembles the selections made by...

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_SOURCE

Field Definitions(5)

Rules & Considerations(33)

constraint

validation

Sample Load Data(4)

_scenario	ITEM_IDR	ALLOC_IDR	ITEM_SOURCE_IDRPK	WH_ID	PALLET	SOM_QTY	TSR_IND	DIFF1_ID	DIFF2_ID	ORDER_NO	PACK_IND	AVAIL_QTY	CASE_SIZE	ITEM_TYPE	DIFF1_DESC	INNER_SIZE	PACK_ROUND	ON_HAND_QTY	SOURCE_TYPE	RELEASE_DATE	BACKORDER_QTY	CALC_MULTIPLE	DEFAULT_LEVEL	MIN_AVAIL_QTY	HOLD_BACK_VALUE	THRESHOLD_PERCENT	FUTURE_ON_HAND_QTY	HOLD_BACK_PCT_FLAG
Example values from field definitions	SAMPLE	1	1	SAMPLE	1.0000	1.0000	S	SAMPLE	SAMPLE	SAMPLE	SA	1.0000	1.0000	SAMPLE	SAMPLE	1.0000	1.000	1.0000	S	2026-01-01	1.0000	SA	S	1.0000	1.0000	1.00	1.0000	S
default	ALT-ALC_ITEM-002	1000000003	1000000003	ALT-ALC_ITEM-002	12.5000	12.5000	Y	ALT-ALC_ITEM-002	ALT-ALC_ITEM-002	Alc Item Source-002-ALT	Al	12.5000	12.5000	Alc Item S	Alc Item Source-002-ALT	12.5000	12.500	12.5000	A	2026-01-03	12.5000	Al	A	12.5000	12.5000	12.50	12.5000	y
default	EDGE-ALC_ITEM-003	1000000005	1000000005	EDGE-ALC_ITEM-003	14.0000	14.0000	N	EDGE-ALC_ITEM-003	EDGE-ALC_ITEM-003	Alc Item Source-003-EDGE	Al	14.0000	14.0000	Alc Item S	Alc Item Source-003-EDGE	14.0000	14.000	14.0000	A	2026-01-05	14.0000	Al	A	14.0000	14.0000	14.00	14.0000	y

Example values from field definitions

ITEM_IDR: SAMPLE
ALLOC_IDR: 1
ITEM_SOURCE_IDRPK: 1
WH_ID: SAMPLE
PALLET: 1.0000
SOM_QTY: 1.0000
TSR_IND: S
DIFF1_ID: SAMPLE
DIFF2_ID: SAMPLE
ORDER_NO: SAMPLE
PACK_IND: SA
AVAIL_QTY: 1.0000
CASE_SIZE: 1.0000
ITEM_TYPE: SAMPLE
DIFF1_DESC: SAMPLE
INNER_SIZE: 1.0000
PACK_ROUND: 1.000
ON_HAND_QTY: 1.0000
SOURCE_TYPE: S
RELEASE_DATE: 2026-01-01
BACKORDER_QTY: 1.0000
CALC_MULTIPLE: SA
DEFAULT_LEVEL: S
MIN_AVAIL_QTY: 1.0000
HOLD_BACK_VALUE: 1.0000
THRESHOLD_PERCENT: 1.00
FUTURE_ON_HAND_QTY: 1.0000
HOLD_BACK_PCT_FLAG: S

default

ITEM_IDR: ALT-ALC_ITEM-002
ALLOC_IDR: 1000000003
ITEM_SOURCE_IDRPK: 1000000003
WH_ID: ALT-ALC_ITEM-002
PALLET: 12.5000
SOM_QTY: 12.5000
TSR_IND: Y
DIFF1_ID: ALT-ALC_ITEM-002
DIFF2_ID: ALT-ALC_ITEM-002
ORDER_NO: Alc Item Source-002-ALT
PACK_IND: Al
AVAIL_QTY: 12.5000
CASE_SIZE: 12.5000
ITEM_TYPE: Alc Item S
DIFF1_DESC: Alc 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
BACKORDER_QTY: 12.5000
CALC_MULTIPLE: Al
DEFAULT_LEVEL: A
MIN_AVAIL_QTY: 12.5000
HOLD_BACK_VALUE: 12.5000
THRESHOLD_PERCENT: 12.50
FUTURE_ON_HAND_QTY: 12.5000
HOLD_BACK_PCT_FLAG: y