Item Loc SOH

Unique alphanumeric value that identifies the item.

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.

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).

This column initially defaults to the unit cost and then is re-calculated any time a receipt into the location occurs, using the estimated landed cost for PO receipts and the from-location average cost for transfer or allocation receipts. It holds the average cost of the units of inventory held at the location. This field is stored in the local currency. For pack items an average cost will not be maintained as the inventory valuation is held at the pack component level.

This column is populated with the unit cost for the item for the primary supplier of the location. This field is stored in the local currency. Pack items will have a unit cost if they are orderable.

Current stock on hand for the item.

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

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

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

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

Current stock on hand for pack component item

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 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 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 RTVs 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).

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

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

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

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

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 date time stamp of the most recent update by the last_update_id. This field is required by the database.

Holds the Oracle user-id of the user who most recently updated this record. This field is required by the database.

Date the item was first received into the system at the location. This field is not displayed in the on-line item location maintenance dialog, but will be populated during the first receipt of the item at the location.

Date the item was most recently received into the system at the location. This field is not displayed in the on-line item location maintenance dialog, but will be populated each time an item is received at the location.

Number of items received on the most recent received date at the location. This field is not displayed in the on-line item location maintenance dialog, but will be populated each time an item is received 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 qty of the most recent sale of the item at this location.

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

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

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.

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

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

This column holds the User id of the user who created the record.

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

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.