Alloc Detail

In Scope

Technical: ALLOC_DETAIL | ID: OR-MFCS-ALLOC_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

Target Structure

Load Approach
Table
Target Objects
ALLOC_DETAIL

Field Definitions(22)

Rules & Considerations(64)

Sample Load Data(4)

default

TO_LOCR
1
ALLOC_NORPK
2
CREATE_IDR
USERENV
TO_LOC_TYPER
Alloc Detail-001
WF_ORDER_NOPK
2
NON_SCALE_INDR
Y
PROCESSED_INDR
N
QTY_ALLOCATEDR
11.0000
QTY_PRESCALEDR
11.0000
LAST_UPDATE_IDR
USERENV
CREATE_DATETIMER
2026-01-01
LAST_UPDATE_DATETIMER
2026-01-01
RUSH_FLAG
Alloc Detail-001
QTY_DISTRO
11.0000
PO_RCVD_QTY
11.0000
QTY_RECEIVED
11.0000
QTY_SELECTED
11.0000
IN_STORE_DATE
2026-01-01
QTY_CANCELLED
11.0000
QTY_RECONCILED
11.0000
QTY_TRANSFERRED
11.0000
UPDATED_BY_WMS_IND
2026-01-01
Alloc Detail | undefined | Oracle Retail