Store Item Stock

the unique identifier of the item. this should be the item number at the level that the item is sold and inventory tracked at.

the unique identifier of the store where the inventory is located.

total quantity of the item that is in the stores inventory and that is sellable.

the quantity of the item that is reserved for transferring out of the store. this is the quantity for items that have transfer out events and return to warehouse events that are in pending status.

the quantity of the item that is reserved for customers.

the quantity of the item that is in transit to this store.

the quantity of the item that is reserved for a return to vendor event that is in the pending state.

the quantity of the item that is not available for sale and is used for stock events where the inventory is moved from unavailable to another status. for example an inventory adjustment may move some of the inventory from this bucket to available to sell.

the quantity of the item that is on the shop floor.

the quantity of the item that is in the delivery bay.

the date of when the store last received inventory for this item into the store.

The total amount of inventory for all receipts on the day specified by LAST_RECEIVED_DAY

the number of stock counts that are open for this item at this store.

the type of the last stock count that was performed.1 - Unit, 2 - Unit and amount,3 - Problem line, 4 - Adhoc,5 - RMS Sync

the date of the last approved stock count.

indicates whether this stock count was conducted before store opening or after store closing. Valid values are:B - Before store open,A - After store open,N - the default value

uin problem line indicator, y indicates a uin problem line item.

First date item was received in stock

Update date Oracle Retail target column UPDATE_DATE on STORE_ITEM_STOCK.

The quantity last requested for this item.

The day the item was last requested.

The quantity requested today for this item.