Allocation Cross Reference

In Scope

Technical: ALC_XREF | ID: OR-ALLOC-ALC_XREF-ACTUAL_LANDED_COST_CROSS_REFERENCE

Stores the cross-reference data for the publishing of the information to the base rms allocation tables (alloc_header and alloc_detail). this table will contain a record for each allocation/item/wh/release date that...

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_XREF

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	WH_IDR	ITEM_IDR	XREF_IDRPK	ALLOC_IDR	RELEASE_DATER	DIFF1_ID	ORDER_NO	CLOSE_IND	ALLOCATED_QTY	XREF_ALLOC_NO	PARENT_ITEM_ID
Example values from field definitions	SAMPLE	SAMPLE	1	1	2026-01-01	SAMPLE	SAMPLE	S	1.0000	1	SAMPLE
default	ALT-ALC_XREF-002	ALT-ALC_XREF-002	1000000003	1000000003	2026-01-03	ALT-ALC_XREF-002	Alc Xref-002-ALT	N	12.5000	4	ALT-ALC_XREF-002
default	EDGE-ALC_XREF-003	EDGE-ALC_XREF-003	1000000005	1000000005	2026-01-05	EDGE-ALC_XREF-003	Alc Xref-003-EDGE	N	14.0000	6	EDGE-ALC_XREF-003

Example values from field definitions

WH_IDR: SAMPLE
ITEM_IDR: SAMPLE
XREF_IDRPK: 1
ALLOC_IDR: 1
RELEASE_DATER: 2026-01-01
DIFF1_ID: SAMPLE
ORDER_NO: SAMPLE
CLOSE_IND: S
ALLOCATED_QTY: 1.0000
XREF_ALLOC_NO: 1
PARENT_ITEM_ID: SAMPLE

default

WH_IDR: ALT-ALC_XREF-002
ITEM_IDR: ALT-ALC_XREF-002
XREF_IDRPK: 1000000003
ALLOC_IDR: 1000000003
RELEASE_DATER: 2026-01-03
DIFF1_ID: ALT-ALC_XREF-002
ORDER_NO: Alc Xref-002-ALT
CLOSE_IND: N
ALLOCATED_QTY: 12.5000
XREF_ALLOC_NO: 4
PARENT_ITEM_ID: ALT-ALC_XREF-002