ShoppingSearchesresultItems
Holds detailed data for items returned in a shopping search, including item ID, pricing, and availability.
Columns
| Name | Type | 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 | Unique identifier for the search phrase used to find the items in the result set, linking to the SearchPhraseId in the ShoppingSearches table. |