JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationslinespriceTiers

Holds quantity-based pricing tiers for negotiation lines, capturing cost variations that apply once certain purchase thresholds are reached.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long Unique identifier for the auction header, linking the price tier data to a specific auction event in the negotiation process.
LinesAuctionHeaderId [KEY] Long Unique identifier for the auction header related to the negotiation line price tier, ensuring the system associates the price tier with the correct auction.
LinesLineId [KEY] Decimal Unique identifier for the negotiation line associated with the price tier, allowing for the precise tracking and management of price tiers per negotiation line.
AuctionHeaderId [KEY] Long Unique identifier for the auction, linking the price tier data to the overall auction event in the negotiation.
LineId [KEY] Decimal Unique identifier for the negotiation line, associating the price tier data with a specific line in the negotiation process.
Line String Number identifying the negotiation line associated with the price tier, helping to track and organize the price tier within the context of the line.
LineDescription String Description of the negotiation line associated with the price tier, providing additional context for the specific line.
PriceTierId [KEY] Decimal Unique identifier for the price tier, helping to track and manage the specific price tier in the negotiation process.
MinimumQuantity Decimal The lowest quantity limit for the price tier, specifying the minimum quantity required to qualify for this particular price tier.
MaximumQuantity Decimal The highest quantity limit for the price tier, specifying the maximum quantity allowed within this tier.
TargetPrice Decimal The target price for the price tier, representing the desired price for the specified quantity range in the negotiation.
CreatedBy String The name or identifier of the user who created the price tier record, ensuring accountability for the data entry.
CreationDate Datetime The date and time when the price tier record was created, marking the initial entry of the price tier into the system.
LastUpdatedBy String The name or identifier of the user who last updated the price tier record, ensuring accountability for modifications.
LastUpdateDate Datetime The date and time when the price tier record was last updated, providing a timestamp for the most recent changes to the record.
Finder String Search or query reference used for locating or filtering specific price tier records within the system.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified date, ensuring that only relevant price tier records for the given period are retrieved.

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