Alc Item Loc

this column contains a unique item location identifier. this value is derived from the sequence alc_item_loc_seq.

this column contains the unique identifier for the allocation within the application.

this column contains the item identifier.

this column contains the warehouse identifier.

this column contains the release date for this item/warehouse.

this column contains the store identifier.

this column contains the store description.

this column contains the allocated quantity for this item/warehouse/release date/store. this quantity will be a whole number.

this column contains the calculated allocation quantity derived from the algorithm. this number will be zero for manual allocations.

this column contains the need quantity derived from the algorithm. this value would be known as the gross need. this quantity can be a number that contains decimals.this number will be zero for manual allocations.

this column contains the stock on hand for this item/store. this number will be zero for manual allocations.

this column contains the store order multiple for this item.

Used to store backorder quantity information used by Allocation Maintenance Results section.

this column contains the freeze values indicator. valid values are:yes = yno = n

this column would contain the diff1 identifier, if populated.this field will be populated for fashion items.

this column would contain the diff1 description, if diff1 identifier is populated.this field will be populated for fashion items.

this column would contain the diff2 identifier, if populated.this field will be populated for fashion items that have multiple diffs.

this column would contain the diff2 description, if diff2 identifier is populated.this field will be populated for fashion items that have multiple diffs.

this column would contain the parent item identifier, if populated.this field will be populated for fashion items.

this column will contain the purchase order identifier, if populated.

this column will contain the supplier identifier, if populated.

this column would contain the parent item diff1 identifier, if populated.this field will be populated for fashion items.

contains the future unit retail price in the standard unit of measure for the item/location/release date. this field is stored in the local currency

indicates the item need to be rushed for to the location corresponding to itemloc

cost of freight Oracle Retail target column COST on ALC_ITEM_LOC.

the date on which the freight need to reach the location

po or asn number item is sourced from.

This column is used to determain the Source type of the item and works with the order_no and wh_id column, Valid values are 1- PO, 2-ASO, 3-warehouse, 4-Whatif, 5-BOL, 6-TSF

holds gross need value Oracle Retail target column GROSS_NEED_QTY on ALC_ITEM_LOC.

holds rule level on hand value

Item Description. Oracle Retail target column ITEM_DESC on ALC_ITEM_LOC.

ITEM TYPES - FashionSKU, ST,FA,SELLPACK,PACKCOMP,STYLE,NSFSP,, NSFMCP, NSFSCP,NSSSP, NSSCP.

Aggregated Dif 3 ID of the Item

Diff3 description. Oracle Retail target column DIFF3_DESC on ALC_ITEM_LOC.

STOCK_ON_HAND is one of four values that will make up TOTAL_ON_HAND_QTY. Break out across on hand bucket is shown in the hover feature.

IN_TRANSIT is one of four values that will make up TOTAL_ON_HAND_QTY. Break out across on hand bucket is shown in the hover feature.

ON_ORDER is one of four values that will make up TOTAL_ON_HAND_QTY. Break out across on hand bucket is shown in the hover feature.

ON_ALLOC is one of four values that will make up TOTAL_ON_HAND_QTY. Break out across on hand bucket is shown in the hover feature.

Determines whether the location is a store or warehouse. Valid values are S and W

The quantity currently allocated from the item/store