Item Loc SOH Mfqueue

The sequence in which the records was placed in the ITEM_LOC_SOH_MFQUEUE. Used to order the publication of messages to the RIB.

Set to Unpublished upon insertion into the table. Set to Hospital when a non-fatal error is encountered during the publication process.

The functional area that this transaction belongs to.

Describes the action in RMS that is causing the message to be published to the RIB.

The thread number on which the item location will be published. Each item location has one and only one thread number.

Time of record creation. Oracle Retail target column TRANSACTION_TIME_STAMP on ITEM_LOC_SOH_MFQUEUE.

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 or warehouse

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

Calculated value from item_loc_soh. For example (stock_on_hand + pack_comp_soh – (tsf_reserved_qty + pack_comp_resv + customer_resv + pack_comp_cust_resv + non_sellable_qty + pack_comp_non_sellable + customer_backorder + pack_comp_cust_back + rtv_qty))