Successful message string.
Store item header query by inventory status (available or non-available) criteria.
Store identifier
Include only items with this merchandise hierarchy department identifier.
Include only items with this merchandise hierarchy class identifier.
Include only items with this merchandise hierarchy subclass identifier
True if should include non-ranged items, false if only ranged items.
Include only items containing this description.
Maximum number of items to return from the query.
Include only items with inventory in this status. Valid values are AVAILABLE, UNAVAILABLE.
Include only items with this SIM internal non-sellable quantity type identifier.
Store item header query by item or Universal Identifier Number (UIN) criteria.
Store identifier
Include only items with this merchandise hierarchy department identifier.
Include only items with this merchandise hierarchy class identifier.
Include only items with this merchandise hierarchy subclass identifier
True if should include non-ranged items, false if only ranged items.
Include only items containing this description.
Maximum number of items to return from the query.
Include only items matching this sku number or embedded within the barcode.
Include only items that have at least one occurance this universal identifier number.
Store item header query by source (supplier, finisher, warehouse) criteria.
Store identifier
Include only items with this merchandise hierarchy department identifier.
Include only items with this merchandise hierarchy class identifier.
Include only items with this merchandise hierarchy subclass identifier
True if should include non-ranged items, false if only ranged items.
Include only items containing this description.
Maximum number of items to return from the query.
Include only items from this source type. Valid values are SUPPLIER, WAREHOUSE, FINISHER.
Include only items from a source with this identifier.
Store item header query by user defined attributes criteria.
Store identifier
Include only items with this merchandise hierarchy department identifier.
Include only items with this merchandise hierarchy class identifier.
Include only items with this merchandise hierarchy subclass identifier
True if should include non-ranged items, false if only ranged items.
Include only items containing this description.
Maximum number of items to return from the query.
Include only items that contain this text type user defined attribute identifier.
Include only items that contain this user defined attribute text. This field is required if text_uda_id exists.
Include only items that contain this value type user defined attribute identifier.
Include only items with uda(s) containing this value. This field is required if value_uda_id exists.
Include only items that contain this date type user defined attribute identifier.
Include only items with uda(s) after this date. This field is required if date_uda_id exists.
Include only items with uda(s) before this date. This field is required if date_uda_id exists.
Store item detail information
Item identifier
Store identifier
Item parent identifier
Item type. Valid values are ITEM, CONSIGNMENT, CONCESSION, NON_INVENTORY, PACK_SIMPLE, PACK_COMPLEX, PACK_SIMPLE_BREAKABLE, PACK_COMPLEX_BREAKABLE, UNKNOWN.
True if item is sellable, false otherwise
True if item is orderable, false otherwise
Short description
Long description
Merchandise hierarchy department identifier
Merchandise hierarchy department name
Merchandise hierarchy class identifier
Merchandise hierarchy class name
Merchandise hierarchy subclass id
Merchandise hierarchy subclass name
Standard unit of measure
Current status Valid values are NONE, ACTIVE, INACTIVE, DISCONTINUED, DELETED, AUTO_STOCKABLE, NON_RANGED.
Default case size
Unique Identifier Number type. Empty if item does not support UINs. Valid values are SERIAL_NUMBER, AGSN.
Unique Identifier Number label. Empty if item does not support UINs.
Unavailable inventory quantity
Non-Sellable inventory quantity
Customer reserved inventory quantity
In transit inventory quantity
Inventory quantity in delivery bay area
Inventory quantity in back room area
Inventory quantity on shop floor
Stock on hand inventory quantity
Available inventory quantity
Transfer reserved inventory quantity
Vendor return inventory quantity
Ordered quantity
Inventory quantity received today
Date item was last received at store
Primary supplier identifier
Primary supplier name
Primary store area sequence identifier
Prime store area sequence name
Universal Product Code
Vendor Product Number
Suggested ticket type code
True if store order is allowed, false otherwise
True if this item is store order replenishment, false otherwise
True if multiple deliveries are allowed, false otherwise
True if quantities inquires should return inventory at the pack level, false indicates it should be estimated from components.
First differentiator type
First differentiator description
Second differentiator type
Second differentiator description
Third differentiator type
Third differentiator description
Fourth differentiator type
Fourth differentiator description.
Price type Valid values are CLEARANCE, PROMOTIONAL, PERMANENT, UNKNOWN, NO_VALUE.
Price promotion type Valid values are COMPLEX, SIMPLE, THRESHOLD, CREDIT, UNKNOWN, NO_VALUE.
Retail price
Retail currency code. A standardized 3 character code defined in ISO-4217
Retail price effective date
Replenishment method code
Multiple unit quantity
Multiple unit price
Multiple unit price currency code. A standardized 3 character code defined in ISO-4217.
Selling unit of measure of multiple units
Next delivery date
Collection of nonSellable quantities by individual non-sellable reason
Collection of user defined attributes
Collection of suppliers
Collection of item images
Store item image
Store item image's universal resource locator.
Store item non-sellable quantity (sub-value of total non-sellable quantity)
SIM internal non-sellable quantity type identifier
Quantity
Store item supplier
SIM internal supplier identifier
Supplier name
Store item user defined attribute
SIM internal user defined attribute identifier.
Value of the user defined attribute
Collection of store item headers
Collection of store item headers
Size of the collection.
Store item header information
Item identifier
Store identifier
Item type Valid values are ITEM, CONSIGNMENT, CONCESSION, NON_INVENTORY, PACK_SIMPLE, PACK_COMPLEX, PACK_SIMPLE_BREAKABLE, PACK_COMPLEX_BREAKABLE, UNKNOWN.
Short description
Long description
Merchandise hierarchy department name
Merchandise hierarchy class name
Merchandise hierarchy subclass name.
Primary supplier identifier
Primary supplier name
True if inventory exists at the criteria input store, false otherwise.
Collection of store item images.
Collection of store item images.
Size of the collection.
Store item image
Sku number
Store identifier. This field is required if the type is QR_CODE.
Universal resource locator
Type Valid values are IMAGE, QR_CODE, UNKNOWN.
Name
Date image becomes active.
Date image ceases being active
Store item reference
Sku number
Store identifier.
Collection of related items.
Collection of related items.
Size of the collection.
Store Related Item Search Criteria Value Object.
Parent sku number id of a set of child items that are related.
Sku number
Store identifier
Store item related item information.
Related sku number
Short description
Long description
Unit of measure
Available stock on hand quantity.
Item differentiator type 1.
Item differentiator type 1 description.
Item differentiator type 2.
Item differentiator type 2 description.
Item differentiator type 3.
Item differentiator type 3 description.
Item differentiator type 4.
Item differentiator type 4 description.
The date this related item becomes effective.
The date this related item is no longer effective.
Relationship type
Mandatory indicator
This service describes the Oracle Retail Store Inventory Management(SIM) Item service