Allocation Item Difference Service Staging
In ScopeTechnical: ALC_SVC_ITEM_LOCS | ID: OR-ALLOC-ALC_SVC_ITEM_LOCS-ACTUAL_LANDED_COST_SERVICE_ITEM_LOCS
Stores stage data for allocation item locations.
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_SVC_ITEM_LOCS
Field Definitions(5)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | COST | WH_ID | ACTION | ROW_ID | ITEM_ID | DIFF1_ID | DIFF2_ID | NEED_QTY | ON_ALLOC | ON_ORDER | ORDER_NO | RLOH_QTY | ALLOC_OUT | ERROR_MSG | FREEZE_IND | IN_TRANSIT | LOCATION_ID | SOURCE_TYPE | RELEASE_DATE | WORKSPACE_ID | ALLOCATED_QTY | BACKORDER_QTY | IN_STORE_DATE | GROSS_NEED_QTY | PROCESS$STATUS | TOTAL_ON_HAND_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | S | 1.0000 | SAMPLE | 1 | 2026-01-01 | 1 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | SAMPLE | 1.0000 |
| default | 12.5000 | ALT-ALC_SVC-002 | Alc Svc It | 100003 | ALT-ALC_SVC-002 | ALT-ALC_SVC-002 | ALT-ALC_SVC-002 | 12.5000 | 12.5000 | 12.5000 | Alc Svc Item Locs-002-ALT | 12.5000 | 12.5000 | Alc Svc Item Locs-002-ALT | A | 12.5000 | ALT-ALC_SVC-002 | 3 | 2026-01-03 | 1000000003 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | PENDING-AL | 12.5000 |
| default | 14.0000 | EDGE-ALC_SVC-003 | Alc Svc It | 100005 | EDGE-ALC_SVC-003 | EDGE-ALC_SVC-003 | EDGE-ALC_SVC-003 | 14.0000 | 14.0000 | 14.0000 | Alc Svc Item Locs-003-EDGE | 14.0000 | 14.0000 | Alc Svc Item Locs-003-EDGE | A | 14.0000 | EDGE-ALC_SVC-003 | 5 | 2026-01-05 | 1000000005 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | ACTIVE-EDG | 14.0000 |
Example values from field definitions
- COST
- 1.0000
- WH_ID
- SAMPLE
- ACTION
- SAMPLE
- ROW_ID
- 1
- ITEM_ID
- SAMPLE
- DIFF1_ID
- SAMPLE
- DIFF2_ID
- SAMPLE
- NEED_QTY
- 1.0000
- ON_ALLOC
- 1.0000
- ON_ORDER
- 1.0000
- ORDER_NO
- SAMPLE
- RLOH_QTY
- 1.0000
- ALLOC_OUT
- 1.0000
- ERROR_MSG
- SAMPLE
- FREEZE_IND
- S
- IN_TRANSIT
- 1.0000
- LOCATION_ID
- SAMPLE
- SOURCE_TYPE
- 1
- RELEASE_DATE
- 2026-01-01
- WORKSPACE_ID
- 1
- ALLOCATED_QTY
- 1.0000
- BACKORDER_QTY
- 1.0000
- IN_STORE_DATE
- 2026-01-01
- GROSS_NEED_QTY
- 1.0000
- PROCESS$STATUS
- SAMPLE
- TOTAL_ON_HAND_QTY
- 1.0000
default
- COST
- 12.5000
- WH_ID
- ALT-ALC_SVC-002
- ACTION
- Alc Svc It
- ROW_ID
- 100003
- ITEM_ID
- ALT-ALC_SVC-002
- DIFF1_ID
- ALT-ALC_SVC-002
- DIFF2_ID
- ALT-ALC_SVC-002
- NEED_QTY
- 12.5000
- ON_ALLOC
- 12.5000
- ON_ORDER
- 12.5000
- ORDER_NO
- Alc Svc Item Locs-002-ALT
- RLOH_QTY
- 12.5000
- ALLOC_OUT
- 12.5000
- ERROR_MSG
- Alc Svc Item Locs-002-ALT
- FREEZE_IND
- A
- IN_TRANSIT
- 12.5000
- LOCATION_ID
- ALT-ALC_SVC-002
- SOURCE_TYPE
- 3
- RELEASE_DATE
- 2026-01-03
- WORKSPACE_ID
- 1000000003
- ALLOCATED_QTY
- 12.5000
- BACKORDER_QTY
- 12.5000
- IN_STORE_DATE
- 2026-01-03
- GROSS_NEED_QTY
- 12.5000
- PROCESS$STATUS
- PENDING-AL
- TOTAL_ON_HAND_QTY
- 12.5000
default
- COST
- 14.0000
- WH_ID
- EDGE-ALC_SVC-003
- ACTION
- Alc Svc It
- ROW_ID
- 100005
- ITEM_ID
- EDGE-ALC_SVC-003
- DIFF1_ID
- EDGE-ALC_SVC-003
- DIFF2_ID
- EDGE-ALC_SVC-003
- NEED_QTY
- 14.0000
- ON_ALLOC
- 14.0000
- ON_ORDER
- 14.0000
- ORDER_NO
- Alc Svc Item Locs-003-EDGE
- RLOH_QTY
- 14.0000
- ALLOC_OUT
- 14.0000
- ERROR_MSG
- Alc Svc Item Locs-003-EDGE
- FREEZE_IND
- A
- IN_TRANSIT
- 14.0000
- LOCATION_ID
- EDGE-ALC_SVC-003
- SOURCE_TYPE
- 5
- RELEASE_DATE
- 2026-01-05
- WORKSPACE_ID
- 1000000005
- ALLOCATED_QTY
- 14.0000
- BACKORDER_QTY
- 14.0000
- IN_STORE_DATE
- 2026-01-05
- GROSS_NEED_QTY
- 14.0000
- PROCESS$STATUS
- ACTIVE-EDG
- TOTAL_ON_HAND_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 24