JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationResponseslinespriceTiers

Specifies quantity-based price tiers in a supplier’s response, outlining price changes above certain order thresholds.

Columns

Name Type Description
SupplierNegotiationResponsesResponseNumber [KEY] Long Unique identifier for the response within the supplier negotiation, linking the price tier data to a specific response in the negotiation process.
LinesLineId [KEY] Long Unique identifier for the line item associated with the response, linking the price tier data to a specific line in the negotiation.
LinesResponseNumber [KEY] Long Unique identifier for the line item response, used to track and reference the supplier’s offer or bid for a particular line item within the negotiation.
ResponseNumber [KEY] Long Unique identifier for the overall response, linking the price tier data to a specific supplier’s overall offer in the negotiation.
LineId [KEY] Long Unique identifier for the line item, used to reference specific line items in the negotiation process and link them to their respective price tiers.
Line String The description or label for the line item, providing identification for the specific item in the supplier’s response.
PriceTierId [KEY] Long Unique identifier for the price tier, allowing for specific tracking of pricing structures that are applied to certain quantity ranges.
MinimumQuantity Decimal The minimum quantity required for the price tier, indicating the starting quantity for which the price tier applies.
MaximumQuantity Decimal The maximum quantity for the price tier, indicating the upper limit of the quantity range within which the price tier applies.
Price Decimal The price offered for the line item within the specified quantity range of the price tier.
CreatedBy String The name or identifier of the user who created the price tier record, ensuring accountability for data entry.
CreationDate Datetime The date and time when the price tier record was created, providing a timestamp for when the tier was added to the system.
LastUpdatedBy String The name or identifier of the user who last updated the price tier record, ensuring accountability for any changes made to the tier.
LastUpdateDate Datetime The date and time when the price tier record was last updated, providing a timestamp for the most recent change.
Finder String Search or query reference related to the SupplierNegotiationResponseslinespriceTiers, used for filtering or looking up specific price tier records in the negotiation process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434