JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationslinespriceBreaks

Stores line-level price break data (volume discounts, date-based pricing) to refine cost evaluations.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long Unique identifier for the auction header, linking the price break 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 break, ensuring the system associates the price break with the correct auction.
LinesLineId [KEY] Decimal Unique identifier for the negotiation line associated with the price break, helping to track and manage the price break for a specific line.
AuctionHeaderId [KEY] Long Unique identifier for the auction, linking the price break data to the overall auction event in the negotiation.
LineId [KEY] Decimal Unique identifier for the negotiation line, associating the price break data with a specific line in the negotiation.
Line String Number identifying the negotiation line, used to track and organize the price break in the context of the specific line.
LineDescription String Description of the negotiation line associated with the price break, providing additional context for the specific line in the negotiation.
PriceBreakId [KEY] Decimal Unique identifier for the price break, allowing for tracking and management of the specific price break in the negotiation process.
ShipToOrganizationId Long Unique identifier for the inventory organization where the supplier ships the item, helping to track shipping details related to the price break.
ShipToOrganization String Name of the inventory organization where the supplier ships the item, helping to specify the location involved in the price break.
ShipToLocationId Long Unique identifier for the location where the supplier ships the item, tracking the shipping details of the price break.
ShipToLocation String Name of the location where the supplier ships the item, helping to specify the receiving location involved in the price break.
Quantity Decimal The quantity involved in the price break, determining the volume or amount eligible for the price adjustment.
TargetPrice Decimal The target price for the price break, indicating the price the procurement organization aims to achieve under the terms of the price break.
PriceBreakStartDate Date The date when the price break becomes effective, marking the start of the period when the price break applies.
PriceBreakEndDate Date The date when the price break expires, indicating the end of the period during which the price break is valid.
CreatedBy String The name or identifier of the user who created the price break record, ensuring accountability for data entry.
CreationDate Datetime The date and time when the price break record was created, marking the initial entry of the price break into the system.
LastUpdatedBy String The name or identifier of the user who last updated the price break record, ensuring accountability for modifications.
LastUpdateDate Datetime The date and time when the price break 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 break 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 break records for the given period are retrieved.

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