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 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 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 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 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 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 ACTIVE, INACTIVE, DISCONTINUED, DELETED, AUTO_STOCKABLE, NON_RANGED, UNKNOWN, NO_VALUE. Default case size Unique Identifier Number type. Empty if item does not support UINs. Valid values are SERIAL, AGSN, UNKNOWN. 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 The currency code of the manufacturer's suggested retail price. A standardized 3 character code defined in ISO-4217. The amount of the manufacturer's suggested retail price. 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 Store item reference Sku number Store identifier. Collection of store item headers Collection of store item headers Size of the collection. 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. Successful message string. Collection of related items. Collection of related items. Size of the collection. 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 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