Itemloc Mfqueue

The sequence in which the record was placed on the table. Used to order the publication of messages to the RIB.

Item identifier from the item_loc table.

Location identifier from the item_loc table.

Specifies whether the location is a store or warehouse.

For warehouses, this will contain the whs physical warehouse. For stores, this will contain the store.

Snapshot of the local_item_desc column on the item_loc table.

Snapshot of the local_short_desc column on the item_loc table.

Snapshot of the status column on the item_loc table.

Snapshot of the primary_supp column on the item_loc table.

Snapshot of the primary_cntry column on the item_loc table.

Snapshot of the receive_as_type column on the item_loc table.

Snapshot of the taxable_ind column on the item_loc table.

Snapshot of the source_method column on the item_loc table.

Snapshot of the source_wh column on the item_loc table.

Snapshot of the primary_repl_supplier column on the repl_item_loc table.

Snapshot of the repl_method column on the repl_item_loc table.

Snapshot of the reject_store_order_ind column on the repl_item_loc table.

Snapshot of the next_delivery_date column on the repl_item_loc table.

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

The thread on which the business transaction will be published. Each business object has one and only one thread_no. For the itemloc_mfqueue table, the business object id is item.

The functional area that the transaction belongs to.

Not used by RMS. Oracle Retail target column CUSTOM_MESSAGE_TYPE on ITEMLOC_MFQUEUE.

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

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

Indicates if an item at a particular store location can have the unit retail marked down by the store.

Contains the unit retail price in the standard unit of measure for the item/location combination.

Contains the unit retail price in the selling unit of measure for the item/location combination.

Contains the selling unit of measure for an items single-unit retail.

This indicates if an item can be replenished multiple times per day at the location. Default value is N

This Column will contain the unique identification number (UIN) used to identify the instances of the item at the location.

This column will contain the label for the UIN when displayed in SIM.

This column will indicate when the UIN should be captured for an item during transaction processing.

This Yes/No indicator indicates if UIN is being generated in the external system.

Snapshot of the ranged_ind column on the item_loc table.

This field will contain a value of Yes when the item can be returned to the location.

holds the custom flex attribute group id that the extended attribute is associated with