Actual Landed Cost Itemsearch Items (GTT)
Out of ScopeTechnical: ALC_ITEMSEARCH_ITEMS_GTT | ID: OR-ALLOC-ALC_ITEMSEARCH_ITEMS_GTT-ALC_ITEMSEARCH_ITEMS_GTT
Working table to help the PLSQL item search logic. This table is used to hold the transaction level item warehouse combinations that meet the search criteria.
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_ITEMSEARCH_ITEMS_GTT
Field Definitions(5)
Rules & Considerations(6)
Sample Load Data(4)
| _scenario | ITEM | LOCATION | ROLLUP_ITEM | ROLLUP_TYPE | ROLLUP_ITEM_DESC | MULTI_COLOR_PACK_IND |
|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | S |
| default | Alc Itemsearch Items Gtt- | 3 | Alc Itemsearch Items Gtt- | Alc Itemsearch Items | Alc Itemsearch Items Gtt-002-ALT | A |
| default | Alc Itemsearch Items Gtt- | 5 | Alc Itemsearch Items Gtt- | Alc Itemsearch Items | Alc Itemsearch Items Gtt-003-EDGE | A |
Example values from field definitions
- ITEM
- SAMPLE
- LOCATION
- 1
- ROLLUP_ITEM
- SAMPLE
- ROLLUP_TYPE
- SAMPLE
- ROLLUP_ITEM_DESC
- SAMPLE
- MULTI_COLOR_PACK_IND
- S
default
- ITEM
- Alc Itemsearch Items Gtt-
- LOCATION
- 3
- ROLLUP_ITEM
- Alc Itemsearch Items Gtt-
- ROLLUP_TYPE
- Alc Itemsearch Items
- ROLLUP_ITEM_DESC
- Alc Itemsearch Items Gtt-002-ALT
- MULTI_COLOR_PACK_IND
- A
default
- ITEM
- Alc Itemsearch Items Gtt-
- LOCATION
- 5
- ROLLUP_ITEM
- Alc Itemsearch Items Gtt-
- ROLLUP_TYPE
- Alc Itemsearch Items
- ROLLUP_ITEM_DESC
- Alc Itemsearch Items Gtt-003-EDGE
- MULTI_COLOR_PACK_IND
- A
Rule Validation Summary
- Source Rule Count
- 12
- Governed Rule Count
- 6