Actual Landed Cost Calculation Allitemloc (Temporary)

Out of Scope

Technical: ALC_CALC_ALLITEMLOC_TEMP | ID: OR-ALLOC-ALC_CALC_ALLITEMLOC_TEMP-ALC_CALC_ALLITEMLOC_TEMP

Temporary table used in the calculation process. This table holds information about the transaction level items in ALC_CALC_SOURCE_TEMP combined with the stores that the allocation is being shipped to.

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: gtt

Target Structure

Load Approach: Table
Target Objects: ALC_CALC_ALLITEMLOC_TEMP

Field Definitions(5)

Rules & Considerations(39)

validation

constraint

Sample Load Data(4)

_scenario	ALLOC_IDR	DEPT	CLASS	TO_LOC	ON_ALLOC	ON_ORDER	SUBCLASS	ALLOC_OUT	CLEAR_IND	ITEM_TYPE	TRAN_ITEM	NEED_VALUE	SOURCE_ITEM	TO_LOC_NAME	TO_LOC_TYPE	SISTER_STORE	STOCK_ON_HAND	TRAN_DIFF1_ID	TRAN_DIFF2_ID	TRAN_DIFF3_ID	TRAN_DIFF4_ID	TRAN_PACK_IND	IN_TRANSIT_QTY	ITEM_LOC_STATUS	SOURCE_DIFF1_ID	SOURCE_DIFF2_ID	SOURCE_DIFF3_ID	SOURCE_DIFF4_ID	SOURCE_PACK_IND	TRAN_ITEM_LEVEL	TRAN_TRAN_LEVEL	SIZE_PROFILE_QTY	ASSIGN_DEFAULT_WH	RLOH_FUTURE_VALUE	SOURCE_ITEM_LEVEL	SOURCE_TRAN_LEVEL	TOTAL_PROFILE_QTY	RLOH_CURRENT_VALUE
Example values from field definitions	1	1	1	1	1.0000	1.0000	1	1.0000	S	SAMPLE	SAMPLE	1.0000	SAMPLE	SAMPLE	S	1	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1.0000	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1	1	1.0000	1	1.0000	1	1	1.0000	1.0000
default	1000000003	1003	1103	3	12.5000	12.5000	1113	12.5000	A	Alc Calc A	Alc Calc Allitemloc Temp-	12.5000	Alc Calc Allitemloc Temp-	Alc Calc Allitemloc Temp Secondary	A	1003	12.5000	ALT-ALC_CA	ALT-ALC_CA	ALT-ALC_CA	ALT-ALC_CA	A	12.5000	P	ALT-ALC_CA	ALT-ALC_CA	ALT-ALC_CA	ALT-ALC_CA	A	3	3	12.5000	9003	12.5000	3	3	12.5000	12.5000
default	1000000005	1005	1105	5	14.0000	14.0000	1115	14.0000	A	Alc Calc A	Alc Calc Allitemloc Temp-	14.0000	Alc Calc Allitemloc Temp-	Alc Calc Allitemloc Temp Core	A	1005	14.0000	EDGE-ALC_C	EDGE-ALC_C	EDGE-ALC_C	EDGE-ALC_C	A	14.0000	A	EDGE-ALC_C	EDGE-ALC_C	EDGE-ALC_C	EDGE-ALC_C	A	5	5	14.0000	9005	14.0000	5	5	14.0000	14.0000

Example values from field definitions

ALLOC_IDR: 1
DEPT: 1
CLASS: 1
TO_LOC: 1
ON_ALLOC: 1.0000
ON_ORDER: 1.0000
SUBCLASS: 1
ALLOC_OUT: 1.0000
CLEAR_IND: S
ITEM_TYPE: SAMPLE
TRAN_ITEM: SAMPLE
NEED_VALUE: 1.0000
SOURCE_ITEM: SAMPLE
TO_LOC_NAME: SAMPLE
TO_LOC_TYPE: S
SISTER_STORE: 1
STOCK_ON_HAND: 1.0000
TRAN_DIFF1_ID: SAMPLE
TRAN_DIFF2_ID: SAMPLE
TRAN_DIFF3_ID: SAMPLE
TRAN_DIFF4_ID: SAMPLE
TRAN_PACK_IND: S
IN_TRANSIT_QTY: 1.0000
ITEM_LOC_STATUS: S
SOURCE_DIFF1_ID: SAMPLE
SOURCE_DIFF2_ID: SAMPLE
SOURCE_DIFF3_ID: SAMPLE
SOURCE_DIFF4_ID: SAMPLE
SOURCE_PACK_IND: S
TRAN_ITEM_LEVEL: 1
TRAN_TRAN_LEVEL: 1
SIZE_PROFILE_QTY: 1.0000
ASSIGN_DEFAULT_WH: 1
RLOH_FUTURE_VALUE: 1.0000
SOURCE_ITEM_LEVEL: 1
SOURCE_TRAN_LEVEL: 1
TOTAL_PROFILE_QTY: 1.0000
RLOH_CURRENT_VALUE: 1.0000

default

ALLOC_IDR: 1000000003
DEPT: 1003
CLASS: 1103
TO_LOC: 3
ON_ALLOC: 12.5000
ON_ORDER: 12.5000
SUBCLASS: 1113
ALLOC_OUT: 12.5000
CLEAR_IND: A
ITEM_TYPE: Alc Calc A
TRAN_ITEM: Alc Calc Allitemloc Temp-
NEED_VALUE: 12.5000
SOURCE_ITEM: Alc Calc Allitemloc Temp-
TO_LOC_NAME: Alc Calc Allitemloc Temp Secondary
TO_LOC_TYPE: A
SISTER_STORE: 1003
STOCK_ON_HAND: 12.5000
TRAN_DIFF1_ID: ALT-ALC_CA
TRAN_DIFF2_ID: ALT-ALC_CA
TRAN_DIFF3_ID: ALT-ALC_CA
TRAN_DIFF4_ID: ALT-ALC_CA
TRAN_PACK_IND: A
IN_TRANSIT_QTY: 12.5000
ITEM_LOC_STATUS: P
SOURCE_DIFF1_ID: ALT-ALC_CA
SOURCE_DIFF2_ID: ALT-ALC_CA
SOURCE_DIFF3_ID: ALT-ALC_CA
SOURCE_DIFF4_ID: ALT-ALC_CA
SOURCE_PACK_IND: A
TRAN_ITEM_LEVEL: 3
TRAN_TRAN_LEVEL: 3
SIZE_PROFILE_QTY: 12.5000
ASSIGN_DEFAULT_WH: 9003
RLOH_FUTURE_VALUE: 12.5000
SOURCE_ITEM_LEVEL: 3
SOURCE_TRAN_LEVEL: 3
TOTAL_PROFILE_QTY: 12.5000
RLOH_CURRENT_VALUE: 12.5000