ShoppingSearchesresultItems
Holds detailed data for items returned in a shopping search, including item ID, pricing, and availability.
Columns
| Name | Type | SupportedFinders | Description |
| ShoppingSearchesSearchPhraseId [KEY] | Long | Unique identifier linking to the search phrase used in the ShoppingSearches table, allowing for specific filtering of result items by search term. | |
| ItemKey [KEY] | String | Unique identifier for the item in the result set, allowing for precise tracking and referencing of individual items. | |
| ItemId | Long | Unique identifier for the item within the system, used for internal tracking and linking to the item’s detailed data. | |
| PunchoutItemId | Long | Identifier for punchout items, typically used in procurement systems to represent items sourced from external catalogs. | |
| PunchoutCatalogId | Long | Identifier for the punchout catalog that the item belongs to, linking it to a third-party supplier's catalog. | |
| ItemDescription | String | A detailed description of the item, providing relevant information about the product for the search result. | |
| CurrencyCode | String | Code representing the currency in which the item’s prices are listed, such as USD or EUR. | |
| OrderTypeLookupCode | String | Lookup code identifying the type of order, used for categorizing orders based on their purpose or processing method. | |
| CategoryName | String | The name of the category to which the item belongs, helping to classify the item within a specific group for easier searching. | |
| CurrencyUnitPrice | Decimal | The unit price of the item in the specified currency, used to indicate the cost per individual item. | |
| UnitPrice | Decimal | The unit price of the item, potentially in the system's default currency, representing the cost per unit. | |
| CurrencyAmount | Decimal | The total price of the item in the specified currency, calculated by multiplying the unit price by the quantity. | |
| Amount | Decimal | The total price of the item, potentially in the system's default currency, calculated by multiplying the unit price by the quantity. | |
| Manufacturer | String | The manufacturer or brand name associated with the item, providing context for the item's origin or producer. | |
| ThumbnailImage | String | URL or path to a small image of the item, typically used for visual representation in a search result. | |
| ItemSource | String | Source of the item, which could indicate whether the item is from an internal catalog, a supplier, or a punchout catalog. | |
| FunctionalCurrencyCode | String | Code representing the functional currency used for accounting or financial purposes within the system. | |
| FunctionalCurrencySymbol | String | Symbol of the functional currency, used for display purposes in the user interface (for example, $, €, £). | |
| CatalogItemKey [KEY] | Long | Unique key used to reference the catalog item, linking it to specific catalog data in the system. | |
| UnitOfMeasure | String | Unit of measurement for the item, indicating how the item is quantified (for example, each, box, kg). | |
| FormattedUnitPrice | String | Formatted string representing the unit price, often used for display purposes, including the currency symbol. | |
| FormattedCurrencyUnitPrice | String | Formatted string representing the unit price in a specified currency, ready for display with the appropriate currency symbol. | |
| FormattedAmount | String | Formatted string representing the total amount, often used for display purposes with the appropriate currency symbol. | |
| FormattedCurrencyAmount | String | Formatted string representing the total amount in a specified currency, ready for display with the appropriate currency symbol. | |
| Finder | String | Search or query reference related to the ShoppingSearchesresultItems, potentially used for filtering or looking up past search results. | |
| SearchPhraseId | Long | PrimaryKey | Unique identifier for the search phrase used to find the items in the result set, linking to the SearchPhraseId in the ShoppingSearches table. |