Allocation Session Item Location Exclusion
In ScopeTechnical: ALC_SESSION_ITEM_LOC_EXCL | ID: OR-ALLOC-ALC_SESSION_ITEM_LOC_EXCL-ACTUAL_LANDED_COST_SESSION_ITEM_LOCATION_EXCLUSION
Stores item-location exclusion information for a session id view.
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ALC_SESSION_ITEM_LOC_EXCL
Field Definitions(5)
Rules & Considerations(17)
Sample Load Data(4)
| _scenario | ITEM_LOC_EXCL_SESSION_IDRPK | ITEM_ID | ALLOC_ID | DIFF1_ID | LOC_TYPE | ORDER_NO | ITEM_DESC | LOCATION_ID | REASON_CODE | SOURCE_TYPE | LOCATION_DESC | FACET_SESSION_ID | ITEM_LOC_EXCL_ID | SOURCE_LOCATION_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE |
| default | 1000000003 | ALT-ALC_SESSIO-002 | 1000000003 | ALT-ALC_SESSIO-002 | A | Alc Session Item Loc Excl-002-ALT | Alc Session Item Loc Excl-002-ALT | ALT-ALC_SESSIO-002 | 3 | 3 | Alc Session Item Loc Excl-002-ALT | ALT-ALC_SESSIO-002 | 1000000003 | ALT-ALC_SESSIO-002 |
| default | 1000000005 | EDGE-ALC_SESSIO-003 | 1000000005 | EDGE-ALC_SESSIO-003 | A | Alc Session Item Loc Excl-003-EDGE | Alc Session Item Loc Excl-003-EDGE | EDGE-ALC_SESSIO-003 | 5 | 5 | Alc Session Item Loc Excl-003-EDGE | EDGE-ALC_SESSIO-003 | 1000000005 | EDGE-ALC_SESSIO-003 |
Example values from field definitions
- ITEM_LOC_EXCL_SESSION_IDRPK
- 1
- ITEM_ID
- SAMPLE
- ALLOC_ID
- 1
- DIFF1_ID
- SAMPLE
- LOC_TYPE
- S
- ORDER_NO
- SAMPLE
- ITEM_DESC
- SAMPLE
- LOCATION_ID
- SAMPLE
- REASON_CODE
- 1
- SOURCE_TYPE
- 1
- LOCATION_DESC
- SAMPLE
- FACET_SESSION_ID
- SAMPLE
- ITEM_LOC_EXCL_ID
- 1
- SOURCE_LOCATION_ID
- SAMPLE
default
- ITEM_LOC_EXCL_SESSION_IDRPK
- 1000000003
- ITEM_ID
- ALT-ALC_SESSIO-002
- ALLOC_ID
- 1000000003
- DIFF1_ID
- ALT-ALC_SESSIO-002
- LOC_TYPE
- A
- ORDER_NO
- Alc Session Item Loc Excl-002-ALT
- ITEM_DESC
- Alc Session Item Loc Excl-002-ALT
- LOCATION_ID
- ALT-ALC_SESSIO-002
- REASON_CODE
- 3
- SOURCE_TYPE
- 3
- LOCATION_DESC
- Alc Session Item Loc Excl-002-ALT
- FACET_SESSION_ID
- ALT-ALC_SESSIO-002
- ITEM_LOC_EXCL_ID
- 1000000003
- SOURCE_LOCATION_ID
- ALT-ALC_SESSIO-002
default
- ITEM_LOC_EXCL_SESSION_IDRPK
- 1000000005
- ITEM_ID
- EDGE-ALC_SESSIO-003
- ALLOC_ID
- 1000000005
- DIFF1_ID
- EDGE-ALC_SESSIO-003
- LOC_TYPE
- A
- ORDER_NO
- Alc Session Item Loc Excl-003-EDGE
- ITEM_DESC
- Alc Session Item Loc Excl-003-EDGE
- LOCATION_ID
- EDGE-ALC_SESSIO-003
- REASON_CODE
- 5
- SOURCE_TYPE
- 5
- LOCATION_DESC
- Alc Session Item Loc Excl-003-EDGE
- FACET_SESSION_ID
- EDGE-ALC_SESSIO-003
- ITEM_LOC_EXCL_ID
- 1000000005
- SOURCE_LOCATION_ID
- EDGE-ALC_SESSIO-003
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 17