RequisitionProductDetails
Retrieves extended information about a requisition item, including its description, category, and associated services or configurations.
Columns
| Name | Type | Description |
| ItemKey | String | A unique identifier for the item in the requisition product details. Example: 'ABC123' for a specific product key. |
| PunchoutItemIdentifier | Long | The unique identifier for an item in a punchout catalog, used to link external catalog data. Example: 10001 for the punchout item identifier. |
| PunchoutCatalogId | Long | The unique identifier for the punchout catalog from which the item is sourced. Example: 20001 for Punchout Catalog ID. |
| ItemDescription | String | A brief description of the item in the requisition. Example: 'Wireless Mouse' for a mouse being requested. |
| LongDescription | String | A detailed description of the item in the requisition, providing further specifications. Example: 'Ergonomic wireless mouse with Bluetooth connectivity'. |
| CurrencyCode | String | The currency code used for pricing the item in the requisition. Example: 'USD' for U.S. Dollars. |
| OrderTypeLookupCode | String | The lookup code that defines the type of order for the item. Example: 'EXPENSE' for an expense-type order. |
| CategoryName | String | The name of the category under which the item is classified. Example: 'Electronics' for items in the electronics category. |
| CurrencyUnitPrice | Decimal | The unit price of the item in the requisition, in the specified currency. Example: 25.99 for the price of one unit in USD. |
| UnitPrice | Decimal | The price of one unit of the item in the default currency. Example: 20.00 for the unit price of the item. |
| CurrencyAmount | Decimal | The total amount for the item in the requisition, in the specified currency. Example: 100.00 for the total cost in USD. |
| Amount | Decimal | The total amount for the item in the default currency. Example: 80.00 for the total amount of the item. |
| SuggestedVendorName | String | The name of the vendor suggested for the purchase of the item. Example: 'ABC Supplies' for the suggested supplier. |
| Manufacturer | String | The manufacturer of the item. Example: 'Logitech' for the maker of the wireless mouse. |
| ThumbnailImage | String | A small image representing the item in the requisition. Example: 'thumbnail.jpg' for an image file of the item. |
| ItemSource | String | The source from which the item is being procured. Example: 'Internal' for items sourced within the company. |
| FunctionalCurrencyCode | String | The currency code of the functional currency used in the business unit. Example: 'USD' for U.S. Dollars as the functional currency. |
| CatalogItemKey [KEY] | Long | The unique key for the item in the catalog. Example: 30001 for Catalog Item Key 30001. |
| FunctionalCurrencySymbol | String | The symbol for the functional currency. Example: '$' for the symbol used in USD. |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer for the item. Example: '12345X' for a specific manufacturer's part number. |
| SupplierPartNumber | String | The part number assigned by the supplier for the item. Example: 'XYZ678' for a supplier-specific part number. |
| UOM | String | The unit of measure for the item in the requisition. Example: 'Each' for a unit of measure indicating individual items. |
| RequisitioningBUId | Long | The unique identifier for the business unit that raised the requisition for the item. Example: 4001 for the business unit requesting the item. |
| FormattedUnitPrice | String | The formatted price for one unit of the item, including the currency symbol. Example: '$25.99' for the unit price in USD. |
| FormattedCurrencyUnitPrice | String | The formatted price for one unit of the item in the specified currency, including the currency symbol. Example: '€23.50' for the unit price in EUR. |
| FormattedAmount | String | The formatted total amount for the item in the requisition. Example: '$100.00' for the total price of the item. |
| FormattedCurrencyAmount | String | The formatted total amount for the item, including the currency symbol. Example: '€90.00' for the total cost in EUR. |
| Bind_itemId | Long | The binding ID for the item in the requisition. Example: 5001 for Item ID 5001. |
| Bind_punchoutItemIdentifier | Long | The binding ID for the punchout item identifier. Example: 6001 for the binding of the punchout item identifier. |
| Bind_sourceDocLineId | Long | The binding ID for the source document line associated with the item. Example: 7001 for the binding of the source document line. |
| Finder | String | A reference or placeholder used for searching and locating specific requisition product detail records. Example: 'Search by Item Key' or 'Search by Supplier'. |