Item Loc SOH Eod

Unique alphanumeric value that identifies the item.

Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher.

Type of location in the location field. Valid values are S (store), W (warehouse), and E (external finisher).

Alphanumeric value that uniquely identifies the item/group at the level above the item.

Alphanumeric value that uniquely identifies the item/group two levels above the item.

Calculated using POs estimated landed cost during Purchase Order (PO) receiving process if elc_ind = y. This field is stored in the local currency. Pack items will not have an average cost stored on item_loc. The stock of a pack item is valued at the component level and therefore an average cost is not applicable for pack items.

If system_options.std_av_ind = a and elc_ind = y then this field holds the estimated landed cost when item is initially set up. It is then updated with POs estimated landed cost each time this item is received at this location. Otherwise, this field holds the primary supplier cost. This field is stored in the local currency. Pack items will not have a unit cost stored on item_loc. Stock of a pack item is valued at the component level and therefore a unit cost is not applicable for pack.

Current stock on hand for the item.

Current stock on hand for pack component item.

All quantities of an item shipped but not received on all transfers and allocations for the destination location.

All quantities of a pack component item shipped but not received on all transfers and allocations for the destination location.

The sum of all requested quantities of an item that have not been shipped on all transfers and stand alone allocations for the source location.

The sum of all requested quantities of a pack component item that have not been shipped on all transfers and stand alone allocations for the source location.

The sum of all expected quantities of an item that have not been shipped on all transfers and stand alone allocations for the destination location.

The sum of all expected quantities of a pack component item that have not been shipped on all transfers and stand alone allocations for the destination location.

All quantities approved but not shipped on all Return To Vendor transactions (RTV) from inventory for an item/location. Will reduce stock on hand when RTV is shipped.

Total non-sellable quantity for an item/location (i.e. sum of inv_status_qty.qty for an item/location across all inventory statuses).

Contains the units of a bulk SKU that are part of unavailable prepacks at a location (store or warehouse).

This will hold the number of units being reserved for customer orders.

This will hold the number of packs being reserved for customer orders.

This will hold the number of units held for customer back orders.

This will hold the number of packs held for customer back orders.

The number of units of the adjusted (inventory adjustment/stock count) item currently at the finisher.

A new field to hold the average simple pack weight for a catch weight simple pack.

Weighted average retail of all the units of the transfer item currently at the finisher.

Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated.

Holds the Oracle user-id of the user who created this record.

Holds the date time stamp of the most recent update by the last_update_id.

Holds the Oracle user-id of the user who most recently updated this record.

The quantity of in progress sale of the item at this location.

Date the item was first received into the system at the location.

Date the item was most recently received into the system at the location.

Number of items received on the most recent received date at the location.

The date of the first sale of the item at this location.

The date of the most recent sale of the item at this location.

The quantity of the most recent sale of the item at this location.

This columns is a mirror of item_loc.primary_cntry and is on this table for performance reasons.

This columns is a mirror of item_loc.primary_supp and is on this table for performance reasons.

This field contains the most recent date up to which sales/issues have been exported to an external system for the item/store or item/warehouse combination.

Date and time of most recent update to stock_on_hand or pack_comp_soh.

All quantities of an item shipped on all transfers from the sending location. This field is used if the system is configured to change inventory ownership to the receiving location when transfer shipments are received.

All quantities of a pack component item shipped on all transfers from the sending location. This field is used if the system is configured to change inventory ownership to the receiving location when transfer shipments are received.