RequisitionProductDetailspriceBreaks
Displays tiered or location-based price variations for an item in a requisition, guiding cost-effective purchasing decisions.
Columns
| Name | Type | Description |
| RequisitionProductDetailsCatalogItemKey [KEY] | Long | The unique identifier for the catalog item associated with the price breaks. Example: 1001 for Catalog Item Key 1001. |
| Quantity | Decimal | The quantity of items eligible for the specified price break. Example: 10 for a price break applicable to 10 units. |
| Price | Decimal | The price per unit for the item at the specified quantity. Example: 15.00 for a price of $15 per unit when 10 units are ordered. |
| Discount | Decimal | The discount applied to the item at the specified quantity. Example: 5.00 for a $5 discount per unit when the quantity is 10. |
| StartDate | Date | The date when the price break is applicable from. Example: '2023-06-01' for the start date of the price break. |
| EndDate | Date | The date when the price break expires or is no longer applicable. Example: '2023-06-30' for the end date of the price break. |
| LineLocationId [KEY] | Long | The unique identifier for the location on the requisition line where the price break is applicable. Example: 2001 for Line Location ID 2001. |
| DeliverTo | String | The location where the item is to be delivered, tied to the price break. Example: 'Warehouse A' for the delivery location. |
| UnitOfMeasure | String | The unit of measure for the item associated with the price break. Example: 'Each' for individual units of the item. |
| CurrencyCode | String | The currency code used for the price break. Example: 'USD' for U.S. Dollars as the currency for the price break. |
| FunctionalCurrencySymbol | String | The symbol for the functional currency used for the price break. Example: '$' for the symbol of USD. |
| FunctionalCurrencyCode | String | The code for the functional currency used in the price break. Example: 'USD' for U.S. Dollars as the functional currency. |
| FunctionalCurrencyPrice | Decimal | The price of the item in the functional currency, accounting for the price break. Example: 12.00 for the functional currency price of the item. |
| FormattedPrice | String | The formatted price for the item, including the currency symbol. Example: '$15.00' for the price formatted in USD. |
| FormattedFunctionalCurrencyPrice | String | The formatted price in the functional currency, including the currency symbol. Example: '€13.00' for the price in EUR. |
| FormattedDiscount | String | The formatted discount amount, including the currency symbol. Example: '-$5.00' for the discount formatted in USD. |
| Bind_itemId | Long | The binding ID for the item associated with the price break. Example: 3001 for the item ID linked to this price break. |
| Bind_punchoutItemIdentifier | Long | The binding ID for the punchout item identifier, used for external catalog data. Example: 4001 for the punchout item ID. |
| Bind_sourceDocLineId | Long | The binding ID for the source document line associated with the price break. Example: 5001 for the line ID from the source document. |
| CatalogItemKey | Long | The unique key for the catalog item in the price break record. Example: 6001 for the catalog item key. |
| Finder | String | A reference or placeholder used for searching and locating specific requisition product details price break records. Example: 'Search by Catalog Item' or 'Search by Quantity'. |