JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftSupplierNegotiationResponseslinespriceTiers

Captures tiered pricing details for a supplier’s draft negotiation line, allowing discounted rates at higher order quantities.

Columns

Name Type Description
DraftSupplierNegotiationResponsesResponseNumber [KEY] Long The unique identifier for the negotiation response, linking the price tier to a specific response within the negotiation.
LinesLineId [KEY] Long The unique identifier for the negotiation response line, associating the price tier with a particular line item in the response.
LinesResponseNumber [KEY] Long The unique identifier for the response within the negotiation line, linking the price tier to the correct supplier response.
ResponseNumber [KEY] Long The unique identifier for the supplier's response, helping to track and manage the specific offer made by the supplier.
LineId [KEY] Long The identifier for the negotiation line, associating the price tier with a specific line item within the negotiation response.
Line String The number that identifies the negotiation line, helping to differentiate between multiple lines in the response.
PriceTierId [KEY] Long The unique identifier for the price tier, linking the tier to the specific negotiation line and its quantity-based pricing structure.
MinimumQuantity Decimal The minimum number of units that qualifies for the price specified in the price tier, setting a threshold for the offer.
MaximumQuantity Decimal The maximum number of units covered by the price in the price tier, indicating the upper limit for the offer.
TargetPrice Decimal The target price for the price tier, reflecting the buyer's ideal price for the specified quantity range.
Price Decimal The price per unit offered by the supplier for the quantity range defined by the price tier, determining the cost for that tier.
CreatedBy String The user who created the price tier record, providing accountability for the initial entry of the pricing details.
CreationDate Datetime The timestamp when the price tier record was created, establishing when the price tier was first entered into the system.
LastUpdatedBy String The user who most recently updated the price tier record, ensuring accountability for any modifications made to the pricing details.
LastUpdateDate Datetime The timestamp of the last update to the price tier record, tracking when the record was last modified.
Finder String A search identifier used to locate specific price tier records in the system.
EffectiveDate Date The date from which the price tier is considered effective, indicating when the tier's pricing structure starts to apply in the negotiation process.

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