Alc Subclass Item Loc SOH Eod

In Scope

Technical: ALC_SUBCLASS_ITEM_LOC_SOH_EOD | ID: OR-RACS-ALC_SUBCLASS_ITEM_LOC_SOH_EOD

This table pre-aggregates inventory buckets from RMS to the subclass/store level. It is meant to aid the performance of the calculation process.

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_SUBCLASS_ITEM_LOC_SOH_EOD

Field Definitions(35)

Rules & Considerations(73)

Sample Load Data(4)

default

LOC
1
DEPT
1001
CLASS
1101
RTV_QTY
11.0000
LOC_TYPE
Alc Subclass Item Loc SOH Eod-001
SUBCLASS
1111
CUSTOMER_RESV
11.0000
PACK_COMP_EXP
11.0000
PACK_COMP_SOH
11.0000
STOCK_ON_HAND
11.0000
IN_TRANSIT_QTY
11.0000
NO_CLR_RTV_QTY
11.0000
PACK_COMP_RESV
11.0000
NON_SELLABLE_QTY
11.0000
PACK_COMP_INTRAN
11.0000
TSF_EXPECTED_QTY
11.0000
TSF_RESERVED_QTY
11.0000
CUSTOMER_BACKORDER
11.0000
PACK_COMP_CUST_BACK
11.0000
PACK_COMP_CUST_RESV
11.0000
NO_CLR_CUSTOMER_RESV
11.0000
NO_CLR_PACK_COMP_EXP
11.0000
NO_CLR_PACK_COMP_SOH
11.0000
NO_CLR_STOCK_ON_HAND
11.0000
NO_CLR_IN_TRANSIT_QTY
11.0000
NO_CLR_PACK_COMP_RESV
11.0000
PACK_COMP_NON_SELLABLE
11.0000
NO_CLR_NON_SELLABLE_QTY
11.0000
NO_CLR_PACK_COMP_INTRAN
11.0000
NO_CLR_TSF_EXPECTED_QTY
11.0000
NO_CLR_TSF_RESERVED_QTY
11.0000
NO_CLR_CUSTOMER_BACKORDER
11.0000
NO_CLR_PACK_COMP_CUST_BACK
11.0000
NO_CLR_PACK_COMP_CUST_RESV
11.0000
NO_CLR_PACK_COMP_NON_SELLABLE
11.0000
Alc Subclass Item Loc SOH Eod | undefined | Oracle Retail