Actual Landed Cost Item Location (Temporary)
Out of ScopeTechnical: ALC_ITEM_LOC_TEMP | ID: OR-ALLOC-ALC_ITEM_LOC_TEMP-ALC_ITEM_LOC_TEMP
this temporary table is used in the process of calculating allocations. no data will be permanently kept on this table.
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_ITEM_LOC_TEMP
Field Definitions(5)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | COST | DEPT | CLASS | STORE | CHILD_ID | ON_ALLOC | ON_ORDER | PACK_IND | SUBCLASS | ALLOC_OUT | CLEAR_IND | RUSH_FLAG | SOURCE_ID | IN_TRANSIT | ITEM_LEVEL | TRAN_LEVEL | IN_STORE_DATE | STOCK_ON_HAND | CHILD_DIFF1_ID | CHILD_DIFF2_ID | CHILD_DIFF3_ID | CHILD_DIFF4_ID | IN_TRANSIT_QTY | SOURCE_DIFF1_ID | SOURCE_DIFF2_ID | SOURCE_DIFF3_ID | SOURCE_DIFF4_ID | ITEM_LOC_TEMP_ID | SIZE_PROFILE_QTY | TSF_EXPECTED_QTY | TOTAL_PROFILE_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | SAMPLE | 1 | SAMPLE | 1.0000 | 1.0000 | S | SAMPLE | 1.0000 | S | S | SAMPLE | 1.0000 | 1 | 1 | 2026-01-01 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | 1.0000 | 1.0000 |
| default | 12.5000 | Alc Item Loc Temp-002-ALT | Alc Item Loc Temp-002-ALT | 1003 | ALT-ALC_ITEM-002 | 12.5000 | 12.5000 | A | Alc Item Loc Temp-002-ALT | 12.5000 | A | A | ALT-ALC_ITEM-002 | 12.5000 | 3 | 3 | 2026-01-03 | 12.5000 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | 12.5000 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | ALT-ALC_ITEM-002 | 1000000003 | 12.5000 | 12.5000 | 12.5000 |
| default | 14.0000 | Alc Item Loc Temp-003-EDGE | Alc Item Loc Temp-003-EDGE | 1005 | EDGE-ALC_ITEM-003 | 14.0000 | 14.0000 | A | Alc Item Loc Temp-003-EDGE | 14.0000 | A | A | EDGE-ALC_ITEM-003 | 14.0000 | 5 | 5 | 2026-01-05 | 14.0000 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | 14.0000 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | EDGE-ALC_ITEM-003 | 1000000005 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- COST
- 1.0000
- DEPT
- SAMPLE
- CLASS
- SAMPLE
- STORE
- 1
- CHILD_ID
- SAMPLE
- ON_ALLOC
- 1.0000
- ON_ORDER
- 1.0000
- PACK_IND
- S
- SUBCLASS
- SAMPLE
- ALLOC_OUT
- 1.0000
- CLEAR_IND
- S
- RUSH_FLAG
- S
- SOURCE_ID
- SAMPLE
- IN_TRANSIT
- 1.0000
- ITEM_LEVEL
- 1
- TRAN_LEVEL
- 1
- IN_STORE_DATE
- 2026-01-01
- STOCK_ON_HAND
- 1.0000
- CHILD_DIFF1_ID
- SAMPLE
- CHILD_DIFF2_ID
- SAMPLE
- CHILD_DIFF3_ID
- SAMPLE
- CHILD_DIFF4_ID
- SAMPLE
- IN_TRANSIT_QTY
- 1.0000
- SOURCE_DIFF1_ID
- SAMPLE
- SOURCE_DIFF2_ID
- SAMPLE
- SOURCE_DIFF3_ID
- SAMPLE
- SOURCE_DIFF4_ID
- SAMPLE
- ITEM_LOC_TEMP_ID
- 1
- SIZE_PROFILE_QTY
- 1.0000
- TSF_EXPECTED_QTY
- 1.0000
- TOTAL_PROFILE_QTY
- 1.0000
default
- COST
- 12.5000
- DEPT
- Alc Item Loc Temp-002-ALT
- CLASS
- Alc Item Loc Temp-002-ALT
- STORE
- 1003
- CHILD_ID
- ALT-ALC_ITEM-002
- ON_ALLOC
- 12.5000
- ON_ORDER
- 12.5000
- PACK_IND
- A
- SUBCLASS
- Alc Item Loc Temp-002-ALT
- ALLOC_OUT
- 12.5000
- CLEAR_IND
- A
- RUSH_FLAG
- A
- SOURCE_ID
- ALT-ALC_ITEM-002
- IN_TRANSIT
- 12.5000
- ITEM_LEVEL
- 3
- TRAN_LEVEL
- 3
- IN_STORE_DATE
- 2026-01-03
- STOCK_ON_HAND
- 12.5000
- CHILD_DIFF1_ID
- ALT-ALC_ITEM-002
- CHILD_DIFF2_ID
- ALT-ALC_ITEM-002
- CHILD_DIFF3_ID
- ALT-ALC_ITEM-002
- CHILD_DIFF4_ID
- ALT-ALC_ITEM-002
- IN_TRANSIT_QTY
- 12.5000
- SOURCE_DIFF1_ID
- ALT-ALC_ITEM-002
- SOURCE_DIFF2_ID
- ALT-ALC_ITEM-002
- SOURCE_DIFF3_ID
- ALT-ALC_ITEM-002
- SOURCE_DIFF4_ID
- ALT-ALC_ITEM-002
- ITEM_LOC_TEMP_ID
- 1000000003
- SIZE_PROFILE_QTY
- 12.5000
- TSF_EXPECTED_QTY
- 12.5000
- TOTAL_PROFILE_QTY
- 12.5000
default
- COST
- 14.0000
- DEPT
- Alc Item Loc Temp-003-EDGE
- CLASS
- Alc Item Loc Temp-003-EDGE
- STORE
- 1005
- CHILD_ID
- EDGE-ALC_ITEM-003
- ON_ALLOC
- 14.0000
- ON_ORDER
- 14.0000
- PACK_IND
- A
- SUBCLASS
- Alc Item Loc Temp-003-EDGE
- ALLOC_OUT
- 14.0000
- CLEAR_IND
- A
- RUSH_FLAG
- A
- SOURCE_ID
- EDGE-ALC_ITEM-003
- IN_TRANSIT
- 14.0000
- ITEM_LEVEL
- 5
- TRAN_LEVEL
- 5
- IN_STORE_DATE
- 2026-01-05
- STOCK_ON_HAND
- 14.0000
- CHILD_DIFF1_ID
- EDGE-ALC_ITEM-003
- CHILD_DIFF2_ID
- EDGE-ALC_ITEM-003
- CHILD_DIFF3_ID
- EDGE-ALC_ITEM-003
- CHILD_DIFF4_ID
- EDGE-ALC_ITEM-003
- IN_TRANSIT_QTY
- 14.0000
- SOURCE_DIFF1_ID
- EDGE-ALC_ITEM-003
- SOURCE_DIFF2_ID
- EDGE-ALC_ITEM-003
- SOURCE_DIFF3_ID
- EDGE-ALC_ITEM-003
- SOURCE_DIFF4_ID
- EDGE-ALC_ITEM-003
- ITEM_LOC_TEMP_ID
- 1000000005
- SIZE_PROFILE_QTY
- 14.0000
- TSF_EXPECTED_QTY
- 14.0000
- TOTAL_PROFILE_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 30