Alc Alloc

In Scope

Technical: ALC_ALLOC | ID: OR-RACS-ALC_ALLOC

Stores a record for all allocations created within oracle retail allocation. this table is the primary place for header level allocation information.

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
ALC_ALLOC

Field Definitions(25)

Rules & Considerations(70)

Sample Load Data(4)

default

TYPER
SA
STATUSR
ACTIVE
ALLOC_IDRPK
1000000001
CREATED_BYR
Alc Alloc-001
CREATED_DATER
2026-01-01
PROCESS_STATUSR
ACTIVE
AUTO_QTY_LIMITS_INDR
N
NEVER_UPDATE_GROUP_INDR
N
ENFORCE_WH_STORE_REL_INDR
yes
NON_SELL_FASHION_PACK_ONLPK
N
LAST_UPDATE_DATEYTIMESTAMP(6)1123LAST_UPDATED_BYR
2026-01-01
CONTEXT
Alc Alloc-001
PARENT_ID
1000000001
PROMOTION
1
ALLOC_DESC
Alc Alloc-001
EXT_REF_ID
STD-ALC_ALLOC-001
PROMO_DESC
Alc Alloc-001
ALLOC_COMMENT
Alc Alloc-001
PARENT_ALLOCATION
Alc Alloc-001
MLD_APPROVAL_LEVEL
Alc Alloc-001
MLD_MODIFIED_LEVEL
Alc Alloc-001
RULE_TEMPLATE_NAME
Alc Alloc Primary
DEAGGREGATED_FASHION
Alc Alloc-001
LOCATION_TEMPLATE_NAME
Alc Alloc Primary
RELEASE_DATE_FROM_IN_STORE_IND
2026-01-01