Actual Landed Cost Calculation Rule Priority (GTT)
Out of ScopeTechnical: ALC_CALC_RULE_PRIORITY_GTT | ID: OR-ALLOC-ALC_CALC_RULE_PRIORITY_GTT-ALC_CALC_RULE_PRIORITY_GTT
Global temporary working table used during allocation processing processing in Oracle Retail Allocation to hold intermediate or session-specific results. Data is transient and supports calculations, matching, validation, or document processing...
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_RULE_PRIORITY_GTT
Field Definitions(5)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | TO_LOC | ALLOC_ID | TRAN_ITEM | CHANNEL_ID | ORG_UNIT_ID | PHYSICAL_WH | SOURCE_ITEM | TO_LOC_TYPE | PROTECTED_IND | 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 | ALLOC_SOURCE_WH_ID | ASSIGNED_PRIORITY_WH |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | S | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 |
| default | 3 | 1000000003 | Alc Calc Rule Priority Gt | 1000000003 | 1000000003 | 9003 | Alc Calc Rule Priority Gt | A | A | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | 1000000003 | T | 1000000003 | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | ALT-ALC_CA | 1000000003 | 9003 |
| default | 5 | 1000000005 | Alc Calc Rule Priority Gt | 1000000005 | 1000000005 | 9005 | Alc Calc Rule Priority Gt | A | A | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | 1000000005 | T | 1000000005 | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | EDGE-ALC_C | 1000000005 | 9005 |
Example values from field definitions
- TO_LOC
- 1
- ALLOC_ID
- 1
- TRAN_ITEM
- SAMPLE
- CHANNEL_ID
- 1
- ORG_UNIT_ID
- 1
- PHYSICAL_WH
- 1
- SOURCE_ITEM
- SAMPLE
- TO_LOC_TYPE
- S
- PROTECTED_IND
- 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
- ALLOC_SOURCE_WH_ID
- 1
- ASSIGNED_PRIORITY_WH
- 1
default
- TO_LOC
- 3
- ALLOC_ID
- 1000000003
- TRAN_ITEM
- Alc Calc Rule Priority Gt
- CHANNEL_ID
- 1000000003
- ORG_UNIT_ID
- 1000000003
- PHYSICAL_WH
- 9003
- SOURCE_ITEM
- Alc Calc Rule Priority Gt
- TO_LOC_TYPE
- A
- PROTECTED_IND
- 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
- T
- 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
- ALLOC_SOURCE_WH_ID
- 1000000003
- ASSIGNED_PRIORITY_WH
- 9003
default
- TO_LOC
- 5
- ALLOC_ID
- 1000000005
- TRAN_ITEM
- Alc Calc Rule Priority Gt
- CHANNEL_ID
- 1000000005
- ORG_UNIT_ID
- 1000000005
- PHYSICAL_WH
- 9005
- SOURCE_ITEM
- Alc Calc Rule Priority Gt
- TO_LOC_TYPE
- A
- PROTECTED_IND
- 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
- T
- 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
- ALLOC_SOURCE_WH_ID
- 1000000005
- ASSIGNED_PRIORITY_WH
- 9005
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 22