Detail

Retrieving inventory requires accessing four very large Merchandising tables:

• ITEM_LOC_SOH - current inventory and components of future inventory

• ORDLOC - on order component of future inventory

• ALLOC_DETAIL - allocation in component of future inventory

• TSFDETAIL - crosslink transfer component of future inventory

To improve RLOH performance, four new subclass level aggregated tables are created for use by Allocation

Table 4-3 RLOH Aggregated Tables

Table	Candidate Key	Source Tables
SUBCLASS_ITEM_LOC_SOH_EOD	Dept Class Subclass Loc	ITEM_LOC_SOH ITEM_MASTER
SUBCLASS_ON_ORDER_EOD	Dept Class Subclass Loc On_order_date	ORDLOC ORDHEAD ITEM_MASTER PACKITEM_BREAKOUT
SUBCLASS_ALLOC_IN_EOD	Dept Class Subclass Loc Alloc_in_date	ALLOC_DETAIL ALLOC_HEADER ITEM_MASTER PACKITEM_BREAKOUT ORDHEAD TSFHEAD
SUBCLASS_CROSSLINK_EOD	Dept Class Subclass Loc	TSFHEAD TSFDETAIL ITEM_MASTER PACKITEM_BREAKOUT
SUBCLASS_ALLOC_OUT_EOD	Dept Class Subclass Loc Alloc_Out_Date	ALLOC_DETAIL ALLOC_HEADER ITEM_MASTER ORDHEAD PACKITEM_BREAKOUT
ALC_SUBCLASS_CUST_ORDER_EOD	Dept Class Subclass Loc	TSFHEAD TSFDETAIL ITEM_MASTER PACKITEM_BREAKOUT

These tables are populated by the ALC_HIER_LVL_INV_SNAPSHOT_SQL package (called by a batch program) nightly.