Allocation Detail
In ScopeTechnical: ALLOC_DETAIL | ID: OR-ALLOC-ALLOC_DETAIL-ALLOCATION_DETAIL
Stores one row for every allocation store/warehouse combination. Allocations can be attached to a purchase order or can be created as standalone.
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
- ALLOC_DETAIL
Field Definitions(5)
Rules & Considerations(36)
constraint
validation
Sample Load Data(4)
| _scenario | TO_LOCRPK | ALLOC_NORPK | TO_LOC_TYPER | QTY_ALLOCATEDR | CREATE_ID | RUSH_FLAG | QTY_DISTRO | PO_RCVD_QTY | WF_ORDER_NO | QTY_RECEIVED | QTY_SELECTED | IN_STORE_DATE | NON_SCALE_IND | PROCESSED_IND | QTY_CANCELLED | QTY_PRESCALED | LAST_UPDATE_ID | QTY_RECONCILED | CREATE_DATETIME | QTY_TRANSFERRED | UPDATED_BY_WMS_IND | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | 1.0000 | SAMPLE | S | 1.0000 | 1.0000 | 1 | 1.0000 | 1.0000 | 2026-01-01 | S | S | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | S | 2026-01-01 |
| default | 3 | 4 | A | 12.5000 | CLIENT_INFO | A | 12.5000 | 12.5000 | 4 | 12.5000 | 12.5000 | 2026-01-03 | N | N | 12.5000 | 12.5000 | CLIENT_INFO | 12.5000 | 2026-01-03 | 12.5000 | 2 | 2026-01-03 |
| default | 5 | 6 | A | 14.0000 | SESSI ON_USER | A | 14.0000 | 14.0000 | 6 | 14.0000 | 14.0000 | 2026-01-05 | Y | N | 14.0000 | 14.0000 | SESSI ON_USER | 14.0000 | 2026-01-05 | 14.0000 | 2 | 2026-01-05 |
Example values from field definitions
- TO_LOCRPK
- 1
- ALLOC_NORPK
- 1
- TO_LOC_TYPER
- S
- QTY_ALLOCATEDR
- 1.0000
- CREATE_ID
- SAMPLE
- RUSH_FLAG
- S
- QTY_DISTRO
- 1.0000
- PO_RCVD_QTY
- 1.0000
- WF_ORDER_NO
- 1
- QTY_RECEIVED
- 1.0000
- QTY_SELECTED
- 1.0000
- IN_STORE_DATE
- 2026-01-01
- NON_SCALE_IND
- S
- PROCESSED_IND
- S
- QTY_CANCELLED
- 1.0000
- QTY_PRESCALED
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- QTY_RECONCILED
- 1.0000
- CREATE_DATETIME
- 2026-01-01
- QTY_TRANSFERRED
- 1.0000
- UPDATED_BY_WMS_IND
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- TO_LOCRPK
- 3
- ALLOC_NORPK
- 4
- TO_LOC_TYPER
- A
- QTY_ALLOCATEDR
- 12.5000
- CREATE_ID
- CLIENT_INFO
- RUSH_FLAG
- A
- QTY_DISTRO
- 12.5000
- PO_RCVD_QTY
- 12.5000
- WF_ORDER_NO
- 4
- QTY_RECEIVED
- 12.5000
- QTY_SELECTED
- 12.5000
- IN_STORE_DATE
- 2026-01-03
- NON_SCALE_IND
- N
- PROCESSED_IND
- N
- QTY_CANCELLED
- 12.5000
- QTY_PRESCALED
- 12.5000
- LAST_UPDATE_ID
- CLIENT_INFO
- QTY_RECONCILED
- 12.5000
- CREATE_DATETIME
- 2026-01-03
- QTY_TRANSFERRED
- 12.5000
- UPDATED_BY_WMS_IND
- 2
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- TO_LOCRPK
- 5
- ALLOC_NORPK
- 6
- TO_LOC_TYPER
- A
- QTY_ALLOCATEDR
- 14.0000
- CREATE_ID
- SESSI ON_USER
- RUSH_FLAG
- A
- QTY_DISTRO
- 14.0000
- PO_RCVD_QTY
- 14.0000
- WF_ORDER_NO
- 6
- QTY_RECEIVED
- 14.0000
- QTY_SELECTED
- 14.0000
- IN_STORE_DATE
- 2026-01-05
- NON_SCALE_IND
- Y
- PROCESSED_IND
- N
- QTY_CANCELLED
- 14.0000
- QTY_PRESCALED
- 14.0000
- LAST_UPDATE_ID
- SESSI ON_USER
- QTY_RECONCILED
- 14.0000
- CREATE_DATETIME
- 2026-01-05
- QTY_TRANSFERRED
- 14.0000
- UPDATED_BY_WMS_IND
- 2
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 52
- Governed Rule Count
- 36