Actual Landed Cost Calculation Flex Supply Chain (GTT)
Out of ScopeTechnical: ALC_CALC_FLEX_SUPPLY_CHAIN_GTT | ID: OR-ALLOC-ALC_CALC_FLEX_SUPPLY_CHAIN_GTT-ALC_CALC_FLEX_SUPPLY_CHAIN_GTT
Temporary staging table used in the warehouse priorization logic within the PL/SQL Calculation Package.
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_FLEX_SUPPLY_CHAIN_GTT
Field Definitions(5)
Rules & Considerations(23)
validation
constraint
Sample Load Data(4)
| _scenario | ALLOC_IDR | TO_LOC | PACK_NO | TRAN_ITEM | CHANNEL_ID | ORG_UNIT_ID | SOURCE_ITEM | TO_LOC_TYPE | TRAN_DIFF1_ID | TRAN_DIFF2_ID | TRAN_DIFF3_ID | TRAN_DIFF4_ID | TSF_ENTITY_ID | TRANSFER_BASIS | SET_OF_BOOKS_ID | SOURCE_DIFF1_ID | SOURCE_DIFF2_ID | SOURCE_DIFF3_ID | SOURCE_DIFF4_ID | TO_LOC_DEFAULT_WH | ALLOC_SOURCE_WH_ID | ASSIGNED_RANGED_SRC_WH |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 |
| default | 1000000003 | 3 | Alc Calc Flex Supply Chai | Alc Calc Flex Supply Chai | 100003 | 1000000003 | Alc Calc Flex Supply Chai | A | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | 1000000003 | A | 1000000003 | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | 9003 | 1000000003 | 9003 |
| default | 1000000005 | 5 | Alc Calc Flex Supply Chai | Alc Calc Flex Supply Chai | 100005 | 1000000005 | Alc Calc Flex Supply Chai | A | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | 1000000005 | A | 1000000005 | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | 9005 | 1000000005 | 9005 |
Example values from field definitions
- ALLOC_IDR
- 1
- TO_LOC
- 1
- PACK_NO
- SAMPLE
- TRAN_ITEM
- SAMPLE
- CHANNEL_ID
- 1
- ORG_UNIT_ID
- 1
- SOURCE_ITEM
- SAMPLE
- TO_LOC_TYPE
- S
- TRAN_DIFF1_ID
- SAMPLE
- TRAN_DIFF2_ID
- SAMPLE
- TRAN_DIFF3_ID
- SAMPLE
- TRAN_DIFF4_ID
- SAMPLE
- TSF_ENTITY_ID
- 1
- TRANSFER_BASIS
- S
- SET_OF_BOOKS_ID
- 1
- SOURCE_DIFF1_ID
- SAMPLE
- SOURCE_DIFF2_ID
- SAMPLE
- SOURCE_DIFF3_ID
- SAMPLE
- SOURCE_DIFF4_ID
- SAMPLE
- TO_LOC_DEFAULT_WH
- 1
- ALLOC_SOURCE_WH_ID
- 1
- ASSIGNED_RANGED_SRC_WH
- 1
default
- ALLOC_IDR
- 1000000003
- TO_LOC
- 3
- PACK_NO
- Alc Calc Flex Supply Chai
- TRAN_ITEM
- Alc Calc Flex Supply Chai
- CHANNEL_ID
- 100003
- ORG_UNIT_ID
- 1000000003
- SOURCE_ITEM
- Alc Calc Flex Supply Chai
- TO_LOC_TYPE
- A
- TRAN_DIFF1_ID
- ALT-ALC_CA
- TRAN_DIFF2_ID
- ALT-ALC_CA
- TRAN_DIFF3_ID
- ALT-ALC_CA
- TRAN_DIFF4_ID
- ALT-ALC_CA
- TSF_ENTITY_ID
- 1000000003
- TRANSFER_BASIS
- A
- SET_OF_BOOKS_ID
- 1000000003
- SOURCE_DIFF1_ID
- ALT-ALC_CA
- SOURCE_DIFF2_ID
- ALT-ALC_CA
- SOURCE_DIFF3_ID
- ALT-ALC_CA
- SOURCE_DIFF4_ID
- ALT-ALC_CA
- TO_LOC_DEFAULT_WH
- 9003
- ALLOC_SOURCE_WH_ID
- 1000000003
- ASSIGNED_RANGED_SRC_WH
- 9003
default
- ALLOC_IDR
- 1000000005
- TO_LOC
- 5
- PACK_NO
- Alc Calc Flex Supply Chai
- TRAN_ITEM
- Alc Calc Flex Supply Chai
- CHANNEL_ID
- 100005
- ORG_UNIT_ID
- 1000000005
- SOURCE_ITEM
- Alc Calc Flex Supply Chai
- TO_LOC_TYPE
- A
- TRAN_DIFF1_ID
- EDGE-ALC_C
- TRAN_DIFF2_ID
- EDGE-ALC_C
- TRAN_DIFF3_ID
- EDGE-ALC_C
- TRAN_DIFF4_ID
- EDGE-ALC_C
- TSF_ENTITY_ID
- 1000000005
- TRANSFER_BASIS
- A
- SET_OF_BOOKS_ID
- 1000000005
- SOURCE_DIFF1_ID
- EDGE-ALC_C
- SOURCE_DIFF2_ID
- EDGE-ALC_C
- SOURCE_DIFF3_ID
- EDGE-ALC_C
- SOURCE_DIFF4_ID
- EDGE-ALC_C
- TO_LOC_DEFAULT_WH
- 9005
- ALLOC_SOURCE_WH_ID
- 1000000005
- ASSIGNED_RANGED_SRC_WH
- 9005
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 23