Actual Landed Cost Itemsearch Inventory (GTT)
Out of ScopeTechnical: ALC_ITEMSEARCH_INV_GTT | ID: OR-ALLOC-ALC_ITEMSEARCH_INV_GTT-ALC_ITEMSEARCH_INV_GTT
Internal helper table for the ALC_ITEM_SEARCH_SQL 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_ITEMSEARCH_INV_GTT
Field Definitions(5)
Rules & Considerations(19)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | DOC_NO | LOCATION | AVAIL_QTY | ITEM_DESC | ROLLUP_ITEM | ROLLUP_TYPE | SOURCE_TYPE | BACKORDER_QTY | ROLLUP_ITEM_DESC | MULTI_COLOR_PACK_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPL | 1.0000 | SAMPLE | S |
| default | Alc Itemsearch Inv Gtt-00 | Alc Itemse | Alc Itemse | Alc Itemse | Alc Itemse | Alc Itemsearch Inv Gtt-002-ALT | 3 | 12.5000 | Alc Itemsearch Inv Gtt-002-ALT | Alc Itemsearch Inv Gtt-00 | Alc Itemsearch Inv G | Alc I | 12.5000 | Alc Itemsearch Inv Gtt-002-ALT | A |
| default | Alc Itemsearch Inv Gtt-00 | Alc Itemse | Alc Itemse | Alc Itemse | Alc Itemse | Alc Itemsearch Inv Gtt-003-EDG | 5 | 14.0000 | Alc Itemsearch Inv Gtt-003-EDGE | Alc Itemsearch Inv Gtt-00 | Alc Itemsearch Inv G | Alc I | 14.0000 | Alc Itemsearch Inv Gtt-003-EDGE | A |
Example values from field definitions
- ITEMR
- SAMPLE
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- DOC_NO
- SAMPLE
- LOCATION
- 1
- AVAIL_QTY
- 1.0000
- ITEM_DESC
- SAMPLE
- ROLLUP_ITEM
- SAMPLE
- ROLLUP_TYPE
- SAMPLE
- SOURCE_TYPE
- SAMPL
- BACKORDER_QTY
- 1.0000
- ROLLUP_ITEM_DESC
- SAMPLE
- MULTI_COLOR_PACK_IND
- S
default
- ITEMR
- Alc Itemsearch Inv Gtt-00
- DIFF_1
- Alc Itemse
- DIFF_2
- Alc Itemse
- DIFF_3
- Alc Itemse
- DIFF_4
- Alc Itemse
- DOC_NO
- Alc Itemsearch Inv Gtt-002-ALT
- LOCATION
- 3
- AVAIL_QTY
- 12.5000
- ITEM_DESC
- Alc Itemsearch Inv Gtt-002-ALT
- ROLLUP_ITEM
- Alc Itemsearch Inv Gtt-00
- ROLLUP_TYPE
- Alc Itemsearch Inv G
- SOURCE_TYPE
- Alc I
- BACKORDER_QTY
- 12.5000
- ROLLUP_ITEM_DESC
- Alc Itemsearch Inv Gtt-002-ALT
- MULTI_COLOR_PACK_IND
- A
default
- ITEMR
- Alc Itemsearch Inv Gtt-00
- DIFF_1
- Alc Itemse
- DIFF_2
- Alc Itemse
- DIFF_3
- Alc Itemse
- DIFF_4
- Alc Itemse
- DOC_NO
- Alc Itemsearch Inv Gtt-003-EDG
- LOCATION
- 5
- AVAIL_QTY
- 14.0000
- ITEM_DESC
- Alc Itemsearch Inv Gtt-003-EDGE
- ROLLUP_ITEM
- Alc Itemsearch Inv Gtt-00
- ROLLUP_TYPE
- Alc Itemsearch Inv G
- SOURCE_TYPE
- Alc I
- BACKORDER_QTY
- 14.0000
- ROLLUP_ITEM_DESC
- Alc Itemsearch Inv Gtt-003-EDGE
- MULTI_COLOR_PACK_IND
- A
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 19